Database Design

Database Design  

Sample data is provided for the database for the sales system. Using the sample data from the Learning Resources, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD.

To complete your Assignment:

  1. For each entity, provide the name, description, fields, data type, primary key, and foreign key. (25 points)
  2. For each direct entity type pair, provide the business rules. (25 points)
  3. Provide the ERD. (25 points)

 

Required Resources

Oppel, A. J. (2009). Databases: A beginner’s guide. New York, NY: McGraw-Hill.

Chapter 7, “Data and Process Modeling”

  • Document:Data Modeling Example Top Down Database Design Approach (PDF)

    The top down database design approach starts with the general and works through to the specific. The steps for the top down database approach are listed below. Refer to the PDF for an example.

    1. Find the entity types.
    2. List directly-related entity type pairs.
    3. Write the business rules to determine cardinality.
    4. Draw the ERD.  Designate primary keys (PKs) and foreign keys (FKs).
    5. Identify other needed attributes.
    6. Review ERD participation and constraints and update the ERD.
  • Document:Data Modeling Example Bottom Up Database Design Approach (PDF)

    The bottom up database design approach starts with the lowest level known specifications to develop the database. Typically, the bottom up database design starts with a form, user view or a report.  The steps for the bottom up database approach are listed below. Refer to the PDF for an example.

    To design a database that will support a “form,” “user view,” or “report.”

    1. Find all the attributes on the form.
    2. Establish the dependencies (determinants).
    3. Group attributes that have a common determinant into an entity type; name it.
    4. Write the business rules; finalize cardinality.
    5. Draw the ERD.
    6. Review ERD participation and constraints and update the ERD.
  • Document: Weeks 2–5 Assignment Database Table (PDF) 

    You will use this database table for this week’s Assignment.