Question 2 36 Marks Question Based Section 2 Block 2 Assesses Ability Transform Relational Q43821718
Question 2 (36 marks)
This question is based on Section 2 of Block 2. It assesses yourability to transform a relational representation into an E–Rconceptual model.
For the relational model below, give the correspondingentity–relationship diagram showing the relationships with theircardinality and participation conditions, the corresponding entitytype definitions, and the constraints. An entity type should not beused to represent a relationship.
relational model EventPlanner
Domains EventCodes = {e0001…e9999}
VenueCodes = {v01…v99}
CatererCodes = {ca01…ca99}
EntertainerCodes = {en01…en99}
CustomerCodes = {cu0001…cu9999}
InvoiceCodes = {0001…9999}
Dates Times = {0:00…23:59}
PeopleCount = {1…9999}
PriceBands = {economy, midprice, luxury}
EntertainerTypes = {singer, band, magician, comedian}
Names = string relation Event EventCode: EventCodes CustomerCode:CustomerCodes Date: Dates
StartTime: Times
EndTime: Times NumberOfPeopleExpected: PeopleCount VenueCode:VenueCodes
CatererCode: CatererCodes primary key EventCode
foreign key VenueCode references Venue foreign key CatererCodereferences Caterer
relation Venue VenueCode:VenueCodes Capacity: PeopleCount PriceBand: PriceBands primary key VenueCode constraint
((project Venue over VenueCode) difference
(project Event over VenueCode)) is empty relation CatererCatererCode: CatererCodes MaximumNumberOfPeopleCanCaterFor:PeopleCount PriceBand: PriceBands
primary key CatererCode
3
relation Entertainer
EntertainerCode: EntertainerCodes Name:Names EntertainerType:EntertainerTypes primary key EntertainerCode
relation EntertainedBy EventCode: EventCodes EntertainerCode:EntertainerCodes primary key (EventCode, EntertainerCode) foreignkey EventCode references Event foreign key EntertainerCodereferences Entertainer
relation Invoice
InvoiceCode: InvoiceCodes EventCode: EventCodes DatePresented:Dates primary key InvoiceCode alternate key EventCode foreign keyEventCode references Event
Expert Answer
Answer to Question 2 (36 marks) This question is based on Section 2 of Block 2. It assesses your ability to transform a relational…
OR