MySQL Forums
Forum List  »  Newbie

school exercise I am suck on
Posted by: Zac Grey
Date: August 08, 2010 05:04PM

I have the following task from school. I am horrible at mysql so any help will be gratefully appreciated.

Normalise the following UD

A cinema complex is playing several movies. Each movie has a set of session times and a cinema which may change for each session. Each cinema has a maximum capacity. Tickets are sold for each movie at a different price depending its rating (i.e. PG movies cost $8 while M movies cost $14). Ratings have an age limit. If a child is below this age they cannot buy a ticket for that movie. A record is kept of the number of tickets sold for each movie. This record will include the type of ticket and the session it was for.

-Create a database using sql statements
-Populate it with at least 3 records per table

So sorry for being so dumb at this.

thanks in advanced

Options: ReplyQuote


Subject
Written By
Posted
school exercise I am suck on
August 08, 2010 05:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.