Validity and consistency ensure different parts of database do not hold varied results of the same information. The validity of a database solution ensures that data incorporates within the possible pieces of data within the database (Davenport, 2013). Therefore, the validity of data within a database solution ensures that records are updated, created and deleted when need stands. The design of a database solution takes up the following structure database solution contains connectivity of relationships as shown in the key diagram above. The stores to the customers have a 1:1 relationship, the products to the stores have a 1: M relationship, suppliers to products have an M: N relationship, while products to product ID have a 0:1 relationship making across foot notation of (1:1, 1: M, M: N, 0:1) within a database. The design of a database solution contains data information of products and customers that is readable to allow for retrieval, consistency, and validity of the information. The design and the applications of database design narrow down to the five stores to control sales and products from the stores to the customers (Turner, 2013). The use of database solutions assists in promoting sales transactions of different departmental stores of the enterprise. Therefore, a good database solution incorporates retrieval, consistency and validity aspects of data information and interpretation of customers in promoting the sales of the product.The potential business rules applicable in-house sales transactions of the departmental store include rules on the sale of goods, sales laws, negotiable instruments rules and documents of the title during transactions. Turner (2013) argues that business rules of the sales of goods require the engagements of both seller and buyers accompanied with mutual agreements during transactions. The sale of goods rules entails as the common commercial transaction within the database. The rights that a seller has specifies within a document allowing the transfer of buyers in return before payment of the purchases made (Turner, 2013).
Coronel, C, Morris, S (2014). Database Systems: Design, Implementation, & Management, London: Cengage Learning.
Davenport, T. H. (2013). Process innovation: reengineering work through information technology. New York: Harvard Business Press.
Özsu, M. T., & Valduriez, P. (2011). Principles of distributed database systems. Springer Science & Business Media.
Pratt, P. J., & Adamski, J. J. (2011). Database management concepts. Boston, Mass: Course Technology.
Turner, J. R. (2013). Database Development and Management. In Encyclopedia of Behavioral Medicine. New York: Springer.
Venkatesh, V., Thong, J. Y., & Xu, X. (2012). Consumer acceptance and use of information technology: extending the unified theory of acceptance and use of technology. MIS quarterly, 36(1), 157-178.
Please type your essay title, choose your document type, enter your email and we send you essay samples