Normalization-e-r mapping , Database Management System

Normalize the following table upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the tables. No need for E-R, mapping, relationships etc. Just tables. State all assumption, logic, and reasoning, to explain your work.

Assumptions:

1. Each project has a unique name, but names of employees and managers are not unique.

2. Each project has one manager, whose name is stored in Projmgr.

3. Many employees may be assigned to work on each project, and an employee may be assigned to more than one project. Hours tells the number of hours per week that a particular employee is assigned to work on a particular project.

4. Budget stores the amount budgeted for a project, and Startdate gives the starting date for a project.

5. Salary gives the annual salary for an employee.

6. Empmgr gives the names of the employee's manager, who is not the same as the project manager.

7. Empdept gives the employee's department. Department names are unique. The employee's manager is the manager of the employee's department.

8. Rating gives the employee's rating for a particular project. The project manager assigns the rating at the end of the employee's work on that project.

Posted Date: 3/12/2013 2:38:02 AM | Location : United States







Related Discussions:- Normalization-e-r mapping , Assignment Help, Ask Question on Normalization-e-r mapping , Get Answer, Expert's Help, Normalization-e-r mapping Discussions

Write discussion on Normalization-e-r mapping
Your posts are moderated
Related Questions
Question : Mr. Smith Harry has a car manufacturing company which has recently integrated management information system. He wishes to obtain more information on ethics and socia

The ER diagram clearly showing the additional tables you have implemented. SQL table creation scripts for the tables you have set up. SQL scripts showing the sample data you

Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

What is the use of group by clause?  Group  by  clause  is  used to apply  aggregate  functions  to a  set  of  tuples. The attributes given in the group by clause are used to

PART MARKING: For this section, we will use part marking. This means we will supply model answers to all questions but we will only mark six questions. We will choose these randoml

how to solve the C type problems?

Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

sir we want er diagram of bank management system in this main menu option as new account,deposit amount,withdraw amount,all acount holder list,modify account,close account

ERD Diagram of Medical Recruitment Agency?