A private club restaurant in California has to maintain members\' table reservat

Question

A private club restaurant in California has to maintain members' table reservations two weeks in advance. The club has to keep past reservations for six months. The above is a simple complete conceptual schema with attribute details. Let us assume that it is correct. (The attribute domain DATE can include descriptions of DATE and/or TIME.) Based on the above conceptual schema, a database designer performed Logical Design and came up with the following Logical Schema: Please review the methods for systematically converting a conceptual schema to a logical schema in class. Please: (a) Describe one error in the above table structures (logical database schema) clearly, (b) Explain why is it an error in more than two sentences. (c) Share your correct logical database schema. Please label your answers ((a), (b), and (c)) clearly. Thank you very much. To answer this particular question, click the link above. Once you are in the forum, click the "Create Thread" button to view the question again, as well as. create and submit your answer.

Explanation / Answer

(a). The two tables given i.e Table1 (with memeber and reservation details), Table2(Table information) are missing the information that how a reservation is linked to a tabel.

(b) It is an error because it is a vital information.Without this how a member will understand that which table is booked in his/her reservation. Also for the resturant management, how will they know that which tables are free for the reservation

(c). Ideally there should be four tables.

     1.Member table (Member ID, Member Name, Member RewardPts)
     2.Reservation table( ReservationDate, ReservationTime, PartySize)
     3.Table table (Table ID, TableNoOfSeats, TableLocDescription)
     4.Status Table ("Member ID", "Reservation ID" and "Table ID")

    The Status table holds the current details of how member, reservation and table are connected together.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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