Need both questions answered for full five stars. Will give a lot of points as w

Question

Need both questions answered for full five stars. Will give a lot of points as well. Question is as follows.

Present the relational schema mapped from the EER model shown in Figure 1. As for your reference, the descriptions of the parking lot problem is illustrated below (from exercise 12.13 and 13.11). A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. The majority of parking spaces are under cover and each can be allocated for use by a member of staff for a monthly rate. Parking spaces that are not under cover are free to use when available. Covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor's vehicle license number. An ER model for the question 2 of assignment 1 is shown in Figure 2. Please present the relational schema mapped from this ER model.

Explanation / Answer

//Relatioanl schema for parkinglot....

Staff(staffNo, Name, extensionTelNo)

Primary Key staffNo

ParkingLot(parking_LotName, location, capacity, noOfFloor)

Primary Key parking_LotName

Covered(spaceNo, staffNo, monthlyRate, parking_LotNo)

Primary Key spaceNo

Foreign Key parkingLotNameRefernces ParkingLot(parking_LotName)

Foreign Key staffNo References Staff(staffNo)

Uncovered(spaceNo, staffNo, parkingLotName)

Primary Key spaceNo

Foreign Key parkingLotNameRefernces ParkingLot(parking_LotName)

Foreign Key staffNo References Staff(staffNo)

Books ( staffNo, spaceNo, dateRequired, visitorVLicenseNo)

Primary Key staffNo, spaceNo

Foreign Key staffNo references Staff(staffNo)

Foreign Key spaceNo references Covered(spaceNo)

=======================================================================

//Relational schema for b....

Movie(movieID,Title,Duration,Type,MovieSeqNo)

Primarykey movieID

Foreignkey MovieSeqNO references Schedule(MovieSeqNO)

TimeSlot(SlotID,SlotDate,StartTime,EndTime,Price,Attendence,MovieSeqNO)

Primarykey SlotID

Foreignkey MovieSeqNO references Schedule(MovieSeqNO)

Schedule(MovieSeqNo,MovieID,SlotID)

Primarykey (MovieID,SlotID)

Screen(ScreenNo,Capacity,TheatreID,SlotID)

Primarykey ScreenNO

Foreignkey TheatreID references to Theatre(TheatreID)

Foreignkey SlotID references to TimeSlot(SlotID)

Theatre(TheatreID,TheatreName,Location,ScreenNO)

Foreignkey ScreenNO references to Screen(ScreenNO)

Primarykey TheatreID

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.