Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.Find all violations of entity and referential integrities. Customers customer # name address1 address2 state str balance 456 ABC Corp. 111 Any St. Houston TX

1.Find all violations of entity and referential integrities.

Customers
customer # name address1 address2 state str balance
456 ABC Corp. 111 Any St. Houston TX 6.25 34560.65
457 DEF CORP 222 ANYWHERE DR. NEW YORK NY 6.50 2145.90
458 GHI CORP. 5 SOMEPLACE CT MIAMI FL 6.45 45670.75
459 JKL CORP. 56 SOME DR. BRYAN TX 6.25 21009.50
460 MNO CORP. 7 NOPLACE CIR. SAN DIEGO CA 5.50 4561.00
INVOICE-ITEMS
INVOICE # ITEM# DESC PRICE QTY
1001 121 WIDGET 2.25 45
1001 540 BOLT .40 25
1002 211 GEAR 3.70 10
1003 121 WIDET 2.25 15
1003 121 WIDGET 2.25 10
1006 348 NUT 0.25 5
INVOICES
INVOICE# DATE CUSTOMER# AMOUNT
1001 11-1-95 456 450.75
1002 11-2-95 457 560.25
11-2-95 460 300.10
1003 11-2-95 459 890.25
1004 11-3-95 450 425.50

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_2

Step: 3

blur-text-image_3

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

The Law And Economics Of Patent Damages, Antitrust, And Legal Process

Authors: James Langenfeld, Frank Fagan, Samuel Clark

2nd Edition

1800710259, 9781800710252

More Books

Students also viewed these Accounting questions