Customers (customerNo, firstName, lastName, postalAddress, homeAddress(street number, street name, suburb, post-code, ci

[answerhappygod]

Customers Customerno Firstname Lastname Postaladdress Homeaddress Street Number Street Name Suburb Post Code Ci 1 (122.25 KiB) Viewed 49 times

Customers (customerNo, firstName, lastName, postalAddress, homeAddress(street number, street name, suburb, post-code, city), gender, cardNo, bookingNo, propertyNo, next-To-KinNo, workType) Repair Services (serviceNo, serviceName, serviceType, price) Staff members (staffNo, firstName, lastName, position, gender, dateOfBirth, salary, sectionName, internalTelephoneNo, officeNo, bookingNo) SectionInformation ( sectionNo sectionName, emailAddress, location, telNo, faxNo) SectionTelephone Nos ( sectionTelephonelDTelephoneNo, sectionName) SectionFaxNos ( sectionFaxID FaxNo, sectionName) Courselnvoice courselnvoiceNo, courseNo, serviceNo, serviceName, startDate, endDate, paymentDueDate, amountToBePaid, customerNo, staffNo) Course Details (courseNo, courseName, startDate, endDate, courseFees, instructorNumber, instructorName) Instructor Details (instructorNo firstName, lastName, position, gender, dateOfBirth, salary, internalTelephoneNo, sectionNo, officeNo) AppointmentReservation (appointmentReservationNo, customerno, dateAndTime, staffNo) AppointmentDetails Appointment No, customer No, customerpropertyAddress, staffNo, repair Description, quotation Price) RepairDetails (repairNo, customerNo, dateAndTime, repairer No) Based on the entities, attributes, and primary keys of your solution for Canberra Work Group (CWG) in Part 2 of this Take-Home Assessment paper, Write the following queries using SQL: • List details of all customers from Canberra that have enrolled in a course order by Customer Number. • How many customers from Canberra have enrolled in a course conducted by an instructor with Instructor Number = 12345? • List the number of male staff in each section. • List the first and last name of all female staff that have made an appointment with a customer from Canberra for repair work • What is the average salary of male staff from Canberra?