Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Examine the sample data for these tables. Check for entity, referential, and column integrity. Identify any data-integrity violations. Assume that all date columns should have
Examine the sample data for these tables. Check for entity, referential, and column integrity. Identify any data-integrity violations. Assume that all date columns should have a date format and all amount (cost) columns should have a number format. Primary key refers to CLIENTS id first_name last_name 100 Antonio Peters 45 Mary Collins Sarika Patel 19 Ivan Balazs Primary key phone_num email 555-1891 apeters@yahoo.com 662-2275 383-4572 sari@patel.com 777-5511 ibalazs@aol.com Foreign Key Foreign Key EVENTS name description cost id 15 date 22-Apr client_id theme_code 100 BB 800.00 Peter's graduation Collins wedding 17 12-Mar 2gs 45 TROP Cocktail hour followed by dinner 25 Garden party 400.00 45 TROP Collins rehearsal dinner Day before wedding 01-May 50 Black-tie affair 1200.00 77 SIXT Elks Club annual fundraiser refers to Primary key THEMES code description CARN Carnival SIXT Sixties TROP Tropical O CLIENTS table Entity integrity: ID for Sarika Patel should not be null. EVENTS TABLE Column integrity: Cost for Collins wedding (event id = 17) is not numeric. Column integrity: Date for Collins rehearsal dinner (event id = 25) is not a valid date format. Referential integrity: There is no client 77 in the CLIENTS table (event id = 50). O CLIENTS table Entity integrity: ID for Sarika Patel should not be null. EVENTS TABLE Column integrity: Cost for Collins wedding (event id = 17) is not numeric. Column integrity: Date for Collins rehearsal dinner (event id = 25) is not a valid date format. Referential integrity: There is no client 77 in the CLIENTS table (event id = 50). Referential integrity: There is no theme corresponding to "BB" in the THEMES table (event id = 15). O CLIENTS table .Entity integrity: ID for Sarika Patel should not be null. EVENTS TABLE Column integrity: Cost for Collins wedding (event id = 17) is not numeric. Column integrity: Date for Collins rehearsal dinner (event id = 25) is not a valid date format. Referential integrity: There is no theme corresponding to "BB" in the THEMES table (event id = 15). O CLIENTS table Entity integrity: ID for Sarika Patel should not be null. EVENTS TABLE Column integrity: Cost for Collins wedding (event id = 17) is not numeric. Referential integrity: There is no client 77 in the CLIENTS table (event id = 50). Referential integrity: There is no theme corresponding to "BB" in the THEMES table (event id = 15)
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