Quiz Chapter 14

Question

You are designing a system to store data on the information of customers who are buying medical products associated with the treatment of mental disorders. You need to store the customers details (name, address, credit card info, etc), the product information that the company sells (names, descriptions, price), and the customers orders (associations between customer and products). In making the design decisions, you must decide between a single database, and a multiple databases, with each of the following types of data separated onto each. What are the considerations that would be made in one design vs. the other?

Answer

A single Database means that the all the product data and confidential order and personal data, is stored on the SAME database. This lack of distribution means that anyone with access to the product catalog (online browsing customers) has some level of access to the same database with ALL the confidential order and customer data. This is likely to be online customers will no login credentials. Distribution into two databases on different systems would allow the confidential database to only be accessed after the customer was in the ordering state, meaning they were logged in.
Topic revision: r2 - 2016-01-10 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback