FUNDAMENTAL DATABASE SUBJECT: Case: A car wash owner wants to monitor the inventory of products and sales of the business. Create a database design in preparation for a system development that would: Store and monitor the supply of products; The number of vehicle washed by a car wash boy. Vehicles can be classified according to its type (motorcycle, van, bus, etc.). The list of vehicles washed by a car wash boy can be monitored. Salary per employee and the vehicles washed can be retrieved. Car wash history per vehicle can be check also. We already Identified the possible tables, so your task will be:
FUNDAMENTAL
Case: A car wash owner wants to monitor the inventory of products and sales of the business.
Create a database design in preparation for a system development that would:
Store and monitor the supply of products; The number of vehicle washed by a car wash boy. Vehicles can be classified according to its type (motorcycle, van, bus, etc.). The list of vehicles washed by a car wash boy can be monitored. Salary per employee and the vehicles washed can be retrieved. Car wash history per vehicle can be check also. We already Identified the possible tables, so your task will be:
1. Add data on the tables (assume that this is not normalized yet)
2. reflect on the table and follow the normalization steps base on the rules.
3. normalize its table
4. add all table in one document (lucidchart/google docs), should have relationships and cardinality.
5. make sure that it is in highest normal form, highest will be BCNF (if needed).
Step by step
Solved in 2 steps with 1 images