VIEWS: 10 PAGES: 3 POSTED ON: 7/14/2012
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 spreadsheet. 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 appropriate) 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 instructor. 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 student. 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 class.
Pages to are hidden for
"Database Fundamentals Final Project"Please download to view full document