Databases Work Conditions Hand in by august 30th

DATABASE DESIGN PROJECT.


This is an individual piece of work


• Create your own database management package using relationship one to many or many to many your work must be an original piece of work (no CD no Dogs no library)

To hand in this work you must include a report containing:
Title page members of the group, project title.


• The topic:


• The objectives


• Database structure



Remember:

Decide on the tables in your proposed database system

Identify the fields that belongs to each of the tables.

Identify the relationship between these tables

Decide the properties of each field.

• Design at least 6 different complex queries (consultas).
In the report you must explain each query.
Show the SQL code for each query.

• Sort and index different data.

• Design a form (Formulario) to enter data.

• Design a form (formulario) to visualize data.

• Make at least six reports (Informes) the Repot must be complete with identification of the pupils logos

You must include the location of your database (name, computer) and the information of how to load and use the database.