Deliverables: The list of deliverables to be handed in on or by the hand-in date is as follows: The Case Description. In

[answerhappygod]

Deliverables:
The list of deliverables to be handed in on or by the hand-in
date is as follows:
The Case Description. In 2-3 pages, produce a description of the
case under study, along with the main user requirements. Expand the
given case by suggesting queries and other system requirements
which you consider useful to end-users.
The data model (Entity Relationship Model plus supporting
narrative, including any assumptions made). For the design of the
ERM you should use an appropriate CASE tool.
A Relational Schema (database design), which comprises listings
of table definitions clearly identifying primary keys and foreign
keys and describing data attributes, and minimum cardinality
actions’ tables for all of the relationships.
The code and results of data definition and manipulation (i.e.
table creation, data insertion and the required SQL queries)
including the appropriate test data.
Business Need: Create a database for a TV show being a
cooking competition called “The BestCook”
Introduction:
The first “BestCook” competition took place in the USA in 1995.
The concept of this successful TV show is to hold competitions
between contestants for the title and prize of the best cook.
Nowadays, the competition is being franchised to many TV channels
across the world which organize it yearly.
The show exists in different formats: BestHomeCook, BestProCook
and Best[...]Cook with the last being open to new suggestions for
future organizations of the competition.
Business Requirements:
You have been approached to create a database for the “BestCook”
competition. The organizers are interested in keeping data about
the contestants, the challenges which are organized, the outcome of
each challenge and overall everything which relates to the
organization of the competition from start to end.
Requirements for the case study (deliverables in
detail)
1. Develop an data model and database design to support the case
requirements. You may be required to make some assumptions. Please
state and explain these in your documentation.
Your deliverables should include:
A data model as an E-R diagram to include all entities and
attributes and the maximum and minimum cardinality for each pair of
related entities.
A database design being a normalised relational schema derived
from the data model which should include all appropriate attributes
associated with each relation, clearly showing the primary key of
each relation and the foreign key(s) where applicable. A data
dictionary describing the type, size and meaning of each data
element or field is also required. Minimum cardinality actions
should
also be described.
Note:
You may make suitable and intelligent assumptions.
Anything that is not stated as part of the requirements may be
assumed.
Your assumptions must NOT override any user requirements.
All assumptions must be clearly stated or explained in your
report.
Set
integrity constraints to help ensure that data is entered with
correct values. You must make sure that your sample data covers all
requirements of the queries in section 3 below. Therefore queries
that yield null results/ output will not gain full marks even if
the SQL code is correct. The code for creating and inserting data
into the tables/relations must be provided.
Suggest meaningful end-user queries to extract information from
your database. Set up and test all queries using an SQL product.
Describe each query and provide both the SQL code and the output of
the query as a screenshot in your report and as part of your
database file.
You are required to describe and then satisfy a minimum of 10
queries extracting data from your database. These queries should
vary from simple (single-table, one or more search criteria) to
more advanced (multiple-table, using join, subqueries, sorting,
functions, views, etc.).