les you design should have attributes (col- ns) for each critical piece of data. See hibit 13-4 for the concept of the table layouts. ar tables should meet the first three rules of a normalization scribe the advantages and disadvantages for Zip using a centralized database as opposed to a arate database for each location. Co., a large, nationwide grocery chain, ins a customer reward system titled the 65 The screen capture that follows shows the relation- ships 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. Microsoft Access - [Relationships] El Edt View Relationships Tools Window Heb Show Me 89 89 X 3 OO 1 Supplies SUID Company Nam Contact Name Contact Title Address City Region 18 818L Order beton OrderID DO Product UnitPrice Quantity Discount Pro ProductD Product Name SupplerID CategoryID QuantityPerUnit Unit Price Unitsin Stock UnitsOnOrder ReorderLevel Discontinued 1 Customer Customer Company Nam ContactName Contact Title Address City Region Orders OrderID Customer ID EmployeeID Order Date RequiredDate ShippedDate Shipvia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCoM Ships Catecode CategoryID CategoryName Description Picture Employee Employee LastName FirstName Title TitleOfCourte BirthDate HireDate Address ORY Company Name Phone