Answered step by step
Verified Expert Solution
Question
1 Approved Answer
describe the tables when done 654 Sales Rep.No RepName HireDate DOB Saeed 11:23 2020 22.5.2002 734 John 20/5/2019 9/2 2000 345 Conor 2/3/2020 10 3/1993
describe the tables when done
654 Sales Rep.No RepName HireDate DOB Saeed 11:23 2020 22.5.2002 734 John 20/5/2019 9/2 2000 345 Conor 2/3/2020 10 3/1993 434 Dustin 17/8/20195 8. 1990 SALESREP Abdulrahman CUSTOMER_Abdulrahman Custo CustName City SalesRepNo Balance 9870 Ahmed Muscat 345 330 8590 Hakimi Cyberjaya 434 700 7840 Mansoor Tedda 654 SOO 14870 Hanif Puchong 345 300 1. Create a database with your name. Your database name must be Abdulrahman_1191102403. (I Mark) 2. Create tables with appropriate referential integrity constraints add (119112403) before table name (8 Marks) 3. Display sales RepNo, RepName who are 25 years old and above (2 Marks) 4. Display all information of customers who live in Muscat and Cyberjaya (2 Marks) 3. Show the average balance of all customers group by sales representative number. (Marks) 6. Display all information in the table CUSTOMER about customers whose CustName starts with the letter "M. 2 Marks) 7. Display all information in the table CUSTOMER about the customer whose customer number is 8590.2 Marks) 8. Display only the name of the sales representative and the name of the customer where average balance of the customer is more than 400. (3 Marks) 9. Display the names of sales representatives who joined before 01 01/2020. Marks) 10. Display the customer name who has the minimum balance. (2 Marks) End of questions Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started