Exam 1: video base questions
for database concepts and
design cs6400 QUESTIONS
AND VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS
ER,EER,hierarchical,relation model - CORRECT ANSWER-Examples of Data models
In tables. The schema Represents the structure with rows,data type,columns - CORRECT
ANSWER-How is data represented in Relation model?
Constraint - CORRECT ANSWER-Rules that that cannot be expressed by data the data structure
alone is a
Integrity - CORRECT ANSWER-Whether or not the database reflects reality well is
Consistency - CORRECT ANSWER-Whether or not the database has internal conflicts is
An Immutable(by the app program) artificial identifier for an entity that represents an entity in
the real world - CORRECT ANSWER-A surrogate is
, Unknown is ok
Inapplicable is not - CORRECT ANSWER-Null values: is unknown and /or inapplicable ok to use in
tables?
A thing is what we know about it - CORRECT ANSWER-Surrogate question: Named-based
representation
External schema,conceptual schema, internal schema - CORRECT ANSWER-ANSI/SPARC 3 level
DB architecture
Consist of
What do they describe?It makes it more efficient.
Schema describes intentions or types
Data describes the extension or data - CORRECT ANSWER-Why is database systems split into
schematic and data?
Relevant, time invariant structural aspects of reality - CORRECT ANSWER-Conceptual schema
describes
Tables and the columns in it. It does not involve how results are displayed - CORRECT ANSWER-
In regards to the conceptual schema, what can be seen?
It is derivative of the conceptual schema that has info from the conceptual schema. - CORRECT
ANSWER-External schema describes
for database concepts and
design cs6400 QUESTIONS
AND VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS
ER,EER,hierarchical,relation model - CORRECT ANSWER-Examples of Data models
In tables. The schema Represents the structure with rows,data type,columns - CORRECT
ANSWER-How is data represented in Relation model?
Constraint - CORRECT ANSWER-Rules that that cannot be expressed by data the data structure
alone is a
Integrity - CORRECT ANSWER-Whether or not the database reflects reality well is
Consistency - CORRECT ANSWER-Whether or not the database has internal conflicts is
An Immutable(by the app program) artificial identifier for an entity that represents an entity in
the real world - CORRECT ANSWER-A surrogate is
, Unknown is ok
Inapplicable is not - CORRECT ANSWER-Null values: is unknown and /or inapplicable ok to use in
tables?
A thing is what we know about it - CORRECT ANSWER-Surrogate question: Named-based
representation
External schema,conceptual schema, internal schema - CORRECT ANSWER-ANSI/SPARC 3 level
DB architecture
Consist of
What do they describe?It makes it more efficient.
Schema describes intentions or types
Data describes the extension or data - CORRECT ANSWER-Why is database systems split into
schematic and data?
Relevant, time invariant structural aspects of reality - CORRECT ANSWER-Conceptual schema
describes
Tables and the columns in it. It does not involve how results are displayed - CORRECT ANSWER-
In regards to the conceptual schema, what can be seen?
It is derivative of the conceptual schema that has info from the conceptual schema. - CORRECT
ANSWER-External schema describes
