IT525 Invoice DB Phase 1

Purpose

This Assignment will require you to work through the normalization concepts you have covered in this class. 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

You will design a database. In this unit, 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.

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