The screen capture that follows shows the relationships in a Microsoft Access database. For each relationship, explain the following:

a. The type of parent€“child relationship it represents.

b. Which attributes in the table are used to link the relationship?

c. The purpose of the relationship.

Transcribed Image Text:

Microsoft Acess - [Relationships] File Ecit View Relationships Iools Window Heb Show Me Suppliers SurpierD CompanyNam ContactName Contact Title Address City Region Order Details Orders Customers Products Order ID ProductID ProductID ProductName SupplerID CategoryID QuancityPerhit UnitPrice UritsirStock untsOnCrder Reorderlovel Discontinued OrderID Customer ID EmployoolD Order Date RequirecDate ShippedDate ShipYia Freght ShipName ShipAddress Shipcry ShipRegion ShipPostalCoc CustomerD Companyvam ContactName ContactTtle odtess Gty |Region UnitPrico Quantity DIsCount Employees EmployeelD LastVame FrstName Ttle TtleOfCourte BrthDate Categories Shippers CategoryD CatagoryName Description Picture ShpperID CompanyName Phone HreDate Address Oty 8J L