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

Ask an Expert

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

Write your message here..

Related Questions

What is a transaction? and how does it differs from update, wh wh

Incident report to the database, The Form input elements are:           ... The Form input elements are:             Reporter name                                                text type input             Password

Find names of employees, Consider the relations EMP(ENO,ENAME,AGE,BASIC_S... Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep

Modify - referential integrity, Update or Modify operation alters the exist... Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

Subclassing, In the ER diagram, one example of subclassing is depicted foll... 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

Explain sequential file organization, Question 1 What do you mean by datab... Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

What are the advantages of using a dbms, What are the advantages of using a... What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Key to represent relationship between tables is called, Key to represent re... Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

Need for client server computing, Need for Client Server Computing- Client/... Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Selective replication-data replication, Selective replication: This is a c... Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require