COMPSCI 1BA3 Lecture Notes - First Normal Form, Management System, Meridian Regional Airport
4 Dec 2012
School
Department
Course
Professor
Document Summary
Each access database can be 2gb, can have 32,768 objects and 255 people can use it at the same time. Field: single characteristic or attribute of a person, place, object, event or idea. Content of a field is called a field value. The data type determines what field values you can enter for the field. Table: collection of fields that describes as person, place, object or idea. A collection of related tables is called a database or relational database. You can connect the records in separate tables through a common field that appears in both tables. A primary key is a field, or a collection of fields, whose values uniquely identify each record in a table. When you include the primary key from one table, as a field in a second table, to form a relationship between two tables, it is called a foreign key.
