Explaining primary key and foreig key-logical database model


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.

773_Class list.jpg

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

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Explaining primary key and foreig key-logical database model
Reference No:- TGS06014

Expected delivery within 24 Hours