Computers and Technology, 05.06.2020 21:09 keyshawn437

The following tables form part of a database held in a relational DBMS:- Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName, guestAddress)

where

Hotel contains hotel details and hotelNo is the primary key;
Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;
Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key;

and

Guest contains guest details and guestNo is the primary key.

Produce some sample tables for these relations that observe the relational integrity rules. Suggest some general constraints that would be appropriate for this schema.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 16:00

An english teacher would like to divide 8 boys and 10 girls into groups, each with the same combination of boys and girls and nobody left out. what is the greatest number of groups that can be formed?

Answers: 2

Answer

Computers and Technology, 24.06.2019 11:00

These statements describe lists in presentation programs: a. bullets can be turned off and on. b. bullets cannot be turned off. c. bullet styles, colors, and sizes can be changed. d. lists don't have to use bullets or numbers. e. numbering styles, colors, and sizes can be changed. f. numbers can be turned off and on. g. numbers cannot be turned off. select all that apply

Answers: 2

Answer

Computers and Technology, 24.06.2019 18:30

Dereck works for long hours on his computer. he frequently experiences physical strain by the end of the day because he does not follow an important rule of ergonomics with respect to the use of keyboards. which of the following actions of dereck could lead to physical strain? a. placing the keyboard exactly in front of him while typingb. keeping hands and wrists straight while typingc. using wrist pads throughout the dayd. pounding at the keys on the keyboard while typinge. resting his hands on the keyboard when he is not typing

Answers: 1

Answer

Computers and Technology, 24.06.2019 21:30

Write an algorithm to check if a number is even or odd and show with flow chart step by step

Answers: 2

Answer

You know the right answer?

The following tables form part of a database held in a relational DBMS:- Hotel (hotelNo, hotelName,...

Questions