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
Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

We define a view in SQL through using the create view command. To describe a view, we must provide the view a name and must state the query in which computers the view. The form of

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

There are a number of possible solutions to the open ended brief. One of the simple ones is shown here without the PKs and FKs. It is important to think of how a number of tasks

Describe the storage structure of indexed sequential files and their access method. Ans: Index offers a lookup capability to rapidly reach the vicinity of the desired record.

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

How can you connect to the MySQL Server? In order to connect to the MySQL server it is necessary to give the username and password so this be able to done with The following

In object oriented design, which steps must designer take to adjust inheritance? To readjust inheritance following steps should be taken: i)  Rearrange and adjust the classe

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat