Question

EasyRentals maintains the following data: VENDOR (Vendor code (unique for each vendor), name, street number, street name, city, region, postcode). PRODUCT (SKU (unique for each product), name of the product, description, price, quantity on hold, make, model, vendor code) SALES REP (sales rep number (unique for each sales rep), first name, last name, email, phone, hired date) CUSTOMER (customer code ((unique for each customer), first name, last name, street number, street name, city, region, postcode) RENTS (add the necessary detail based on the business rules indicated in the narration) 1. Using Microsoft Access, create the following and the additional required tables. There is a many-to-many relationship, and you are required to break it down into two one-to-many relationships before you create the tables. You are also required to choose the appropriate data type for the attributes. (10 marks) (Hint: create tables in a sequence first parents and then child tables)

A. VENDOR
B. PRODUCT
C. CUSTOMER
D. SALES REP
E. RENTS

Answer 1

To create the required tables in Microsoft Access, break down the many-to-many relationship into two one-to-many relationships and create parent and child tables.

Step-by-step explanation:

To create the required tables in Microsoft Access, you will need to break down the many-to-many relationship into two one-to-many relationships. This means you'll create a parent table and a child table for each relationship. For example, in the case of VENDOR and PRODUCT, create a VENDOR table with attributes like Vendor code, name, street number, etc. Then, create a PRODUCT table with attributes like SKU, name, description, etc., and include the Vendor code as a foreign key. Repeat this process for each relationship.