Query
a message to the database requesting data from specific records and fields
Relational Database Model
consists of tables
Primary Key
uniquely identifies by each column
used to link tables
Entity Relationship Diagram
a graphical representation of all entity relationships
high level plan for databases
Logical or relational diagram
shows each relation as a table
- see how databases are related to each other through these primary keys
Data dictionary
a repository of information about the data and their organization
- consists of schema and metadata
Schema
a plan that describes the structure of the databases, including
- names and sizes of fields
- id of primary keys
- relationship
Metadata
additional details about the data
- source of the data
- tables related to the data
- field and index information
- programs and processes that use the data
- population rules: what is inserted, or updated, and how often
SQL (Sequeled query languages)
languages database management systems used to create, retrieve, and update data in a relational database
Attributes
- Object-oriented database model
characteristics of an object (id, size, start year, etc) stored as data
Object-oriented database model
uses an object-oriented approach for the database structure
- store OBJECTS not records
- consists of different OBJECTS that have ATTRIBUTES and METHODS
Methods
- Object-oriented database model
Procedures an object can perform (grade, play, etc)
Data warehouse
a large repository database that supports management decision making
Data mart
a smaller collection of data focusing on a particular subject or department
