WorksheetsInformation Management Summative Test (MIDTERM)
Total questions: 40
Worksheet time: 30mins
What is a data model?
A set of rules for constructing a database
The visual plan for building a database
A graphical system used to represent data relationships
All of the above
Which of the following is NOT a component of a data model?
Structural part
Manipulative part
Integrity rules
Set of Operations
What is the process of hiding irrelevant internal details from users in a database system called?
Data modeling
Data manipulation
Data abstraction
Normalization
What are the three major components of the Relational Model?
Entities, Attributes, Relationships
Classes, Objects, Methods
Relations, Attributes, Domains
Tables, Rows, Columns
What is the highest level of data abstraction, which shows only a part of the actual database to users?
Physical Level
Logical Level
View Level
Internal Schema
What is an "entity" in the context of data modeling?
A set of characteristics representing an object
The association between two objects
A real-time object about which data is collected and stored
A restriction placed on data
Which symbol is used to represent a relationship between two entities?
Rectangle
Ellipse
Diamond
Line
In a relational database, how are data relationships represented?
By using diamond symbols
By common values in related tables
By tree-like structures
By creating a separate table for each relationship
What type of relationship exists when one record in table A can be linked with many records in table B, but one row in table B is linked to only one row in table A?
One-to-one
One-to-many
Many-to-many
Many-to-one
What is a "constraint" in a database?
A visual representation of a system
A collection of rules to ensure data integrity
The process of building a working model of a database
A representation of a table with rows and columns
What is the main purpose of a Conceptual Model?
To describe a database-specific implementation
To define the structure of data elements and their relationships
To organize and define business concepts and rules
To provide a foundation for the Physical model
Which data model organizes data in a tree-like structure where a child node can only have one parent node?
Network Model
Relational Model
Hierarchical Model
Object-Oriented Model
In the Entity-Relationship (ER) model, what do ellipses represent?
Entity sets
Attributes
Relationships
Constraints
Which level of data abstraction describes how data is actually stored in the database?
View Level
Logical Level
Physical Level
Conceptual Level
What is the difference between a database schema and an instance?
A schema is a snapshot, and an instance is a design.
A schema is a formal description of the database structure, while an instance is the data stored at a specific time.
A schema changes frequently, while an instance changes rarely.
A schema is the data, while an instance is the relationships.
What is the first step in the Database Planning stage of the Database Development Life Cycle?
System definition
Requirements collection and analysis
Defining the mission statement
Database design
The process of constructing a model of the information used in an enterprise, based on a specific data model, is known as:
Conceptual Database Design
Logical Database Design
Physical Database Design
Application Design
What is the primary purpose of normalization in database design?
To increase data redundancy
To ensure that relations do not display data redundancy
To simplify the physical implementation of the database
To create a working model of the database application
What is the physical realization of the database and application designs called?
Prototyping
Implementation
Testing
Operational Maintenance
Which of the following is an optional step in the Database Development Life Cycle?
Database Planning
Implementation
DBMS Selection
Testing
What happens during the Data Conversion and Loading stage of the database development lifecycle?
The database schema is modified
The application user interface is designed
Existing data is transferred into the new database
Performance is monitored and maintained
Which database model was the most widely used before the Relational Model was introduced?
Hierarchical Model
Object-Oriented Model
Network Model
Entity-Relationship Model
What is a "relation" in the Relational Model?
A relationship between entities
A named column in a table
A table with rows and columns
A constraint on the data
The Database Development Life Cycle starts with what phase?
Requirements collection and analysis
Database planning
System definition
Database design
Which phase of the database development lifecycle involves creating a working model to allow designers and users to visualize the final system?
Application Design
Implementation
Testing
Prototyping
Which of the following is NOT one of the three components of the Relational Data Model?
Data Structure
Data Manipulation
Data Security
Data Integrity
In an ERD, what is a weak entity?
An entity that has multiple primary keys.
An entity that is represented by a single rectangle and has its own primary key.
An entity whose existence depends on another strong entity.
An entity that has no attributes.
A student is a prerequisite for another student. Which type of relationship does this represent?
Binary Relationship
Recursive/Unary Relationship
Ternary Relationship
Quaternary Relationship
Which of the following describes a composite attribute?
An attribute that can take many values, like a person's skill set.
An attribute that is calculated from other attributes, like years of service.
An attribute that cannot be divided into simpler components, like gender.
An attribute that can be split into components, such as an address divided into street, city, and zip code.
What is the purpose of an Entity Relationship Diagram (ERD)?
To represent a database in the form of tables.
To write SQL queries for data manipulation.
To visually represent data objects, their attributes, and relationships.
To ensure data integrity and security.
A Physical Data Model describes a database-specific implementation of the data model.
TRUE
FALSE
A Logical Model is a fully attributed conceptual model where attributes are fully spelled out with no abbreviations.
TRUE
FALSE
In a Hierarchical Model, a child node can have multiple parent nodes.
TRUE
FALSE
Schema changes very frequently, whenever data is removed or added in the database.
TRUE
FALSE
The View Level is the lowest level of data abstraction and describes how data is actually stored in a database.
TRUE
FALSE
A primary key can contain a null value.
TRUE
FALSE
A relationship of degree three, involving three entities, is called a binary relationship.
TRUE
FALSE
Cardinality specifies the maximum number of relationships, while ordinality specifies the minimum number of relationships.
TRUE
FALSE
A fan trap occurs when a model has a relationship with partial participation.
TRUE
FALSE
A stored attribute is an attribute that can be calculated based on other attributes.
TRUE
FALSE
