Quiz3 Flashcards
A new database designer is struggling with the process of identifying and documenting business rules. They are considering skipping this part of the process and moving forward. If you were their mentor, which statement would show the importance of this step to the new designer?
a. It improves the ability to understand the nature, role, and scope of data.
b. It helps to standardize the view of the company’s data.
c. It identifies management problems within the company.
d. It makes it easy to recognize the data contained in an attribute.
a. It improves the ability to understand the nature, role, and scope of data.
A noun in a business rule translates to a(n) _____ in the data model.
a. entity
b. attribute
c. relationship
d. constraint
a. entity
A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
a. entity
b. attribute
c. relationship
d. constraint
c. relationship
Business rules that are properly written will define entities, attributes, relationships, and _____.
a. fields
b. objects
c. constraints
d. classes
c. constraints
Business rules use simple language to establish definitions of entities, attributes, relationships, and constraints. For instance, a business rule establishing that entities can have multiple attributes, and that each available attribute may be associated with only one entity, might be stated as “An employee may be assigned multiple devices” and “Each device may be assigned to only one employee”. Classify the relationship between EMPLOYEES and DEVICES in this example using shorthand notation.
a. 1..1
b. ..
c. M:N
d. 1:M
d. 1:M
Complete the following statement: Business rules must ______.
a. be based only on end user perceptions
b. be rendered in writing
c. include constraints
d. represent many-to-many (M:N) relationships
b. be rendered in writing
Sally’s Dog Grooming Salon is creating a database of every dog she grooms. She wants to collect specific information about the breed, height, weight, and age of each dog. What building block does “dog” represent in her data model?
a. attribute
b. relationship
c. entity
d. class
c. entity
The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.
a. internal schema
b. logical design
c. external model
d. physical independence
b. logical design
When creating a student roster, a school cannot enroll more than 20 students per course. This is an example of what data modeling building block?
a. attribute
b. entity
c. relationship
d. constraint
d. constraint
Which of the following is true of business rules?
a. They allow the designer to set company policies with regard to data.
b. They allow the designer to develop business processes.
c. They can serve as a communication tool between the users and designers.
d. They provide a framework for the company’s self-actualization.
c. They can serve as a communication tool between the users and designers.
Within the database environment, a data model represents data structures and their attributes, relations, constraints, and transformations with the purpose of supporting a specific problem domain. Define “problem domain” in the context of data models.
a. a blueprint containing all necessary instructions for building a database that will meet all end-user requirements
b. a clearly defined area within a real-world environment that will be systematically addressed
c. a relatively simple and usually graphical representation of complex real-world objects or events
d. the process of creating a specific data model for a particular set of real-world data to be addressed
b. a clearly defined area within a real-world environment that will be systematically addressed
You are designing a conceptual model and are in the process of matching the DBMS requirements to the entity-relationship diagram (ERD) to create a data model that is software-independent. Which stage of the design phase are you doing?
a. internal schema
b. logical design
c. external model
d. physical independence
b. logical design
Jaiden is in the translation of business rules to data model components. How should he label the address attribute for an entity named CLIENT?
a. ADDRESS
b. CLADD
c. CLIENT_ADDRESS
d. BILLING_ADDRESS
c. CLIENT_ADDRESS
When identifying and documenting business rules, it is important to recognize that despite being crucial contributors to the development of business rules, it pays to _____ the end-user’s perceptions of business operations.
a. ignore
b. verify
c. describe
d. prioritize
b. verify