- At The End Of This Specific Task Students Should Be Able To Use Sql Statements To Create And Change Databases Table 1 (42.8 KiB) Viewed 55 times
At the end of this specific task, students should be able to: . Use SQL statements to create and change databases, tables, and indices . Use the INSERT, UPDATE and DELETE statements to modify the data in a table . Construct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER BY clause . Demonstrate an understanding of database migration a local instance to an Azure SQL database A. Complete the following task by working on a local MS SQL Server. For each task in this section you need to submit copies of all your SQL scripts as well as the results of the scripts (e.g. the query results or the finished tables.) 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).
Car CarNo Car Make Model Body Type Kilometres Travelled HYU001 Hyundai Hatchback 1500 HYU002 Hyundai Hatchback 3000 BMW001 BMW Sedan 20000 BMW002 BMW Sedan 9500 TOY001 Toyota Sedan 15000 TOY002 Toyota SUV 98000 TOY003 Toyota Sedan 15000 MER001 Mercedes c180. Sedan 5200 Benz MER002 Mercedes A200 Sedan Sedan. 4080 Benz The Independent Institute of Education (Pty) Ltd 2022 21, 22, 23 Grand i10 1.0 Motion i20 1.2 Fluid 320d 1.2 240d 1.4 Corolla 1.0 Avanza 1.0 Corolla Quest 1.0 FOR001 Ford Inspector Inspector_no 1101 1102 1103 1104 Driver Fiesta 1.0 Sedan Name Bud Barnes Tracy Reeves Sandra Goodwin Shannon Burke Name Address Gabrielle 917 Heuvel St Botshabelo Clarke Free State 9781 Geoffrey 1114 Dorp St Paarl Western Franklin Cape 7655 Fawn Cooke 2158 Prospect St Garsfontein Gauteng 0042 Darlene 2529 St. John Street Peters Somerset West Western Cape 7110 Vita Soto 1474 Wolmarans St Sundra Mpumalanga 2200 Opal Rehbein 697 Thutlwa St Letaba Limpopo 0870 Vernon 1935 Thutlwa St Letsitele Hodgson Limpopo 0885 Crispin 330 Sandown Rd Cape Wheatly Town Western Cape 8018 Melanie 616 Loop St Atlantis Western Cape 7350 Cunningham Kevin Peay 814 Daffodil Dr Elliotdale Eastern Cape 5118 The Independent institute of Education (Pty) Ltd 2022 21; 22; 23 Rental Inspector Carno HYU001 Bud Barnes HYU002 Bud Barnes FORO01 Bud Barnes BMW002 Tracy Reeves TOY002 Tracy Reeves MERO01 Sandra Goodwin HYU002 Shannon Burke Shannon Burke TOY003 Return Carno Inspector HYU001 Bud Barnes HYU002 Bud Barnes FORO01 Bud Barnes BMW002 Tracy Reeves TOY002 Tracy Reeves MERO01 Sandra Goodwin HYU002 Shannon Burke TOY003 Shannon Burke Service Kilometres 15000 15000 50000 15000 50000 15000 50000 15000 15000 Available yes yes yes yes yes yes yes yes yes 15000 7600 Email Mobile [email protected] 0821585359 [email protected] 0822889988 [email protected] 0837695468 [email protected] 0836802514 Email Mobile [email protected] 0837113269 [email protected] 0847728052 [email protected] 0821966584 [email protected] 0841221244 [email protected]. 0824567924 [email protected] 0826864938 [email protected] 0855991446 [email protected] 0838347945 [email protected] 0827329001 [email protected] 0832077149 Page 4 of 14 2022 yes Page 5 of 14 2022 Rental Fee Start Date End Date Driver Gabrielle Clarke Gabrielle Clarke 2021-08-30 2021-08-31 5000 5000 2021-09-01 2021-09-10 Geoffrey Franklin 6500 2021-09-01 2021-09-10 Vita Soto 7000 2021-09-20 2021-09-25 Darlene Peters 2021-10-03 2021-10-31 5000 8000 Darlene Peters 2021-10-05 2021-10-15 Vernon Hodgson 5000 2021-12-01 2022-02-10 5000 2021-08-10 2021-08-31 Melanie Cunningham Driver Return Date Elapsed Fine Gabrielle Clarke 0 Date 2021-08-31 0 2021-09-10 0 2021-09-10 0 2021-09-30 5 Gabrielle Clarke Geoffrey Franklin Vita Soto Darlene Peters Darlene Peters Vernon Hodgson 0 0 2500 1000 500 0 2021-10-31 2 2021-10-15 1 2022-02-10 0 2021-08-31 0 0 Melanie Cunningham