Overall you have most of the essential codes and tables setup. The error you got for removing a supplier is likely to do with the supplier id being a foreign key. In other words, you had set up the supplier id as a primary key on another table (perhaps the products or customer table). In terms of the reorder level – you should have this on the products table as mentioned in assignment 4. But even if you didn’t have this in your ERD model, you could still add or modify the products table to include this attribute when you write your SQL statement.
GWDA372 
Overall you have most of the essential codes and tables setup. The error you got for removing a supplier is likely to do with the supplier id being a foreign key. In other words, you had set up the supplier id as a primary key on another table (perhaps the products or customer table). In terms of the reorder level – you should have this on the products table as mentioned in assignment 4. But even if you didn’t have this in your ERD model, you could still add or modify the products table to include this attribute when you write your SQL statement.
LikeLike
0 Pingbacks