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