Unit 3 Final Project Part 1 Pick a company or business from the following list. This will be the basis for your entire final project. If you have a company or business that is not listed, get approval from your instructor. Retail Business Possible Ideas: Clothing, Computer, Plumbing, Auto Supply, Stationary, Furniture, Shoes Service Company Electrical, Heading, Air Conditioning, Lawn Care, House Remodeling Restaurant Theme Park General Construction Contractor Modeling Agency School/College Create a Word table including un-normalized data for your business of choice. Identify information that is, or could be, regarded as important to the company for which the database is being designed. For example, if you have a database design for a production environment, then information that would be important to this company might be total production per day, total production by department for a given period, or a comparison of production and sales from one month to the next. This information will be the basis for queries, forms, and reports in the development stage of your project. All of these items can be completed in a Word document format. Create dependency diagrams for all entities (tables) in your database. Be sure that each entity (table) is in 3NF and includes a relational. These cannot be hand-written/drawn; use Word, PowerPoint, or MS Visio via the XenDesktop to accomplish this. Deliverables Assignment Upload: Un-normalized table data, any business information, dependency diagrams (including relational schemas) normalized to 3NF. All items can be submitted in a Word document format.

Unit 3 Final Project Part 1


Pick a company or business from the following list. This will be the basis for your entire final project. If you have a company or business that is not listed, get approval from your instructor.

Retail Business Possible Ideas: Clothing, Computer, Plumbing, Auto Supply, Stationary, Furniture, Shoes
Service Company Electrical, Heading, Air Conditioning, Lawn Care, House Remodeling
Restaurant
Theme Park
General Construction Contractor
Modeling Agency
School/College
Create a Word table including un-normalized data for your business of choice. Identify information that is, or could be, regarded as important to the company for which the database is being designed. For example, if you have a database design for a production environment, then information that would be important to this company might be total production per day, total production by department for a given period, or a comparison of production and sales from one month to the next. This information will be the basis for queries, forms, and reports in the development stage of your project. All of these items can be completed in a Word document format.

Create dependency diagrams for all entities (tables) in your database. Be sure that each entity (table) is in 3NF and includes a relational. These cannot be hand-written/drawn; use Word, PowerPoint, or MS Visio via the XenDesktop to accomplish this.

Deliverables

Assignment Upload: Un-normalized table data, any business information, dependency diagrams (including relational schemas) normalized to 3NF. All items can be submitted in a Word document format.