ISYS224 Database Systems : Assignment 1 — Relational Database Design & Implementation

profileaks198
assignment-1_data.xlsx
Home>Information Systems homework help>ISYS224 Database Systems : Assignment 1 — Relational Database Design & Implementation

Sheet1

Cinema ID CinemaName Email BranchID BranchAddress BranchPhoneNumber Screen ScreenName No.Of.Seats Session ID Date Movie Start Time MovieID Name Year Language LengthInMinutes
C001 Rob Stark Cinemas [email protected] B001 13,Ned Lane,Stark,Winterfell-2134 98506254 S001 RS1 56 SS01 9/1/14 15:30 M001 Guardians of the Galaxy 2014 English 121
C001 Rob Stark Cinemas [email protected] B001 13,Ned Lane,Stark,Winterfell-2134 98506254 S001 RS1 56 SS02 9/1/14 10:00 M002 The Expendables 3 2014 English 126
C001 Rob Stark Cinemas [email protected] B001 13,Ned Lane,Stark,Winterfell-2134 98506254 S002 RS2 53 SS03 9/2/14 11:00 M003 The Hundred-Foot Journey 2014 French 122
C001 Rob Stark Cinemas [email protected] B001 13,Ned Lane,Stark,Winterfell-2134 98506254 S002 RS2 53 SS04 9/2/14 16:00 M001 Guardians of the Galaxy 2014 English 121
C001 Rob Stark Cinemas [email protected] B001 13,Ned Lane,Stark,Winterfell-2134 98506254 S002 RS2 53 SS05 9/3/14 10:00 M004 Bad Neighbours 2014 Spanish 97
C001 Rob Stark Cinemas [email protected] B002 99,Tywin Lane, Lannister,Winterfell-2457 98505456 S003 RS3 56 SS06 9/1/14 12:30 M005 The Fault in our Stars 2014 English 126
C001 Rob Stark Cinemas [email protected] B002 99,Tywin Lane, Lannister,Winterfell-2457 98505456 S003 RS3 56 SS07 9/1/14 15:30 M001 Guardians of the Galaxy 2014 English 121
C001 Rob Stark Cinemas [email protected] B002 99,Tywin Lane, Lannister,Winterfell-2457 98505456 S004 RS4 36 SS08 9/2/14 15:30 M002 The Expendables 3 2014 English 126
C001 Rob Stark Cinemas [email protected] B002 99,Tywin Lane, Lannister,Winterfell-2457 98505456 S004 RS4 36 SS09 9/4/14 11:00 M007 22 Jump Street 2014 Italian 112
C001 Rob Stark Cinemas [email protected] B003 58,Daenerys Rd, Targaryen,Winterfell-5633 98513334 S005 RS5 98 SS10 9/3/14 16:30 M006 The Shawshank Redemption 1994 English 142
C001 Rob Stark Cinemas [email protected] B003 58,Daenerys Rd, Targaryen,Winterfell-5633 98513334 S005 RS5 98 SS11 9/1/14 11:00 M003 The Hundred-Foot Journey 2014 French 122
C001 Rob Stark Cinemas [email protected] B003 58,Daenerys Rd, Targaryen,Winterfell-5633 98513334 S006 RS6 66 SS12 9/5/14 10:00 M005 The Fault in our Stars 2014 English 126
C001 Rob Stark Cinemas [email protected] B003 58,Daenerys Rd, Targaryen,Winterfell-5633 98513334 S006 RS6 66 SS13 9/3/14 12:30 M002 The Expendables 3 2014 English 126
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S007 RS7 98 SS14 9/2/14 15:30 M004 Bad Neighbours 2014 Spanish 97
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S007 RS7 98 SS15 9/4/14 11:00 M008 Schindler's List 1993 German 195
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S008 RS8 23 SS16 9/1/14 16:30 M009 12 Angry Men 1957 English 96
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S008 RS8 23 SS17 9/5/14 12:30 M003 The Hundred-Foot Journey 2014 French 122
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S009 RS9 69 SS18 9/1/14 10:00 M005 The Fault in our Stars 2014 English 126
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S009 RS9 69 SS19 9/5/14 10:00 M001 Guardians of the Galaxy 2014 English 121
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S010 RS10 77 SS20 9/5/14 16:30 M002 The Expendables 3 2014 English 126
C001 Rob Stark Cinemas [email protected] B004 87,Peter Avenue,Baelish,Winterfell-6937 98532145 S010 RS10 77 SS21 9/2/14 11:00 M006 The Shawshank Redemption 1994 English 142
C002 Tyrion Lannister Cinemas [email protected] B005 15,Sansa Lane,Stark,Winterfell-2134 98462223 S011 TY1 63 SS22 9/2/14 15:30 M001 Guardians of the Galaxy 2014 English 121
C002 Tyrion Lannister Cinemas [email protected] B005 15,Sansa Lane,Stark,Winterfell-2134 98462223 S011 TY1 63 SS23 9/1/14 12:30 M004 Bad Neighbours 2014 Spanish 97
C002 Tyrion Lannister Cinemas [email protected] B005 15,Sansa Lane,Stark,Winterfell-2134 98462223 S012 TY2 31 SS24 9/5/14 18:00 M002 The Expendables 3 2014 English 126
C002 Tyrion Lannister Cinemas [email protected] B005 15,Sansa Lane,Stark,Winterfell-2134 98462223 S012 TY2 31 SS25 9/3/14 15:30 M007 22 Jump Street 2014 Italian 112
C002 Tyrion Lannister Cinemas [email protected] B006 79,Jamie Lane, Lannister,Winterfell-2457 98456237 S013 TY3 88 SS26 9/3/14 10:30 M001 Guardians of the Galaxy 2014 English 121
C002 Tyrion Lannister Cinemas [email protected] B006 79,Jamie Lane, Lannister,Winterfell-2457 98456237 S013 TY3 88 SS27 9/5/14 11:00 M003 The Hundred-Foot Journey 2014 French 122
C002 Tyrion Lannister Cinemas [email protected] B006 79,Jamie Lane, Lannister,Winterfell-2457 98456237 S014 TY4 54 SS28 9/1/14 19:30 M009 12 Angry Men 1957 English 96
C002 Tyrion Lannister Cinemas [email protected] B006 79,Jamie Lane, Lannister,Winterfell-2457 98456237 S014 TY4 54 SS29 9/5/14 17:00 M001 Guardians of the Galaxy 2014 English 121
C002 Tyrion Lannister Cinemas [email protected] B006 79,Jamie Lane, Lannister,Winterfell-2457 98456237 S015 TY5 69 SS30 9/2/14 10:00 M005 The Fault in our Stars 2014 English 126
C002 Tyrion Lannister Cinemas [email protected] B006 79,Jamie Lane, Lannister,Winterfell-2457 98456237 S015 TY5 69 SS31 9/5/14 16:30 M008 Schindler's List 1993 German 195
C002 Tyrion Lannister Cinemas [email protected] B007 8, Ygritte Rd,Baelish,Winterfell-6937 98754676 S016 TY6 75 SS32 9/1/14 12:30 M002 The Expendables 3 2014 English 126
C002 Tyrion Lannister Cinemas [email protected] B007 8, Ygritte Rd,Baelish,Winterfell-6937 98754676 S016 TY6 75 SS33 9/5/14 18:00 M004 Bad Neighbours 2014 Spanish 97
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S017 JS1 35 SS34 9/4/14 11:00 M001 Guardians of the Galaxy 2014 English 121
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S017 JS1 35 SS35 9/4/14 11:00 M003 The Hundred-Foot Journey 2014 French 122
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S018 JS2 65 SS36 9/3/14 16:30 M009 12 Angry Men 1957 English 96
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S018 JS2 65 SS37 9/1/14 12:30 M006 The Shawshank Redemption 1994 English 142
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S019 JS3 85 SS38 9/4/14 13:00 M001 Guardians of the Galaxy 2014 English 121
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S019 JS3 85 SS39 9/2/14 19:30 M004 Bad Neighbours 2014 Spanish 97
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S020 JS4 65 SS40 9/5/14 11:00 M002 The Expendables 3 2014 English 126
C003 Jon Snow Cinemas [email protected] B008 1,Arya Avenue,Stark,Winterfell-2134 98123455 S020 JS4 65 SS41 9/3/14 19:00 M001 Guardians of the Galaxy 2014 English 121
C003 Jon Snow Cinemas [email protected] B009 81,Cersei Rd, Lannister,Winterfell-2457 98362145 S021 JS5 75 SS42 9/4/14 16:30 M005 The Fault in our Stars 2014 English 126
C003 Jon Snow Cinemas [email protected] B009 81,Cersei Rd, Lannister,Winterfell-2457 98362145 S021 JS5 75 SS43 9/5/14 12:30 M003 The Hundred-Foot Journey 2014 French 122
C003 Jon Snow Cinemas [email protected] B009 81,Cersei Rd, Lannister,Winterfell-2457 98362145 S022 JS6 96 SS44 9/1/14 10:00 M007 22 Jump Street 2014 Italian 112
C003 Jon Snow Cinemas [email protected] B009 81,Cersei Rd, Lannister,Winterfell-2457 98362145 S022 JS6 96 SS45 9/3/14 15:30 M004 Bad Neighbours 2014 Spanish 97
C003 Jon Snow Cinemas [email protected] B010 53,Theon Park,Greyjoy,Winterfell-5331 98745612 S023 JS7 48 SS46 9/5/14 15:30 M008 Schindler's List 1993 German 195
C003 Jon Snow Cinemas [email protected] B010 53,Theon Park,Greyjoy,Winterfell-5331 98745612 S023 JS7 48 SS47 9/2/14 20:00 M001 Guardians of the Galaxy 2014 English 121
C003 Jon Snow Cinemas [email protected] B010 53,Theon Park,Greyjoy,Winterfell-5331 98745612 S024 JS8 37 SS48 9/1/14 11:00 M002 The Expendables 3 2014 English 126
C003 Jon Snow Cinemas [email protected] B010 53,Theon Park,Greyjoy,Winterfell-5331 98745612 S024 JS8 37 SS49 9/2/14 18:00 M003 The Hundred-Foot Journey 2014 French 122
C003 Jon Snow Cinemas [email protected] B010 53,Theon Park,Greyjoy,Winterfell-5331 98745612 S025 JS9 91 SS50 9/1/14 12:30 M005 The Fault in our Stars 2014 English 126
C003 Jon Snow Cinemas [email protected] B010 53,Theon Park,Greyjoy,Winterfell-5331 98745612 S025 JS9 91 SS51 9/4/14 11:00 M009 12 Angry Men 1957 English 96
C004 Joffrey Cinemas [email protected] B011 2,Bran Rd, Stark,Winterfell-2134 98784563 S026 JB1 49 SS52 9/3/14 11:00 M001 Guardians of the Galaxy 2014 English 121
C004 Joffrey Cinemas [email protected] B011 2,Bran Rd, Stark,Winterfell-2134 98784563 S026 JB1 49 SS53 9/5/14 15:30 M006 The Shawshank Redemption 1994 English 142
C004 Joffrey Cinemas [email protected] B011 2,Bran Rd, Stark,Winterfell-2134 98784563 S027 JB2 68 SS54 9/3/14 12:30 M007 22 Jump Street 2014 Italian 112
C004 Joffrey Cinemas [email protected] B011 2,Bran Rd, Stark,Winterfell-2134 98784563 S027 JB2 68 SS55 9/2/14 16:30 M002 The Expendables 3 2014 English 126
C004 Joffrey Cinemas [email protected] B012 41,Tyrion Lane, Lannister,Winterfell-2457 98235164 S028 JB3 16 SS56 9/1/14 11:00 M005 The Fault in our Stars 2014 English 126
C004 Joffrey Cinemas [email protected] B012 41,Tyrion Lane, Lannister,Winterfell-2457 98235164 S028 JB3 16 SS57 9/2/14 10:00 M004 Bad Neighbours 2014 Spanish 97
C004 Joffrey Cinemas [email protected] B012 41,Tyrion Lane, Lannister,Winterfell-2457 98235164 S029 JB4 37 SS58 9/2/14 15:30 M001 Guardians of the Galaxy 2014 English 121
C004 Joffrey Cinemas [email protected] B012 41,Tyrion Lane, Lannister,Winterfell-2457 98235164 S029 JB4 37 SS59 9/4/14 12:30 M003 The Hundred-Foot Journey 2014 French 122
C004 Joffrey Cinemas [email protected] B012 41,Tyrion Lane, Lannister,Winterfell-2457 98235164 S030 JB5 39 SS60 9/5/14 19:30 M008 Schindler's List 1993 German 195
C004 Joffrey Cinemas [email protected] B012 41,Tyrion Lane, Lannister,Winterfell-2457 98235164 S030 JB5 39 SS61 9/1/14 20:00 M001 Guardians of the Galaxy 2014 English 121
C004 Joffrey Cinemas [email protected] B013 22, Ramsay Rd, Greyjoy,Winterfell-5331 98466314 S031 JB6 98 SS62 9/2/14 10:00 M001 Guardians of the Galaxy 2014 English 121
C004 Joffrey Cinemas [email protected] B013 22, Ramsay Rd, Greyjoy,Winterfell-5331 98466314 S031 JB6 98 SS63 9/3/14 15:30 M001 Guardians of the Galaxy 2014 English 121
C004 Joffrey Cinemas [email protected] B013 22, Ramsay Rd, Greyjoy,Winterfell-5331 98466314 S032 JB7 36 SS64 9/1/14 11:00 M009 12 Angry Men 1957 English 96
C004 Joffrey Cinemas [email protected] B013 22, Ramsay Rd, Greyjoy,Winterfell-5331 98466314 S032 JB7 36 SS65 9/3/14 18:00 M006 The Shawshank Redemption 1994 English 142
C004 Joffrey Cinemas [email protected] B013 22, Ramsay Rd, Greyjoy,Winterfell-5331 98466314 S033 JB8 44 SS66 9/2/14 12:30 M002 The Expendables 3 2014 English 126
C004 Joffrey Cinemas [email protected] B013 22, Ramsay Rd, Greyjoy,Winterfell-5331 98466314 S033 JB8 44 SS67 9/1/14 15:30 M007 22 Jump Street 2014 Italian 112
C004 Joffrey Cinemas [email protected] B014 4, Hound Avenue,Baelish,Winterfell-6937 98457376 S034 JB9 66 SS68 9/4/14 10:00 M003 The Hundred-Foot Journey 2014 French 122
C004 Joffrey Cinemas [email protected] B014 4, Hound Avenue,Baelish,Winterfell-6937 98457376 S034 JB9 66 SS69 9/5/14 16:30 M004 Bad Neighbours 2014 Spanish 97
C004 Joffrey Cinemas [email protected] B014 4, Hound Avenue,Baelish,Winterfell-6937 98457376 S035 JB10 88 SS70 9/3/14 11:00 M005 The Fault in our Stars 2014 English 126
C004 Joffrey Cinemas [email protected] B014 4, Hound Avenue,Baelish,Winterfell-6937 98457376 S035 JB10 88 SS71 9/4/14 12:30 M002 The Expendables 3 2014 English 126
C004 Joffrey Cinemas [email protected] B015 25,Shae Rd, Targaryen,Winterfell-5633 98745623 S036 JB11 79 SS72 9/1/14 18:00 M003 The Hundred-Foot Journey 2014 French 122
C004 Joffrey Cinemas [email protected] B015 25,Shae Rd, Targaryen,Winterfell-5633 98745623 S036 JB11 79 SS73 9/3/14 11:00 M001 Guardians of the Galaxy 2014 English 121
mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected]