Cis515

Powerful 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 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.

You May Also Find These Documents Helpful

  • Good Essays

    CIS515 - Module05

    • 693 Words
    • 3 Pages

    1. Describe technical architecture as a structured process and compare it to software architecture. How are the two related? In what ways does it allow us to design better systems? Technical Architecture A technical architecture is the design and documentation of a software application. Technical architecture gives the overall picture of the application. Usually enterprise architect who understand the business and fluent in technology provide the important bridge between MIS and business. Technical…

    • 693 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Database design Chapter 1

    • 347 Words
    • 2 Pages

    CIS515 – CLASS #1 NOTES 1. Database – is a collection of related files (Tables) 2. File (Table) – is a collection of records (Rows) 3. Record (Rows) – is a collection of fields (Columns) 4. Field (Columns) – is a collection of characters (Bytes) 5. Character (Bytes) – is a collection of 8 bits 6. Bits – the smallest representation of data, it is either 1 (on voltage) or 0 (off voltage) Database File  Table Record  Rows Field  Columns Character  Bytes Bits…

    • 347 Words
    • 2 Pages
    Satisfactory Essays