CS4600 Manikantta duggishettti

Database theory and applications Central ID 700632568

HW#1

1.1.3

1. Schema definition

2. Storage structure and access-method definition

3. Schema and physical-organization modification

4. Granting of authorization for data access

5. Routine maintenance as to backup the data, free disk space

available

2.12

aperson_name(company_name= Frist Bank Corporation(works))

b) person_name,city(company_name= Frist Bank Corporation(works employee ))

c) person_name,sterrt,city(company_name= Frist Bank Corporation salary > 1000 (works employee ))

2.13

a) loannumber(amount > 10000 (loan))

b) customer_name(balance > 6000 (depositor account))

c) customer_name(balance > 6000 branch_name=Uptown (depositor account))

3.11

a) SELECT DISTINCT name

FROM student NATURAL JOIN takes NATURAL JOIN course

WHERE dept_name = Comp.Sci.;

b) (SELECT ID,name

FROM student NATURAL JOIN takes)

minus

(SELECT ID,name

FROM student NATURAL JOIN takes

WHERE year