Produce some sample tables for these relations that observe the relational integrity rules. Suggest some general constraints that would be appropriate for this schema. Student should provide some sample tables, observing entity and referential integrity. In particular, ensure the uniqueness for the composite primary keys of the Room and Booking tables.
What will be an ideal response?
There can be no two bookings for the same room in the same hotel on the same day.
For the Booking relation, dateFrom must be before dateTo.
Room price must be greater than 0 and less than £200.
You might also like to view...
A(n) ________ displays the user information from the PowerPoint Options dialog box, the current date, and blinking insertion point
Fill in the blank(s) with correct word
C:\Users\Tony\Documents\Notes\memo.txt is an example of a(n) ________
Fill in the blank(s) with correct word
Each object in an Access database application displays at the left side of the Access window in the ____.
A. Pinned space B. Navigation Pane C. Objects Bar D. Objects Tab
A workstation is not booting correctly. The technician wants to locate bad sectors and recover readable information. Which of the following commands would the technician use?
A. chkdsk c: /f B. chkdsk c: /i C. chkdsk c: /c D. chkdsk c: /r