ࡱ> ')&7 1bjbjUU .7|7|1l```````t t MMM$ "`M >MMM``=M``M`` `(:Tt2c(0 dtt````Comp2400 Assignment 2 Joseph Curtis: 3952239 Tables...Draft 2 City (CityName)  Hotel (Name, CityName, Address, Telephone, Manager, CityName, NoOfRooms[count(Room.RoomNo)])  Room (RoomNo, HotelName, RoomType, Beds, Smoking)  RoomType (RoomType, MaxOccup)  RoomTarrif (?Single, ?Double, ExtraPerson, HotelName, RoomType) AdvanceBooking (ArrDate, DepDate, Deposit, RoomAll, Persons, HotelName, GuestName)  Guest (Name, Address, Telephone, CreditcardNo, CreditCardType) Allocation (Persons, Date, Reg, RoomNo, GuestName)  ResturauntCharge (Meal, Persons, ChargeType, Amount, Date, RoomNo, GuestName)? Primary Key? TelephoneCharge (TelNo, Time, ChargeType, Amount, Date, RoomNo, GuestName)???? Primary Key? RoomService (Service, Time, ChargeType, Amount, Date, RoomNo, GuestName) .9@HPRTU\`  8ACDLNO %1>*.j5CJOJQJU\^JmHnHsH u5>*OJQJ\^J56OJQJ\]^J5OJQJ\^J5\59>*B*\ph2./0ABRU  CNO 8 $   81&\/01      8 ,1h. A!"#$%  i8@8 NormalCJ_HaJmH sH tH >`> Heading 1$@&5OJQJ\^JB`B Heading 2$@&6CJ(OJQJ]^J8`8 Heading 3$@& 56\]<A@< Default Paragraph Font1./0ABRU  CNO&\/0300(000000000000000000000000000000000001118@(  NB  S D NB  S D NB @ S D NB  S D NB  S D NB  S DNB @ S DNB   S DNB   S DNB   S D NB   S DNB  S DNB  S DNB  S DNB  S D NB  S DNB  S D NB  S D NB  S D B S  ?RS  !"#$1 QmtQ$ tMq tTMtTMP9t I t$ IxtEpat:t Tt\ /l7t@ /dt/t\ /HtH/t/gt / Kt/Kt /Kt3 333-./9@%\]u03 Joseph CurtiseC:\My Documents\UNI\semester 2 2002\comp2400\assignment2\Comp2400 Assignment 2, Table Definitions.doc Joseph CurtisD:\Documents and Settings\Satan Loves You!!!\Application Data\Microsoft\Word\AutoRecovery save of Comp2400 Assignment 2, Table Definitions.asd Joseph CurtisD:\Documents and Settings\Satan Loves You!!!\Application Data\Microsoft\Word\AutoRecovery save of Comp2400 Assignment 2, Table Definitions.asd Joseph CurtisD:\Documents and Settings\Satan Loves You!!!\Application Data\Microsoft\Word\AutoRecovery save of Comp2400 Assignment 2, Table Definitions.asd@1@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New"h+i",i-v20d:2Comp2400 Assignment Joseph Curtis Joseph CurtisOh+'0 ( D P \hpxComp2400 AssignmentompJoseph Curtisnmoseose Normal.dotiJoseph Curtisnm14eMicrosoft Word 9.0@NSI@.T@|7Tv՜.+,0 hp   Virgil & Co.s: Comp2400 Assignment Title  !"#$%(Root Entry FP2:T*1Table WordDocument.SummaryInformation(DocumentSummaryInformation8CompObjjObjectPoolP2:TP2:T  FMicrosoft Word Document MSWordDocWord.Document.89q