Deadline: Monday November 24 at 10:00 P.M.

Assignment 2 you will be using existing database tables and queries for “Website Data” as a guide, create an analysis of the “Language Data”. Additionally you are to create a data entry form for table "LanguageRankings" and a simple report based on your final Language data summarization query. For full marks, you have to go beyond just using the queries in the starting database and add an additional level of analysis which can be done either: 1) comparing the language data by classes 2) comparing some other data in this database to the language data.

The data for this assignment can be found by clicking on this link: [ClassSurveySample_Asst2.mdb]

Resources

Background information regarding this assignment is available in this document [Media:F08 Assignment2Background Information.doc]

Query Information regarding this assignment is available in this document [Media:F08 Assignment2QueryReview.doc]

Objectives

  1. To practice organizing spreadsheet data into a relational database and thus reinforce the principles of relational database design.
  2. To gain experience performing a realistic data analysis exercise using database queries.
  3. To introduce the idea of building up an analysis via sequential queries. Each query does one step of the required data organization or analysis at a time.

Steps

  1. Use the database that contains the survey information that you entered this year: [Starting database]
  2. Using the existing queries in the starting database (which organize and analyze the “Website Data”) as your guide, develop a matching series of queries to organize and analyze the “Language” data section of the survey.
  3. Create appropriate primary keys for all tables.
  4. Create a Data Entry form for "LanguageRankings”
  5. Create a simple report based on your final query summarizing the “Language” data.

Marking Guideline

Grading (main assignment): 100 Points

  1. Queries: 60 points (10 points for queries that incorporate new analysis)
  2. Table “LanguageRankings” properly loaded: 6 points
  3. All tables with appropriate primary keys: 4 points
  4. Simple Data Entry form based on “LanguageRankings”: 10 points
  5. Simple Report based on your final data summarization query for the Language data: 10 points
  6. Data Entry and Report Design: 10 points.

Grading (bonus portion of the assignment): 10 points

The current database design contains 6 tables. Try refine the current design to eliminate redundant information in tables. Present your alternative database design as a set of table designs and table relationships in an Access database named "Assign2Bonus_LastName_FirstName_StudentID.mdb".

Marking Sheet for Assignment 2 Database: [Excel spreadsheet]

Submission

Name the assignment file: Assign1_LastName_FirstName_StudentID.xls. Submit the assignment in the fashion described in the assignment submission specifications. NOTE: It's highly recommended that you save your database in Acess2003 format rather than as an Access2007 database because in the past some student submissions in 2007 would not open using Office 2007 (but the 2003 files would work).

Original Work

This assignment is not a group work project and each student must submit their own work. If in doubt, check the U of C's honesty policy: http://www.ucalgary.ca/honesty/ and check with your TA. Also be aware of U of C's definitions of Plagiarism/Cheating/Other Academic Misconduct and the penalties and procedures associated with incidents of Plagiarism/Cheating/Other Academic Misconduct: http://www.ucalgary.ca/pubs/calendar/2008/how/How_LB.htm. Finally here is a link some more specific guidelines pertinent to the course: [Academic misconduct]