Database Management System Fundamentals

What is the primary purpose of an Enterprise Data Model?

To define the attributes of entities in a specific project
To provide a detailed view of data structures in a database
To capture the nature and relationships of data across an organization (correct)
To establish one-to-one relationships between entities

What type of relationships can exist between entities?

One-to-one, one-to-many, and many-to-many relationships (correct)
Only one-to-many and many-to-many relationships
Only one-to-one and one-to-many relationships
Only many-to-many relationships

What graphical representation captures the nature and relationships of data?

Data warehouse
Data model (correct)
Project data model
Relational database

What is the main difference between an Enterprise Data Model and a Project Data Model?

The level of detail provided (D) Signup and view all the answers

What is a characteristic of entities in a data model?

They are described in noun form (B) Signup and view all the answers

What is the primary feature of relational databases?

Use of tables and primary/foreign keys (C) Signup and view all the answers

What is the primary difference between the System Development Life Cycle (SDLC) and prototyping?

SDLC is a well-planned and time-consuming process, whereas prototyping is a rapid and cursory approach (B) Signup and view all the answers

What is the main purpose of the planning phase in the System Development Life Cycle (SDLC)?

To gain a preliminary understanding of the business situation (B) Signup and view all the answers

What is the primary focus of the analysis phase in the System Development Life Cycle (SDLC)?

Thorough analysis of the business situation (A) Signup and view all the answers

What is the main difference between the design phase and the implementation phase in the System Development Life Cycle (SDLC)?

The design phase focuses on logical and physical database design, whereas the implementation phase focuses on writing programs and building databases (A) Signup and view all the answers

What is the primary purpose of the maintenance phase in the System Development Life Cycle (SDLC)?

To monitor, repair, and enhance the database (D) Signup and view all the answers

What is the primary advantage of using the System Development Life Cycle (SDLC) approach?

It is a detailed and comprehensive approach (D) Signup and view all the answers

What is the primary function of an Enterprise System in an organization?

To act as the backbone of the organization (D) Signup and view all the answers

Which of the following approaches is characterized by being methodical, structured, and time-consuming?

Traditional SDLC (C) Signup and view all the answers

What is the primary benefit of using Rapid Application Development (RAD) when a database is already in place?

It enables faster development and more adaptability (D) Signup and view all the answers

Which type of data repository does not typically involve relational databases?

Data Lakes (D) Signup and view all the answers

What is the primary purpose of a project in database development?

To reach an objective that has a beginning and an end (B) Signup and view all the answers

What is the main purpose of a Customer Relationship Management system?

To manage customer interactions (B) Signup and view all the answers

What is the term for the process of managing the overall operations of an organization?

Enterprise Resource Planning (C) Signup and view all the answers

During which stage of the SDLC is a project initiated and planned?

Planning (B) Signup and view all the answers

What is the primary purpose of an Executive Dashboard?

To visualize data and make informed decisions (B) Signup and view all the answers

What is the primary purpose of the external schema in the three-schema architecture?

To provide a user view of the database (C) Signup and view all the answers

Which of the following is NOT a flavor of Rapid Application Development (RAD)?

Traditional SDLC (B) Signup and view all the answers

What is the name of the fictional company used as a case throughout the book?

Pine Valley Furniture (C) Signup and view all the answers

What is the typical size of a personal database?

Megabytes (B) Signup and view all the answers

What is the primary characteristic of a departmental database?

Used by several users, usually department-wide (D) Signup and view all the answers

What is the typical size of an enterprise application database?

Gigabytes, terabytes, or even petabytes (A) Signup and view all the answers

What type of database architecture is shown in Figure 1-12?

Multi-Tiered Client/Server (C) Signup and view all the answers

What is the primary difference between a personal database and a departmental database?

Number of users (D) Signup and view all the answers

What is the typical user base of an enterprise application database?

A large user base, company-wide (D) Signup and view all the answers