COMPSCI 1BA3 Lecture Notes - Database Design, First Normal Form, Management System
5 Dec 2012
School
Department
Course
Professor
Document Summary
Backstage view- select current/existing dbase or create new (blank or template) Query = ask dbase a question = english rdbms syntax; form (input), report (output) The first step is to identify each entity, and its individual attributes. Entity: a person, object or event: next, define each entity"s attributes as a set of fields; each access entity is called a table. Each field (i. e. , column) has a specific data-type. A set of field values is called a record (i. e. , row) Enter data values into your table(s) and store the data as an access 2010 file (. accdb) An access table is a two-dimensional representation of a relation. Databases and relationships: a group of related tables is properly known as a relational database; access simply uses. Restrictions on keys: pk must have unique values; no duplicates allowed, pk must not have a null value; a data value is required.
