Answered: 1. Does deleting row [C002] in CUSTOMER…

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 1PSE

See similar textbooks

Related questions

Concept explainers

Question

1. Does deleting row [C002] in CUSTOMER affect referential integrity? Why or why not? Limit your answers to two (2) sentences only.

2. Does deleting row [C005] in CUSTOMER affect referential integrity? Why
or why not? Limit your answers to two (2) sentences only. *

3. Does deleting the last row in ORDERDET affect referential integrity? Why or why not? Limit your answers to two (2) sentences only.

4. Describe how row[3002] in SUPPLIER can be deleted without violating referential integrity. Limit your answers to three (3) sentences only. *

5. Enumerate the candidate keys of SUPPLIER *

6. Enumerate the candidate keys of ITEM

7. Identify the composite candidate key of the table ORDERDET.
example format: x + y [where x and y. are the attributes that must be concatenated to form a unique identifier in ORDERDET]

8. Provide the foreign key definition for the table ITEM. *
example format: FK x references y, nulls [not] allowed

9. Provide the foreign key definition for the table ORDER *
example format: FK x references y, nulls [not] allowed

10. Which of the following are true regarding the real-world scenario depicted through the database? *

a. There is no need to associate a customer with an order.
b. Customer may have multiple orders.
c. All suppliers recorded in the database must supply at least one item.
d. An order may consist of more than one item.
e. No items are manufactured in-house. f. Every item must be provided by some supplier.
g. Every item must be part of an order.

Analyze the sample database below and answer the following questions.
SUPPLIER
suppld
1001
CUSTOMER
custid
C001
CO02
CO03
C004 STEVE PINKMAN
C005
address
J.P. RIZAL, MAKATI CITY
U.N. AVENUE, MANILA
AYALA AVENUE, MAKATI CITY
MUNTINLUPA CITY
PARANAQUE, METRO MANILA
CABUYAO, LAGUNA
sname
GREGORY WHITE
WALTER REDDINGTON
SHERLOCK HOUSE
COLGATE PALMOLIVE
UNILEVER
PROCTER & GAMBLE
1002
1003
1004
3001
3002
NOSNHOC 8 NOSNHOC
PEPSI COLA INC
NESTLE
STEVE PINKMAN
ITEM
itemno
तरूc
JOHNSON'S BABY POWDER
JOHNSON'S BABY OIL
PINOY DECAF
COFFEE-MATE
CREAM SILK MOISTURIZING
PANTENE SHAMPOO
PANTENE CONDITIONER
CREAM SILK DAMAGE REPAIR
LUX SHAMPO0
COLGATE TOOTHPASTE
PINOY TOOTHBRUSH
qtyonhand qtyonorder
111
510
575
215
365
152
0745
825
365
2/8
130
price
suppid
B1
35.00 1004
28.00 1004
65.00
85.00 3002
44.00 1002
25.00
B2
250
0.
0.
0.
75
80
0.
120
C1
C2
IS
S2
S3
54
1003
45.00 1003
40.00
S5
11
12
1002
42.00 1002
55.00
1001
25.00
ORDER
ORDERDET
itemno
podate
Custid
postat
poid
S1
T1
S3
S1
T2
S3
S2
S5
S2
B2
qlyord unitprice
50 40.00
20 53.00
30 40.00
100 65.00
55 85.00
80 45.00
25 42.00
120 42.00
50 25.00
250 28.00
piod
07/21/2010
08/15/2010
09/04/2010
09/04/2010
09/06/2010
1.
2.
CO01
served
CO02 | served
C001 pending
C003 pending
C004 pending
1
1
2.
3.
4
4
N34

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions