Study sets matching "database processing chapter 6"

Study sets
Classes
Users

Study sets matching "database processing chapter 6"

51 terms
Database Processing Chapter 6 & 5
Each attribute of an entity becomes a…
A surrogate key should be considered w…
Which of the following is not true abo…
In a relational database design, all r…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
Answer: C... Diff: 3 Page Ref: 194
Answer: C
Answer: B
Each attribute of an entity becomes a…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
A surrogate key should be considered w…
Answer: C... Diff: 3 Page Ref: 194
51 terms
Database Processing Chapter 6 & 5
Each attribute of an entity becomes a…
A surrogate key should be considered w…
Which of the following is not true abo…
In a relational database design, all r…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
Answer: C... Diff: 3 Page Ref: 194
Answer: C
Answer: B
Each attribute of an entity becomes a…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
A surrogate key should be considered w…
Answer: C... Diff: 3 Page Ref: 194
51 terms
Database Processing Chapter 6 & 5
Each attribute of an entity becomes a…
A surrogate key should be considered w…
Which of the following is not true abo…
In a relational database design, all r…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
Answer: C... Diff: 3 Page Ref: 194
Answer: C
Answer: B
Each attribute of an entity becomes a…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
A surrogate key should be considered w…
Answer: C... Diff: 3 Page Ref: 194
51 terms
Database Processing Chapter 6 & 5
Each attribute of an entity becomes a…
A surrogate key should be considered w…
Which of the following is not true abo…
In a relational database design, all r…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
Answer: C... Diff: 3 Page Ref: 194
Answer: C
Answer: B
Each attribute of an entity becomes a…
Answer: A... Diff: 1 Page Ref: 193 Fig 6-1
A surrogate key should be considered w…
Answer: C... Diff: 3 Page Ref: 194
100 terms
Database Processing-Chapter 1
(T or F) 1)The purpose of a database i…
(T or F) 2)In a database, each table s…
(T or F) 3)In a database, each row in…
(T or F) 4) In every database, not jus…
TRUE... Diff: 1 Page Ref: 3
TRUE... Diff: 1 Page Ref: 3
FALSE... Diff: 2 Page Ref: 3
FALSE... Diff: 2 Page Ref: 3
(T or F) 1)The purpose of a database i…
TRUE... Diff: 1 Page Ref: 3
(T or F) 2)In a database, each table s…
TRUE... Diff: 1 Page Ref: 3
90 terms
Database Processing-Chapter 4
(T or F) 1) When you are given a set o…
(T or F) 2) The first step in assessin…
(T or F) 3) To count the number of row…
(T or F) 4) To determine the number an…
TRUE... Diff: 1 Page Ref: 128
TRUE... Diff: 2 Page Ref: 128-129 Fig 4-1
FALSE... Diff: 2 Page Ref: 128
FALSE... Diff: 1 Page Ref: 128
(T or F) 1) When you are given a set o…
TRUE... Diff: 1 Page Ref: 128
(T or F) 2) The first step in assessin…
TRUE... Diff: 2 Page Ref: 128-129 Fig 4-1
100 terms
Database Processing-Chapter 5
(T or F) 1) A data model is a plan for…
(T or F) 2) An entity is something tha…
(T or F) 3) Entities of a given type a…
(T or F) 4) An entity class is describ…
TRUE... Diff: 1 Page Ref: 145
TRUE... Diff: 1 Page Ref: 145
TRUE... Diff: 1 Page Ref: 145
TRUE... Diff: 2 Page Ref: 145
(T or F) 1) A data model is a plan for…
TRUE... Diff: 1 Page Ref: 145
(T or F) 2) An entity is something tha…
TRUE... Diff: 1 Page Ref: 145
90 terms
Database Processing-Chapter 3
(T or F) 1)All relations are tables, b…
(T or F) 2) A relation is a three-dime…
(T or F) 3) A characteristic of a rela…
(T or F) 4) A characteristic of a rela…
TRUE... Diff: 1 Page Ref: 96
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
TRUE... Diff: 1 Page Ref: 97-98 Fig 3-4
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
(T or F) 1)All relations are tables, b…
TRUE... Diff: 1 Page Ref: 96
(T or F) 2) A relation is a three-dime…
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
88 terms
Database Processing-Chapter 2
(T or F) 1) SQL stands for Standard Qu…
(T or F) 2) SQL is only a data manipul…
(T or F) 3) SQL was developed by IBM i…
(T or F) 4) In addition to being a dat…
FALSE... Diff: 1 Page Ref: 32
FALSE... Diff: 3 Page Ref: 36
TRUE... Diff: 1 Page Ref: 35
FALSE... Diff: 2 Page Ref: 36
(T or F) 1) SQL stands for Standard Qu…
FALSE... Diff: 1 Page Ref: 32
(T or F) 2) SQL is only a data manipul…
FALSE... Diff: 3 Page Ref: 36
Database Processing-Chapter 3
(T or F) 1)All relations are tables, b…
(T or F) 2) A relation is a three-dime…
(T or F) 3) A characteristic of a rela…
(T or F) 4) A characteristic of a rela…
TRUE... Diff: 1 Page Ref: 96
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
TRUE... Diff: 1 Page Ref: 97-98 Fig 3-4
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
(T or F) 1)All relations are tables, b…
TRUE... Diff: 1 Page Ref: 96
(T or F) 2) A relation is a three-dime…
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
64 terms
Database Chapter 6
A table is in BCNF if every determinan…
A table is in fourth normal form if it…
Relational models view the data as par…
Dependency diagrams are very helpful i…
F
T
T
T
A table is in BCNF if every determinan…
F
A table is in fourth normal form if it…
T
100 terms
Database Processing-Chapter 1
(T or F) 1)The purpose of a database i…
(T or F) 2)In a database, each table s…
(T or F) 3)In a database, each row in…
(T or F) 4) In every database, not jus…
TRUE... Diff: 1 Page Ref: 3
TRUE... Diff: 1 Page Ref: 3
TRUE... Diff: 2 Page Ref: 3
FALSE... Diff: 2 Page Ref: 3
(T or F) 1)The purpose of a database i…
TRUE... Diff: 1 Page Ref: 3
(T or F) 2)In a database, each table s…
TRUE... Diff: 1 Page Ref: 3
Database Chapter 6
Only large database systems have a nee…
The acronym DBA refers to either the o…
The purpose of concurrency control is…
All actions in an atomic transaction a…
False
True
True
True
Only large database systems have a nee…
False
The acronym DBA refers to either the o…
True
90 terms
Database Processing-Chapter 4
(T or F) 1) When you are given a set o…
(T or F) 2) The first step in assessin…
(T or F) 3) To count the number of row…
(T or F) 4) To determine the number an…
TRUE... Diff: 1 Page Ref: 128
TRUE... Diff: 2 Page Ref: 128-129 Fig 4-1
FALSE... Diff: 2 Page Ref: 128
FALSE... Diff: 1 Page Ref: 128
(T or F) 1) When you are given a set o…
TRUE... Diff: 1 Page Ref: 128
(T or F) 2) The first step in assessin…
TRUE... Diff: 2 Page Ref: 128-129 Fig 4-1
49 terms
Database Processing Chapter Nine
Which of the following is not a databa…
Which of the following is true about m…
The task of diagnosing errors due to c…
Measures that are taken to prevent one…
a.) managing the database structure... b.) managing data activit…
a.) The DBA need not get input from users on the issue becaus…
a.) formal policies for requesting changes.... b.) database stru…
a.) concurrency control.... b.) checkpoint.... c.) database recover…
Which of the following is not a databa…
a.) managing the database structure... b.) managing data activit…
Which of the following is true about m…
a.) The DBA need not get input from users on the issue becaus…
Chapter 4 - Database Processing
database
columns
fields
rows
a self describing collection of integrated records
also called fields, or groups of bytes. has multiple columns…
another name for columns
also called records, a group of columns in a database table
database
a self describing collection of integrated records
columns
also called fields, or groups of bytes. has multiple columns…
90 terms
Database Processing-Chapter 3
(T or F) 1)All relations are tables, b…
(T or F) 2) A relation is a three-dime…
(T or F) 3) A characteristic of a rela…
(T or F) 4) A characteristic of a rela…
TRUE... Diff: 1 Page Ref: 96
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
TRUE... Diff: 1 Page Ref: 97-98 Fig 3-4
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
(T or F) 1)All relations are tables, b…
TRUE... Diff: 1 Page Ref: 96
(T or F) 2) A relation is a three-dime…
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
88 terms
Database Processing-Chapter 2
(T or F) 1) SQL stands for Standard Qu…
(T or F) 2) SQL is only a data manipul…
(T or F) 3) SQL was developed by IBM i…
(T or F) 4) In addition to being a dat…
FALSE... Diff: 1 Page Ref: 32
FALSE... Diff: 3 Page Ref: 36
TRUE... Diff: 1 Page Ref: 35
FALSE... Diff: 2 Page Ref: 36
(T or F) 1) SQL stands for Standard Qu…
FALSE... Diff: 1 Page Ref: 32
(T or F) 2) SQL is only a data manipul…
FALSE... Diff: 3 Page Ref: 36
100 terms
Database Processing-Chapter 5
(T or F) 1) A data model is a plan for…
(T or F) 2) An entity is something tha…
(T or F) 3) Entities of a given type a…
(T or F) 4) An entity class is describ…
TRUE... Diff: 1 Page Ref: 145
TRUE... Diff: 1 Page Ref: 145
TRUE... Diff: 1 Page Ref: 145
TRUE... Diff: 2 Page Ref: 145
(T or F) 1) A data model is a plan for…
TRUE... Diff: 1 Page Ref: 145
(T or F) 2) An entity is something tha…
TRUE... Diff: 1 Page Ref: 145
18 terms
Chapter 6 Database
Two-step process for database design
Information-level design
Physical-level design
User view
Information-level design... Physical-level design
completed independently of any particular DBMS
information-level design adapted for the specific DBMS that w…
set of requirements necessary to support operations of a part…
Two-step process for database design
Information-level design... Physical-level design
Information-level design
completed independently of any particular DBMS
44 terms
Chapter 5: Database Processing
Access
Attributes
BigData
Bigtable
A popular personal and small workgroup DBMS product licensed…
Characteristics of an entity. Example attributes of Order are…
A term used to describe data collections that are characteriz…
A nonrelational data store developed by Google.
Access
A popular personal and small workgroup DBMS product licensed…
Attributes
Characteristics of an entity. Example attributes of Order are…
30 terms
Chapter 5 Database Processing
Databases are required to keep track o…
A database is a self-describing collec…
Bytes, which are characters of data, a…
In a database, columns are also called…
T
T
F
F
Databases are required to keep track o…
T
A database is a self-describing collec…
T
38 terms
Chapter 5: Database Processing
fields
records
table
primary key
also called columns; groups of bytes in a database table
also called rows, groups of columns in a database table
also called files, groups of similar rows or records in a dat…
a column in a relation whose values identify a unique row of…
fields
also called columns; groups of bytes in a database table
records
also called rows, groups of columns in a database table
37 terms
Chapter 5 - Database Processing
Access
Bigtable
Byte
Cassandra
A popular personal and small workgroup DBMS product from Micr…
A nonrelational data store developed by Google.
1) Characters of data 2) 8-bit chunks
A durable, nonrelational data store that operates over hundre…
Access
A popular personal and small workgroup DBMS product from Micr…
Bigtable
A nonrelational data store developed by Google.
Database Concepts Kroenke Chapter 6
ACID Transaction
After Image
Atomic
Authentications
Is one that is atomic, consistent, isolated, and durable.
Used in recovery to perform rollforward. Applies to a redo tr…
Is one transaction in which all the database actions occur or…
Makes sure the user has the basic right to use the system in…
ACID Transaction
Is one that is atomic, consistent, isolated, and durable.
After Image
Used in recovery to perform rollforward. Applies to a redo tr…
46 terms
Chapter 5: Database Processing
What is the purpose of a database?
database
byte
columns/fields
To keep track of things
self-describing collection of integrated records
character of data
what bytes are grouped into... i.e student number, student name
What is the purpose of a database?
To keep track of things
database
self-describing collection of integrated records
51 terms
Chapter 5: Database Processing
access
attributes
BigData
bigtable
a popular personal and small workgroup DBMS product from Micr…
characteristics of an entity. example attributes of Order wou…
a term used to describe data collection that are characterize…
a nonrelational data store developed by Google
access
a popular personal and small workgroup DBMS product from Micr…
attributes
characteristics of an entity. example attributes of Order wou…
47 terms
Database Processing: 14th edition Kroenke - Chapter 9
Data administration
Database administration (DBA)
Concurrency control
A transaction, or logical unit of work…
a function concerning all of an organization's data assets.
a person or office specific to a single database and its appl…
ensures that one user's work does not inappropriately influen…
is a series of actions taken against the database that occurs…
Data administration
a function concerning all of an organization's data assets.
Database administration (DBA)
a person or office specific to a single database and its appl…
Database processing chapter 1 - 3
Database
Primary Key
Surrogate Key
Composite Key
A collection of related tables and other structures
A column that uniquely identifies a row in a table
an artificial column that is added to the table to serve as t…
Keys that have two or more columns
Database
A collection of related tables and other structures
Primary Key
A column that uniquely identifies a row in a table
25 terms
Chapter 5: Database Processing
Access
Attributes
BigData
Bigtable
A populat personal & small workgrouo DBMS product from Micros…
Characteristics of an entity.
A term used to describe data collections that are characteriz…
A no relational data store developed by Google
Access
A populat personal & small workgrouo DBMS product from Micros…
Attributes
Characteristics of an entity.
Chapter 5: Database Processing
Identify an open source DBMS product.
Which of the following is true of MySQL?
A data model is a ________.
A foreign key is essential in relation…
MySQL
It is license-free for most applications.
Logical representation of database data
TRUE
Identify an open source DBMS product.
MySQL
Which of the following is true of MySQL?
It is license-free for most applications.
21 terms
Chapter 5- Database Processing
columns
Database
Database administration
database application
bytes that are grouped together
a collection of organized data that allows access, retrieval,…
the function in an organization that is responsible for the m…
a collection of forms, reports, queries, and application prog…
columns
bytes that are grouped together
Database
a collection of organized data that allows access, retrieval,…
15 terms
Database Management: Chapter 6
atomic attribute
denormalization
dependency diagram
determinant
An attribute that cannot be further subdivided to produce mea…
A process by which a table is changed from a higher-level nor…
A representation of all data dependencies within a table.
Any attribute in a specific row whose value directly determin…
atomic attribute
An attribute that cannot be further subdivided to produce mea…
denormalization
A process by which a table is changed from a higher-level nor…
Chapter 7: Database Processing Applications
SQL/Persistent Stored Modules (SQL/PSM)
user-defined function
stored procedure
trigger
Enterprise-class DBMS products include these features that en…
Similar to a computer program function and provides a reusabl…
Similar to a computer program subroutine, but is store in the…
A program attached to a specific table or view within a datab…
SQL/Persistent Stored Modules (SQL/PSM)
Enterprise-class DBMS products include these features that en…
user-defined function
Similar to a computer program function and provides a reusabl…
90 terms
Database Processing-Chapter 4
(T or F) 1) When you are given a set o…
(T or F) 2) The first step in assessin…
(T or F) 3) To count the number of row…
(T or F) 4) To determine the number an…
TRUE... Diff: 1 Page Ref: 128
TRUE... Diff: 2 Page Ref: 128-129 Fig 4-1
FALSE... Diff: 2 Page Ref: 128
FALSE... Diff: 1 Page Ref: 128
(T or F) 1) When you are given a set o…
TRUE... Diff: 1 Page Ref: 128
(T or F) 2) The first step in assessin…
TRUE... Diff: 2 Page Ref: 128-129 Fig 4-1
Database Chapter 6
Base Table
Catalog
Data Control Language (DCL)
Data Definition Language (DDL)
A table in the relational data model containing the inserted…
A set of schemas that, when put together, constitute a descri…
Commands used to control a database, including those for admi…
Commands used to define a database, including those for creat…
Base Table
A table in the relational data model containing the inserted…
Catalog
A set of schemas that, when put together, constitute a descri…
90 terms
Database Processing-Chapter 3
(T or F) 1)All relations are tables, b…
(T or F) 2) A relation is a three-dime…
(T or F) 3) A characteristic of a rela…
(T or F) 4) A characteristic of a rela…
TRUE... Diff: 1 Page Ref: 96
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
TRUE... Diff: 1 Page Ref: 97-98 Fig 3-4
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
(T or F) 1)All relations are tables, b…
TRUE... Diff: 1 Page Ref: 96
(T or F) 2) A relation is a three-dime…
FALSE... Diff: 2 Page Ref: 97-98 Fig 3-4
97 terms
Database Processing chapter 7, 8, 9
Chapter 7... When a surrogate key is used…
Given the SQL statement... CREATE TABLE…
The SQL keyword used to limit column v…
An SQL virtual table is called _______…
d.) the relationship changes to a non-identifying relationship
c.) RepName is a candidate key
b.) CHECK
b.) a view
Chapter 7... When a surrogate key is used…
d.) the relationship changes to a non-identifying relationship
Given the SQL statement... CREATE TABLE…
c.) RepName is a candidate key
20 terms
Database Processing: 14th edition Kroenke - Chapter 7
Data manipulation language (DML)
Data control language (DCL)
CREATE TABLE statement
The DEFAULT keyword
used for Queries(SELECT), Inserting date(INSERT), modifying d…
Used to grant (or revoke) database permissions to (from) user…
used for creating relations where each column is described wi…
not a constraint
Data manipulation language (DML)
used for Queries(SELECT), Inserting date(INSERT), modifying d…
Data control language (DCL)
Used to grant (or revoke) database permissions to (from) user…
17 terms
Database Processing: 14th edition Kroenke - Chapter 8
Database redesign is necessary because
regular subquery can be processed
correlated subquery
Operators that create specialized form…
To fix mistakes made during the initial database design.... To a…
from the bottom up.
looks similar to a regular subquery but the processing is nes…
the SQLE XISTS comparison operator and the SQL NOT EXISTS com…
Database redesign is necessary because
To fix mistakes made during the initial database design.... To a…
regular subquery can be processed
from the bottom up.
37 terms
Chapter 5 - Database Processing
Access
Bigtable
Byte
Cassandra
A popular personal and small workgroup DBMS product from Micr…
A nonrelational data store developed by Google.
1) Characters of data 2) 8-bit chunks
A durable, nonrelational data store that operates over hundre…
Access
A popular personal and small workgroup DBMS product from Micr…
Bigtable
A nonrelational data store developed by Google.
37 terms
Chapter 1 Database processing
data model database design
Interest
relational database (RDB)
tables
The development team proceeds in two steps: first, create ___…
DBs is to help people track things of _____ to them
Most commonly used type of DBs is the _____ (___)
RDB stores data in _____
data model database design
The development team proceeds in two steps: first, create ___…
Interest
DBs is to help people track things of _____ to them
Database chapter 6
Information-level design
Physical-level design
User view
Cumulative design
completed independently of any particular DBMS
information-level design adapted for the specific DBMS that w…
set of requirements necessary to support operations of a part…
supports all user views encountered during design process
Information-level design
completed independently of any particular DBMS
Physical-level design
information-level design adapted for the specific DBMS that w…
33 terms
Chapter 6 - Database
Information-level design
Physical-level design
User view
Cumulative design
completed independently of any particular DBMS
information-level design adapted for the specific DBMS that w…
set of requirements necessary to support operations of a part…
supports all user views encountered during design process
Information-level design
completed independently of any particular DBMS
Physical-level design
information-level design adapted for the specific DBMS that w…
97 terms
Database Processing chapter 7, 8, 9
Chapter 7... When a surrogate key is used…
Given the SQL statement... CREATE TABLE…
The SQL keyword used to limit column v…
An SQL virtual table is called _______…
d.) the relationship changes to a non-identifying relationship
c.) RepName is a candidate key
b.) CHECK
b.) a view
Chapter 7... When a surrogate key is used…
d.) the relationship changes to a non-identifying relationship
Given the SQL statement... CREATE TABLE…
c.) RepName is a candidate key
50 terms
Chapter 6 Database 2015
1. Identify the three major tasks for…
2. What is the relationship between en…
3. Why is the choice of the primary ke…
4. What are the three characteristics…
a. Create a table for each entity... b. Create relationships by…
a. Entities and tables: Entities become tables ... b. Attributes…
a. The DBMS will use the primary key to facilitate searching…
a. Short... b. Numeric... c. Fixed
1. Identify the three major tasks for…
a. Create a table for each entity... b. Create relationships by…
2. What is the relationship between en…
a. Entities and tables: Entities become tables ... b. Attributes…
Database Chapter 6
candidate keys
null status
domain constraint
range constraint
alternate identifiers of unique rows in a table
indicates whether or not the value of the column can be NULL
column values must be a given set of specific values
column values must be within a given range of values
candidate keys
alternate identifiers of unique rows in a table
null status
indicates whether or not the value of the column can be NULL
Database Chapter 6
Normalization
Denormalization
Prime Attribute
Nonprime Attribute (nonkey attribute)
A process for evaluating and correcting table structures to m…
Produces a lower normal form; that is; a 3NF will be onverted…
Any attribute that is at least part of a key.
Is not part of any candidate key.
Normalization
A process for evaluating and correcting table structures to m…
Denormalization
Produces a lower normal form; that is; a 3NF will be onverted…
49 terms
Database Processing Chapter Nine
Which of the following is not a databa…
Which of the following is true about m…
The task of diagnosing errors due to c…
Measures that are taken to prevent one…
a.) managing the database structure... b.) managing data activit…
a.) The DBA need not get input from users on the issue becaus…
a.) formal policies for requesting changes.... b.) database stru…
a.) concurrency control.... b.) checkpoint.... c.) database recover…
Which of the following is not a databa…
a.) managing the database structure... b.) managing data activit…
Which of the following is true about m…
a.) The DBA need not get input from users on the issue becaus…
36 terms
MIS Chapter 5: Database Processing
Database
rows or records
Table or file
Key
- Self-describing collection of integrated records... - a databa…
- how columns or fields are grouped into
- a group of similar rows or records
- a column or group of columns that identifies a unique row i…
Database
- Self-describing collection of integrated records... - a databa…
rows or records
- how columns or fields are grouped into
1 of 10