PERSONNEL PersonlD Name (LName, OH MName, |FName) Phone Hire Date MgrNum |PType D H G FOUSEKEEPING GUIDE # JHKID {Assigned Condos) Family GuideID Level CertDate CertRenewDate Optional many is Okay Or, create a family member ID GuestID Fname Relationship Birthday [Age) CLEANING CondolD DateCleaned HKID Optional many is Okay CONDO GUEST "RESERVATION CondolD BldgNum UnitNum SqrFt Bdrms Baths WeeklyFee + GuestID LName FName Address Street, City, State) Phone SpouseFName ResID OcGuestID ActID GuideID InvoiceID ORDate NumberinParty TotalCost] Optional many is Okay BOOKING optional BookID CondolD Ocl GuestID StartDate EndDate [TotalFeePaid] = ACTIVITY INVOICE ActID Description Hours PPP Distance Type InvoiceID BookID CondolD #GuestID InvoiceDate (CondoFee] [ActivityFee] [Invoice Total] iSales Tax] Grand Total) Condold is optional If there is no link to Guest, Guestin is also optional CIS 365 - Business Database Systems HW4 - Convert FamCation Resort EERD to Relations (70 Points) Convert FamCation Resort EERD into Relations 1

Subject:Computer SciencePrice:12.86 Bought8

Share With

PERSONNEL PersonlD Name (LName, OH MName, |FName) Phone Hire Date MgrNum |PType D H G FOUSEKEEPING GUIDE # JHKID {Assigned Condos) Family GuideID Level CertDate CertRenewDate Optional many is Okay Or, create a family member ID GuestID Fname Relationship Birthday [Age) CLEANING CondolD DateCleaned HKID Optional many is Okay CONDO GUEST "RESERVATION CondolD BldgNum UnitNum SqrFt Bdrms Baths WeeklyFee + GuestID LName FName Address Street, City, State) Phone SpouseFName ResID OcGuestID ActID GuideID InvoiceID ORDate NumberinParty TotalCost] Optional many is Okay BOOKING optional BookID CondolD Ocl GuestID StartDate EndDate [TotalFeePaid] = ACTIVITY INVOICE ActID Description Hours PPP Distance Type InvoiceID BookID CondolD #GuestID InvoiceDate (CondoFee] [ActivityFee] [Invoice Total] iSales Tax] Grand Total) Condold is optional If there is no link to Guest, Guestin is also optional CIS 365 - Business Database Systems HW4 - Convert FamCation Resort EERD to Relations (70 Points) Convert FamCation Resort EERD into Relations 1. Follow data integrity constraint requirements 2. Transforming from EERD to relations via the 7-step process. You DON'T need to show the process step by step, just show the final result. 3. Draw the diagram with links from foreign keys to other entities similar to the example below. Underline and bold the primary key. Underline foreign keys with a dotted line. If the foreign key is also a primary key of the entity, only bold and underline the attribute with a solid line. CUSTOMER Customer CustomerName Customer Address Customer City Customer State Customer Postal Code ORDER OrderID OrderDate CustomerID ORDER LINE OrderID ProductID Ordered Quantity PRODUCT ProductID ProductDescription ProductFinish Product Standard Price ProductLineID 4. Cluster logically related entities on one page, but turn in ONE pdf document. Page 1: Personnel, Housekeeping, Guide, Condo, Cleaning Page 2: Guest, Family, Condo, Booking, Invoice Page 3: Guest, Guide, Reservation, Activity, Invoice