IV. (30 points) Database Implementation: Based on the normalized database relations above, create the following SQL quer

[answerhappygod]

Iv 30 Points Database Implementation Based On The Normalized Database Relations Above Create The Following Sql Quer 1 (55.71 KiB) Viewed 51 times

IV. (30 points) Database Implementation: Based on the normalized database relations above, create the following SQL queries. Write SQL queries to create your CS Lab database. (Include all your relations for the database). Add primary keys for your relations and foreign keys where necessary. Write queries that insert 5 or more records in all your relations you have created above. This means 5 records per relation. • Write simple select statements that retrieves records from the tables without any condition. (1 Select statement per table) Write 1 simple select statements that retrieves records from all the tables using some simple condition. (1 Select statement per table) Write 2 advanced select statements that select data from two or more of your tables. You can use exists, and , join etc. Write a query that retrieves students who have visited the CS Lab more than others. • Write a query that retrieves tutors who get paid more than any other tutor per • Write a query that retrieves tutors who get lowest hourly rate pay. Write a query that calculates and retrieves the average hourly rate of all tutors. • Write 3 update statements that update certain records based on some conditions Write 1 statement that deletes a record from a table based on some condition hour