Database:Flatfile:Tasks

Overview
A flatfile database is a database containing only one table. A spreadsheet can be used to manage a flat file database. In these exercises you are to create a separate database containing a single table.

database: Stock

1. Build a database to manage stock

.. add other fields that you think are necessary.
 * Entity (table): tblStock
 * Attributes (fields)
 * StkID, Identifier, Autonum
 * StkDsn, Description, Text, 50
 * StkWholesalePrice, Retail Price, Currency
 * StkRetailPrice, Retail Price, Currency
 * StkCount, Number in stock, Integer
 * StkLastPurchaseDate, Date last item bought, date

database: AssetRegister

2. Build a database to manage an asset register