Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

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

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

1 . Television News channels importantance of our Life pattern ?

Answered: 1 week ago