ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 4 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 23 May 2017 My Price 9.00

efer to class lectures and Lynda video

1. Normalize the table below in TABLE 1. You don’t have to show each step of normalization but need to show the final table structure. You have to decompose this table into different tables using the first three normal forms. (Refer to class lectures and Lynda videos for help)
TABLE 1

Employee Name

Home Address

Work Address

Home Phone

Work Phone

Skills

John Doe

123 Levick St, Philadelphia, PA 19123

23 Penn Dr, Edison NJ 08506

212-345-2334

214-548-5489

Java, C++, C#

Mary Jane

45 Welsh Road, Philadelphia, PA 19152

102 Commerce Dr, Philadelphia, PA 19123

145-589-6866

875-965-5428

Ruby, Python, Java

The output should be like the example below:
Indicate the primary key as bold and underlined.
Indicate the foreign Keys with an asterisk (*)
There will few more tables remaining so add the remaining tables and submit your assignment on Angel

EMPLOYEES

ADDRESSES

EmployeeID

FirstName

LastName

1

John

Doe

2

Mary

Jane

AddressID

AddressType

Address1

Address2

City

State

Zip

EmployeeID*

1

Home

123 Levick St

NULL

Philadelphia

PA

19123

1

2

Home

45 Welsh Road

NULL

Philadelphia

PA

19152

2

3

Work

23 Penn Dr

NULL

Edison

NJ

08506

1

4

Work

102 Commerce Dr

NULL

Philadelphia

PA

19123

2

Answers

ComputerScienceExpert
(11)
Status NEW Posted 23 May 2017 04:05 AM My Price 9.00

-----------

Attachments

file 1495516241-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)