Cs 302 vocab reverse
Terms
undefined, object
copy deck
- A single piece of information within a record, such as zip code, name, address, etc.
- Attribute
- A unique field in a table that can be used as a primary key, there can be several candidate keys in a given table
- Candidate Key
- Deletes all records in all related tables when the primary key of a given table is deleted
- Cascade delete
- Updates all records in all related tables when the primary key of a given table is update
- Cascade Update
- John Doe, 114 N. Wilkshire Ave, 309-309-0099
- Customer Table
- or 'table' used in an ER diagram to represent a table in the database to be created
- Entity
- Entity relationship diagram used to visually illustrate the relationships in a database
- ER Diagram
- A temporary view of information in the database to get quick answers based on a table or query
- Filter
- The primary key of a table used in a table other than its own to relate those two tables together
- Foreign Key
- Shows a single view of the information used int he pivot table by utilizing the row OR column area and the details area
- Pivot 1D
- Provides multiple views of information used in the pivot table by utilizing the Row AND Column area as well as the detail area
- Pivot 2D
- A powerful data-analysis tool used to summarize hundreds of records in a concise tabular format
- Pivot Table 1D/2D
- The unique field that uniquely identifies each record in a table
- Primary Key
- A permanent view of information in the database based on criteria
- Query
- A single instance of the type of object that the table that contains the record is, EX.
- Record
- Ensures that the data in a database stays consistent and precise
- Referential Integrity
- used to show how data relates form on table to another table in a ER diagram, comes in three different types 1-1, 1-M, M-M
- Relationship
- An object in a database that stores records of a single object, such as Customer, Item, Team, Associate etc.
- Table