TASK 1:

Create 3 tables named as Seller, Buyer, and Product.

Buyer: Buyer ID, Buyer Name, Contact #, Address

Seller: Seller ID, Seller Name, Contact #, Address, Product ID

Product: Product ID, Product Name, Price per product.

Orders: Order ID, Buyer Name, Product name

Use appropriate primary keys in each table. Create relationships between the tables and display all the products a buyer having ID no 3 has purchased.

If you find any field missing in a table, you may add it

Attach the screenshots of all tables in design views and datasheet views and relationship among tables

SOFTWARE : MS ACCESS

SOLVE PLEASE AS SOON AS POSSIBLE NEED URGENT