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

Query 1list all movies played in landmark or music box

Query 1 List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates. Query 2 List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, la ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

Movie theater database entity-relationship modeldevelop a

Movie Theater Database: Entity-Relationship Model Develop a Microsoft Access database based upon the below Entity Relationship Model. Be sure to include tables, fields, keys, relationships, and data in your database. You ...

1 draw and explain erm diagram andnbsp explain what is

1. Draw and explain ERM diagram and  explain what is REM 2. Explain what is Normalization . what is 0NF,1NF, 2NFand ,3NF and explain what is in the tables Entity Relationship Modeling and Normalization: 1 System Analysis ...

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, ...

Assignmentcreate a simple excel spreadsheet with data to

Assignment Create a simple excel spreadsheet with data to update the database. 1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wiz ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

Problem iyoull be happy to know that we made a strong case

Problem I "You'll be happy to know that we made a strong case to manage¬ment that we should hire a new systems analyst to specialize in ecommerce development," says Al Falfa, a systems analyst for the multi-outlet intern ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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