Database Assignment - Spring 2010

Assignment: Create a database. Add data. Create SQL statements and navigation buttons.

Your database MUST be on a different topic from anyone else in the class.

Examples:

When you have picked your topic, Ms. Gorski will help you design your database. Do not change the design without permission. Many students in the past have fallen into this trap and have had to completely redo their database because they did not design it the way they should have. Database design is not easy.

The database that you make will be marked using this rubric:

  Checklist Level 1 Level 2 Level 3 Level 4 Level 4+
Data - tables and records
  • 2 Tables
  • 30-60 records
  • Additional table
  • Additional field
  • Hyperlink in a field
  • Bitmap picture in a field
 All required tables. 30 records in total. 40 records in total. 50 records in total. Excessive numbers of records OR extra features: hyperlink in a field, pictures in a field. Many of the features listed in Level 4.
Queries - SQL statements
  • Query with select
  • Query with from
  • Query with Join
  • Query with Order by
  • Query with Group By
  • Variables in SQL
  • Calculations in SQL
  • SQL in SQL
 Select and From is used. Joins (two table selects) are used. Order By is used to sort. Group By is used to make subtotals. Variables used in SQL statements to allow users to ask for data. OR Calculations in SQL statements. OR SQL statements are used inside SQL statemements Many of the features listed in Level 4.
Reports
  • Report for each table
  • Report for each query
  • Pictures
  • Titles Meaningful
  • No expr100 field headings
  • Field lengths adjusted
 Report for each table. Report for each query. Pictures are used on the reports. Titles are meaningful. No "expr10000" appear as field headings. Field lengths are adjusted so data isn't cut off. Customization of font, colour to make the report your own.
Data Entry Forms.
  • data entry form for each table.
  • title
  • instructions
  • show one record at a time
  • pictures
  • pull down menu
  • radio buttons
  • tabs to group fields
  • subform
 Data Entry Form for each Table. Title on each Data Entry Form. They are set up to show only one record at a time. Instruction on each Data Entry Form. Pictures. An extra feature: Pull down menu, radio buttons, group fields in tabs, subform Many examples of level 4.
Main Menu Form.
  • buttons to each report and form.
  • named Main Menu.
  • buttons logically grouped.
  • Title.
  • Subtitles.
  • Custom pictures on buttons.
  • Sans-serif titles
  • No underlining
  • Colour scheme
 One exists. Some buttons. Buttons to each report and form. Main menu is named "MAIN MENU". Pictures are used. Well formatted. Buttons are logically grouped. Titles are used. Subtitles. Custom pictures on the buttons. Really professionally formatted - sans serif, serif fonts, no underlining, nice colour scheme.