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) |