About Our Project
Our database is designed to consolidate the process involved with building a new pool, and retrieving specific information related to that order. This database will allow for the advancement from archaic paper files to modern electronic collections of information related to customers, orders, and employees. The customer table contains all of the relevant information for a new pool order, such as customer name, address, and purchase date, as well as all of the information for their specific pool, like shape, liner color, and pump type. The employee table contains information regarding active workers of the company, like their name, address, role, and salary. The employee assignments table identifies which teams worked on specific pool builds and for how long. Lastly, the specific pool build mission table tracks information regarding the actual process of building the pool, like potential hazards to the digging crew, the dates on which building started and ended, and a diagram related to the building of the pool.
The forms contained in this database are where majority of the business value is created. These forms allow for managers to easily create files for new customers, new employees, and new builds, while creating a streamlined system to retrieve this information when making decisions at the end of periods. It is these forms, along with queries, that allow for the creation of our reports, which are vital to decision-making for higher-level management in the company.
The forms contained in this database are where majority of the business value is created. These forms allow for managers to easily create files for new customers, new employees, and new builds, while creating a streamlined system to retrieve this information when making decisions at the end of periods. It is these forms, along with queries, that allow for the creation of our reports, which are vital to decision-making for higher-level management in the company.