movietickets 1

movietickets 1 - Attribute Entity Name MOVIES Attribute...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Attribute Entity - Attribute Name Description Attribute Datatype Name MOVIES Movie_ID Uniquely identifies a Movie INTEGER Movie_Title The name of big screen Movie VARCHAR(50) Movie_Release_Date The date Movie is- VARCHAR(30) released to Theaters Movie_Year The year Movie is released INTEGER to Theaters Movie_Duration The length time of a Movie INTEGER Movie_Genre The category of a Movie VARCHAR(30) Movie_Revenue The gross earnings of Movie DECIMAL Movie_Rating MPPA Movie evaluation for a VARCHAR(5) specific audience Movie_Synopsis The summary of a Movie VARCHAR(500) THEATERS Theater_ID Uniquely identifies a Theater INTEGER Theater_Name This is Theater building with VARCHAR(50) collection of screens and showings Theater_Ticketable Ticketable Theater is a Theater VARCHAR(50) in partnership with movietickets.com. Where tickets can be bought Theater_Phone The contact telephone of INTEGER the Theater Theater_Address The Theater Street name VARCHAR(50) and number MEMBERS Mem_ID Uniquely identifies a registered
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/11/2010 for the course MIS 3400 taught by Professor N/a during the Spring '10 term at Uni. Münster.

Page1 / 4

movietickets 1 - Attribute Entity Name MOVIES Attribute...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online