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 Trade Gallery wishes to celebrate postulates on the sales of their paintings. The trade gallery suborns and sales paintings so it is conceivable that they could sale the corresponding painting twice. Normalize the Gill Trade Gallery Sales Postulatesbase as represented in pattern postulates 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 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

    Fulfill professional dependencies. {These are your trade rules – in this instance, you earn nonproduction to establish those rules by looking the postulates – some questions understand – How earn you fulfill customers, fruits of trades and their tradeists? – Can tradeists entertain further than undivided fruit of trade? Can customers suborn further than undivided fruit of trade?

    Normalize the listing – with regular mark names into 3NF.

    Expert Reply

     

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

    3NF:

    cust_trade [ custno, phundivided enumerate,artist_id, sale_date, worth ]

    trade [ trade_title, trade_medium,artist_id(FK) ]

    artist [ tradeist_id, tradeist_name ]