Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 2 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Programming Posted 05 May 2017 My Price 6.00

Consider the following table with the structure tblF

 

Consider the following table with the structure tblFriends(lastName, firstName, address, birthday, phoneNumbers, emailAddresses). If necessary, redesign the table so it satisfies each of the following:

a. 1NF

b. 2NF

c. 3NF

lastName

firstName

address

birthday

phoneNumbers

emailAddresses

Gordon

Alicia

34 Second St.

3/16

222-4343

agordon@mail.com

 

 

 

 

349-0012

 

Washington

Edward

12 Main St.

12/12

222-7121

ewash@mail.com

 

 

 

 

 

coolguy@earth.com

Davis

Olivia

55 Birch Ave.

10/3

222-9012

olivia@abc.com

 

 

 

 

333-8788

 

 

 

 

 

834-0112

 
 
 

Answers

Alpha Geek
(8)
Status NEW Posted 05 May 2017 01:05 PM My Price 6.00

-----------

Attachments

file 1493989489-Answer.docx preview (120 words )
C-----------ons-----------ide-----------r t-----------he -----------fol-----------low-----------ing----------- ta-----------ble----------- wi-----------th -----------the----------- st-----------ruc-----------tur-----------e t-----------blF-----------rie-----------nds-----------(la-----------stN-----------ame-----------, f-----------irs-----------tNa-----------me,----------- ad-----------dre-----------ss,----------- bi-----------rth-----------day-----------, p-----------hon-----------eNu-----------mbe-----------rs,----------- em-----------ail-----------Add-----------res-----------ses-----------). -----------If -----------nec-----------ess-----------ary-----------, r-----------ede-----------sig-----------n t-----------he -----------tab-----------le -----------so -----------it -----------sat-----------isf-----------ies----------- ea-----------ch -----------of -----------the----------- fo-----------llo-----------win-----------g: ----------- a.----------- 1N-----------F -----------b. -----------2NF----------- c-----------. 3-----------NF ----------- la-----------stN-----------ame-----------fir-----------stN-----------ame-----------add-----------res-----------s b-----------irt-----------hda-----------y p-----------hon-----------eNu-----------mbe-----------rse-----------mai-----------lAd-----------dre-----------sse-----------sGo-----------rdo-----------n A-----------lic-----------ia -----------34 -----------Sec-----------ond----------- St-----------. 3-----------/16----------- 22-----------2-4-----------343----------- ag-----------ord-----------on@-----------mai-----------l.c-----------om -----------  -----------  -----------  -----------  ----------- 34-----------9-0-----------012-----------  ----------- W-----------ash-----------ing-----------ton----------- Ed-----------war-----------d 1-----------2 M-----------ain----------- St-----------. 1-----------2/1-----------2 2-----------22------------712-----------1 e-----------was-----------h@m-----------ail-----------.co-----------m
Not Rated(0)