database
introduction
I have been provided with a data set which contains over five thousand records of CD Sales by an unknown company. This data set is a flat-file database. The data is split up into 15 columns separated by commas (,) and quotation marks ("). A screen dump of the data set in Notepad is shown below:
Before I design the structure I must study the data set's characteristics carefully so I will be able to create a fully customised database in Microsoft Access. To uphold the integrity of any data added in the future I will also include some data validation.
I will then create a special dummy data set and use it to carry out extensive testing to ensure that the database functions correctly and efficiently. The dummy data set will be designed to test all aspects of the database and data ranges within it, this will fully ensure its reliability.
I will then import the data and then check it carefully to make sure that it is correct. After these verification checks I will then extract some meaningful information from the database and interprete it accurately. I will attempt to identify some significant trends and then make some well informed recommendations to the company.
Click next to continue...