Identify the foreign keys in this schema. Explain how the entity and referential integrity rules apply to these relations.
What will be an ideal response?
For each relation, the primary key must not contain any nulls.
Room is related to Hotel through the attribute hotelNo. Therefore, the hotelNo in Room should
either be null or contain the number of an existing hotel in the Hotel relation. In this case study, it
would probably be unacceptable to have a hotelNo in Room with a null value.
Booking is related to Hotel through the attribute hotelNo. Therefore, the hotelNo in Booking
should either be null or contain the number of an existing hotel in the Hotel relation. However,
because hotelNo is also part of the primary key, a null value for this attribute would be
unacceptable. Similarly for guestNo. Booking is also related to Room through the attribute
roomNo.
You might also like to view...
Most classes need to be imported before they can be used in an app. Why is every app allowed to use classes System and String without first importing them?
What will be an ideal response?
?
Referring to the figure above, which of the following aspects of responsive design does the figure show?
A. testing with an emulator B. implementing a shim C. progressive enhancement D. responsive navigation
What are the three major virtual disk file types, and how do they differ?
What will be an ideal response?
Who among the following has final approval of all requests for changes in project scope, budget, and schedule?
a. The steering team b. The systems analyst c. The project manager d. The project sponsor