Database Fundamentals Final Project by A88JtEa


									                Database Fundamentals Final Project (V10.0)

The student will create an Access database containing pertinent data, reports, forms and
queries. The final project is worth 25% of the student’s overall grade.

There will be no make-up options for final projects not turned in on or prior to the due
date assigned by the instructor. Projects may however be turned in early.

The student will be provided with the standard Database Fundamentals final project, (aka
“canned project”).

 The data for the canned project will be represented in a non-normalized Excel

   1. The student will infer the business rules based on the data in the spreadsheet.

   2. Based on the business rules the student will normalize the data into entities.

   3. The student will complete an ERD for the database.

   4. Then create the database in Access and enter all the data from the spreadsheet.

   5. The student will create the queries, forms and reports specified.

Optional independent Final Project database design: A student may be authorized to
pursue a database design of their own choosing by their instructor. Before pursuing an
independent design the student must obtain written approval from their instructor. This is
to ensure that the student is capable of completing the project in the given timeframe. The
criteria for an independent project:

   1. The student must have a work related or personal need to justify the database.
   2. The instructor must approve the database concept and establish the grading
      metrics prior to the student pursuing an independent design.
   3. “Common” database concepts that are readily available or those found in course
      materials, on internet, demos, etc will be rejected.

For evaluation and grading purposes the student will submit to the instructor:

   1. A typed listing of the business rules uncovered in #1 above.

   2. A drawn ERD that they completed in #3 above.

   3. The Access database with the appropriate data, forms, queries and reports.
The 250 total points Database Fundamentals final project will be graded on the
following criteria:

   1. A typed listing of the business rules supporting the database: (25 points)
         a. Describing the entities.
         b. Describing the attributes (with special attention to the determinants)
         c. Describing all business relationships between the entities.

   2. ERD grading criteria: (25 points)
        a. Correctly drawn syntax
        b. Correct entities, primary and foreign keys and attributes
        c. Correct relationships with optionality.

   3. The Access database overall design grading criteria: (50 points)
         a. Proper naming conventions:
         b. Appropriate Metadata (column descriptions)
         c. Appropriate datatypes, formats and input masks (where appropriate)
         d. Caption properties for all columns
         e. Correctly constructed primary and foreign keys
         f. Correctly established relationships with referential integrity (where

   4. Completed database queries grading criteria: (100 points)
        a. Correctness of the result table generated
        b. Proper query naming conventions
        c. Efficient query construction

   5. Completed database forms grading criteria: (25 points)
        a. A properly constructed startup form allowing navigation to all table forms
           and reports in print preview mode.
        b. Input forms for all tables with navigation command buttons
        c. Proper title and column naming in all forms

   6. Completed database reports grading criteria: (25 points)
        a. Accuracy of the reports
        b. Layout of the reports
        c. Proper title and column naming
The student may submit the final project in one of three ways:

1. Hard Copy: A student may turn in a floppy disk, CD or jump drive containing the
   database, ERD and listing of business rules written in MS Word. The final grade will
   be assigned by the instructor on review of the database and associated information.
   Any final project materials (jump drives, CDs etc) will not be returned to the student
   without prior arrangement with the instructor.

   All final projects submitted in this manner will only be accepted if:
        They are turned in on or prior to the completion deadline as defined by the
        All project materials are enclosed in an envelope and clearly marked with the
           student’s name, the instructor’s name and the unique number of the class.
        Submitted to the appropriate lab desk so the project can be time and date
           stamped by the lab attendant. For the Appleton campus this is the IT lab desk
           in room E105.
        Projects slipped into the instructor’s mailbox, under the office door etc will
           not be accepted.

2. One-on-one: For classroom students, the student will demonstrate their database to
   the instructor during assigned lab hours in the classroom. The instructor will review
   the database design, providing immediate feedback on the design and grade to the

   If there is insufficient time remaining in a classroom to grade the student’s project the
   instructor may make other arrangements outside of the class or collect the material
   and grade it as a hard copy assignment (#1 above).

3. Online students: Online students are expected to be able to email all final project
   materials to their instructor. In special circumstances the instructor may elect to meet
   with an online student for grading either during a regularly scheduled office hour or
   time permitting in the lab our of another regularly scheduled Database Fundamentals

To top