Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions