SQL Assignment - ICS208 MYP - Jan 2010

Pick ONE of the following databases.

Sports Database (to help you remember sports team information)
- Team Table: ID, Name, Division, Ranking
- Player Table: ID, TeamID, FirstName, LastName, Position, JerseyNumber, Points
Friends Database (to help you remember your friends' phone numbers)
- Friend Table: ID, FirstName, LastName, PhoneNum, Email, Age
- Club Table: ID, Name, When it meets, When it meets, Length of meeting
- FC Table: FriendID, ClubID
Study Notes Database (to help you study)
- Term: ID, Unit Num, Keyword, Definition, Difficulty Level
- Unit: ID, Name, Course, Exam Date, Exam Time
Mark Database (to track your own marks)
- Mark: ID, Title, CourseID, CategoryID, Unit Number, Mark Value
- Category: ID, Percent, Title
- Course: ID, Name
Budgeting Database (to track your finances)
- Expense: ID, Amount, Store ID, When Purchaised, What Purchaised, Category ID, Payment method
- Store: Store ID, Name, Location
- Category: Category ID, Name

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

	Checklist	Level 1-2	Level 3-4	Level 5-6	Level 7	Level 8
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.	50 records in total.	60 records in total.	An additional field or table that is not stated in the above design. (Get approval first) OR Excessive numbers of records OR extra features: hyperlink in a field, pictures in a field.	Many of the features listed in Level 7.
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 7.
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 7.
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.