Assume That Firedup Has Created A Database With The Following Tables Customer Customersk Name Phone Emailaddress S 1 (409.7 KiB) Viewed 29 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!