Homework answers / question archive / You are hired as a business analyst to design a relational database using MySql

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

Computer Science

Share With

---

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 3rd? 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