Understanding business rules; Identifying entities and relationship; Crow's Foot Entity Relation Diagram (ERD); Resolving M:N realioship; Forms; Reports.
Task:
1. Given the following statement: A manufacturer suppliers goods to a variety of Vendors. A Vendor generally receives goods from many manufacturers.
Extend the on the file i will attach to this ( i will send the datebase access sheet) to include the above statement in your design and design the ERD of the database in Visio.
2. Create a form for the Product table.
3. Create a report for the Product table. grade will be based on the quality of your design and presentation. What to turn in: The updated database and the visio file.
Attachment:- database.accdb