CIS Exam 2

Total Flash Cards » 37
Text Size: S | M | L
Entity - is some identifiable thing that users want to track:
  • Customers
  • Computers
  • Sales
Attribute describe an entity’s characteristics.All entity instances of a given entity class have the same attributes, but vary in the values of those attributes.
DDL Short for Data Definition Language, DDL is a computer language that is used to define data structures. In Database Management Systems (DBMS), it is used to specify a database scheme as a set of definitions (expressed in DDL). In SQL, the Data Definition Language (DDL) allows you to create, alter, and destroy database objects.
Chen Notation Entity relationship model
NULL no legal or binding force; invalid.
Data recorded facts and figures
Data Model is a plan or blueprint for a database design.
  • A data model is more generalized and abstract than a database design.
It is easier to change a data model then it is to change a database design, so it is the appropriate place to work through conceptual database problems

DML
data Manipulation language It is used to retrieve, store, modify, delete, insert and update data in database.
Primary Key
  • - is a candidate key selected as the primary means of identifying rows in a relation.
    • There is only one primary key per relation.
    • The primary key may be a composite key.
    • The ideal primary key is short, numeric, and never changes.
aggregate functions Aggregate functions perform a calculation on a set of values and return a single value. Except for COUNT, aggregate functions ignore null values. Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement.
Aggregate functions can be used as expressions only in the following:
  • The select list of a SELECT statement (either a subquery or an outer query).
  • A HAVING clause.
Join - Join conditions can be specified in either the FROM or WHERE clauses
Table organizes the information about a single topic into rows and columns
Relationship Entities can be associated with one another
Tuple tuple uniquely identifies a slice of data from a cube. The tuple is formed by a combination of dimension members, as long as there are no two or more members that belong to the same hierarchy.
Derived Attributes - are attributes whose values are generated from other attributes---Something u can calculate from other attributes
Mandatory Participation IF you see a vertical hash mark THEN that entity is mandatory (required) (minimum cardinality of one [ 1]).

SQL Structured Query Language is an internationally recognized standard database language that is used by all commercial DBMSs.
Candidate Key is a key that determines all of the other columns in a relation.
Foreign Key
  • is the primary key of one relation that is placed in another relation to form a link between the relations.
    • A foreign key can be a single column or a composite key.
    • The term refers to the fact that key values are foreign to the relation in which they appear as foreign key values.
ER Model a set of concepts and graphical symbols that can be used to create conceptual schemas.
Relation
  • - is a two-dimensional table that has the following characteristics:
    • Rows contain data about an entity.
    • Columns contain data about attributes of the entity.
    • All entries in a column are of the same kind.
    • Each column has a unique name.
    • Cells of the table hold a single value.
    • The order of the columns is unimportant.
    • The order of the rows is unimportant.
No two rows may be identical.
Composite Key is a key that consists of two or more columns.
Functional Dependency occurs when the value of one (set of) attribute(s) determines the value of a second (set of) attribute(
Identifier - are attributes that name, or identify, entity instances. The identifier of an entity instance consists of one or more of the entity’s attributes.
Surrogate Key - is an artificial column added to a relation to serve as a primary key.
  • DBMS supplied
    • Short, numeric, and never changes—an ideal primary key
    • Has artificial values that are meaningless to users
    Normally hidden in forms and reports
Key is a combination of one or more columns that is used to identify rows in a relation.
Codds Rules —A Relational Database: —Rows contain data about one entity —Columns contain data about attributes of the entities —All entries in a column are of the same kind —Each column has a unique name —Cells of the table hold a single value (No commas!) —The order of the columns is unimportant —The order of the rows is unimportant —No two rows may be identical —So….you can get to any data if you know the table name, column name, and key attribute —
DBMS —The Database Management System (DBMS) creates, processes, and administers databases.
Primary key is a candidate key selected as the primary means of identifying rows in a relation.
  • There is only one primary key per relation.
  • The primary key may be a composite key.
Identifiers •Identifiers are attributes that name, or identify, entity instances. •The identifier of an entity instance consists of one or more of the entity’s attributes.
Composite identifiers are identifiers that consist of two or more attributes.
Cardinality means “count,” and is expressed as a number. •Maximum cardinality is the maximum number of entity instances that can participate in a relationship. •Minimum cardinality is the minimum number of entity instances that must participate in a relationship.
recursive relationship occurs when an entity has a relationship to itself
Data redundancy- Why is it a problom it creates redundancy, fix it by normalization
Super Key group of all possible keys
View Snap shot of database at one given point
Modification Anomaly (Three kinds)- update, delete, insert