Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume the following relations: : Customer (Cust ID LName, FName, Address, CardType, Credit CardNo, Expiration Date, Security Code) Cust 10 LName FName Address Credit Card

image text in transcribed

Assume the following relations: : Customer ("Cust ID LName, FName, Address, CardType, Credit CardNo, Expiration Date, Security Code) Cust 10 LName FName Address Credit Card No Expiration Date 1000 1001 1002 1003 Thomas Trump Smith Flint Abayomi Akcje Susan Stane Address 1 Address 3 Address 4 Address 2 CardType DSIC AMEX VISA AMEX 6000 7465 9585 8934 7382 8324 99778438 7488 4738 2323 4323 Jan, 2019 Nov, 2020 July 2021 April 2022 Security Code 873 210 347 773 Product("Prod ID Prod_Name, Current_Price) Prod 10 PRD_75 PRD 12 PRD_14 PRD_09 Prod_Name Hair Gel Shampoo Notebook Olive o Current Price 7.25 4.99 52.95 11.49 Purchases ("Date. *CustID "Prod ID Price) Date CustID 7/11/2010 1003 2/19/2015 1003 4/04/2004 100: 5/09/2016 1003 3/06/2015 1001 Prod 10 PRD 09 PRD 09 PRD 12 PRD 09 PRD 75 Price 8.99 9.45 2.99 10.99 7.45 Q1: Will Deleting the following tuple from the Purchases table violate any relational constraints? (e.g., entity, key, integrity, domain, or semantic) 4/04/2004 1001 PRD 12 2.99 Explain? Q2: Will Deleting the following tuple from the Product table violate any relational constraints? (e.g., entity, key, integrity, domain, or semantic) PRD 12 Shampoo 4.99 Explain? 4/04/2004 1001 PRD 12 2.99 Q3: Will Updating the following tuple from the Customer table violate any relational constraints? (e.g., entity, key, integrity, domain, or semantic) Update "Credit Card No" = "55334 7382 8324" 1002 Smith Susan Address 4 VISA 9937 8438 7488 July, 2021 Explain? 347

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 Systems An Application Oriented Approach Complete Version

Authors: Michael Kifer, Arthur Bernstein, Richard Lewis

2nd Edition

0321268458, 978-0321268457

More Books

Students also viewed these Databases questions

Question

What is DDL?

Answered: 1 week ago