CS 6400 EXAM 1
ACTUAL QUESTIONS & VERIFIED ANSWERS
STUDY MATERIAL
2026 UPDATED | 100% CORRECT –GT.
GEORGIA INSTITUTE OF TECHNOLOGY
Exam 1 1
, Part 1
Lecture Notes
Textook chapters: 1, 2, 3, 4
Lecture: Fundamentals of Databases
Lecture: Extended Entity -Relationship Model
Lecture 1: Fundamentals of Database
what is model:
a model is a means of communication
users of a model must have a certain amount of knowledge in
common
a model
only emphasizes selected aspects
is described in some language
can be erroneous
may have features that do not exist in reality
Question: What is a database management system?
A software system allowing users to create and maintain a database
When to use a Data management system?
To use:
in data intensive apps. Some app is process intensive
persistent storage of data, even it is shutdown, the data still there
centralize control of data: enforce policies across a database
control of redundancy
control of consistency and integrity
share data
data documentation: .schema
backup and recovery
Exam 1 2
, Not use:
initial investment is very high
generality is not needed *What is generality?
data and applications are simple
real-time requirement cannot be met
multiple user access is not needed
What is modeling
Data modeling: Extended entity relationship model: fixing a perception of structures of reality, 认知结构
process modeling: data modeling language use of the model reflects process of reality
Relational model:
relational model is represent in table:
data structures
schema represents the structure of data
rows represent the current state of reality modeled by this table
Constraints:
express rules that cannot be expressed by the data structures alone
e.g. general constrains in schema: name text NOT NULL CHECK >0
Exam 1 3
ACTUAL QUESTIONS & VERIFIED ANSWERS
STUDY MATERIAL
2026 UPDATED | 100% CORRECT –GT.
GEORGIA INSTITUTE OF TECHNOLOGY
Exam 1 1
, Part 1
Lecture Notes
Textook chapters: 1, 2, 3, 4
Lecture: Fundamentals of Databases
Lecture: Extended Entity -Relationship Model
Lecture 1: Fundamentals of Database
what is model:
a model is a means of communication
users of a model must have a certain amount of knowledge in
common
a model
only emphasizes selected aspects
is described in some language
can be erroneous
may have features that do not exist in reality
Question: What is a database management system?
A software system allowing users to create and maintain a database
When to use a Data management system?
To use:
in data intensive apps. Some app is process intensive
persistent storage of data, even it is shutdown, the data still there
centralize control of data: enforce policies across a database
control of redundancy
control of consistency and integrity
share data
data documentation: .schema
backup and recovery
Exam 1 2
, Not use:
initial investment is very high
generality is not needed *What is generality?
data and applications are simple
real-time requirement cannot be met
multiple user access is not needed
What is modeling
Data modeling: Extended entity relationship model: fixing a perception of structures of reality, 认知结构
process modeling: data modeling language use of the model reflects process of reality
Relational model:
relational model is represent in table:
data structures
schema represents the structure of data
rows represent the current state of reality modeled by this table
Constraints:
express rules that cannot be expressed by the data structures alone
e.g. general constrains in schema: name text NOT NULL CHECK >0
Exam 1 3
