Develop a structurally sound relational database schema showing the minimum number of fields, tables, and relationships between the tables. Do not identify any properties of any of the fields other than the field names and whether or not the field is a key field. (An Access-like relationship diagram would be fine.)
You need to track the following information:
Customer Name and Address
Inventory Description and Part Number
Sales Transactions to each customer (assume that only one type of item is sold in each transaction)