This database
system is aimed for the Five Star Pool Services business based in Lancaster,
New York. The business expert for
this group is Adam Timmerman, who has worked for the pool company for 3 months
thus far.
Five Star Pool Service’s main business is opening and closing pools. This company has many jobs that take the work crews across the county and there are many places where the operations and administrative management could be improved upon with the aid of a database system. This includes avoidable disorganization, and planning for client’s demands differing between types of products and services.
The "database expert" for this project is Steven Porras and this database is to create business value for this swimming pool maintenance company. This is a 3-entity database that is divided into Customer ID information, Product ID information, and lastly, a linking entity for Customer ID and Product ID (Transactions/Order ID). The Forms will be utilized to add data to the Customer ID and Product ID Tables and a series of five specialized Reports will help interpret the data as effectively as possible, and ultimately create business value.
Five Star Pool Service’s main business is opening and closing pools. This company has many jobs that take the work crews across the county and there are many places where the operations and administrative management could be improved upon with the aid of a database system. This includes avoidable disorganization, and planning for client’s demands differing between types of products and services.
The "database expert" for this project is Steven Porras and this database is to create business value for this swimming pool maintenance company. This is a 3-entity database that is divided into Customer ID information, Product ID information, and lastly, a linking entity for Customer ID and Product ID (Transactions/Order ID). The Forms will be utilized to add data to the Customer ID and Product ID Tables and a series of five specialized Reports will help interpret the data as effectively as possible, and ultimately create business value.