Database Management Midterm

Limitations

For Jared, a database consultant, to avoid false expectations, he must make the end user aware of the ___ of both the DBMS and the database.

2NF

From a structural point of view, 3NF is better than _____.

three

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.

Database systems enable the data in the database to be shared among multiple applications or users.

One of the advantages of database systems is that ___

d. SELECT * FROM PROVIDERS WHERE PHONE LIKE '231%'

All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE '___ 231 ___' b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' c. SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%' d. SELECT * FROM PROVIDERS WHERE PHONE LIKE '231%'

iterative

An ERD is created through which of the following processes?

ORDER BY

Sorting records returned by a SELECT statement is done with a _____ clause

[schema name].[table name]

Standard two-part naming in SQL Server follows which convention?

analysis

The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).

Heart

The DBMS may be referred to as the database system's ___?

5

The Systems Development Life Cycle (SDLC) is divided into __ phases.

Collection of files

The database structure itself is stored as a __?

Conceptual design

The first stage in the database design process is __?

Data analysis and requirements

The first step of the conceptual design is __?

installing the DBMS

The implementation and loading phase of the Database Life Cycle (DBLC) involves _____.

data anomalies

The main goal of normalization is to eliminate _____. .

Recycle database

The options below are examples of databases except?

logical design

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Data

The term database system refers to an organization of components that define and regulate the collection, storage, management, and use of ___ within a database environment.

database administrator

. In a situation whereby the data has been loaded into the database, John, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

Data integrity

. What would you define as the condition in which all of the data in the database are consistent with the real-world events and conditions?

It improves the ability to understand the nature, role, and scope of data.

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?

entity

A noun in a business rule translates to a(n) _____ in the data model.

relationship

A verb associating two nouns in a business rule translates to a(n) _____ in the data model.

analysis

Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).

views

Unnormalized tables yield no simple strategies for creating virtual tables known as _____.

logical design

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?

Systems analysis

__ is the process that establishes the need for an information system and its extent.

True

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes. (T/F)

the primary key

According to a standard data-modeling checklist, the non-key entities in an entity-relationship (ER) data model must be fully dependent on _____.

determinant

Any attribute whose value determines other values within a row is known as a(n) _____.

Systems development.

As a database architect, you usually explain that applications transform data into the information that forms the basis for decision making within the framework of __.

Map

As a database designer, the first step that you would take in creating the logical design is to ___ the conceptual model.

Designing the database

As a database designer, which of the options below would you not include in the implementation phase of a database design?

Each CONTAINER contains between 0 and 100 UNITs.

Determine which of the following simple-language expressions represents a valid constraint.

constraints

Business rules that are properly written will define entities, attributes, relationships, and _____.

1:M

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.

be rendered in writing

Complete the following statement: Business rules must ______.

dependency

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

data redundancies

In exchange for possible reductions in performance, what unwanted element does normalization reduce?

normalization

In order for you to yield a useful ERD, you must combine ER modeling with which of the following entities?

*

In the SELECT clause, you can indicate that you want to include all columns using the _____.

True

In the context of partial dependencies, data redundancies occur because every row entry requires the duplication of data. (T/F)

Data

Information is produced by processing _____.

CLIENT_ADDRESS

Jaiden is in the translation of business rules to data model components. How should he label the address attribute for an entity named CLIENT?

DBMS features and tools

Jerry is a stakeholder in ABC company, he is considering ___ as one of the factors that will affect ABC company's purchasing decision of a DBMS, the items that he should consider include: some database software's variety of tools that facilitate application development.

Data about data

Metadata is ___?

unnormalized

Raw data in its original state that has data anomalies such as redundant or multivalued data is _____ data.

Relational

SQL is used to interact with what kind of database?

entity

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?

database design

Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).

SELECT c

What SQL command do you use to query a database?

accomplish all of these goals

What does normalization help you do?

Insert new rows into a table

What does the INSERT statement do?

A value that represents missing or unknown data

What is a NULL value?

1 -- A bit column can store either a 1, representing true, or a 0, representing false. If a column is declared as NOT NULL, data is required in that column.

What is acceptable data for a column declared as a BIT and NOT NULL?

SELECT

What sort of statement retrieves data in a SQL code?

partial dependency

What type of dependency is shown during normalization, if the conversion to the second normal form involves removing all attributes dependent on only a part of a composite primary key?

Cloud database

When a database offers all the advantages of a local DBMS and resides on the internet, it is referred to as a(n) _____ database.

In-memory database

When a database stores the majority of data in RAM rather than in hard disks, it is referred to as a(n) _____ database.

constraint

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?

verify

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.

<>

Which comparison operator indicates a value is not equal?

COUNT

Which function determines the number of rows in a table?

Desktop database

Which of the answers below is an example of a single-user database?

Internet

Which of the answers below is not consider as one of the five (5) major parts of the database system?

a. A spreadsheet allows for the manipulation of data in a tabular format

Which of the answers below is not one of the reasons a spreadsheet is not considered a database? a. A spreadsheet allows for the manipulation of data in a tabular format A spreadsheet does not support self-documentation through metadata c. A Spreadsheet does not support enforcement of data types or domains d. A Spreadsheet does not support defined relationships among tables

c. Improved data sharing

Which of the answers below is one of the advantages provided by the Database management system (DBMS)? a. Decreased end-user productivity b. Maximized data inconsistency c. Improved data sharing d. Less data integration

Memory chip errors

Which of the following is a hardware-induced database failure?

User management

Which of the following is not a function of a DBMS?

c They can serve as a communication tool between the users and designers.

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.

two-to-one

Which of these is NOT a type of relationship in a relational database? a. two-to-one b. many-to-one c. many-to-many d. one-to-many

d. both A & C

Which statement about primary keys is true? a. Primary key values must be unique. b. a primary key value is required for every table. c. Primary keys can be made up of one or more columns. d. both A & C

a clearly defined area within a real-world environment that will be systematically addressed

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.