RESID EMPID ROOM FNAME LNAME UA100 145A Brightly UA100 1 Grand Ave UA349 START END BLDG ADDRESS Brittany 2020-01-09 2020-01-09 Baldor 1 Grand Ave 101 Brittany Brightly 2020-01-13 2020-01-14 Baldor 2020-01-05 2020-01-05 MS 2020-02-01 2020-02-07 MS 2020-02-14 2020-02-16 Baldor 2020-01-20 2020-01-21 Baldor 1 Grand Ave 85 John Low 5 Grand Ave UA852 345 Ben Cuervas 5 Grand Ave UA978 101 Mac 1 Grand Ave UA349 145A John 100 200 300 350 400 475 Apple Low 1. First, start by identifying each of the functional dependencies between the attributes. 2. Determine which attributes represent the primary keys and any alternate keys if any are present. 3. Determine whether or not the table is presently in third normal form. 4. Demonstrate how you could encounter insertion, deletion, and modification anomalies on the table provided above. 5. Demonstrate the process of normalization for this table. Clearly represent the entities in first (1NF), second (2NF), and third (3NF) normal form. Briefly describe what was accomplished at each level of normalization. 6. Submit an entity relationship (ER) diagram of the schema in third normal form (3NF) and create these tables within DB2. Submit your SQL with the appropriate constraints.
RESID EMPID ROOM FNAME LNAME UA100 145A Brightly UA100 1 Grand Ave UA349 START END BLDG ADDRESS Brittany 2020-01-09 2020-01-09 Baldor 1 Grand Ave 101 Brittany Brightly 2020-01-13 2020-01-14 Baldor 2020-01-05 2020-01-05 MS 2020-02-01 2020-02-07 MS 2020-02-14 2020-02-16 Baldor 2020-01-20 2020-01-21 Baldor 1 Grand Ave 85 John Low 5 Grand Ave UA852 345 Ben Cuervas 5 Grand Ave UA978 101 Mac 1 Grand Ave UA349 145A John 100 200 300 350 400 475 Apple Low 1. First, start by identifying each of the functional dependencies between the attributes. 2. Determine which attributes represent the primary keys and any alternate keys if any are present. 3. Determine whether or not the table is presently in third normal form. 4. Demonstrate how you could encounter insertion, deletion, and modification anomalies on the table provided above. 5. Demonstrate the process of normalization for this table. Clearly represent the entities in first (1NF), second (2NF), and third (3NF) normal form. Briefly describe what was accomplished at each level of normalization. 6. Submit an entity relationship (ER) diagram of the schema in third normal form (3NF) and create these tables within DB2. Submit your SQL with the appropriate constraints.
Chapter14: Introduction To Swing Components
Section: Chapter Questions
Problem 10PE
Related questions
Question
I am needing help in understanding Question 4. Please provide step by step explanation of each of the anomalies. Thank you
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning