Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Pt 1-Database Cpts
Database Fundamentals
| Question | Answer |
|---|---|
| changes to a list causing confusion & uncertainty to said list | modification problems |
| attribute value that has never been supplied; such values ambiguous & can mean value is unknown, not appropriate, or known to be blank | null values |
| data are stores in relations & relationships between rows represented by data values | relational data model |
| consists of relations; in practice: contains relations w/duplicate rows | relational database |
| holds data about one & only one theme, in most circumstances | table |
| insert, update, & deleted are considered the | modification actions |
| international language for defining structure & processing of relational database | Structured Query Language (SQL) |
| self-describing collection of related records, or for relational databases, of related tables | database |
| set of programs used to define, administer, & process a database & its applications | database management system (DBMS) |
| set of one or more computer programs that serves as intermediary between user & DBMS | database application |
| 4th component of a data base system; employ database application to keep track of things | users |
| description of structure of database is contained within database itself; allows for contents of database to be determined by looking inside database itself | self-describing |
| common data shared between two or more tables | related tables |
| data concerning structure of data in database stored in data dictionary | metadata |
| relationship constraint on foreign key values | referential integrity constraints |
| condition which 2 or more transactions are processed against database at same time | concurrency |
| database technology used to track things used by only one user; including only a few tables, & each table would have at most a few hundred rows | personal database system |
| enormous databases supporting thousands of concurrent users; containing hundreds of tables w/millions of rows of data | enterprise-class database systems |
| study of database technology is important because databases are used increasingly in __ __ everywhere | information systems |
| purpose of textbook is to teach essential database concepts, technology, & techniques needed to become a __ __ | database developer |
| helps people keep track of things | purpose of a database |
| exists when storing of 1 row in table records facts about 2 themes, deletion of a row removes facts about 2 themes, or data change must be made in multiple rows for consistency | types of modification problems |
| assigns unique identifier to specific rows because said rows may have duplicate information | ID column |
| process tables in relational databases; join together & display data stored in separate tables, create new tables, & query data from tables in many ways; use to insert, update, & delete data | purpose of SQL |
| when two tables share data or themes | relationships in relational databases |
| database, DBMS, one or more database applications, & user | four components of databases |
| creates & processes forms | application metadata |
Created by:
lfrancois
Popular Computers sets