Answer to Question #113601 in Databases | SQL | Oracle | MS Access for inv

Question

Customers have Catogory: 1, 2 and 3 and a unique number.
Each transport operation is a job, which involves picking loads of products from a start location and delivers it to an end location. number is given for each job and for each load when they are created.
A Load is transported using a specific transport unit, which consists of lorry, driver, assistant, and a container. A container is fixed to a trailer so it needs to be coupled to a lorry at the start of a Job. (Single container can transport only one chemical product due to safety requirements).
Payments for a job depends on customer type, product type (No Risk, High risk) and the load type (small, medium and large).
Transport operations are run from 9 regional depots. Jobs are allocated to individual depots to service. Depots hold, manage and maintain transport units which allocated to them to service Jobs. transport units are held at the base Depot they belong to.
Identify user and system requirements

Answer 1

Dear inv, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order