Database of Business Rules Entities and Attributes

Database (AMC) : Business Rules and attributes ERD Normalized scheme Database schema Foreign key constraints Queries Business Rules: Store has many departments Departments has many employees Payslips belong to employee Products has many suppliers Suppliers has many products Order has many products Entity Relationship Diagram: Entities and attributes: ERD: Normalized Schema: Table Name Attribute Attribute Description Data Type Primary/ Foreign Key Foreign Key Reference Table Stores store_id Store number Integer(11) PK name Store name Varchar(