Submitted by: Submitted by Tiro
Views: 126
Words: 886
Pages: 4
Category: Business and Industry
Date Submitted: 03/12/2013 07:00 AM
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...