problem 1) Answer all the problems.
i) Briefly describe is DBMS?
ii) What is Atomicity?
iii) describe the roles of DBA?
iv) prepare down the difference between strong and weak entity set.
v) What is specialization? How it differs from generalization?
problem 2) What is data abstraction? Describe the various level of data abstraction.
problem 3) What is data model? describe all types of data model with diagram.
problem 4) What is ER diagram? Describe with suitable diagram.
problem 5) Answer all the problems.
i) What is domain?
ii) What is primary key?
iii) prepare down the difference between candidate key and super key.
iv) What is NULL?
v) Give names of five aggregate functions.
problem 6) What are relations? Describe all kinds of relations.
problem 7) What are predicates? Describe join predicates with appropriate ex.
problem 8) Give various advantage of SQL.