Answer to Question #252408 in Databases | SQL | Oracle | MS Access for Shanu

Question

Instillation Management Form

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

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. Because these facilities are often very large, they can include carpenters and masons as well as water installers. The facilities use equipment such as aquariums, air pumps and thermostats. There can be multiple computers in a facility.

Staff Management Record

Staff Number| Name| Type

............................................................................................................

Equipment Type Table

Type| Equipment

Identify the user and system requirements to design a database for the above scenario and design a relational database system using conceptual design (ER Model).

Answer 1

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