click below
click below
Normal Size Small Size show me how
Database Terms
Question | Answer |
---|---|
A unique identifier for each record | Primary Key |
An attribute of one table that is related to the primary key of another table. | Foreign Keys |
A set of data that describes and gives information about other data. | Metadata |
A virtual relation defined by the database administrator in order to keep subjects from viewing certain data. | View |
An intersection of a row and a column | Cell |
A collection of related data items | Record |
A collection of records of the same type | File |
The overall Structure and Design of the database. | Schema |
A row in a two-dimensional database | Tuple |
A column in a two-dimensional database | Attribute |
The process of removing duplicates and ensuring that each attribute only describes the primary key | Normalization |
States that the primary key cannot be NULL | Entity Integrity |
Manages and controls a database | DBMS |
Central repository of data elements and their relationship | Data Dictionary |
Ensures that data entered into a row reflects an allowable value | Semantic Integrity |
Every foreign key in a secondary table has a primary key in the parent table. | Referential Integrity |
Used to create, modify, and delete tables | Data Definition Language (DDL) |
Used to query and update data stored in tables | Data Manipulation Language (DML) |