SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

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

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 314 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 21 Dec 2017 My Price 10.00

oneunnormalized relation using all of the attributes

I need with unnormalize relations. Thank you for your help.

  •  

    Create oneunnormalized relation using all of the attributes from your relations.  Do not use your current tables as individual UNF tables.  All attributes for the entire database must be in one relation.  None can be added along the way except if you are breaking down non-atomic fields.  Use the appropriate brackets and braces to represent non-atomic fields and their subparts, multivalued attributes, and derived values.  At this point, do not mark any primary keys.  

    Next, you are to normalize your relations.  For each relation explain what you had to do to insure 1NF, then 2NF, and then 3NF.  Show the tables as they change for each step through normalization.  Even if a table does not change from one normal form to the next, it must be shown in each step.  This is tedious and time consuming but not hard.  If you find you are missing an attribute, go back and add it to the UNF and make corrections to the work you have done on the other normal forms.  Place a comment before the UNF to let me know you have added a field and why.

    Make sure you only do what is appropriate for each normal form.  DO NOT use intuition or gut feelings.  Follow the rules and nothing more!

     

     

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 21 Dec 2017 07:12 AM My Price 10.00

-----------  ----------- 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

Not Rated(0)