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 Tactics Gallery wishes to practise basis on the sales of their paintings. The tactics gallery subsidizes and sales paintings so it is conceivable that they could sale the similar painting twice. Normalize the Gill Tactics Gallery Sales Basisbase as represented in exemplification basis under.

    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 inside 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 inside the Sea Water Color 8/11/2022 9500.00

    Warrant functional dependencies. {These are your employment rules – in this predicament, you succeed failure to create those rules by looking the basis – some questions comprise – How succeed you warrant customers, employments of tacticss and their tacticsists? – Can tacticsists possess past than undivided employment of tactics? Can customers subsidize past than undivided employment of tactics?

    Normalize the listing – with lawful property names into 3NF.

    Expert Repartee

     

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

    3NF:

    cust_tactics [ custno, phundivided compute,artist_id, sale_date, worth ]

    tactics [ tactics_title, tactics_medium,artist_id(FK) ]

    artist [ tacticsist_id, tacticsist_name ]