Using MS Access create a database system that will handle the transaction of a certain trading firm. The following are the rules and policies that govern how the business of the company will operate. Create a table for the products sold by the company. Product table should store the identification number of the product as its primary key, product description or product name, and its sale price. The firm sells its products on a retail basis to a customer. Create a table for the customers. Customer table should contain customer identification number as primary key, first name, family name, middle name, telephone number, and address. The firm buys products from different vendors; however, each product is bought from only one seller/vendor. Create a table for vendor with the following fields; vendor's identification number as a primary key, vendor's (company) name, address, telephone number, email address, contact person’s name. Build a relationship with the tables to define the policies of the company and control the data entries. Each product the firm sells must be bought from only one vendor. Build a one-to-one relationship between product and vendor. The firm sells its products to any customer on a retail basis; each customer on the other hand can buy any of the products the firm sells. Build a many-to-many relationship between customers and products. Note that you need to create a junction table when building a many-to-many relationship. Create the following queries. Query 1: Create a view that will show the vendor’s identification number, vendor’s name, and address. Query 2: Combine the first and family names of the customer to generate a view showing customer identifications and full names of the customers. Query 3: Combine vendor and product tables to show the supplier of each of the products sold by the firm. Query 4: Combine customer and product tables to show the customers buying the products. Query 5: Combine product and customer tables to show the products bought by the customers

Using MS Access create a database system that will handle the transaction of a certain trading firm. The following are the rules and policies that govern how the business of the company will operate. Create a table for the products sold by the company. Product table should store the identification number of the product as its primary key, product description or product name, and its sale price. The firm sells its products on a retail basis to a customer. Create a table for the customers. Customer table should contain customer identification number as primary key, first name, family name, middle name, telephone number, and address. The firm buys products from different vendors; however, each product is bought from only one seller/vendor. Create a table for vendor with the following fields; vendor's identification number as a primary key, vendor's (company) name, address, telephone number, email address, contact person’s name. Build a relationship with the tables to define the policies of the company and control the data entries. Each product the firm sells must be bought from only one vendor. Build a one-to-one relationship between product and vendor. The firm sells its products to any customer on a retail basis; each customer on the other hand can buy any of the products the firm sells. Build a many-to-many relationship between customers and products. Note that you need to create a junction table when building a many-to-many relationship. Create the following queries. Query 1: Create a view that will show the vendor’s identification number, vendor’s name, and address. Query 2: Combine the first and family names of the customer to generate a view showing customer identifications and full names of the customers. Query 3: Combine vendor and product tables to show the supplier of each of the products sold by the firm. Query 4: Combine customer and product tables to show the customers buying the products. Query 5: Combine product and customer tables to show the products bought by the customers

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using MS Access create a database system that will handle the transaction of a certain trading firm. The following are the rules and policies that govern how the business of the company will operate.

Create a table for the products sold by the company. Product table should store the identification number of the product as its primary key, product description or product name, and its sale price.

The firm sells its products on a retail basis to a customer. Create a table for the customers. Customer table should contain customer identification number as primary key, first name, family name, middle name, telephone number, and address.

The firm buys products from different vendors; however, each product is bought from only one seller/vendor. Create a table for vendor with the following fields; vendor's identification number as a primary key, vendor's (company) name, address, telephone number, email address, contact person’s name.

Build a relationship with the tables to define the policies of the company and control the data entries.

Each product the firm sells must be bought from only one vendor. Build a one-to-one relationship between product and vendor. The firm sells its products to any customer on a retail basis; each customer on the other hand can buy any of the products the firm sells. Build a many-to-many relationship between customers and products. Note that you need to create a junction table when building a many-to-many relationship.

Create the following queries.

Query 1: Create a view that will show the vendor’s identification number, vendor’s name, and address.
Query 2: Combine the first and family names of the customer to generate a view showing customer identifications and full names of the customers.
Query 3: Combine vendor and product tables to show the supplier of each of the products sold by the firm.
Query 4: Combine customer and product tables to show the customers buying the products.
Query 5: Combine product and customer tables to show the products bought by the customers.

Expert Solution