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)

Proposals 5 Discussions 1

Denis K.

31 0

Budget: 2000 RUB Deadline: 3 days

You are ready to perform your laboratory work in the shortest possible time and quality. The price can be discussed.

Vadim Lyubivy

25 4

Projects 26
Rating -
Rating 821

Budget: 8000 RUB Deadline: 3 days

Good day, I will do my job, I have experience. Please write to me at LS.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

I am looking for a plugin developer for Minecraft 1.16.5.

Java 3 proposals 1:41

604 USD
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 17 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 19 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD

Aleksey Ivanov
Volgograd, Russia

Projects 1
Rating -
Rating 83

Aleksandr B.

Denis K.

Vadim Lyubivy

Proposals are currently absent

Current freelance projects in the category Databases & SQL

I am looking for a plugin developer for Minecraft 1.16.5.

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities