COMPSCI 1BA3 Study Guide - Midterm Guide: Database, Relational Database, Foreign Key
9 Dec 2012
School
Department
Course
Professor
Document Summary
Identify each entity and it"s individual attributes: entity- a person, object or event. Next, define each entity"s attributes as a set of fields: fields- a single characteristic or attribute of the entity, table- collection of fields which describes the entity. Relational database- a group of related tables (simply known as database ) Common field- ability to connect records in the separate tables which appears in both. Primary key (pk)- a field, or collection of fields, whose values uniquely identify each record in a table. Foreign key (fk)- when you combine a pk from one table to form a relationship between two tables, the field is now called a fk. Dbms- software program that lets you create databases and then manipulate data in them. Query- can be thought of as a question you ask about the data stored in the database. Simple query wizard- used to quickly select records and fields to form a question.
