![subject](/tpl/images/cats/informatica.png)
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.
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 22:30
Who needs to approve a change before it is initiated? (select two.) -change board -client or end user -ceo -personnel manager -project manager
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 23:30
Which of the following is not a symptom of chronic fatigue syndrome
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 05:00
Acompany is inviting design for its new corporate logo from its users. this is an example of ? a. crowdfunding b. crowdvoting c. crowdsourced design d. crowdtracking
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 00:00
Afashion designer wants to increase awareness about her brand. which network can she use and why she can use the blank to blank her products online. answers for the first blank: internet, extranet, or intranet answers for the second blank: market, design, and export
Answers: 1
You know the right answer?
The following tables form part of a database held in a relational DBMS:-
Hotel (hotelNo, hotelName,...
Questions
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 03.12.2021 21:50
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 03.12.2021 21:50
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 03.12.2021 21:50
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/User.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 03.12.2021 21:50
![question](/tpl/images/cats/himiya.png)
Chemistry, 03.12.2021 21:50
![question](/tpl/images/cats/health.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/es.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/User.png)
SAT, 03.12.2021 21:50
![question](/tpl/images/cats/mat.png)