Study Guides (248,409)
Canada (121,518)
Economics (463)
ECON 1BB3 (164)
Midterm

Comp Sci Midterm 2.docx

2 Pages
124 Views
Unlock Document

Department
Economics
Course
ECON 1BB3
Professor
Rita Cossa
Semester
Winter

Description
Comp Sci Midterm 2­ Review Notes 1.1 • Shutter Bar (Open/Close Button):  allows you to open/close the navigation pane  (arrow on the right of the navigation pane) • Navigation pane: area that lists all the objects in the database (tables, reports,  etc.)­ (thing on the left) • Datasheet view: shows the tables contents as a data sheet • ID column­ the automatic primary key field which access makes • Add and delete group: contains operations for adding different types of fields,  including text and currency • Datasheet: displays the table’s contents in rows and columns similar to  excel­  each row will be a separate record in the table, and each column will contain the  field values for one field in the table • Field: a single characteristic or attribute of a person, place, object, event or idea • Table: collection of fields that describes a person, place, object, event or idea • Field value: specific value or content (name/header) • Record: the set of all field values • Database/relational database: a collection of related tables • Primary key: field or collection of fields whose values uniquely identify each  record in a table (no two records can contain the same value) • Foreign key: when you include the primary key from one table as a field in a  second table to form a relationship between two tables • Database management system (dbms): lets you create databases then manipulate  them o Allows you to create table structures containing fields, tables and table  relationships o Add new r
More Less

Related notes for ECON 1BB3

Log In


OR

Join OneClass

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

Sign up

Join to view


OR

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.


Submit