This project tested my understanding of Data Modeling and Normalization.
The following database was created using Relational Database Design, Entity
Relationship Diagrams and other Case Tools.
- Deliverable - 1A - List all Products by supplier name
- Deliverable - 1B - Query employee with the best sales
- Deliverable - 1C - List employees in decending order according to commission of all sales representitives
- Deliverable - 1D - Query employee with the most distinct products sold
- Deliverable - 1E - Query sales representitive in order by ID, customer name, orderid
- Deliverable - 1F - Query suppliers of hacksaw parts
- Deliverable - 1G - Query all parts needed for hacksaw
- Deliverable - 1H - Query customer with the largest amount spent
- Deliverable - 1I - Query supplier with largest amount spent by store
- Deliverable - 1J - Query all items according to profit margin in Decending order
- Deliverable - 1K - Query courses completed by employee order by firstname and date
- Deliverable - 2A - Existing ERD (Picture)
- Deliverable - 3A - Improved ERD (Picture)
- Deliverable - 4A - Query product price in year 2014
- Deliverable - 4B - Query the mananager of employee 'SAMs'department
