Answer to Question #291293 in Databases | SQL | Oracle | MS Access for msms

Question

Polly Pipe is a water sports provider and installer. Polly Pipe is focused in placing aquariums at business customers. Customers can request several installations, but each installation is tailor-made for a specific customer. Facilities are classified by type. One or more employees are assigned to each facility. The facilities use equipment. Below are examples of paper records.

Staff Management Record

Staff Number| Name| Type|

SHA1| Dave Clark| Plumber

Equipment Type Table

Type| Equipment|

Tanks| 20 gallon tank, 50 gallon tank

Instillation Management Form

Installation ID| Installation Type| Installation Name and Address| Customer| Equipment| Types of Staff Required| Period of Staff assignment|

234| Freshwater Tropical| Oak House| 17 Wroxton Road, Hertfordshire| John Carter| 2 air pumps, 200 gallons fish tank| 1 x Carpenter,1 x Aquatics installer| From 2012/12/10|

ERD Please!!

Answer 1

Dear msms, 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