Answered step by step
Verified Expert Solution
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.
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 # | 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 |
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
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