Complete chapters 11 and 12 before doing these exercises. 1. What is normalization? 2. When is a table in 1NF? 3. When is a table in 2NF? 4. When is a table in 3NF? 5. Identify and discuss each of the indicated dependencies in the dependency diagram shown in Figure 12.2. C1 C2 C3 C4 C5 Figure 12.2 For question 5, by A. Watt.
Added by Laurie W.
Close
Step 1
Normalization is a process in database design that organizes data attributes (or columns) and tables (or relations) to minimize data redundancy and improve data integrity. The goal is to divide large tables into smaller, manageable pieces and establish Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 54 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Aarya B.
Akash M.
CBR-ERD The following ERD will be used to answer the questions on this examination. You may reference this image on-screen or download the image so that you can more comfortably scroll in to enhance readability. Please use this ERD when answering all questions. Instructions for A: If a table is already properly normalized, then you do not need to make any modifications to it. Only write down your response to those table(s) that require normalization. Answer the following referring to the CUSTOMER schema. You are to properly normalize the tables to 3NF, allowing customers to have more than one phone number. Format: TableName ([PK] Primary Key, [FK] Foreign Key, Attribute Fields)
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD