Page 1 of 1

Assume that FiredUp has created a database with the following tables: CUSTOMER (CustomerSK, Name, Phone, EmailAddress) S

Posted: Mon Jun 06, 2022 2:28 pm
by answerhappygod
Assume That Firedup Has Created A Database With The Following Tables Customer Customersk Name Phone Emailaddress S 1
Assume That Firedup Has Created A Database With The Following Tables Customer Customersk Name Phone Emailaddress S 1 (409.7 KiB) Viewed 31 times
Assume that FiredUp has created a database with the following tables: CUSTOMER (CustomerSK, Name, Phone, EmailAddress) STOVE (SerialNumber, Type, Version, DateOfManufacture) REGISTRATION (CustomerSK, SerialNumber, Date) STOVE REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, Customer SK)

R. Show the names and email addresses of all customers who have registered a stove, and who have had the stove repaired. S. Show the names and email addresses of all customers who have registered a stove, but who have not had any stove repaired.