preview

Cis515

Better Essays

DATABASE ADMINISTRATOR FOR DEPARMENT STORE

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 …show more content…

At the highest level it is fairly easy to state that Sales happen in a Store, Customers buy Products and Products are sold to Customers but this does not accurately define the cardinality of each relationship which, shows the numeric quantity on each side of the relationship. For example, how many sales take place in one store?
Following this procedure through we can arrive at a list which shows a detailed breakdown of the relationships, and as we have 6 entities there should be a total of 30 relationships as each entity will have a relationship with every other entity (5 each).
Customers ⋄ Sales: 1 customer can buy something several times

Sales ⋄ Customers: 1 sale is made per customer

Customers ⋄ Products: 1 customer can buy multiple products

Products ⋄Customers: 1 product can be purchased by multiple customers

Customers ⋄ Stores: 1 customer can purchase in multiple shops

Stores ⋄ Customers: 1 store can service multiple customers

Stores ⋄ Products: 1 store has multiple products

Products ⋄ Stores: 1 product can be sold in multiple stores

Stores ⋄ Sales: in 1 store multiple sales can be made

Sales ⋄ Stores: 1 sale can only be made in 1 store at the same time

Products ⋄ Sales: 1 product can

Get Access