WEEK 8 1) Design a database to track information of your choice that includes at least 6 entity/tables 2) There must be at least 30 attributes in total for the 6 chosen tables (average 5 fields per...

WEEK 8
1) Design a database to track information of your choice that includes at least 6 entity/tables
2) There must be at least 30 attributes in total for the 6 chosen tables (average 5 fields per table)
3) Create a data model that includes conceptual, logical and physical model for MySQL
4) These model needs to have scenarios that has: one-to-many and many-to-many
relationship

WEEK 9
5) Use the same database provided by the class or create a new one; to create your table
6) Every table should have a primary key
7) Table relationship has to be based on foreign key and shown within your physical table
8) Insert 5 data records in every table
9) Create a database view that return result set of all record and all columns within all 6 tables