Question 1:
Illustrate out the concept of Foreign Key. How a foreign key distinct from the Primary Key? Can the Foreign Key accept nulls?
Question 2:
With an essential example illustrate out (i) Basic Constructs of E-R Modeling (ii) E-R Notations.
Question 3:
Illustrate the first three Normal Forms taking the use of an un-normalized relation and reducing it to 3 NF.
Question 4:
Illustrate out the concept of the Data Mining? How it is related with the data warehouse.
Question 5:
Write down the SQL queries by using Data Manipulation Language (DML) statements.
Question 6:
Make the payroll database considering table employee.