Answer to Question #252349 in Databases | SQL | Oracle | MS Access for Sonu

Question

Polly Pipe is a water sports provider and installer based in Braintree, England. They need you to design and implement a database that meets the data requirements. These necessities are defined in this scenario and below are samples of the paper records that the Polly Pipe preserves.

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.

Identify the user and system requirements to design a database for the above scenario.

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.