ITEC 1010 - M Section - Winter 2000

Assignment Four

Due: March 14

Part I - MS Access

Design and implement a relational database that includes the following features:

three tables (see below)
one form with fields from at least two of the tables
one query showing a subset of the fields and records of the main table based on at least two selection criteria
one query on multiple tables
one query on a query
one database report showing information from at least two tables, and including a suitable image file in the report header

The requirements for the tables are as follows:

the main table should contain keys into each of the other two tables
each table should contain a minimum of 10 entities and 5 attributes

Prepare a separate, typed discussion (approximately 2 pages) called "Database Design" that discusses the techniques used in the database above. Concentrate on the following:

the hierarchical nature of your data storage system and the accessibility of your data to clients
security issues involved in the collection, management and dissemination of the database information

Submission:

Please submit Part I of this assignment during the lecture on Tuesday, March 14. If you cannot attend the lecture, arrange for a fellow student to submit the assignment on your behalf.

Part I of this assignment should be on 8.5 by 11 inch paper, affixed with a staple in the top left-hand corner. Do not use a Duo-tang or other binder. Include a cover page containing, as a minimum, the course code, section, and title; your name and student number; the assignment number, part, and title.

Following the cover page, include printouts of the tables, form, queries and report. Following this, include the written discussion ("Database Design").

Late Penalty:

Submitted after the Mar 14 lecture, but before the Mar 16 lecture: 25%
Submitted during the Mar 16 lecture: 50%
Submitted after the Mar 16 lecture: 100%

Part II - HTML

(a) HTML Frames

Convert your web page from Assignment One so that it uses frames. The left side of the new design should contain a frame with links to the major sections of your resume (e.g., contact info, education, work experience, hobbies, courses taken). The contents of this frame will not change as the user navigates through the pages. The right side of the new design should contain a frame (a much larger one) to hold the pages to which the menu of links refers. That is, as the user clicks on a link in the left-hand frame, the contents of the right-hand frame changes to the page referenced by the link.

(b) HTML Stylesheets

Create a stylesheet file that specifies the following layout:

H1 headings appear in font family Comic Sans MS, colour in red, and centred
H2 headings also appear in font family Comic Sans MS, coloured in blue (and not centred)
Set the default body font size to 14 point and the default font family to Arial
A class attribute for text body to be used with the DIV tag, named sub1 (for subsection 1), which indents the text division by 20 pixels and sets the font size to 12 point.
Ordered and unordered lists to have orange text of courier font, size 10 point and background colour cyan.

Create an HTML document that uses this stylesheet file and demonstrates each feature in the stylesheet.

(c) HTML Forms

This form will use the processing program "formProc.cgi", which does not need to be created. You create just the GUI and never use the Submit button.

Create a form that allows the user of the document to enter information about a course at York University. The form should have elements where the user can enter the following:

Faculty offering the course (a drop down selection list containing AK, AS, ES, FA, GL, SB, SC)
course number (e.g., ITEC1010)
credit weight (a drop down selection list containing 01, 02, 03, 04, 05, 06, and 09)
course name (e.g., Information and Organizations)

Submission:

Send email to the TA (ta1010m@math.yorku.ca). The subject line should contain your student number and last name, for example

    Subject: 2012345678, Smith

The body of the email messagge should contain the URLs for each section of your assignment, for example:

    http://www.student.yorku.ca/~yu123456/Ass4PartIIa.html 
    http://www.student.yorku.ca/~yu123456/Ass4PartIIb.html 
    http://www.student.yorku.ca/~yu123456/Ass4PartIIc.html

The assignment must be accessible on the Web. If a URL does not access a document it will be considered that you did not submit that section of the assignment. To avoid typing mistakes, it is suggested that you copy-and-paste the URLs from Netscape into the email message.

Late Penalty:

E-mail messages posted after midnight on March 14 will be accepted with the following penalty:

Received before midnight on March 15: 25%
Received before midnight on March 16: 50%
Received before midnight on March 17: 75%
Received on or after March 18: 100%

If you have any questions, please send email to the TA: ta1010m@math.yorku.ca