Sheet “1”

1-A Database Management System (DBMS) is a set of programs that enables you to store, modify, and extract information from a database

2-1.A program to debit or credit an account. 2. A program to add a new account. 3. A program to find the balance of an account. 4. A program to generate monthly statements.

n 3- Database Applications:

l Banking: transactions

l Airlines: reservations, schedules

l Universities: registration, grades

l Sales: customers, products, purchases

l 4- Storage manager is a program module that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system.

a- select employee-name from works where company-name _ .First Bank Corporation.

b- select e.employee-name, city from employee e, works w where w.company-name = .First Bank Corporation. and
w.employee-name = e.employee-name

c- select * from employee where employee-name in
(select employee-name from works where company-name = .First Bank Corporation. and salary À 10000)

d- select e.employee-name from employee e, works w, company c where e.employee-name = w.employee-name and e.city = c.city and
w.company -name = c.company –name

e- select P.employee-name from employee P, employee R, manages M where P.employee-name = M.employee-name and
M.manager-name = R.employee-name and
P.street = R.street and P.city = R.city

f- select employee-name from works where company-name __ .First Bank Corporation.

g- select employee-name from works where salary _ all
(select salary from works where company-name = .Small Bank Corporation.)

h- select T.company-name from company T where (select R.city from company R where R.company-name = T.company-name) contains (select S.city from company S
where