Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Q1. Consider a relational database regarding hotels, customers (or guests) and their bookings which is maintained by an online hotel booking company. The database comprises of the given tables (primary keys are underlined):

Hotel (hId, hName, hAddress, hCity)
Guest( gId, gName, gAddress, gCity)
Room( hid, roomNo, type, price )
Booking(gId, hId, roomNo, fromDate, year, noOfDays)

Here, hId and gId are identifiers for the hotels and guests and the Booking relation points out that a guest booked a hotel room for a specified number of days (noOfDays) starting from Date of a given year. For instance, a tuple < g12345, h5555, 220, Jan05, 2005, 8 > in Booking points out that guest g12345 booked room 220 of the h5555 hotel for 8 days starting on Jan 5, 2005.

A) prepare down a relational algebra expression which returns the ids of the hotels located in the Vancouver which were not booked at all in year 2005.

B) prepare down a relational algebra expression which returns the ids of the guests who have booked at least one room of type “suite” in every hotel situated in Vancouver.

C) prepare down a Tuple Relational Calculus (TRC) query which finds the ids and names of the hotels for which every one of our guests had made a booking throughout the year 2004.

Q2. Differentiate between the term RDBMS and DBMS.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M910259

Have any Question? 


Related Questions in DBMS

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Create a database to keep inventory of something you own

Create a database to keep inventory of something you own, such as books, CDs, movies, collectibles, etc. You can make these up if you want. (You could use this in real life to keep track of what other people have borrowe ...

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

Save a copy of the tal distributors database located within

Save a copy of the TAL Distributors database located within the Shared Files of the course. You will use this copy to create indexed fields in your database. The current TAL Distributors database only has a few customers ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Unlimited pickers is a group of workers who have joined

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to l ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen