The stakeholders in a Shoe Repair Shop in a local mall want to start the process of computerizing components of the operations of the Business. They want to start this by developing a software system to track areas of inventory, sales, and services. The software system must store the data and information. The stakeholders have decided that the best place to store and track the data and information is in an enterprise-level Relational Database Management System (RDBMS). You have been contracted to design, implement, and test the relational database that will support the Middleware Software that will interface and sit on top of the relational database. The software component has been contracted to a different entity. The design documentation that you create for the relational database will assist the Middleware Developer.
In this assignment, you will work on one of the first stages of the development of the relational database. This is the creation of the ER Diagram that will represent the conventional model of the relational database for the Shoe Repair Shop. Analysis has already met with the stakeholders to better understand the requirements for the software system and relational database. Written below are some of the requirements relative to the development of the database component for the system.
The company wants to maintain Customer Information. They need the customer's name, phone number, and email address when a shoe repair service is purchased.
The company wants to maintain records of the products that are offered for sale in the store. The company wants a digital list of products for sale to customers. A product has a unique product number, price, and name They also want to track the quantity on hand and a reorder level for each product for sale.
The company wants to maintain records of the sales and services that they have had with Customers. A receipt is printed for a customer listing the details of the sales and services ordered or purchased by a customer during the transaction. The receipt contains the date and time of the transaction. Each receipt has a unique transaction number.
The company wants to maintain a digital list of Repair Services offered to Customers. A point of sales transaction can contain one or more services. Each service has a unique identifier number, a name, price, and description of the service.
The company wants to maintain a digital list of Vendors they purchase products from. Venders supply the products that the Shoe Repair Shop offers for sale at the counter or online. A single product can be purchased from one or more Vendors.
A customer purchases a service or a product at the sales counter. In the first stage of the software system, the company only wants to record the amounts paid for the services and products, not the payment types.
A point of sale to a customer may include one or more products and services.
For this assignment, students have the option of creating the ER Diagramming model in either Chen Modeling Notation or Crowfeet Modeling notation
All ER Diagrams must be submitted in a PDF.