Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the table below. This table is used by an art school that offers art courses to the general public. This table has modifications problems.
Consider the table below. This table is used by an art school that offers art courses to the general public. This table has modifications problems. Customer Phone Course cou Fee Course Amount Date Paid 10/01/2009 $250 206-555-1234 Adv Pastels $500 1. List two cases in which modifying the data will cause inconsistencies (loss of information/incorrect information/redundant information). Ariel Johnson Robin Green 312-555-8860 9/15/2009 | $350 Beg Oils $350 We can remove the problems and ambiguities by creating a separate table for each theme represented in the list. Paul Jackson 306-555-1488 10/1/2009 $500 Adv Pastels $500 206-555-1234 3/15/2009 $350 Int Pastels $350 2. How many themes can you identify? 3. Design an entity corresponding to each theme with its attributes 4. Find or define a key for each entity Ariel Johnson Jeff Parson 212-555-6678 10/1/2009 $500 Adv Pastels $500 Miguel Sears | 770-555-2345 9/15/2009 $350 Beg Oils $350 Draw the ERD for each table and show the primary keys and foreign keys as applicable for each. Leah Kyles 444-555-6666 | 11/15/2009 | $250 Adv Pastels $500 Draw the Crow foot diagram showing the cardinality of each relationships between entities. Solve the M:N relationships by introducing bridge entities. Lynda Myers 509-334-6267 10/15/2009 $0 Beg Oils $350 Consider the table below. This table is used by an art school that offers art courses to the general public. This table has modifications problems. Customer Phone Course cou Fee Course Amount Date Paid 10/01/2009 $250 206-555-1234 Adv Pastels $500 1. List two cases in which modifying the data will cause inconsistencies (loss of information/incorrect information/redundant information). Ariel Johnson Robin Green 312-555-8860 9/15/2009 | $350 Beg Oils $350 We can remove the problems and ambiguities by creating a separate table for each theme represented in the list. Paul Jackson 306-555-1488 10/1/2009 $500 Adv Pastels $500 206-555-1234 3/15/2009 $350 Int Pastels $350 2. How many themes can you identify? 3. Design an entity corresponding to each theme with its attributes 4. Find or define a key for each entity Ariel Johnson Jeff Parson 212-555-6678 10/1/2009 $500 Adv Pastels $500 Miguel Sears | 770-555-2345 9/15/2009 $350 Beg Oils $350 Draw the ERD for each table and show the primary keys and foreign keys as applicable for each. Leah Kyles 444-555-6666 | 11/15/2009 | $250 Adv Pastels $500 Draw the Crow foot diagram showing the cardinality of each relationships between entities. Solve the M:N relationships by introducing bridge entities. Lynda Myers 509-334-6267 10/15/2009 $0 Beg Oils $350
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started