IGNOU Solved Assignments Introduction to DBMS

Question 1: Produce an E-R diagram, which documents the entities and relationships involved in the Assets Management System of an Organisation. Create a relational schema to hold the necessary information. Identify the tables, perform normalisation to the tables and fully implement the code with necessary validations using MS-Access/DBASE or any other similar package. Provide necessary documentation and coding for the project.
Note: Assumptions can be made wherever necessary

Ans:

In this question just we have to perform two task, (1) Er. Diagram and second is normalization of data base.

Here we are taking the employer as a full time or part time as a simple assets management system.

ER. Diagram:

Here we have the table type in such a given bellow:

Normalization-I

Employee (Emp_no, name, Date_of_birth)
Full_Time (empl_no_salary)
Part time (Empl_no, type)
Faculty (Emp_no, Degree, Interest)
STAFF (Empl_no, Hour_rate)
Teaching (Emp_no, stipend)

This is the first normalization from this form is also called Flat file.

2nd Nor malization:

A relation is said to be in 2NF. If it is in 1 NF and non-key attributes are functionality dependent on the key attributes.

3rd Normalization: