Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following relational schema and instances: Hotel (hotelNo, hotelName, city) Room( roomNo, hotelNo, Type, price) Booking(hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo, guestName, guestAddress, guestAge)

image text in transcribedimage text in transcribed

Consider the following relational schema and instances: Hotel (hotelNo, hotelName, city) Room( roomNo, hotelNo, Type, price) Booking(hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo, guestName, guestAddress, guestAge) price 19.00 29.00 39.00 58.00 86.00 29.99 59.99 10.00 15.00 18.00 30.00 35.00 single family 501 Hotel Room 8 hotelno hotelname city roomno hotelno type fb01 Grosvenor London 501 f601 single fbO2 Watergate Paris 601 f601 double ch01 Omri Shoreham London 701 f601 family ch02 Phoenix Park London 1001 f602 single dc01 Latham Berlin 1101 fb02 double 1001 ch01 single 1101 ch01 family 701 ch02 801 ch02 double 901 dc01 single 1001 dc01 double 1101 dc01 Booking 7 hotelno guestro datefrom dateto roomno fb01 10001 2004-04-01 2004-04-08 fb01 10004 0000-00-00 2005-05-15 601 fb01 10005 2004-05-01 2004-05-07 501 fb01 10002 2004-05-17 2004-05-29 601 fbO2 10003 2004-04-04 2004-04-10 1001 fbO2 10005 2004-05-12 2004-05-30 1101 cho1 10006 2004-04-21 NULL 1101 cho2 10002 2004-04-25 2004-05-06 801 dc01 10007 2004-05-13 2004-05-15 1001 dc01 10003 2004-05-20 HULL 1001 Guest 8 guestno guestname guestaddress questage 10001 John Kay 56 High St, London 25 10002 Mike Ritchie 18 Tain St, London 30 10003 Mary Tregear 5 Tarbot Rd, Aberdeen 50 10004 Joe Keogh 2 Fergus Dr Aberdeen 28 10005 Carol Farrel 6 Achray St, Glasgow 19 10006 Tina Murphy 63 Well St. Glasgow 40 10007 Tony Shaw 12 Park Pl. Glasgow 20 Consider the following relational schema and instances: Consider the following relational schema: Hotel(hotelNo, hotelName, city) Room( roomNo, hotelNo, Type, price) Booking hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo, guestName, guestAddress, guestAge) And using the document provided by the professor, answer the following question What is the cardinality of the following relational expression? Mcity (Hotel Room Booking))

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB.NET Databases

Authors: Thearon Willis

1st Edition

1594864217, 978-1594864216

More Books

Students also viewed these Databases questions

Question

What is real estate economics in your own words?

Answered: 1 week ago

Question

Find the derivative. f(x) 8 3 4 mix X O 4 x32 4 x32 3 -4x - x2

Answered: 1 week ago