(Get Answer)

accounting exercise and need support to help me learn. pls see the attachments below Requirements: vary ACCT-361: Tables Lab Exercise Creating the Linking Table and Relationships Pets-R-US Pets-R-Us entered the retail sales business just a few days ago and has experienced fair success. Pets-R-Us products include food, treats, grooming, and medical supplies for dogs and cats. The owners hope to expand the business into a chain at many area shopping centers. You have been asked to review data collected from Pets-R-Us for the first few days of operations. The following is an REA model with cardinalities of the sales event only. The objective of this exercise is to help you learn how to create the linking table with a joint primary key and the relationships with referential integrity. We will use this database for future instruction and assignments. Required: 1.The four main tables have already been created and populated.2.You will create the required linking table for the *.* relationship as detailed on the REA model. Allfive tables are listed below, along with their primary and foreign keys. The remaining attributesare detailed on the next page.Master tables Event tables tblCustomer: Customer ID tblInventory: Item # tblAssociate: Sales Clerk ID tblSale: Invoice #, [Customer ID], [Clerk ID] tblSale-Merchandise: [Invoice#], [Item #] 3.Create the relationships among the foreign and primary keys. Be certain to enforce referentialintegrity. Add input masks as appropriate. We will learn more about input masks and validationrules in our forms and controls labs.4.Populate the linking table with the records listed for that table on page two of these instructions.Only a few records have been selected for each table to keep data entry time down for thisexercise.5.To view the E-R diagram and copy the image of your screen (for future assignments and theproject): From the toolbar, select Database Tools and then Relationships. To create the image,simply press the “print screen” key on your keypad. This will copy the screen image to yourclipboard. Open a Word document and select copy to copy the contents of your clipboard. 6. To view the “data dictionary,” which documents each table and its properties, select the documenter in the database tools tab. Select the tables and choose “OK.” In the options, you can restrict the output. I typically choose only the items for the table and “Nothing” for fields and indexes. Populated tables: tblCustomer Customer ID First Name Last Name Street Address City State Zip Telephone 100 Anita Hamburger 1424 5th St Hagerstown MD 21740 3016049222 101 Evan Chapman 405 Hickory Ln Fairfax VA 22031 7034524909 102 Charlie Shockey 1434 Wilshire Ave Baltimore MD 21066 3016026992 tblInventory Item # Description Sales Price BQOH BQOH Date Standard Cost Reorder Point CA052 Super Catnip Leaves & Blossoms $2.81 32 31-May-16 $1.50 20 CB003 Class Act II Oval Cat Dish $12.80 6 31-May-16 $7.65 2 DF020 Bio Spot Flea and Tick Dog Collar $7.72 39 31-May-16 $3.70 15 tblSalesClerk Sales Clerk ID Clerk Name SSN Commission Rate 1 Baker, Heather 234-34-5212 $0.02 2 Hylton, Constance 401-93-8888 $0.02 tblSale Invoice # Invoice Date Sales Clerk ID Customer ID 1001 01-Jun-16 1 100 1002 01-Jun-16 2 101 1003 01-Jun-16 1 102 tblSale-Inventory Invoice # Item # Qty Sold 1001 CA052 5 1001 CB003 1 1002 DF020 2 1003 CA052 1 1003 DF020 1 ACCT-361: Helpful Hints Tables and Relationships Create a New Database Using your start button, locate the Microsoft Office folder under “All Programs” and click on Microsoft Access. Choose a blank database and click “Create”. Create a New Table Select the Create tab and then choose Table Design in the create toolbar. Once you have chosen a field name and a data type, carefully review the field properties at the lower part of the screen. You may want to change the size or format of the field, create input masks, or add validation rules. We will learn more about the masks and rules in our controls lab. Set Primary Key Highlight the row of the field you wish to make the primary key by clicking in the gray box next to the row. Select the Primary Key icon on the toolbar. To remove the key from a field, highlight the row of the field. Select the key icon on the toolbar. To create a composite primary key using two attributes, highlight both rows at the same time and select the key icon. Create Relationships and Enforce Referential Integrity Select the Database Tools tab. Click on the Relationships icon on the toolbar. It resembles an ER diagram. Select the tables in your database one at a time. If you accidentally close the window that lists your tables, select the “Show Tables” icon on the toolbar under the Design tab. To create the relationships, highlight a foreign key in your table. Drag it and place it on top of the corresponding primary key in the related table. A window will pop up that allows you to edit the relationship. Select “Enforce Referential Integrity.” If you forgot to enforce referential integrity when setting your relationships, in the relationships window, highlight the relationship line and right click. A short-cut menu will appear that will allow you to edit the relationship. To Return to the “Design” View of a Table There are two ways. The first is to double-click the table name in the object window. This will open the table in datasheet view. It will also provide a Design icon in the Home tab. This icon resembles a protractor. Click on the icon to view the table design. The quicker way to do this is to right click on the table name in the object window. This will open a short-cut menu where you can choose “Design View.” Two Mistakes that Will Cause Error Reporting When Creating Relationships Data type mismatches – the PK and FK must be of the same data type Referential integrity error – there is data in the FK field that does not exist in the PK field of the related table. ACCT-361: Helpful Hints Tables and Relationships Create a New Database Using your start button, locate the Microsoft Office folder under “All Programs” and click on Microsoft Access. Choose a blank database and click “Create”. Create a New Table Select the Create tab and then choose Table Design in the create toolbar. Once you have chosen a field name and a data type, carefully review the field properties at the lower part of the screen. You may want to change the size or format of the field, create input masks, or add validation rules. We will learn more about the masks and rules in our controls lab. Set Primary Key Highlight the row of the field you wish to make the primary key by clicking in the gray box next to the row. Select the Primary Key icon on the toolbar. To remove the key from a field, highlight the row of the field. Select the key icon on the toolbar. To create a composite primary key using two attributes, highlight both rows at the same time and select the key icon. Create Relationships and Enforce Referential Integrity Select the Database Tools tab. Click on the Relationships icon on the toolbar. It resembles an ER diagram. Select the tables in your database one at a time. If you accidentally close the window that lists your tables, select the “Show Tables” icon on the toolbar under the Design tab. To create the relationships, highlight a foreign key in your table. Drag it and place it on top of the corresponding primary key in the related table. A window will pop up that allows you to edit the relationship. Select “Enforce Referential Integrity.” If you forgot to enforce referential integrity when setting your relationships, in the relationships window, highlight the relationship line and right click. A short-cut menu will appear that will allow you to edit the relationship. To Return to the “Design” View of a Table There are two ways. The first is to double-click the table name in the object window. This will open the table in datasheet view. It will also provide a Design icon in the Home tab. This icon resembles a protractor. Click on the icon to view the table design. The quicker way to do this is to right click on the table name in the object window. This will open a short-cut menu where you can choose “Design View.” Two Mistakes that Will Cause Error Reporting When Creating Relationships Data type mismatches – the PK and FK must be of the same data type Referential integrity error – there is data in the FK field that does not exist in the PK field of the related table.