Fundamentals of Database Management

1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls?

2. With a necessary example explain (i) Basic Constructs of E-R Modeling (ii) E-R Notations.

3. Explain the first 3 Normal Forms taking the help of an un-normalized relation and reducing it to 3 NF.

4. Explain the concept of Data Mining? How it is related with data warehouse.

5. Write the SQL queries using Data Manipulation Language (DML) statements.

a. Insert values into student table with field names using insert command
b. Display the table student using select command
c. Update student address in student table using update command.
d. Delete a row from student table

6. Create the payroll database considering table employee.

a. Do simple queries on the above database.
     i. list all information of the above both tables.
     ii. list the empno, ename, jobtitle,and hiredate of employee from the employee table.
b. list the name, salary of the employees who are clerks.
c. list the name,job,salary of every employee joined on certain date. (say ‘december 17,1980')
d. list name and annual salary of all the employees.
e. list the employees who have salary between certain range (say between Rs. 1000 & 2000)