This database will consist of lists of food-items, drinks, sweeties and confectionaries that he owns. I will add the names of the components into a table. This table will show that

The first 200 words of this essay...

DATABASE COURSEWORK.

IDENTIFY

My Uncle Samuel is the salesman of a newsagent shop called Samuel and son's co. limited. He is busy and disorganized because he is always away on trips and is never around to take inventory of his stock. So I decided to create a database for him to help him make his business more efficient. This database will consist of lists of food-items, drinks, sweeties and confectionaries that he owns. I will add the names of the components into a table. This table will show that all the information required in the database has been entered. I spoke to him about this and he has given me this criteria:

> The database must allow him to see the details of customers quickly and easily.

> He must be able to see who owes him money.

> He wants to be able to check out customers in a location and be able to specify their location.

> He wants to be able to enter a price and see all the items and commodities above or below that price.

> He wants to be able to print a commodities price list.