BIL3203 - Database Management

Find and analyse a system that collects and stores data, declare data and data characteristics in this system, reason to keep that data, the media that keeps the data, and make a prediction about the amout of data to be collected in 1 day, 1 week (distribution of data over the days), 1 month, and 1 year.

Define your entities, their attributes and key attributes of data in your first homework. Declare thre types of relationships in your entities.

Normalize the data you collected in your homework. Define the tables and their keys.

Draw the ER Diagram of your tables. Construct your database in MS Access