際際滷

際際滷Share a Scribd company logo

439 presentation

Download as PPT, PDF
Adove Pun
Adove Pun

The document describes the entities, attributes, and relationships for a database model of a jazz festival. The entities include musical acts, musicians, stages, vendors, items, staff members, locations, and more. Relationships connect entities like musical acts to performances, staff members to locations, and vendors to the items they sell. Data types are identified for attributes such as names stored as varchar and dates stored as datetime. Primary and foreign keys are specified to link entities together.

1 of 17
Download to read offline
Jazz Fest Tim Parker & Rabin Pun
439 presentation
439 presentation
439 presentation
439 presentation
439 presentation
Musician (Id, Name) MusicalActStaffMember (Id, Name, Title, *MusicalActId) Stage (Id, Name, *LocationId) Stage_Staff (*StageId, *EventStaffMemberId) EventStaff (Id, Name, DOB, Duty) Stage Id - int, primary key Name - varchar(50) LocationId - int, foreign key
Stage_Staff (*StageId, *EventStaffMemberId) EventStaffMember (Id, Name, DOB, *EventStaffMemberDutyId) EventStaffMemberDuty (Id, WorkDescription, PayRate) EventStaffMember Id - int, primary key Name - varchar(50) DOB - datetime Duty - int, foreign key
Vendor_Sells_Item (*VendorId, *ItemId) Item (Id, Name, *ItemTypeId) ItemType (Id, Category) Item Id - int, primary key Name - varchar(50) ItemTypeId - int, foreign key
Logical Model Vendor (Id, Name, *LocationId, *VendorTypeId) VendorType (Id, Description) Vendor_Sells_Item (*VendorId, *ItemId) Item (Id, Name, *ItemTypeId) ItemType (Id, Category) VendorStaffMember(Id, Name, DOB, *VendorId) Patron (TicketNumber, DateTimeArrived) Patron_Access_VIP(*PatronTicketNumber, *VIPAreaId) VIPArea (Id, Name, *LocationId) VIPArea_Provides_Item (*VIPAreaId, *ItemId) VIPArea_Staff (*VIPAreaId, *EventStaffMemberId) PerformanceDetails (Id, StartTime, EndTime, *StageId) MusicalAct_PerformanceDetails (*PerformanceDetailsId, *MusicalActId) MusicalAct (Id, Name, Genre) MusicalAct_Contains_Musican (*MusicalActId, *MusicianId) Musician (Id, Name) MusicalActStaffMember (Id, Name, Title, *MusicalActId) Stage (Id, Name, *LocationId) Stage_Staff (*StageId, *EventStaffMemberId) EventStaffMember (Id, Name, DOB, *EventStaffMemberDutyId) EventStaffMemberDuty (Id, WorkDescription, PayRate) TicketBooth (Id, Location) TicketBooth_Staff (*TicketBoothId, *EventMemberStaffId) Location (Id, CoordinateX, CoordinateY)
Meta-data Vendor (Id - int, primary key, Name - varchar(50), LocationId - int, foreign key, VendorTypeId - int, foreign key) VendorType (Id - int, primary key, Description, varchar(50)) Vendor_Sells_Item (VendorId - int, foreign key, ItemId - int, foreign key) Item (Id - int, primary key, Name - varchar(50), ItemTypeId - int, foreign key) ItemType (Id - int, primary key, Category - varchar(50)) VendorStaffMember (Id - int, primary key, Name - varchar(50), DOB - datetime, VendorId - int, foreign key) Patron (TicketNumber - int, primary key,, DateTimeArrived - datetime) Patron_Access_VIP (PatronTicketNumber - int, foreign key, VIPArea - int, foreign key) VIPArea (Id - int, primary key, Name - varchar(50), LocationId - int, foreign key) VIPArea_Provides_Item (VIPAreaId - int, foreign key, ItemId - int, foreign key) PerformanceDetails (Id - int, primary key, StartTime - datetime, EndTime - datetime) MusicalAct_PerformanceDetails (PerformanceDetailsId - int, foreign key, MusicalActId - int, foreign key) MusicalAct (Id - int, primary key, Name - varchar(50), Genre - varchar(50)) MusicalAct_Contains_Musician (MusicalActId - int, foreign key, MusicianId - int, foreign key Musician (Id - int, primary key, Name - varchar(50)) MusicalActStaffMember (Id - int, primary key, Name - varchar(50), Title - varchar(50), MusicalActId - int, foreign key) Stage (Id - int, primary key, Name - varchar(50), LocationId - int, foreign key) EventStaffMember (Id - int, primary key, Name - varchar(50), DOB - datetime, Duty - int, foreign key) EventStaffMemberDuty (Id - int, primary key, WorkDescription - varchar(50), PayRate - double, units = dollars($)) EventStaff_Works_Location (EventStaffId - int, foreign key, LocationId - int, foreign key) TicketBooth (Id - int, primary key, LocationId - int, foreign key) Location (Id - int, primary key, CoordinateX - int, CoordinateY int)
439 presentation
$1.00
$5.00
$10.00
$20.00
439 presentation

More Related Content

439 presentation

  • 1. Jazz Fest Tim Parker & Rabin Pun
  • 7. Musician (Id, Name) MusicalActStaffMember (Id, Name, Title, *MusicalActId) Stage (Id, Name, *LocationId) Stage_Staff (*StageId, *EventStaffMemberId) EventStaff (Id, Name, DOB, Duty) Stage Id - int, primary key Name - varchar(50) LocationId - int, foreign key
  • 8. Stage_Staff (*StageId, *EventStaffMemberId) EventStaffMember (Id, Name, DOB, *EventStaffMemberDutyId) EventStaffMemberDuty (Id, WorkDescription, PayRate) EventStaffMember Id - int, primary key Name - varchar(50) DOB - datetime Duty - int, foreign key
  • 9. Vendor_Sells_Item (*VendorId, *ItemId) Item (Id, Name, *ItemTypeId) ItemType (Id, Category) Item Id - int, primary key Name - varchar(50) ItemTypeId - int, foreign key
  • 10. Logical Model Vendor (Id, Name, *LocationId, *VendorTypeId) VendorType (Id, Description) Vendor_Sells_Item (*VendorId, *ItemId) Item (Id, Name, *ItemTypeId) ItemType (Id, Category) VendorStaffMember(Id, Name, DOB, *VendorId) Patron (TicketNumber, DateTimeArrived) Patron_Access_VIP(*PatronTicketNumber, *VIPAreaId) VIPArea (Id, Name, *LocationId) VIPArea_Provides_Item (*VIPAreaId, *ItemId) VIPArea_Staff (*VIPAreaId, *EventStaffMemberId) PerformanceDetails (Id, StartTime, EndTime, *StageId) MusicalAct_PerformanceDetails (*PerformanceDetailsId, *MusicalActId) MusicalAct (Id, Name, Genre) MusicalAct_Contains_Musican (*MusicalActId, *MusicianId) Musician (Id, Name) MusicalActStaffMember (Id, Name, Title, *MusicalActId) Stage (Id, Name, *LocationId) Stage_Staff (*StageId, *EventStaffMemberId) EventStaffMember (Id, Name, DOB, *EventStaffMemberDutyId) EventStaffMemberDuty (Id, WorkDescription, PayRate) TicketBooth (Id, Location) TicketBooth_Staff (*TicketBoothId, *EventMemberStaffId) Location (Id, CoordinateX, CoordinateY)
  • 11. Meta-data Vendor (Id - int, primary key, Name - varchar(50), LocationId - int, foreign key, VendorTypeId - int, foreign key) VendorType (Id - int, primary key, Description, varchar(50)) Vendor_Sells_Item (VendorId - int, foreign key, ItemId - int, foreign key) Item (Id - int, primary key, Name - varchar(50), ItemTypeId - int, foreign key) ItemType (Id - int, primary key, Category - varchar(50)) VendorStaffMember (Id - int, primary key, Name - varchar(50), DOB - datetime, VendorId - int, foreign key) Patron (TicketNumber - int, primary key,, DateTimeArrived - datetime) Patron_Access_VIP (PatronTicketNumber - int, foreign key, VIPArea - int, foreign key) VIPArea (Id - int, primary key, Name - varchar(50), LocationId - int, foreign key) VIPArea_Provides_Item (VIPAreaId - int, foreign key, ItemId - int, foreign key) PerformanceDetails (Id - int, primary key, StartTime - datetime, EndTime - datetime) MusicalAct_PerformanceDetails (PerformanceDetailsId - int, foreign key, MusicalActId - int, foreign key) MusicalAct (Id - int, primary key, Name - varchar(50), Genre - varchar(50)) MusicalAct_Contains_Musician (MusicalActId - int, foreign key, MusicianId - int, foreign key Musician (Id - int, primary key, Name - varchar(50)) MusicalActStaffMember (Id - int, primary key, Name - varchar(50), Title - varchar(50), MusicalActId - int, foreign key) Stage (Id - int, primary key, Name - varchar(50), LocationId - int, foreign key) EventStaffMember (Id - int, primary key, Name - varchar(50), DOB - datetime, Duty - int, foreign key) EventStaffMemberDuty (Id - int, primary key, WorkDescription - varchar(50), PayRate - double, units = dollars($)) EventStaff_Works_Location (EventStaffId - int, foreign key, LocationId - int, foreign key) TicketBooth (Id - int, primary key, LocationId - int, foreign key) Location (Id - int, primary key, CoordinateX - int, CoordinateY int)
  • 13. $1.00
  • 14. $5.00