Movieticket 1

Movieticket 1 - ,Mem_ID,CHAR(18,Cre_Type,Cre_expdate,INTEGER,Cre_bill Zipcode TICKET

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

View Full Document Right Arrow Icon
Sheet1 Page 1 Attribute Entity Name,Attribute Name,Description,Attribute Datatype,Domain MOVIES,Movie_ID,,INTEGER, ,Movie_Title,,VARCHAR(), ,Movie_Release_Date,,, ,Movie_Year,,INTEGER, ,Movie_Duration,,, ,Movie_Genre,,CHAR(18), ,Movie_Revenue,,FLOAT, ,Movie_Rating,,CHAR(), THEATERS,Theater_ID,,INTEGER, ,Loc_Zipcode,,, ,Theater_Name,,VARCHAR(), ,Theater_Ticketable,,CHAR(18), ,Theater_Phone,,INTEGER, ,Theater_Address,,VARCHAR(), MEMBER,Mem_ID,,CHAR(18), ,Mem_Fname,, ,Mem_Lname,, ,Mem_Zipcode,,INTEGER ,Mem_Gender,,CHAR(18) ,Mem_Birth,,INTERVAL TICKETSORDER,Tic_Track_ID,,INTEGER ,Show_ID,, ,Mem_ID,,CHAR(18) ,Cre_Num,,INTEGER ,Order_Quanity,, LOCATIONS,Loc_Zipcode,, ,Loc_City,,CHAR(18) ,Loc_State,, CREDIT CARD,Cre_Num,,INTEGER
Background image of page 1

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

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

Unformatted text preview: ,Mem_ID,,CHAR(18) ,Cre_Type,, ,Cre_expdate,,INTEGER ,Cre_bill Zipcode,, TICKET GROUPS,Ticket_Type,,CHAR(18) ,Tic_Track_ID,,INTEGER ,Ticket_Ser_Price,,FLOAT ,Ticket_Price,, SCREEN,Screen_Num,,CHAR(18) ,Theater_ID,,INTEGER ,Screen_Name,,CHAR(18) ,Screen_Size,, SHOWINGS,Show_ID,,INTEGER ,Theater_ID,, ,Movie_ID,, ,Show_Time,,DATETIME ,Show_Date,,CHAR(18) ,Screen_Num,,INTEGER FEATURES,Theater_ID,, ,Feature_Type,,VARCHAR() ROLES,Cont_ID,,INTEGER ,Movie_ID,, Sheet1 Page 2 ,Role_type,,CHAR(18) CONTRIBUTORS,Cont_ID,,INTEGER ,Cont_Lname,,CHAR(18) ,Cont_Fname,, ,Cont_MInitial,, MEMBER_FAV_THEATER,Theater_ID,,INTEGER ,Mem_ID,,CHAR(18)...
View Full 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 / 2

Movieticket 1 - ,Mem_ID,CHAR(18,Cre_Type,Cre_expdate,INTEGER,Cre_bill Zipcode TICKET

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