Database Project design

You are hired as a business analyst to design a relational database using MySql.

1. Pick a small company or business from the following list. This will be the basis for your entire 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, Furniture, Shoes

○ Service Company - Electrical, Heating, Air Conditioning, Lawn Care, House Remodeling

○ Restaurant ○ Theme Park ○ General Construction Contractor ○ Modeling Agency ○ school

2. Perform Business area analysis ○ Business overview, ○ RDBMS used, ○ Security and data integrity Applied, ○ summary of your experience.

3. Logical design:

○ Data model: ○ Define entities and attributes (You should have at least 5 entities) ○ Normalized to 3​rd​ Normal Form ○ Entity Relationship Diagram using Crow foot notation

4. Physical Design using MySql or Oracle ○ Convert all entities to tables and attributes to columns ○ Define data types, primary keys, foreign keys, indexes, check and

not null constraints. ○ Create SQL scripts to create tables, primary keys, foreign keys,

indices, sequences, etc. 5. Database Execution:

○ Create database objects using Oracle or MySql ■ SQL scripts to create tables, primary keys, and foreign

keys, and check constraints if applicable ○ Create SQL script to INSERT at least 5 rows to each table ○ Output of SELECT (SELECT * FROM <table name>) for all tables.

Project Submission:

● Business area analysis (step 2) – Word file ● ER diagram- Visio, ppt, word. ● Normalized Entity – attribute list – word or text file ● DDL and DML statements for all tables- word or a text file ● Output of SELECT statements – text or Excel file