Question 1)a) What do you mean by “Databases”? Define and describe it with the help of at least three examples.
b) Briefly describe the various types of databases with the help of appropriate examples.
Question 2) What are significant factors in selecting a file organization? Give a brief discussion on important file organizations.
Question 3) The figure below shows class list of university. Convert this user view to a set of 3NF relations. Assume the following:
a) An instructor has a unique location.
b) A student has a unique major.
c) A course has a unique title.
Question 4)a) What do you understand by referential integrity? Give the basic rules for insertion and deletion that assure referential integrity.
b) What are the main differences between primary key and foreign key? Describe it in detail with the help of appropriate examples.
Question 5) Write a brief note on the following terms:
a) Entity
b) Attributes
c) Cardinality
d) Categorization
Question 6)a) Define logical database model. What are its types? Describe it in detail with the help of appropriate examples.
b) Define physical database design. Describe its major components and objectives in detail.
Question 7) a) Write down steps to create simple form application to maintain information of employees of a company.
b) Describe briefly the four basic components of a report?
Question 8) What do you understand by a report object navigator and object type? Give list of different report object types and their description.
Question 9)a) What do you mean by a form object type? Give list of different object types and their description.
b) Describe some of the important SQL functions with the help of examples.
Question 10) Write a brief note on the following terms:
a) Radio Groups
b) Layout Editor
c) Form Module
d) Conceptual Design