Study Guides (400,000)
CA (150,000)
McMaster (9,000)
COMPSCI (40)
Final

COMPSCI 1BA3 Study Guide - Final Guide: Xhtml, Autocomplete, Foreign Key


Department
Computer Science
Course Code
COMPSCI 1BA3
Professor
Dr.Hurst
Study Guide
Final

This preview shows half of the first page. to view the full 3 pages of the document.
Final Exam
Monday, December 10, 2012
9:00-11:00
Pre-Exam Review
Excel
10% of exam deals with excel
More about concepts and terminology
Not about key strokes and key presses
Some of it involves syntax (IFs, VLOOKUP, etc.)
Hardest part of excels is pivot tables
If contain three parts: the condition, what to do if its true and what to do if its
false
Nested IF: one structure inside another structure
Test nested ifs separately (build in steps)
Access
Know terms and understand concepts
What is a key
How do we establish relationships between entities
What’s the difference between a foreign key and a primary key
What are the simple names for tuples and records
Want to populate primary table with data first then the foreign table
When deleting do it the opposite way (foreign table then primary table)
Do not need to know where the buttons are just understand what it means to
perform that action
What is the navigation pane for: collects and lets you see the various objects
you have in your database
Use wizard to do reports and forms (know what they are for one for input
one for output)
Use wizard to do the job then fix it to your specific needs
When making a query you make it first and do not use the wizard (can use
QBE)
Importing from text files
Difference between ordinary text files from csv text files
Enforce integrity constraints: referential integrity (foreign key value cannot
be used unless the primary key value exists in another table), cascade update
and cascade delete (why do not always tick off because do not necessarily
want to lose records in the primary table)
Constraint on primary key: uniqueness
Relational operators are comparison operators (less than, greater than, equal
to)
Logical operators (and, or)
You're Reading a Preview

Unlock to view full version