Database Design: Gathering Information

Play an AI-generated podcast conversation about this lesson

What is the first step in gathering information for designing a database?

Interviews with stakeholders
Work shadowing
Reviewing business documents
Initial interviews with chief stakeholders (correct)

What is the purpose of reviewing business documents in the information-gathering process?

To define business rules
To identify data elements (correct)
To search for materials for entities and attributes
To conduct work shadowing

Which document type is used to display summarized or formatted data according to the text?

Reports (correct)
Questionnaires
Procedures
Forms

In the context of information gathering, what does 'work shadowing' refer to?

Observing the flow of information (A) Signup and view all the answers

Why is it important to keep a record of the information-gathering process?

To maintain documentation of the process (D) Signup and view all the answers

What task is NOT part of the initial steps in gathering information for database design?

Defining business rules (C) Signup and view all the answers

What is the primary purpose of developing a security schema for a database?

To determine who has access to what data (B) Signup and view all the answers

What type of information do databases typically contain that could pose financial and legal risks if revealed?

Credit card numbers and social security numbers (D) Signup and view all the answers

What is the primary purpose of access control in a database?

To provide different levels of access based on user roles and responsibilities (C) Signup and view all the answers

Which of the following is a key requirement for most databases in terms of access and security?

Excluding anyone without the proper authentication credentials (C) Signup and view all the answers

What type of information in a database could be of great value to a competitor?

Core business information (B) Signup and view all the answers

What is the main purpose of access control in a database system?

To provide different levels of access based on user roles and responsibilities (B) Signup and view all the answers

Which of the following is a key benefit of maintaining a project notebook?

It helps review the completeness of the database design later. (C) Signup and view all the answers

What is the primary role of a server in a client-server relationship?

To make resources or services available to requesting clients. (D) Signup and view all the answers

Which statement about servers and clients is true?

The server and client can be on the same physical machine. (B) Signup and view all the answers

In a client-server relationship, which of the following could be a client?

All of the above (D) Signup and view all the answers

What is one of the major tasks in database design, according to the passage?

Designing the client application(s) for the database. (D) Signup and view all the answers

Which of the following statements about servers is true?

Servers often have more processing power and memory than other computers. (D) Signup and view all the answers

What is the primary purpose of database requirements?

To ensure the database meets the business needs of the organization (D) Signup and view all the answers

Which of the following is an example of a data requirement for a database?

Storing information about customer names, addresses, and purchase history (C) Signup and view all the answers

What is the purpose of report requirements in a database?

To ensure the database can generate various reports by combining data from different entities (B) Signup and view all the answers

Which of the following is an example of an access and security requirement for a database?

Allowing authorized personnel to view and edit sensitive student data (B) Signup and view all the answers

What type of requirement is needed to ensure that a database can store information about student gender and ethnicity for reporting purposes?

Data requirement (B) Signup and view all the answers

Which of the following statements about database requirements is true?

Data requirements refer to the attributes needed to store all necessary information (B) Signup and view all the answers

Which of the following best describes the purpose of business rules in database design?

To govern the way data is acquired, stored, and used by the business (B) Signup and view all the answers

What is the primary purpose of identifying entities and attributes in database design?

To define the logical design of the database, independent of any specific DBMS (A) Signup and view all the answers

What is the primary purpose of a surrogate key in database design?

To provide a unique identifier for each instance of an entity when there is no suitable natural key (C) Signup and view all the answers

What is the primary difference between a natural key and a surrogate key in database design?

Natural keys are based on attributes that belong naturally to the entity, while surrogate keys are artificially created (D) Signup and view all the answers

What is the primary purpose of a composite key in database design?

To provide a unique identifier for each instance of an entity when there is no single attribute that can serve as a good candidate key (D) Signup and view all the answers

Which of the following is a key characteristic of a good candidate key in database design?

It must be unique and not change over time (D) Signup and view all the answers