1. Create a databse that has been approved by the course instructor
. The database should include at least four or five tables, and each table
should include at least several tuples as test
data . There should be enough tuples to thouroughly test all queries.
The report should contain the
following:
(a) A title page
containg the name of the project, the course number and name, the
instructor's name and a list of the team members.
(b) A brief description of your database requirements
( projet abstract).
(c) An ER-diagram.
(d) The schema of the database.
(e) A printout of your create table statements.
(f) A printout of the contents of all the
tables.
(g) Several examples of queries applied
to your database and their results. This should include update queries
of all types.
(h) Source code of all scripts or embedded-SQL
programs if appropriate
(i) Printouts of all tables and output
rusulting from the queries executed in (e,f) above.
(j) A description of the team organization. What each team member
was responsible for completing on the project . In other words,
what part of the project
did each team member contribute.
(k) A summary of the project
including: How it can be enhanced; How can it be improved; Having
completed the project; what would your team do differently
if you were to
do it again.
2.You may use any relational database system you choose
. However you must demonstrate, during the period set aside for final exams,
that your database actually works. If you
choose a database other than Postgres on sandbox, you will be required
to do the complete
setup of your system in advance of your project
presentation.
3. You will be required to fill out a form evaluating your database
design project. On this form you will be required to evaluate your
performance and the performance of your fellow
team members. This assessment will assist the instructor in awarding an
individual grade for a group project. So your
project grade will be based on the professors assessment of the project
overall and
your individual performance as well
as individual team member assessment of your performance on the project.
4. Individual Projects conforming to the above criteria in (1)
above may be required of all graduate students unless they have elected
to do a research project in lieu of the above. At the discretion of the
instructor, graduate students may be required to do a group
project that must also conform to (1) above. If
a researh project is done then a research report of 12 plus pages is
required.
The format , style and area of research of this
report will be by mutual agreement with the professor.