COMPSCI 1BA3 Study Guide - Midterm Guide: Database, Relational Database, Foreign Key

25 views2 pages

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.

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

Related Documents