keep the "yourname" part the same, this is just practice work

you can choose any values and any two cities you like sir

Trimester 1 2020-2021 (2010) DOB City SALESREP Your Name Sales Rep.No Rep Name HireDate 654 734 345 434 CUSTOMER Your Name Cust. Ne CustName 9870 8590 7840 4870 Sales RepNo Balance 345 434 654 345 1. Create a database with your name. Your database name must be yourname_yearstudent ID(1 Mark) 2. Create tables with appropriate referential integrity constraints. Add your student ID with table name (8 Marks) 3. Insert all records into the respective tables. For the empty values, you can choose any values you like (4 Marks) 4. Display sales RepNo, RepName who are 25 years old and above (2 Marks) Display all information of customers who live in any two cities (2 Marks) 6. Show the average balance of all customers group by sales representative number (Marks) 7. Display all information in the table CUSTOMER about customers whose CustName starts with the letter M (2 Marks) * Display all information in the table CUSTOMER about the customer whose customer number is 8590.2 Marko Display only the name of the sales representative and the name of the customer where average balance of the customer is more than 400 Marks) 10. Display the names of sales representatives who joined before 01/01/2020. (2 Marks) 11. Display the customer name who has the minimum balance (2 Marks) End of questions Describe each table as Proof