CIS exam 2

37 cards


 
  
Created Nov 4, 2013
by
tkrause5

 

 
Table View
 
Download
 
Print

Flashcard Set Preview

  Side A   Side B
1
Entity
 
- is some identifiable thing that users want to track:
  • Customers
  • Computers
  • Sales
2
Attribute
 
describe an entity’s characteristics.All entity instances of a given entity class have...
3
DDL
 
Short for Data Definition Language, DDL...
4
Chen Notation
 
Entity relationship model
5
NULL
 
no legal or binding force; invalid.
6
Data
 
recorded facts and figures
7
Data Model
 
is a plan or blueprint for a database design.        
  • A...
8
DML
 
data Manipulation language   It is used to retrieve, store, modify, delete,...
9
Primary Key
 
  • - is a candidate key selected as the primary means of identifying rows in a...
10
aggregate functions
 
Aggregate functions perform a calculation on a set of values and return a single value. Except...
11
Join
 
- Join conditions can be specified in either the FROM or WHERE clauses
12
Table
 
organizes the information about a single topic into rows and columns
13
Relationship
 
Entities can be associated with one another
14
Tuple
 
 tuple uniquely identifies a slice of data from a cube. The tuple is formed by a combination...
15
Derived Attributes
 
- are attributes whose values are generated from other attributes---Something u can calculate...
16
Mandatory Participation
 
IF you see a vertical hash mark THEN that entity is mandatory (required) (minimum cardinality...
17
SQL
 
Structured Query Language is an internationally recognized standard database language that...
18
Candidate Key
 
is a key that determines all of the other columns in a relation.
19
Foreign Key
 
  • is the primary key of one relation that is placed in another relation to form...
20
ER Model
 
a set of concepts and graphical symbols that can be used to create conceptual schemas.
21
Relation
 
  • - is a two-dimensional table that has the following characteristics:
    • Rows...
22
Composite Key
 
is a key that consists of two or more columns.
23
Functional Dependency
 
occurs when the value of one (set of) attribute(s) determines the value of a second (set of)...
24
Identifier
 
- are attributes that name, or identify, entity instances. The identifier of an entity instance...
25
Surrogate Key
 
- is an artificial column added to a relation to serve as a primary key.
  • DBMS...
26
Key
 
is a combination of one or more columns that is used to identify rows in a relation.
27
Codds Rules
 
—A Relational Database: —Rows contain data about one entity —Columns contain...
28
DBMS
 
—The Database Management System (DBMS) creates, processes, and administers databases.
29
Primary key
 
is a candidate key selected as the primary means of identifying rows in a relation.
  • There...
30
Identifiers
 
•Identifiers are attributes that name, or identify, entity instances. •The...
31
Composite identifiers
 
are identifiers that consist of two or more attributes.
32
Cardinality
 
means “count,” and is expressed as a number. •Maximum cardinality is the...
33
recursive relationship
 
occurs when an entity has a relationship to itself
34
Data redundancy- Why is it a problom
 
it creates redundancy, fix it by normalization
35
Super Key
 
group of all possible keys
36
View
 
Snap shot of database at one given point
37
Modification Anomaly (Three kinds)-
 
update, delete, insert

No comments yet! Be the first to add a comment below!

Please login to post comments.
After login, we will forward you back to this flashcard.


Upgrade and get a lot more done!
Upgrade    Cancel