Q1: No major issues found in your answers.
Q2: Tables you need – product category, products, suppliers, shipping companies, customers, orders. You don’t need employee table because there’s no business rule for this ie. employees have no direct relationship with any of the above. Ideally should populate each table with a couple of tuples with fictional data not just one tuple of data.
Q3: Other than lines drawn to identify the relationship between the each table in the model, you should also identify which attribute is primary key and/or foreign key. You did identified the keys but not the lines to identify the relationships.
GWDA372 
Q1: No major issues found in your answers.
Q2: Tables you need – product category, products, suppliers, shipping companies, customers, orders. You don’t need employee table because there’s no business rule for this ie. employees have no direct relationship with any of the above. Ideally should populate each table with a couple of tuples with fictional data not just one tuple of data.
Q3: Other than lines drawn to identify the relationship between the each table in the model, you should also identify which attribute is primary key and/or foreign key. You did identified the keys but not the lines to identify the relationships.
LikeLike
0 Pingbacks