CS 6400 Exam 1
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
When your data and applications are simple and stable or multipe user access is not needed. Or
when you have an application with serious real time requirements and the DBMS cannot run
fast enough to meet them.
What is the data modeling process? - CORRECT ANSWER-The data modeling process has two
steps:
- To fix a perception of structures of reality (select aspects of reality that are important to us
while ignoring others)
- Then to represent that perception (use abstraction to organize selected aspects)
What two languages are used for the data modeling process, and what can they represent? -
CORRECT ANSWER-- Extended Entity Relationship EER model. Which is good for fixing a
perception of structures of reality.
- The Relational Model. Which is good for representing this perception inside a database.
What is process modeling? - CORRECT ANSWER-The aim of fixing and representing a perception
of processes of reality.
These processess are not represented inside the database, but are reflected in the way we use
the database through the DBMS.
, Data models contains formulations that allow us to express? - CORRECT ANSWER-- Data
structures
- Constraints
- Operations
- Keys and Identifiers
- Integrity and consistency
- Null Values
- Surrogates
A data model is not the same as a model of data? (True or False) - CORRECT ANSWER-True.
A model of data is a database (model of reality), and a data model is the tool or the formulas
that we use to create such a model.
What are some example of data models? - CORRECT ANSWER-- Entity Relationship Model (fix a
perception of reality)
- Relational Model (implement that perception into DBMS)
- Hierarchical Model (Implemented in IBMIMS database in 1967 and fundamental model used
by XML DBs today)
What does the schema represent? - CORRECT ANSWER-A schema represents aspects of the
data that are stable over time. Such as a table name, column names, and data types within a
table.
What structures constitute the schema of a particular table? - CORRECT ANSWER-The table
name, column name, and data types together would be the schema of a particular table. As all
of these are consistent/stable aspects of the table data and therefore, the schema is NOT
expected to change.
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
When your data and applications are simple and stable or multipe user access is not needed. Or
when you have an application with serious real time requirements and the DBMS cannot run
fast enough to meet them.
What is the data modeling process? - CORRECT ANSWER-The data modeling process has two
steps:
- To fix a perception of structures of reality (select aspects of reality that are important to us
while ignoring others)
- Then to represent that perception (use abstraction to organize selected aspects)
What two languages are used for the data modeling process, and what can they represent? -
CORRECT ANSWER-- Extended Entity Relationship EER model. Which is good for fixing a
perception of structures of reality.
- The Relational Model. Which is good for representing this perception inside a database.
What is process modeling? - CORRECT ANSWER-The aim of fixing and representing a perception
of processes of reality.
These processess are not represented inside the database, but are reflected in the way we use
the database through the DBMS.
, Data models contains formulations that allow us to express? - CORRECT ANSWER-- Data
structures
- Constraints
- Operations
- Keys and Identifiers
- Integrity and consistency
- Null Values
- Surrogates
A data model is not the same as a model of data? (True or False) - CORRECT ANSWER-True.
A model of data is a database (model of reality), and a data model is the tool or the formulas
that we use to create such a model.
What are some example of data models? - CORRECT ANSWER-- Entity Relationship Model (fix a
perception of reality)
- Relational Model (implement that perception into DBMS)
- Hierarchical Model (Implemented in IBMIMS database in 1967 and fundamental model used
by XML DBs today)
What does the schema represent? - CORRECT ANSWER-A schema represents aspects of the
data that are stable over time. Such as a table name, column names, and data types within a
table.
What structures constitute the schema of a particular table? - CORRECT ANSWER-The table
name, column name, and data types together would be the schema of a particular table. As all
of these are consistent/stable aspects of the table data and therefore, the schema is NOT
expected to change.