Identify functional dependencies. (These are your business rules-in this case, you will want to make those...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
1.Record The Preceding Transactions In The General Journal, In The Given Order. (Do Not Round Intermediate Calculations. Round Your Final Answers To The Nearest Whole Dollar Amount. If No Entry Is...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
A carefully crafted vision statement can help you communicate your company's goals to employees and management in a single sentence or a few concise paragraphs. While a well-thought-out statement may...
-
11. Which one is not a source for collecting references? Ans : O Proquest Ebscohost O Scopus Safe assign
-
Consider air flowing past a hemisphere resting on a flat surface, as in Fig. P8.99. If the internal pressure is pi, find an expression for the pressure force on the hemisphere. By analogy with Prob....
-
For the directed graph G = (V, E) in Fig. 7.12, classify each of the following statements as true or false. (a) Vertex c is the origin of two edges in G. (b) Vertex g is adjacent to vertex h. (c)...
-
How do you classify I.C. engines ?
-
Merrill Corp. has the following information available about a potential capital investment: Initial investment ..........$1,600,000 Annual net income .......... $ 250,000 Expected life ............ 8...
-
Manufacturing cost data for Crane Company, which uses a job order cost system, are presented below. Indicate the missing amount for each letter. Assume that in all cases manufacturing overhead is...
-
For R, partition the data sets into 60% training and 40% validation and implement the 10-fold cross-validation. Use the statement set. seed(1) to specify the random seed for data partitioning and...
-
3045 Use the information in the financial statements to compute the following ratios: 4300 (a) Return on assets (total assets at December 31, 2016, was $200,000) Numerator:/Denominator:=Return on...
-
A test requires that you answer first Part A and then either Part B or Part C. Part A consists of 7 true/false questions, Part B consists of 9 multiple choice questions with one correct answer out of...
-
Consider two mutually exclusive projects A and B: Project Co Cash Flows (dollars) G C NPV at 10% A -33,000 23,400 B -53,000 36,000 23,400 36,000 +$ 7,612 +9,479 a. Calculate IRRS for A and B. Note:...
-
Discuss or reflect on ways in which provocative issues related to one's professional perspectives and beliefs might be explored without eroding co-educator collegiality and school spirit.?
-
Verify that the following function is a probability mass function, and determine the requested probabilities [Give exact answers in form of fraction.] f(x) = (7/8) (1/8)*, x = 0,1,2,... (a) P(X = 2)...
-
What are your thoughts about having the client be the expert and not the therapist? Identify a barrier that might make it difficult to implement the solution-focused model with the client described...
-
Calculate the molarity of NaOH in the solution prepared by dissolving it's 4g in enough water to Porm 250 mL of solution.
-
Graph one period of each function. y = 4 cos x
-
Tom has a successful business with $100,000 of income in 2012. He purchases one new asset in 2012, a new machine which is 7-year MACRS property and costs $25,000. If you are Tom's tax advisor, how...
-
Van makes an investment in a partnership in 2012. Van's capital contributions to the partnership consisted of $30,000 cash and a building with an adjusted basis of$70,000, subject to a nonrecourse...
-
Olive Corporation was formed and began operations on January 1, 2012. The corporation's income statement for the year and the balance sheet at year-end are presented below. The corporation made...
-
If the angle between vectors \(\vec{A}\) and \(\vec{B}\) is \(110^{\circ}\) and if \(A=1.7 \mathrm{~N}\) and \(B=2.0 \mathrm{~m}\), what is the value of \(\vec{A} \cdot \vec{B}\) ?
-
You throw a textbook to a friend who is at their dormitory window \(2.2 \mathrm{~m}\) above you. You are standing \(4.0 \mathrm{~m}\) away from the building and your throw is perfectly made such that...
-
A traveller walks \(30 \mathrm{~m}\) along a train platform, dragging their suitcase behind them using a strap attached to the top. The traveller's hand is \(0.25 \mathrm{~m}\) above the top of the...
Study smarter with the SolutionInn App