Using the ER diagram for Supplier and Part entities provided (attached here), convert the ERD logical design into a physical database using Microsoft Access.Make sure that you have to create both tables, then use "Database Tools"/"Relationship" to set a specific relationship type between two entities.Once you created both tables, type in at least 5 sample records per entity table ( special care needed when you enter sample data in FK field).Perform a Query to obtain "Supplier_ID", "Supplier_Name", "Part_Num", "Part_Name" data from both entity tables.Also create a form and report using any entity PartSupplierI Part_NumI Supplier_IDPart_NameSupplier_NamePart_DescriptionSupplier_AddrUnitPriceSupplier_CityWarehouseSupplier_StateSupplier_ID8)

core aspect of software engineering is the subdivision of the development process into a series of…

Answered: convert the ERD logical design into a…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Using the ER diagram for Supplier and Part entities provided (attached here), convert the ERD logical design into a physical database using Microsoft Access.
Make sure that you have to create both tables, then use "Database Tools"/"Relationship" to set a specific relationship type between two entities.
Once you created both tables, type in at least 5 sample records per entity table ( special care needed when you enter sample data in FK field).
Perform a Query to obtain "Supplier_ID", "Supplier_Name", "Part_Num", "Part_Name" data from both entity tables.
Also create a form and report using any entity