Question: 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 -
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. 1) The sample data provided below from the CIT113_Project_1.accdb database is included in one table, SESSION. Put the data in this table into 3rd normal form (3NF). SESSION X SESSION_ID 51 Functional Dependencies are: 53 STUDENT JO STUDENT NAME. DATE Smith Smith Davis Jones Davis STI STUDENT_ID-> STUDENT_NAME, TOPIC TUTOR_ID -> TUTOR_EMAIL SESSION_ID-> DATE, ROOM, STUDENT, TUTOR, BOOK USED 571 ST2 ST4 ST2 TOPIC 8/2/2021 FIN 8/4/2021 501 3/6/2021 ACC 206-284-6783 515-636-9874 8/3/2021 FIN 1/2/2021 SQL TUTOR_ID 3 Channing 15 Frings 3 Channing 15 Frings TUTI TUTS TUTS TUT1 TUTS ROOM BOOK 629 Deumlich 631 Murphy 632 Deumlich 629 Deumlich 621 Murphy 2) The Gill Art Gallery wishes to maintain data on the sales of their paintings. The art gallery buys and sells paintings, so it is conceivable that they could sell the same painting twice. Normalize the Gill Art Gallery Sales Database as represented in sample data below. SALES X CUST_NAME- CUST_PHON- ARTIST_ID ARTIST_NAMART TITLE ART_MEDIUI James 206-284-6783 Laugh with Tee Oil Green 449-243-8768 South Toward 1 Water Color At the Movies Acrylic James Davis South Toward 1 Water Color TUTOR EMAIL tut1@cicillinois.edu tut3@cicillinois.edu tut)@cicillinois.edu tutl@claillinois.edu tuts@cicillinois.edu SALE DATE SALE_PRICE- 9/17/2020 $7,000.00 5/11/2021 $1,800.00 4/12/2020 $5,550.00 8/11/2022 $9,500.00
Step by Step Solution
3.39 Rating (143 Votes )
There are 3 Steps involved in it
To normalize the given list of attributes into Third Normal Form 3NF we need to follow the normalization process starting with 1NF through to 2NF and then to 3NF The purpose of normalization is to eli... View full answer
Get step-by-step solutions from verified subject matter experts
