Database Implementation: Based on the normalized database relations above,

create the following SQL queries.

Write SQL queries to create a 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 statement 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. Using a join. Write the query that retrieves the student who has visited the CS Lab more than any one else.

Write thequery that retrieves the tutors who gets paid the most by the CS Lab. Write a query that retrieves the tutor who get lowest hourly rate pay. Write the 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

Transcribed Image Text:

date of hire Bdate weekly hours worked Ssn title LName Coordinate FName Employee can only be one Emplid phone# Address Hour rate Tutors Description tutor -N Title Courses Date of visit Hours Credit Name Course visiting for Tutee visit Time IN Time out Reason for visit LName Name FName Serial Number Manufacturer laptop Phone# Student Loans Books Email Address Emplid BookID Authors Title Employee PK Emplid Ssn LName FName Date of hire Bdate weekly hours worked Title Phone# Address Hour Rate Student PK Emplid FK Serial Number FName LName Phone# Email Address Tutee's visit tutee's visit Date of visit Time In Time Out Course visiting for FK Emplid E FK Emplid S PK PK Course Name Title Course Description Credit Hours Title Books BookID Authors tutee's visit Date of visit Time In Time Out Course visiting for PK BookID Title Authors Books FK Emplid Title Course PK Course Name Description Credit PK Emplid FName Hours FK Emplid Student Laptops PK Serial number LName Phone# Email Address Name manufacturer date of hire Bdate weekly hours worked Ssn title LName Coordinate FName Employee can only be one Emplid phone# Address Hour rate Tutors Description tutor -N Title Courses Date of visit Hours Credit Name Course visiting for Tutee visit Time IN Time out Reason for visit LName Name FName Serial Number Manufacturer laptop Phone# Student Loans Books Email Address Emplid BookID Authors Title Employee PK Emplid Ssn LName FName Date of hire Bdate weekly hours worked Title Phone# Address Hour Rate Student PK Emplid FK Serial Number FName LName Phone# Email Address Tutee's visit tutee's visit Date of visit Time In Time Out Course visiting for FK Emplid E FK Emplid S PK PK Course Name Title Course Description Credit Hours Title Books BookID Authors tutee's visit Date of visit Time In Time Out Course visiting for PK BookID Title Authors Books FK Emplid Title Course PK Course Name Description Credit PK Emplid FName Hours FK Emplid Student Laptops PK Serial number LName Phone# Email Address Name manufacturer