COMPSCI 1BA3 Study Guide - Final Guide: Xhtml, Autocomplete, Foreign Key
2 Nov 2013
School
Department
Course
Professor
Document Summary
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) 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.
