How can we help?

You can also find more resources in our Help Center.

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
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
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
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
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
51 terms
Database Processing Chapter 5-6
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 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
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
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
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
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
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…
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
40 terms
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
45 terms
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
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…
12 terms
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…
24 terms
Chapter 5: Database Processing
Database
Key
Regional Databases
Metadata
A collection of tables plus relationships among the rows in t…
A column or a group of columns that identifies a unique row i…
Databases that carry their data in the form of tables and tha…
Data that describes data.
Database
A collection of tables plus relationships among the rows in t…
Key
A column or a group of columns that identifies a unique row i…
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…
21 terms
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…
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…
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…
Chapter 5: Database Processing
database
byte
columns
Rows
self-describing collection of integrated records
character of data
groups of bytes (also known as fields)
groups of columns/fields (also known as records)
database
self-describing collection of integrated records
byte
character of data
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
14 terms
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…
12 terms
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
23 terms
Chapter 6 Database Design
The ____ is short, numeric, and fixed
____ meet the ideal, but have no meani…
The terms candidate key and alternate…
____ are alternate identifiers of uniq…
ideal primary key
Surrogate keys
synonymous
Candidate keys
The ____ is short, numeric, and fixed
ideal primary key
____ meet the ideal, but have no meani…
Surrogate keys
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
Database Systems- Chapter 6
Physical Design
Logical Design
Things to Consider when choosing a DBMS
Primary Data
process of adapting the logical design of the database to the…
can be adapted to meet the limitations and features of the ch…
-Compatibility with existing networks and systems... -Hardware a…
________ ____ file which stores all the data objects and the…
Physical Design
process of adapting the logical design of the database to the…
Logical Design
can be adapted to meet the limitations and features of the ch…
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.
18 terms
Chapter 5: Database Processing
Q5-1 Why Do You Need to Know About Dat…
Reasons For Learning Database Technology
What is the Purpose of a Database
Q5-2 What is a Database?
Database Technology... - databases are everywhere, which makes t…
1) Need to have knowledge to assess how hard (and how expensi…
the purpose of a database is to help people keep track of thi…
Database = a self-describing collection of integrated records…
Q5-1 Why Do You Need to Know About Dat…
Database Technology... - databases are everywhere, which makes t…
Reasons For Learning Database Technology
1) Need to have knowledge to assess how hard (and how expensi…
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
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
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.
102 terms
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.
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…
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,…
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
21 terms
Database Management: Chapter 6
Relational DBMS (RDBMS)
Catalog
Schema
Data definition Language (DDL)
a database management system that manages data as a collectio…
A set of schemas that, when put together, constitute a descri…
a structure that contains descriptions of objects created by…
Commands used to define a database, including those for creat…
Relational DBMS (RDBMS)
a database management system that manages data as a collectio…
Catalog
A set of schemas that, when put together, constitute a descri…
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
63 terms
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…
1 of 10