29 Jun Bottom Up/Top Down Database Design

Order Instructions

Construct relations in first, second and third normal form.

 

Bottom Up/Top Down Database Design

 

Purpose

 

This Assignment will require you to work through normalization concepts covered in this module’s assigned readings. The Assignment requires you to locate an example form online, and develop a normalized database using the top-down or bottom-up approach based on the content found in the online form selected.

 

Assignment Instructions

 

Part 1: Perform a Bottom-up Database Design

 

Find a form on the Web and follow the bottom-up database design approach. Please include the website URL and an image of this form.

 

Find all the attributes on the form.

Establish the dependencies (determinants).

Group attributes that have a common determinant into an entity type; name it.

Find directly-related entity type pairs.

Determine the connectivity for each pair.

Draw the ERD.

Review the ERD and update to be in 3NF if ERD from step 6 is not in 3NF.

Part 2: Begin Designing a Database

 

Module_3 Database Design Sample document shows the parts of the database design for this module.

 

Please keep your database design simple. Have no more than 10 tables, including associative entities. If you must, narrow the scope of your database design in order to meet this requirement.

 

Part 2 Requirements

 

You will design a database. Questions and problems from Chapters 3, 4, 5, and 6 can be used as the concept for the database you create for this project. In this module, you will start by defining the purpose of the database and the information the database is to provide. You will list entities, write the business rules for each relationship between entities and create an ERD. Refer to the Module_3 Database Design Sample document for an example.

 

Part 2, Section 1: Database Definition

 

State the purpose of the database.

Define the requirements of the database. Describe who are the users and how the database will be used,

Part 2, Section 2: Database Design

 

This section of the Assignment must include at least 5 tables and should have no more than 10 tables.

 

List the entities of your database.

Present the business rules that determine connectivity in your ER model. Do not give rules for links to associative entities; simply give the M:N relationship rules and the name of the associative entity you will use for that relationship. Example: Apartment – Tenant. One apartment may currently be occupied by one or more tenants. (many)One tenant may occupy many apartments (but only one at a time). (many)Apartment M:N Tenant; AE: ApartmentTenant

Draw the ERD; copy the drawing into your Word project document.

Assignment Requirements

 

The Assignment should contain sufficient information to adequately answer the questions and contain no spelling, grammar, or APA errors. Points deducted from grade for each writing, spelling, or grammar error are at your instructor’s discretion.

 

For more information on APA style formatting, go Academic Writer under Academic Tools of this course.

 

Also review the university policy on plagiarism