Database Implementation: Based on the normalized database relations above, create the following SQL queries. Write SQL queries
Question:
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
Statistics Unlocking The Power Of Data
ISBN: 9780470601877
1st Edition
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock