Normalize table 3nf , Database Management System

Normalize the following tables 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.

Employee = Empid + Empname + SSN + Empadd + Empphone + DOB + Sex + DateHired + Lastdateworked + Averrating + WordProc + Typing + Filing + Bookkping + Steno + Availcode

Client = Clid + Clname + Cladd + Clphone + Contact + BillingYTD + PaymentYTD

Job = Job# + Jobtitle + Startdate + Expectenddate + Dailyrate + Dailyhours + Reporttoname + Reporttoadd + Reporttophone + Jobstatus + Clid*

Invoice = Invoice# + Invoicedate + Oldbal + Totcharges + Newbal + Totpaid + Clid*

Payroll = Check# + Paydate + Gross + Fed + Fica + State + Local + Net + Grossytd + Netytd + Fedytd + Ficaytd + Stateytd + Localytd + Empid*

Job-Employee = Job# + Empid + Ratername + Ratingdate + Emprating

Assumptions:


1. Employee address depends on employee phone.

2. Reporttoadd depends on Reporttophone.

3. Dailyrate depends on Jobtitle.

4. Net depends on combination of Gross, Fed, Fica, State, Local

5. Netytd depends on Grossytd, Fedytd, Ficaytd, Stateytd, Localytd

6. Newbal depends on Oldbal, Totcharges.

7. Net, Netytd, Grossytd, Fedytd, Ficaytd, Stateytd, Localytd are calculated fields.

8. Newbal is sum of oldbal and totcharges.

9. We would normally want the Reporttoadd with the Job record. Similarly, the Dailyrate is a piece of information that is integral to a Job record.

Posted Date: 3/12/2013 2:40:09 AM | Location : United States







Related Discussions:- Normalize table 3nf , Assignment Help, Ask Question on Normalize table 3nf , Get Answer, Expert's Help, Normalize table 3nf Discussions

Write discussion on Normalize table 3nf
Your posts are moderated
Related Questions
Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

Explain the utilities which help the DBA to manage the database? Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion wit

Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows: σ AGE The resu

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu

Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th