Business

QUESTION 1

a) SELECT price, type

FROM room

WHERE hotelno =

(SELECT hotelno

FROM hotel

WHERE hotelname = 'Grosvenor');

b) SELECT (guestno, guestname, guestaddress)

FROM guest, booking, hotel

WHERE guest.guestno =booking.guestno AND

hotel.hotelno = booking.hotelno AND

(datefrom <= ‘SYSTEM DATE’

AND dateto >= ‘SYSTEM DATE’) AND

hotelname = ‘Grosvenor’);

c) SELECT (r.hotelno, r.roomno, r.type, r.price)

FROM room r, hotel h

WHERE r.hotelno = h.hotelno AND

h.hotelname = 'Grosvenor’ AND

roomno NOT IN

(SELECT roomno

FROM booking b, hotel h

WHERE (datefrom <= ‘SYSTEM DATE’

AND dateto >= ‘SYSTEM DATE’)

AND b.hotelno=h.hotelno

AND hotelname = 'Grosvenor');

Question

DISTRIBUTED DATABASE SYSTEM ARCHTECTURE (MASCOM)

NETWORKK

NETWORK

SERVER 2

SERVER 1

SITE 3

NETWORK

NEWORK

SITE 1

SITE 2

Distributed database

A major objective of distributed databases is to provide ease of access to data for users at many different locations. To meet this objective, the distributed database system must provide location transparency, which means that a user (or user program) using data for querying or updating need not know the location of the data.

QUESTION 3

a) PROFESSOR

Name

Address

Course

Section

Class

Sex

STUDENT

studName

Address

Course

Section

Class

DOB

Sex

Name

LName s

MiddleName s

FName s

Stud_id int

Address

StreetNo s

StreetName s

Apartment s

City s

State s

Country s

DOB

Month s

Date s

Year int

b)

Room

RoomNo

SectionName

CourseName

prof_Id

Course

CourseName

Faculty

Module

ModuleCode

Class

Section

SectionNo

SectionName

Prof-Id

RoomNo

c)

* Section

SectionNo

SectionName

Prof-Id

RoomNo

1

Course

CourseName

ModuleCode

ClassNo

SectionName

M...