MSDS 420 Final Flashcards |
Quizlet
Science Computer Science
MSDS 420 Final
5.0 (3 reviews)
Terms in this set (31)
The basic structures of a relational database
(as defined by the relational model) are tables,
columns (or fields), rows (or records), and
keys.
Describe the basic features of
-representing and querying data
the relational data model, and
structured and mathematical way
discuss their importance to
-SQL provides an internally
the end user and the
consistent mathematical language
designer.
-data points relate to each other and must be
managed in a secure, rules-based, consistent
way.
- To ensure that data is always accurate and
accessible, relational databases follow certain
integrity rules.
Explain how the entity The ER model helped produce a more
relationship (ER) model structured relational database design
helped produce a more environment because it allowed designers to
structured relational database visually see entities and their relationships.
design environment.
Cardinality, in the context of ERD, is the
number of instances of one entity that can, or
What does it mean cardinality must, be associated with each instance of
within the context of entity another entity. In general, there may be one-to-
relationship diagram? one, one-to- many, or many-to-many
relationships.........................................................An
employee has attributes such as an employee
number, name, department number, etc.
1/9
, MSDS 420 Final Flashcards |
Quizlet
MSDS 420 Final
2/9
Quizlet
Science Computer Science
MSDS 420 Final
5.0 (3 reviews)
Terms in this set (31)
The basic structures of a relational database
(as defined by the relational model) are tables,
columns (or fields), rows (or records), and
keys.
Describe the basic features of
-representing and querying data
the relational data model, and
structured and mathematical way
discuss their importance to
-SQL provides an internally
the end user and the
consistent mathematical language
designer.
-data points relate to each other and must be
managed in a secure, rules-based, consistent
way.
- To ensure that data is always accurate and
accessible, relational databases follow certain
integrity rules.
Explain how the entity The ER model helped produce a more
relationship (ER) model structured relational database design
helped produce a more environment because it allowed designers to
structured relational database visually see entities and their relationships.
design environment.
Cardinality, in the context of ERD, is the
number of instances of one entity that can, or
What does it mean cardinality must, be associated with each instance of
within the context of entity another entity. In general, there may be one-to-
relationship diagram? one, one-to- many, or many-to-many
relationships.........................................................An
employee has attributes such as an employee
number, name, department number, etc.
1/9
, MSDS 420 Final Flashcards |
Quizlet
MSDS 420 Final
2/9
