Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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

Database Technology And Management Computers And Information Processing Systems For Business

Authors: Robert C. Goldstein

1st Edition

0471887374, 978-0471887379

More Books

Students also viewed these Databases questions