In the creation of a potential relational database model for a sales database, it is essential to identify the different entities to be included within the database and their different attributes (Ritchie, 2002). For our business, the following are the entities that will be present in the potential relational database model for sales.
Customer ID: each customer will have their own specific and unique customer ID to help identify the customer, the purchases they have made and their frequency of purchase.
Contact Information: each customer will have their contact information stored for future reference and delivery of products if need be.
Product ID: each Product will have its unique ID to help trace the product from its production through sales. This will also help identify a faulty batch.
Batch Number: each product batch sold will have its own unique batch number to help track each batch sold and even facilitate recall of a faulty batch.
Sell by Date: since the business deals with fresh and organic produce, it is essential that the products are maintained at optimum level of freshness. As such, all the products will have a sell by date tag or sticker on them.
Vendor ID: each vendor associated with the sale of every product from the business will have their own unique identification code to help in identifying and tracking sales through the vendor. This will help identify the most active and efficient vendors.
Contact Information: each and every vendor associated with the sale of the business’ products will have their contact information stored for future reference and delivery purposes.
Internal Store Departments
Departmental ID: Each department within the business will have a unique identification code that will help identify each department and the number of sales each department makes. This will help identify efficient departments and fast moving products to help make informed sales and marketing decisions. The following departments have been found to exist within the business;
- Fresh Produce Dpt.
- Food Dpt.
- Smoothie bar Dpt.
- Natural Pest Control Dpt.
- Agrovet Dpt.
Harrington, J. L. (2002). Relational database design clearly explained. New York: Morgan Kaufmann Publishers.
Ritchie, C. (2002). Relational database principles. London: Continuum.