Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
27 Cards in this Set
- Front
- Back
How many components does a data base system have and what are they?
|
4
Users, database application, dbms, and database |
|
Database
|
A collection of related tables and other structures
|
|
DBMS
Database Management system |
a computer program used to create, process, and administer the database
|
|
Database application
|
a set of one or more computer programs that serves as an intermediary between the user and the DMBS
|
|
Users
|
employ a database application to keep track of things.
|
|
A database is self-describing collection of related tables. Define the two terms.
|
Self-describing: a description of the structure of the database is contained within the database itself
related tables: I.e (adviser and student) relate to eachother |
|
Metadata
|
data about the structure of a database
|
|
Functions of a DBMS
|
create database, create tables, create supporting structures, read database data, modify(insert, update, or delete) database data, maintain database structures, enforce rules, control concurrency, provide security, preform backup and recover
|
|
Referential integrity constraint
|
rules the DBMS enforces (find notes to elaborate more)
|
|
concurrency
|
controlled by ensuring that one users work does not inappropriately interfere with another user's work.
|
|
Functions of database application programs
|
create and process forms, process user quieries, create and process reports, execute application logic, control application
|
|
what are the three type of modification problems(actions)
|
insert, delete, change(update)
|
|
Entity
|
the formal name for a "thing" that is being tracked. Defined as something of importance to the user that needs to be represented in the database.
|
|
Relation
|
special type of two dimensional table consisting of rows and columns
|
|
What is the equivalent term for a table?
|
File or Relation
|
|
What is the equivalent term for a row?
|
Record or Tuple
|
|
What is the equivalent term for a column?
|
Field, Attribute
|
|
Composite Key
|
a key that contains two or more attributes
|
|
Candidate key
|
keys that uniquely identify each row in a relation. Candidate to becoming the primary key
|
|
Primary Key
|
the canidate key that is chosen as the key that the DBMS will use to uniquely identify each row in a relation
|
|
Surrogate Key
|
a column with a unique DBMS-assigned identifier that has been added to a table to be the primary key.
|
|
Surrogate Key T or F
1. the values change |
False
|
|
Foreign Key
|
The primary key values used in the first relation becomes an attribute in the second relation with the same value
|
|
Null value
|
missing value in a cell in a relation.
No value is appropriate, the value is known to be blank, the value is simply unknown |
|
What is the functionally dependent and what is the determinant in:
Cookiecost= NumberofBoxes x 5 |
dependent is cookie cost
determinant is numberofboxes |
|
NumberOfBoxes---->CookieCost
|
The numberofboxes determines cookiecost
|
|
(Quantity, UnitPrice) ---> ExtendedPrice
|
the composite quantity and unit price is the determinant of extendedprice
|