Dbms qustions

1.What is DBMS? Advantages of DBMS.

2.Structure of a DBMS. Basic component of DBMS.

3.Advantages of DBMS.

4.Define the term RELATION. Compare DBMS and RDBMS.

5.Define and explain with one example of each DML,DCL,DDL.

6.Three level architecture of DBMS.

7.Explain data independence along with logical independence and physical Independence.

8.Explain the term views and how views are important in maintanence of security

9.Write short note on the following:
a.Trigger, b.Cursors, c.Embeded SQL, d.4GL, e.OODBMS, f.OORDBMS

10.Data model.

11.Explain with brief and with examples about the various data model.

12.ERD draw:
a.HOSPITAL, b.UNIVERSITY, c.COLLEGE, d.AIRLINES, e.COMPANY,
f.MEDICAL STORE, g.NEWSPAPER PUBLICATION, h.LIBRARY,
i.PROJECT MAINTANENCE, j.INVENTORY(Stack Maintanence),
k.HOTEL MANAGEMENT

13.Explain the term PRYMARY KEY, FORIEGN KEY,CANDIDATE KEY,
ALTERNATE KEY,SUPER KEY.

14.Explain the term cardinality and types of cardinality.

15.Explain Functional dependency and Multivalued dependency with example.

16.12 CODD rules.

17.Differential between weak and strong entitiy. How weak entites are Implemented? 18.Define aggregation and explain with example.

19.Explain Generalization and Specialzation with example.

20.What are the various anamolies in DBMS. Explain each of them with an example.

21.What is Normalization and what are the advantages of Normalization?

22.Explain 1NF,2NF,3NF,BCNF with proper example.

23.Compare and contrast 3NF and BCNF. “If a database is in BCNF then it is also in 3NF”-prove.

24.Provide an example where a database is in 3NF but not in BCNF.

25.Index sequential file organization.

26.Direct acess file organization.

27.Normalize the following table upto BCNF.