Saturday, May 27, 2017

PRINCIPLES OF DATABASE DESIGN S4 KTU QUESTION PAPERS I






PART A

1. Define the following terms.

a) Database and DBMS

b) Schema.

c) Role of DBA

PART B

d) Relation schema in relational model.

2. Explain different types of attribute ?

3. Write a note on weak entity with example?

4. Explain data independence and its types?

PART C

5. Describe in detail about the three schema architecture ?

6. Illustrate the 1:N relation with a suitable example?

7. Draw an ER diagram for company schema with structural constraints specified using (min,max) notation ,given entity types EMPLOYEE,DEPARTMENT,PROJECT and DEPENDENT ?

8. Explain the characteristics of relations in relational data model?


Load disqus comments

0 comments

Follow us on Facebook
Powered by: KTU Online