A. Complete the following task by working on a local MS SQL Server
1. Create all the main tables using SQL. (Remember to show all your SQL scripts and the finished tables as stated in the instructions).
2. Create all the lookup tables using SQL.
3. Populate data on all the relevant tables (Car, Inspector, Driver, Rental, Return).
4. Populate data on all the relevant tables (Car, Inspector, Driver, Rental, Return).
5. Write a query that will return all the rentals placed between the following dates . 6. Write a query that selects all the rentals placed by Bud Barnes.
7. Write a query that displays all the returns for the car make Toyota.
8. Write a query that counts the number of rentals that were placed for the car make Hyundai.
9. Write a query to update the Model of the car with the CarNo FOR001 from Fiesta to “Focus. 10. Write a query that will display the CarNo, Driver Name, Rental Fee, Start Date, End Date and Availability of all available rentals.
11. Write a query that will show a list of the available car makes in the database use the DISTINCT command. 12. Write a query that will determine the cars which will need service soon. If a car’s kilometres travelled is 9000 kilometres away from the service kilometres that would indicate that the car would need to get a service soon.
B. Migrate the database that you have created above to Windows Azure Online Platform.
For this section you need to submit the following evidence:
BEN02 Planning and Presenting a Micro-Enterprise Idea BTEC Level 1/2
Read MoreBTEC Unit 35: Engineering Services Delivery Plan for Sector-Specific Organizations | HND Level 5 Assignment 2
Read MoreTQUK Level 3 Administering Medication and Monitoring Effects in Adult Care Assignment
Read MoreUnit 10: 3D Modelling and Assembly Drawing for Vice – Engineering Design Portfolio BTEC Level 3
Read MoreWhy is it important that you correlate the appropriate information of the patient when they arrive for their appointment?
Read MoreNCFE Level 3 Roles and Responsibilities in Health And Social Care
Read MoreMP3395 Turbocharger Performance Evaluation and System Analysis CW2 Assessment, AY2024-25
Read MoreKey Research Policies and Funding Models at University of Strathclyde
Read MoreCIPD Level 5 Associate Diploma Key Assessment Questions
Read MoreLaw Assignment Questions Critical Legal Analysis & Solutions
Read More