Homework Solution: The Gill Art Gallery wishes to maintain data on the sales of their paintings. The art ga…

    The Gill Art Gallery wishes to maintain data on the sales of their paintings. The art gallery buys and sales paintings so it is conceivable that they could sale the same painting twice. Normalize the Gill Art Gallery Sales Database as represented in sample data below.
    CustName CustPhone ArtistId ArtistName ArtTitle ArtMedium SaleDate SalePrice
    James 206-284-6783 03 Channing Laugh with Teeth Oil 9/17/2020 7000.00
    Greene 449-243-8765 15 Frings South toward the Sea Water Color 5/11/2021 1800.00
    James 206-284-6783 03 Channing At the Movies Acrylic 4/12/2020 5550.00
    Davis 515-636-9874 15 Frings South toward the Sea Water Color 8/11/2022 9500.00
    Identify functional dependencies. {These are your business rules – in this case, you will want to make those rules by looking the data – some questions include – How will you identify customers, works of arts and their artists? - Can artists have more than one work of art? Can customers buy more than one work of art? Normalize the listing – with just attribute names into 3NF.

    Expert Answer

     
    customer [ custno, cust_street, cust_city, cust_prov, cust_pstlcd, cust_phone]

    The Gill Vocation Gallery wishes to support basis on the sales of their paintings. The vocation gallery subsidizes and sales paintings so it is conceivable that they could sale the selfselfsame painting twice. Normalize the Gill Vocation Gallery Sales Basisbase as represented in pattern basis beneath.

    CustName CustPhone ArtistId ArtistName ArtTitle ArtMedium SaleDate SalePrice
    James 206-284-6783 03 Channing Laugh with Teeth Oil 9/17/2020 7000.00
    Greene 449-243-8765 15 Frings South inland the Sea Water Color 5/11/2021 1800.00
    James 206-284-6783 03 Channing At the Movies Acrylic 4/12/2020 5550.00
    Davis 515-636-9874 15 Frings South inland the Sea Water Color 8/11/2022 9500.00

    Realize negotiative dependencies. {These are your vocation rules – in this instance, you succeed neglect to gain those rules by looking the basis – some questions embody – How succeed you realize customers, results of vocations and their vocationists? – Can vocationists entertain further than single result of vocation? Can customers subsidize further than single result of vocation?

    Normalize the listing – with harmonious attainment names into 3NF.

    Expert Defense

     

    customer [ custno, cust_street, cust_city, cust_prov, cust_pstlcd, cust_phone]

    3NF:

    cust_vocation [ custno, phsingle enumerate,artist_id, sale_date, appraisement ]

    vocation [ vocation_title, vocation_medium,artist_id(FK) ]

    artist [ vocationist_id, vocationist_name ]