COMPSCI 1BA3 Chapter Notes -Relational Database Management System, Unique Key, Database Design
12 Sep 2013
School
Department
Course
Professor
Document Summary
Field: single characteristic/attribute of a person, place, object, event or idea. Customer id, first name, last name, phone number, contract amount, etc. Table: collection of fields that describe person, place, object, event or idea. Field value: value or content in a field. Record: set of field values (each row of field values is a record) Common field: a field that occurs in separate tables that can be used to connect records in those tables. Primary key: field/collection of fields whose values uniquely identify each record in a table (no record has the same primary key value) Foreign key: when a primary key from one table exists in another table but not as the primary key. Foreign key does not have to have unique values, two tables are related. Database management system (dbms): software program that lets you create databases and manipulate data in them. More than one user can enter, retrieve and analyze data from database.
