Final Project - Relational Database Design and Implementation.
In this lab you will be designing a relational database; you will need to describe the specifications and information need(s) the database must fulfill.
Think of an genetics/bioinformatics information system of which a database should be a component. The system may be one you've studied for another class, one you would like to have at work or for your own use, or one with which you'd like to experiment. You may also make use of publicly available databases to include as entities in your model.
Describe the situation. Include a description of the information
system, its purpose, the intended users, the attribute domains, the types of
queries you expect, and any other assumptions you are making. Be sure that
your assumptions are realistic. The description should be at least 2
paragraphs in length, but will probably be longer. (20 points)
Draw an ER diagram that represents the information that should
be in your database. Include attributes, cardinality, participation,
specialization (if any), etc. (25 points)
Design the database schema (tables) for your database. Indicate
the primary keys, foreign keys, and functional dependencies for each table. (25
points)
Create the database, and add some representative records (5-10)
to each table. (10 points)
Write 5 queries that are typical of your application, and run
them. (20 points)
To hand in your database, please email the database (parts 3-5) to me and print out and hand in the text description (part 1) and the diagram (part 2).
© Bradley Hemminger