Exercise
Database Normalisation
Last update 1998.02.18 (1998.02.15 )





Get familiar with Microsoft Access by using Query By Example on exisiting databases.

Also take a look at the the design a the database to house research projects and associated data.
http://delphi.kstr.lth.se/reports/swebu97/swebu97.html#Heading14 (SWEBU - Swedish Building Research on the World Wide Web).

EXERCISE 2:

Create a database which will contain information about projects during semester 6 (spring 1998) and those students carrying them out.
  1. Define the main entities (objects) you think the database should contain.
  2. Describe those entities in database tables with appropriate attributes
    (make your own table structure - or use the one in the figure below)



  3. create the tables in Microsoft Access and define datatypes and field sizes etc. for each attribute in the table
  4. why is groupid not an attribute in the person table in the figure above?
  5. make a 'forespørgsl' (Select Query) to find out which persons belongs to which project groups and projects. Order the result by group identity.

    If you really want to have a look at possible table contents - click HERE

    If you want to down load the whole database click HERE

    Per Christiansson