Use the drop-down menus to explain how to create a one-to-one relationship using the primary keys of two tables. 1. Open the database.
2. On the Database Tools tab, in the Relationships group, click
3. On the Relationship Tools Design tab, in the Relationships group, click
4. In the dialog box, click one of the tables to add, and click Add
5. Click the other table to add, click Add, and click
6. Click and drag the primary key from a table, and drop it on the primary key of the other table.
7. In the Edit Relationships dialog box, make sure the correct fields are being linked.
8. Click the Enforce Referential Integrity checkbox, and click

Bandar industries berhad of malaysia manufactures sporting equipment. one of the company’s products, a football helmet for the north american market, requires a special plastic. during the quarter ending june 30, the company manufactured 35,000 helmets, using 22,500 kilograms of plastic. the plastic cost the company $171,000. according to the standard cost card, each helmet should require 0.6 kilograms of plastic, at a cost of $8 per kilogram. 1. what is the standard quantity of kilograms of plastic (sq) that is allowed to make 35,000 helmets? 2. what is the standard materials cost allowed (sq x sp) to make 35,000 helmets? 3. what is the materials spending variance? 4. what is the materials price variance and the materials quantity variance?