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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.