Project #89101 - Database Design & Implementation SQL

this has been aseries of assignments so am posting every thing but u only have to do assignment two the 2nd part where u have to impment the data base into an sql server, u might need to look at my data dictionary as there is afew things that are wrong that u may need to correct to implment the data this is the teachers feed back 

 

 

ER Diagrams Feedback
------------------------
Missing the movie description attribute from movie table, and review date from review table and cost of session.
Italics normally indicate FKs - don't use it otherwise in an ER diagram.
Movie must have at least one genre - cardinality error.
A compound PK in the ticket table won't allow a customer to purchase multiple tickets for a session.
A compound PK consisting of the movie and customer FKs would ensure that a customer can only review a specific movie once.
Otherwise well done.


Data Dictionary Feedback
------------------------
The classification table needed to contain the abbreviation of the classification (e.g. G, PG, M...) as well as the classification name.  Using an integer as the PK of this table won't allow you to store the abbreviation.
Most of the tables will be using auto incrementing integers for the PK - be sure to specify the IDENTITY option for them.
Cinema seating capacity column missing.
Movie duration should be stored as a number (e.g. a SMALLINT), not as a TIME of the day or a date.
The review rating column should have a check constraint to make sure it is between 0 and 5.
Details of MovieGenres table not specified correctly.
You must specify the table and column that every FK references.
Session date/time needs to store both a date and a time.

 

# in the scenario folder only task 3 and 4 are relevant

Subject Computer
Due By (Pacific Time) 11/01/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy