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 17:00, silvijaaa
The two main ways in which marketers address the competition with their strategies are by satisfying a need better than a competition and by
Answers: 2
image
Computers and Technology, 23.06.2019 01:30, giannav57
How do you set up a slide show to play continuously, advancing through all the slides without requiring your interaction? a. click set up slide show, and then select the loop continuously until ‘esc' and show without narration options. b. click set up slide show, and then select the loop continuously until ‘esc' and use timings, if present options. c. click set up slide show, and then select the show presenter view and use timings, if present options. d. click set up slide show, and then select the show without animation and browsed at a kiosk (full screen) options.
Answers: 3
image
Computers and Technology, 23.06.2019 01:40, littlebirdd987
You have a linux system that has a 1000gb hard disk drive, which has a 90gb partition containing an ext4 filesystem mounted to the / directory and a 4gb swap partition. currently, this linux system is only used by a few users for storing small files; however, the department manager wants to upgrade this system and use it to run a database application that will be used by 100 users. the database application and the associated data will take up over 200gb of hard disk space. in addition, these 100 users will store their personal files on the hard disk of the system. each user must have a maximum of 5gb of storage space. the department manager has made it very clear that this system must not exhibit any downtime as a result of hard disk errors. how much hard disk space will you require, and what partitions would you need to ensure that the system will perform as needed? where would these partitions be mounted? what quotas would you implement? what commands would you need to run and what entries to /etc/fstab would you need to create? justify your answers.
Answers: 3
image
Computers and Technology, 23.06.2019 15:30, PlzNoToxicBan
The song about casey jones a railroad engineer who gives his life on the job would most likely gall under the folk song category of? a-work song b-nonsense song c-religious song d-ballad
Answers: 1
Do you know the correct answer?
Consider the following database schema (primary keys are underlined) and SQL queries: Hotel (hotel...

Questions in other subjects: