Title: Assignment 4 - Project Planning
Course: KVCC BUS210 > Section: Assignments

The goal of this assignment is to get you to start to solidify the direction of your final project for this course. We have not discussed this much in class however we have been doing work towards it in the assignments and exam. We will discuss this more in the days to come however your task is to first select a business and then develop a database or modify a current database using the information that we have discussed in class. Some of the topics we have discussed already include:

1.           Business rules and how they relate to database development

2.           Data models and different levels of abstraction

3.           The relational database model

4.           Types of Keys

5.           Different Relationships

6.           How redundancy is dealt with

7.           Entity relationship models and ERD

8.           Extended Entity Relationship model

Areas to still cover:

1.           Normalization

2.           SQL

3.           Database Design

4.           Transaction Management

5.           Performance Tuning

Think about these above topics and answer the following questions:

1.                   What business will you examine? (You can leave the actual name out and describe what they do)

2.                   Why did you select this business?

3.                   What kind databases if any are currently used within the organization?

4.                   Are you planning on designing a new database or will you be modifying a current one?

a.           If modifying, why? What kind of modifications will you make?

b.           If developing new what need are you fulfilling? What will be the purpose/goals for this database?

5.                   What style of database are you planning on developing, IE Relational, Object oriented, NoSQL?

6.                   How will you discover the business rules of the organization?

7.                   What other methods will you use to discover the entities, attributes, and relationships necessary for this database?

9.           What have you completed so far and what are you currently working on in relation to this project?

10.       What are your next steps?

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Assignment 4(1).pdf