24FreelanceFreelance marketplace that never sleeps
Closed

Web programmer services required

523 views 0 responses#29860
Project status
Closed
BudgetNegotiable
FormatOne-time projectprepayment possible
PaymentBank transfer, E-money
Responses acceptedFinisheduntil 03.08.2020
Responses0category average: 0.1
Views52327 in 14 days

Project description

We need a web programmer. You need to work with SQL.
The database contains 4 tables:
Item (mkr, mdl, tp)
Comp (cd, mdl, spd, rm, hd, cd, prc)
Note(cd, model, spd, rm, hd, prc, scrn)
Prn(cd, mdl, clr, tp, prc)
The Item table represents the manufacturer (mkr), model number (mdl) and type ('PC' for PC, 'Laptop' for PC notebook or 'Printer' for printer). The model numbers in the Item table are supposed to be unique to all manufacturers and product types. In the Comp table for each PC, uniquely defined by a unique code - cd, the model is indicated - mdl (external key to the Item table), speed - spd (processor in megahertz), memory - rm (in megabytes), disk size - hd (in gigabytes), speed of the reader - cd (for example, '4x') and price - prc. The Note table is similar to the Comp table except that instead of the speed of the CD, it contains the screen size of -scrn (in inches). The Prn table for each printer model indicates whether it is colored - clr ('y' if colored), printer type - tp (laser - 'Laser', inkjet - 'Jet' or matrix - 'Matrix') and price - prc.

It is necessary:
1. Indicate the model, speed and disk size of all PCs costing more than $400. Delete: mdl, spd and hd
2. Find the printers that have the highest price. Delete: mdl, prc
3. Indicate the average speed of the PC that the manufacturer A has released.
4. Find the average size of each of the manufacturers that produce printers. Output: mkr, medium HD size.
5.Find printer manufacturers that produce PCs with the smallest rm volume and the fastest processor of any PC with the smallest rm volume.
Web programming Bank transfer, E-money

SafeDeal Escrow Protection

Payora SafeDeal Astrina Shield Verified

Funds are locked in Payora USDT (TRC-20) escrow and released to the freelancer only after delivery approval.

24
Twenty · tip

How to write a response that gets picked

  • Open with the client’s task, not with a story about yourself.
  • Link one or two similar works from your portfolio.
  • Name a price and a deadline — and what exactly they include.
  • Ask one clarifying question: it starts the conversation.

Responses 0

Response texts are visible only to the client.

Same category

Similar projects

All projects in the category
Price and stock monitoring script for suppliers

Price and stock monitoring script for suppliers

We need a script that auto-collects prices and stock from supplier sites and feeds, compares them, keeps history and alerts on changes.

Web programming24.09.20260213
0responses
Delivery and Courier Dispatch System

Delivery and Courier Dispatch System

A web app to intake orders, assign couriers, plan routes, track statuses, show a live map and reports.

Web programming24.09.20260248
0responses
Good to know
How do I respond to this project?

Log in as a freelancer, describe how you will solve the task, name your price and deadline. The client reads responses and starts a dialogue with the best ones.

Who can see my response?

Only the client who posted the project and you. Other freelancers do not see your text or price.

Where can I find similar work?

New projects in “Web programming” appear every day. All projects in the category

What this page answers