Answer to Question #281887 in Databases | SQL | Oracle | MS Access for Nishi

Question

Polly Pipe is a water sports provider and installer based in Braintree, England. They need to design and implement a database. 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.

Produce a technical documentation and a user guide for the developed database system. Suitable diagrams (Use case diagram, class diagram, flow charts, DFD level 0 and 1) should be included in the technical documentation to show data movement in the system. Assess the developed database by suggesting future enhancements to ensure the effectiveness of the system. 

Answer 1

The user and system requirements are:

1. The system should be able to handle the customer details.

2. The appropriate installation should be available with ease.

3. The system should be able to handle the facility details.

4. The decision making Should be efficient.

5. The payment gateway should be secure.