Database Design
3 credits
All objectives are discovered | 30 |
All subjects are identified | 30 |
All fields are identified | 40 |
Total | 100 pts |
To identify mission objectives and subjects for a given database
Biag Domhrt is responsible for administering the local chapter of a national student art contest. In previous years this contest, which spans all of Oklahoma, was carried out using paper forms that were sent through the mail. Because this was a slow and error prone process Biag has decided that this year he would like to move the contest online and has hired a web developer to create a web application for managing the project. This web application will store all of the contest data in a database, which is where you come in. Biag and his web developer have hired you to design their database.
To get you started you are being provided with Biag's email address (biag@suchnull.com) and all of the paper forms and spreadsheets that were used in previous years to run the contest. Based on the project information you've been provided and any answers you receive to questions you ask Biag, create a mission statement and compile a list of mission objectives for the project.
From this list of mission objectives create a list of subjects that it appears is needed for the project database.
Using the project description you were given as well as the additional forms, create a preliminary field list for the project database.
All of the information gathered for this lab should be written into a plain text file and submitted as your solution.