Shopfromhome sells goods of different types and from different brands and sizes which comprises of groceries, clothing, household electronics, toys, toiletries, beverages, cosmetics, almost everything needed in an average home Shopfromhome has over three hundred (300) employees, working in different units of the company; these employees help to keep the business moving, by making sure customers are satisfied with every transaction made with the mall. Business Activities within Shopfromhome flows in this description, Goods are supplied to Shopfromhome in bulk, which is recorded into the INVENTORY BOOK Payments for the goods supplied, if goods are in good condition, payment is made. Shopfromhome sells goods supplied, to its customers in units. For every transaction, an Employee is dedicated to completing the transaction, which is recorded into a book called the SALES BOOK.

Use Microsoft Access to design a database for Shopfromhome.

- it has to capture all the activities mentioned above. - define all the tables that will be involved follow the design of the School database given in the slides

- show the attributes or fields for each table.

- draw the schema on access.