COMPSCI 1BA3 Lecture Notes - Database Design, First Normal Form, Management System

22 views15 pages

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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents