DAD 220 - Chapter 2: Relational
Database with complete
verified solutions
Database Model - answer A database model is a conceptual
framework for database software.
Relational Model - answer The relational model is a database
model based on mathematical principles, with three parts.
What are the three parts of a relational model? - answer 1. A data
structure that prescribes how data is organized.
2. Operations that manipulate data structures.
3. Rules that govern valid relational data.
The relational data structure and operations are based on "_"
theory. - answer set
Set - answer A set is a collection of values, or elements, with no
inherent order.
What are sets denoted by? - answer Sets are denoted with braces.
(Ex: {apple, banana, lemon})
What three mathematical concepts are the relational data structure
based on? - answer The relational data structure is based on three
mathematical concepts: the domain, tuple, and relation.
, Domain - answer A domain is a named set of possible database
values, such as integers, dictionary words, or logical values TRUE
and FALSE.
Tuple - answer A tuple is a finite sequence of values drawn from a
fixed domain. (Ex: (3, apple, TRUE) is a tuple drawn from domains
(Integers, DictionaryWords, LogicalValues).)
Relation - answer A relation is a named set of tuples drawn from
the same sequence of domains. (Ex: The relation below is named
Grocery and contains three tuples.)
Do relation tuples have an inherent order? - answer Since a
relation is a set, the relation tuples have no inherent order.
Attribute - answer In the relational model, each tuple position is
called an attribute and given a unique name. (Ex: In the Grocery
relation, the first, second, and third positions might be named
Quantity, FruitType, and OrganicCertification.)
Domain, tuple, relation, and attribute are "_" terms. - answer
mathematical
What is the mathematical term equivalent for "data type"? - answer
Domain (files: data type)
What is the mathematical term equivalent for "row"? - answer
Tuple (files: record)
What is the mathematical term equivalent for "table"? - answer
Relation (files: file)
Database with complete
verified solutions
Database Model - answer A database model is a conceptual
framework for database software.
Relational Model - answer The relational model is a database
model based on mathematical principles, with three parts.
What are the three parts of a relational model? - answer 1. A data
structure that prescribes how data is organized.
2. Operations that manipulate data structures.
3. Rules that govern valid relational data.
The relational data structure and operations are based on "_"
theory. - answer set
Set - answer A set is a collection of values, or elements, with no
inherent order.
What are sets denoted by? - answer Sets are denoted with braces.
(Ex: {apple, banana, lemon})
What three mathematical concepts are the relational data structure
based on? - answer The relational data structure is based on three
mathematical concepts: the domain, tuple, and relation.
, Domain - answer A domain is a named set of possible database
values, such as integers, dictionary words, or logical values TRUE
and FALSE.
Tuple - answer A tuple is a finite sequence of values drawn from a
fixed domain. (Ex: (3, apple, TRUE) is a tuple drawn from domains
(Integers, DictionaryWords, LogicalValues).)
Relation - answer A relation is a named set of tuples drawn from
the same sequence of domains. (Ex: The relation below is named
Grocery and contains three tuples.)
Do relation tuples have an inherent order? - answer Since a
relation is a set, the relation tuples have no inherent order.
Attribute - answer In the relational model, each tuple position is
called an attribute and given a unique name. (Ex: In the Grocery
relation, the first, second, and third positions might be named
Quantity, FruitType, and OrganicCertification.)
Domain, tuple, relation, and attribute are "_" terms. - answer
mathematical
What is the mathematical term equivalent for "data type"? - answer
Domain (files: data type)
What is the mathematical term equivalent for "row"? - answer
Tuple (files: record)
What is the mathematical term equivalent for "table"? - answer
Relation (files: file)
