The Purpose of the Projects
The purpose of these projects is to give you an opportunity to choose an
aspect of the database field and learn something more about it yourself. The
field is so large that I cannot possibly cover all everything students may
be interested in.
- Most student choose to develop a front end for a database, and make
it user friendly so that friends or family actually use it.
- Usually this includes forms for data entry and canned queries
- Often this front end uses PHP with MYSQL or PostGres to put the
database on the web.
- Sometimes students use Acess because their client want to be able
to use their own PC.
- Some students concentrate on the design, while other concentrate on
making the front end user friendly.
Your summary (due March 29) should include:
- Who is working on your project (one or two people may work on a
project),
- What the focus of learning on your project will be,
- A paragraph about the purpose of the database involved in your project,
- How it will be implemented (what DBMS you intend to use).
What your project should include:
- An abstract of your project: its purpose and how that will be accomplished
- An English description of the database to be implemented
- An E-R diagram
- The relation schema derived from the E-R diagram, showing PK, FK and other
constraints
- The implementation of your DB in the DBMS of your choice
- Some sort of front end to your DB that makes it possible (easy) for non CS
people to use
How your project will be graded
- You will need to turn in:
- a formal abstract of your project,
- the English description of the database to be implemented,
- an E-R diagram, and
- the relational schema with constraints.
- You may also want to include problems you encounted, and how (or if) you
overcame them.
- You should plan and practice a five-to-ten minute demontration showing off
your project.
You MUST plan and time your demo. You will be given no more than ten
minutes, no matter what kind of catastrophe occurs.
- Your grade will be a combination of the written work you turn in and what
your demo shows.
- There will be a signup sheet for you to sign up to demo your project. The
demo week will be the week of April 19. You should turn your paper work in
on the 19th, so I can have some background on your project before you demo it.