Click here for more: Scholars nexus
Exam 1: video base questions for database concepts and design
cs6400 Questions with Detailed Verified Answers
What stage of the database application is EER model in?
Ans: Specifications
What are the 4 stages of database application methodology?
Ans: Analysis,specification,Design,implementation
What is a database?
Ans: A model of reality
What is a dbms?
Ans: A software system allowing users to create and maintain database
When to use a dbms?
Ans: Data intensive,control redundancy,persistent storage of data, integrity,multiple
use support,sharing data,when you need backup.
When not to use dbms?
Ans: Cost too high for software and training
What are the major topics for database?
© Get it right 2025 Getaway - Stuvia US All rights reserved
, Click here for more: Scholars nexus
Ans: Data modeling,processing ,and efficiency
What is data modeling use for?
Ans: One To fix perception of structures of reality and two represent perception
what two ways is processes represented ?
Ans: Embedded in code & executed in Ad-hocIn
Examples of Data models
Ans: ER,EER,hierarchical,relation model
How is data represented in Relation model?
Ans: In tables. The schema Represents the structure with rows,data type,columns
Rules that that cannot be expressed by data the data structure alone is a
Ans: Constraint
Whether or not the database reflects reality well is
Ans: Integrity
Whether or not the database has internal conflicts is
Ans: Consistency
A surrogate is
© Get it right 2025 Getaway - Stuvia US All rights reserved
Exam 1: video base questions for database concepts and design
cs6400 Questions with Detailed Verified Answers
What stage of the database application is EER model in?
Ans: Specifications
What are the 4 stages of database application methodology?
Ans: Analysis,specification,Design,implementation
What is a database?
Ans: A model of reality
What is a dbms?
Ans: A software system allowing users to create and maintain database
When to use a dbms?
Ans: Data intensive,control redundancy,persistent storage of data, integrity,multiple
use support,sharing data,when you need backup.
When not to use dbms?
Ans: Cost too high for software and training
What are the major topics for database?
© Get it right 2025 Getaway - Stuvia US All rights reserved
, Click here for more: Scholars nexus
Ans: Data modeling,processing ,and efficiency
What is data modeling use for?
Ans: One To fix perception of structures of reality and two represent perception
what two ways is processes represented ?
Ans: Embedded in code & executed in Ad-hocIn
Examples of Data models
Ans: ER,EER,hierarchical,relation model
How is data represented in Relation model?
Ans: In tables. The schema Represents the structure with rows,data type,columns
Rules that that cannot be expressed by data the data structure alone is a
Ans: Constraint
Whether or not the database reflects reality well is
Ans: Integrity
Whether or not the database has internal conflicts is
Ans: Consistency
A surrogate is
© Get it right 2025 Getaway - Stuvia US All rights reserved
