Project translated automatically. Log in or register, to view the original You need to do 2 laboratory work ( 4 and 5 in the attached file, version 1) Laboratory 4 – Two tables are required.The first contains information about the companies, namely the name of the company (up to 250 characters).The second is the information about the cars produced by companies: the name of the car (up to 150 characters), its value (full number) and a reference to the company.Further, get information about companies and cars in the form of a two-level list.The first level contains the names of companies in the alphabetical order.On the second are the information about the cars for this company, sorted by the names of the cars in the alphabetical order.All these pages must be extracted from the base with one request, i.e.and e.It is not possible to make a request purely for the companies, and then for each company to extract additional request information about the cars.(You need to write a script to create a database tables, fill the database with and remove the database tables.page according to the task) Laboratory 5 – It is necessary to create three tables – cars, firms and countries.The car table has a name, links to the company and the country.There are two pages to be implemented.The first shows a list of cars in the form of a table of three columns.In the first column the name of the car is given, in the second - the name of the company with a reference to the page of view of the company.In the third column is the name of the country.The list of vehicles must be ordered by the name of the vehicle.The second page shows detailed information about the company on its key, namely: the name of the company and the number of cars of the company (you need to write a script to create tables and a script to fill these tables with data)