MySQL Forums :: Newbie :: school exercise I am suck on


Advanced Search

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 Zac Grey 08/08/2010 05:04PM
Re: school exercise I am suck on Barry Galbraith 08/08/2010 05:08PM
Re: school exercise I am suck on Rotciv Santiago 08/08/2010 07:34PM
Re: school exercise I am suck on Rick James 08/10/2010 12:12AM
Re: school exercise I am suck[sic] on Rick James 08/10/2010 12:15AM


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.