Tables-Introduction to Database Systems-Lab Tasks, Exercises of Introduction to Database Management Systems

Shashi Palam assigned this task for lab of Introduction to Database Systems course at Baddi University of Emerging Sciences and Technologies. It includes: Schema, Tables, Insert, Rows, Listย Price, Type, Greater, Database, System

Typology: Exercises

2011/2012

Uploaded on 07/13/2012

olala
olala ๐Ÿ‡ฎ๐Ÿ‡ณ

4.5

(2)

34 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Lab๎˜ƒTask๎˜ƒ4๎˜ƒ
๎˜ƒ
Consider๎˜ƒthe๎˜ƒfollowing๎˜ƒschema:๎˜ƒ
Hotel๎˜ƒ(hotelno,๎˜ƒhotelname,๎˜ƒcity)๎˜ƒ
Room๎˜ƒ(roomNo,๎˜ƒtype,๎˜ƒprice,๎˜ƒhotelno)๎˜ƒ
Guest๎˜ƒ(guestNo,๎˜ƒguestName,๎˜ƒguestAddress,๎˜ƒroomNo)๎˜ƒ
๎˜ƒ
1. Create๎˜ƒthe๎˜ƒabove๎˜ƒtables.๎˜ƒ
2. Insert๎˜ƒrows๎˜ƒin๎˜ƒthe๎˜ƒabove๎˜ƒmentioned๎˜ƒtable.๎˜ƒ
3. List๎˜ƒthe๎˜ƒprice๎˜ƒand๎˜ƒtype๎˜ƒof๎˜ƒall๎˜ƒrooms๎˜ƒat๎˜ƒthe๎˜ƒGrosvenor๎˜ƒHotel.๎˜ƒ
4. List๎˜ƒthe๎˜ƒrooms๎˜ƒthat๎˜ƒare๎˜ƒcurrently๎˜ƒunoccupied๎˜ƒat๎˜ƒGrosvenor๎˜ƒHotel.๎˜ƒ
5. List๎˜ƒhotel๎˜ƒname,๎˜ƒroom๎˜ƒtype๎˜ƒfrom๎˜ƒthe๎˜ƒabove๎˜ƒschema.๎˜ƒ
6. List๎˜ƒhotel๎˜ƒdetails,๎˜ƒroom๎˜ƒdetails๎˜ƒfrom๎˜ƒthe๎˜ƒabove๎˜ƒtable.๎˜ƒ
7. List๎˜ƒcity๎˜ƒof๎˜ƒhotel๎˜ƒand๎˜ƒroom๎˜ƒnumber๎˜ƒhaving๎˜ƒprice๎˜ƒgreater๎˜ƒthan๎˜ƒ5000.๎˜ƒ
docsity.com

Partial preview of the text

Download Tables-Introduction to Database Systems-Lab Tasks and more Exercises Introduction to Database Management Systems in PDF only on Docsity!

Consider Hotel Room Guest (hotelno, (guestNo,(roomNo, the following hotelname, type,guestName, price, schema: city) hotelno) guestAddress, Lab^ Task roomNo)^4

              1. CreateInsertListListListListList thethehotelhotelcity rows the priceroomsof name,details, hotelabove in and the that androom room tables.typeabove are room typeof currentlydetails mentioned all number fromrooms from unoccupiedthe athaving thetable. above the above Grosvenor price schema. at table. Grosvenorgreater Hotel. than Hotel. 5000. docsity.com