Courses/Computer Science/CPSC 203/CPSC 203 Template/Labs Template/Assignment 2 (Databases)

=Assignment Description= In this assignment, you will be using existing database tables and queries for “Website Data” as a guide and create a similar analysis for “Language Data”. Additionally you should 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:
 * Due: April 03 2009 at 11:59PM
 * 1) comparing the language data by classes
 * 2) comparing some other data in this database to the language data.

Depending upon your instructor, the data for this assignment can be found by clicking on this link:


 * 1) Jalal Kawash -- [[Media:ClassSurvey-Jalal.mdb]]
 * 2) Wayne Eberly -- [[Media:ClassSurvey-Wayne.mdb]]
 * 3) Donny Cheung -- [[Media:ClassSurvey-Donny.mdb]]

=Resources=
 * Background information regarding this assignment is available in this document [[Media:W09_Assignment2Background_Information.doc]]
 * Query Information regarding this assignment is available in this document [[Media:W09_Assignment2QueryReview.doc]]

=Objectives=
 * 1) To emphasize and 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) Students must use the appropriate survey database depending upon who your instructor is. If you use wrong starting database then your TA will award you F grade.
 * 2) *Jalal Kawash -- [[Media:ClassSurvey-Jalal.mdb]]
 * 3) *Wayne Eberly -- [[Media:ClassSurvey-Wayne.mdb]]
 * 4) *Donny Cheung -- [[Media:ClassSurvey-Donny.mdb]]
 * 5) 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.
 * 6) Create appropriate primary keys for all tables.
 * 7) Create a Data Entry form for "LanguageRankings”
 * 8) Create a simple report based on your final query summarizing the “Language” data.

=Marking Guidelines=
 * 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) General Correctness and Good Design: 10 points

=Submission= Name the assignment file: Assign1_LastName_FirstName_StudentID.mdb. 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). The deadline for take-home assignments is firm. No extensions will be granted under any circumstances. If you are unable to submit through Blackboard due to technical difficulties, then and only then, email submissions will be accepted, as long as they are received by your instructor before the deadline.

=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

--Jey 23:59, 1 March 2009 (MST)