CIS 515-Strategic Planning Of Database Systems
Potential sales and department store transactions stored within the database.
Following the successful expansion of the retail environment to several new stores there is a clear need for an enterprise wide relational database especially with the envisaged increase in sales as a result of current marketing activity.
There are several important steps to consider when designing a database, as a well-designed database should be deployed and not only support the accuracy and integrity of business information but also avoid redundant data and assist with has enterprise level reporting tasked. If we analyze the transactions carried out in each store we can produce a list of the principal entities which are involved with a store based transaction:
Customers – those who enter the store and buy the products.
Vendors – the companies who supply stock to the stores.
Products – the products themselves, which are available in store for purchase.
Store – Location of the actual premises where the transaction takes place.
Employees – staff that work in each store and deal with the customers.
Sales – physical process of selling a product or product(s).
These would make up the core entities of the database and each entity would have various attributes with further relevant information which can be displayed in a hierarchical nature.
Customers
Customer #
Name
Address
Phone Number
Vendors
Company ID
Product
Cost
Contact Name
Contact Address
Contact Number
Products
Price
Type
Manufacturer
Store
Name
Address
Employee
Employee ID #
Name
Address
Sales
Products
Date
Customer
Employee
Store
These can be seen as the key attributes for each entity and provides the information required from each transaction by capturing the essential essence of the business operations. At the simplest level the organization, a store maintains various products
References: Carter, J. (n.d.). Database Design and Programming with Access, SQL, Visual Basic and ASP. Churcher, C. (n.d.). Beginning Database Design . Liu, L., & Ozsu, M. T. (n.d.). Encyclopedia of Database Systems. Springer. O 'Brien, M. C., & Winter, J. (n.d.). Developing Stored Procedures for Microsoft SQL Server. Pratt, P. J., & Adamski, J. J. (n.d.). Concepts of Database Management. Rob, P., & Coronel, C. (n.d.). Database Systems: Design, Implementation, and Management.