Computers and Technology

Consider the following database schema (primary keys are underlined) and SQL queries: Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName, guestAddress)
1. SELECT r. room No, r. type, r. price FROM Room r, Booking b, Hotel h WHERE r. roomNo = b. room No AND b. hotelNo = h. hotelNo AND h. hotelName = "Ritz" AND r. price > 100;
Given the schema above, consider providing a comparative analysis of a relational DB and an object-oriented DB with respect to:
a. Select queries (you can work on the two queries already provided above)
b. Insert queries (create any one example query)
c. Delete queries (create any one example query)
Your comparative analysis should be supported by the arguments based on how these queries are handled internally by the database engines (RDBMS and OODBMS). • For the object oriented DBs query handling you can provide a pseudocode to support your claim in a more effective way to gain the maximum score).

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 09:40, vanessacasillas452
In the lab, which of the following displayed a list of all installed services and included a description of the service, the current state, and whether the service started automatically or manually? a. the services manager b. the applications summary c. the recommended services d. list the safe services list
Answers: 2
image
Computers and Technology, 22.06.2019 10:30, darrengresham999
Choose the best explanation for the following statement communication is symbolic
Answers: 3
image
Computers and Technology, 24.06.2019 09:00, king514
Technician a says that a new replacement part is always good. technician b says that sometimes recent repair work will be the cause of a complaint. who is correct? a. both technicians a and b b. technician a c. technician b d. neither technician a nor b
Answers: 3
image
Computers and Technology, 24.06.2019 16:30, kjhgfcvb5761
The database design steps are listed below in the incorrect order. choose the correct order number next to each step. determine the information to be stored in the database. determine the fields needed to record the data determine if there will be any repetition of data entered, and separate the fields into tables to normalize the data. create relationships to connect the tables.
Answers: 3
Do you know the correct answer?
Consider the following database schema (primary keys are underlined) and SQL queries: Hotel (hotel...

Questions in other subjects:

Konu
Mathematics, 09.12.2019 18:31