3 Pages
Unlock Document

York University
Information Technology
ITEC 1010
Marina Erechtchoukova

Part I: [50] Each Question is worth 1 point You should first answer in the booklet, and then transfer your answers to the answer sheet provided. Your mark is the total of correct answers, wrong answers are NOT deducted. Contains multiple choice and True/False questions. See Mid-Term example Part II: [10] Short Answers 1. [4] List, but do not describe, main components of expert systems: 1. 2. 3. 4. 2. [6] Database management systems can be classified according to underlying data model. List, but do not describe six types of DBMS. 1. 2. 3. 4. 5. 6. 1 Part III: [20] HTML See Assignment # 4 Part IV: [20] MS Access: 1. Design two tables, which are part of a database, by completing the forms below. Enter information only in cells where the cell is applicable to the field. The following assumptions are to be used: • Student ID contains 9 alphanumeric symbols • No first or last name is longer than 25 characters • Most students live in Toronto • Most students have phone numbers with the area code 416 • No course code is longer than 8 characters • A mark is added to the table only if it is greater than or equal to 50 • Maximum mark is 100 Table: Student Field Name Field Type Field Primary Default Value Validation Rule Length/Subtype Key (check if true) Stud
More Less

Related notes for ITEC 1010

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.