CGS1540C Midterm

The _____ relationship is the "relational model ideal."

1:M

How many rows, and columns does table1 × table2 have?

6 rows, 5 columns

Recognizing the entities CLASS and STUDENT in a college ERD, what bridged entity can a database designer add to help ensure each student is assigned their classes for specific courses?

ENROLL

In explaining data, you could say that the word data covers the collection of ___ stored in the database.

Facts

A primary key can't be null, but it can contain null attributes.

False

It is unnecessary for the database designer to determine which data to enter into the database and how to organize that data in the database management system.

False

The relational model is hardware-dependent and software-independent.

False

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

Heart

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

Internet

A table of products with a foreign key of vend_code references to the table vendor. Which of the following could be an unintended effect of deleting an entry in the vendor table?

It damages the referential integrity.

April is a database administrator, she wants to provide a description of the data characteristics and the set of relationships that link the data found within the database. What should she use?

Metadata

End-user data is data that is __ of interest to the end user?

Raw facts

.How would you define data that is verifiable?

The data always yields consistent results.

_____ data exist in the format in which they were collected.

Unstructured

In a relational table, an intersection of a row and a column represents ____________.

a single data value

Which of the following keys in a table would cause you to violate BCNF if used more than once?

candidate

Dale's boss has tasked him with creating a simple representation of the entire employee database including items such a hire date, office contact number, and resume. What type of model should Dale construct?

data

One of the reasons we need database is because they are the best ways to store and manage ___.

data

When the related table uses a composite primary key, it becomes difficult to create which key?

foreign

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

normalization

Sally is more concerned with data location, formatting, and specific reporting requirements. Which describes Sally's role?

the applications programmer

What conceptual model is being used if an entity-relationship diagram (ERD) is being used?

the conceptual model

In the context of Laney's 3 Vs of Big Data databases, which term refers to the fact that data is collected in multiple data formats?

variety

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.

1:M

While trying to resolve a database failure, which of the answers below would you say might have caused the database failure?

A bad disk

Tess is working for a railway company and needs to create a diagram to depict the different working aspects of their reservation system such as passenger, ticket booking method, payment method, and ticket type. What notation would be the best way to visually showcase these components?

Class Diagram Notation

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

Cloud database

The database structure itself is stored as a __?

Collection of files

Starting with the objects PROFESSOR, CLASS, ROOM, how would a database begin building a diagram showcasing their relationship between each other?

Create a binary relationship

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.

Data

Which of the answers listed below is an example of structured data?

Data in an excel spreadsheet

While a database analyst is analyzing data, they find different versions of the same data appearing in different places? What do you call this type of situation?

Data inconsistency

One of the advantages of database systems is that ___

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

The options below are examples of a cloud database except?

Desktop database

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.

False

Even when a good database blueprint is available, an application's programmer's view of the data should match that of the manager and the end user.

False

The external model is the representation of the database as "seen" by the DBMS.

False

The order of the rows and columns is important to the DBMS.

False

The row's range of permissible values is known as its domain.

False

Which of the answers below is one of the advantages provided by the Database management system (DBMS)?

Improved data sharing

What is the result of revealing the meaning of raw facts?

Information

Which of the answers below is one of the problems with File system Data Processing?

Lengthy development time

Which term represents a micro view of the entities within the ERD.

Normalization

When designing a college ERD where the PROFESSOR entity connects to other entities, its relationship to DEPARTMENT would most likely be expressed as which of the following?

PROFESSOR chairs a DEPARTMENT

The _________operator yields a vertical subset of a table.

PROJECT

_____ returns only the attributes requested, in the order in which they are requested.

PROJECT

. _____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.

Performance tuning

Which of the following is a reason to use indices in a database?

Retrieve data ordered by a specific attribute.

To be considered minimally relational, the DBMS must support the key relational operators _____, PROJECT, and JOIN.

SELECT

After looking at the database design, another designer found that the primary keys were not established with a simple underline. Knowing that single-valued attribute can almost always be labeled as primary identities, which of the following attributes would be a good candidate as a primary key for a table?

SS_NUMBER

When working with a company with thousands of stores nationwide that use attributes like STORE_ADDRESS, CUST_ADDRESS, EMP_ADDRESS, and VEND_ADDRESS, what should a database designer consider breaking down so managers can determine, for example, which cities the company makes the most and least amount of money at?

STORE_ADDRESS

Jun is shopping with his partner and presents a coupon for a "buy one, get one free" deal on soap. He checks out and then hands the same coupon to his partner to use. What business rule does this invalidate?

Select All

Which of the answers below would you consider hardware while gathering requirements for a database?

Server

. _____ is the result of formatting disorganized data in order to facilitate storage, use, and generation of information.

Structured data

When using a foreign key the same value shows up in several rows. Why is this not considered data redundancy?

The elimination of the foreign key would result in losing the information of the relation.

A data warehouse can store data derived from many sources.

True

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

True

Connectivities and cardinalities are established by concise statements known as business rules.

True

Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

True

A database contains how many types of data?

Two

A company you are consulting with tells you that after their recent social media campaign they need more space to store all the data being generated. Which characteristic of Big Data databases do they need to address?

Volume

In a table of clients of a store, there is a field to store how much a client has spent. Which of the following is the best description of the attribute domain of how much the client has spent?

[0, ∞)

Although a student's registration form may list information gathered from the COURSE, CLASS, BUILDING, and ROOM table, which of the following would be the most accurate phrase describing these table's relationship with each other in an UML class diagram?

a CLASS uses a ROOM in a BUILDING

Improving _____ leads to more flexible queries.

atomicity

A(n) _____ is the equivalent of a field in a file system.

attribute

Which of the following pairs of attributes could have a functional dependence?

attribute 2, attribute 4

Which of the following could be a primary key?

attribute 3

In the context of relational databases, a column in a relational table is associated with the _____(s) of a real-world person, place, thing, or event.

attributes

Complete the following statement: Business rules must ______.

be rendered in writing

When identifying types of relationships represented by business rules, consider that relationships between entities are _____.

bidirectional

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _____.

business rules

As a database developer, how would you explain how a database structure in a DBMS is stored?

collection of files

When discovering new business rules, interviews with _____ are faster and more direct, but may be less reliable.

company managers

M:N relationship can be changed into two 1:M relationships using a __________.

composite entity

A database stores the data of the sales using the primary key RECEIVE_NUM in the SALE table and the products in the PRODUCT table with primary key PROD_NUM. To create the relation that represents what products were sold in a SALE a M:N relationship is necessary. What should be used to represent this in a relational model?

composite entity with RECEIVE_NUM + PROD_NUM

Your manager has requested a report that gives them a global view of the entire database being used as the basis for the identification and high-level description of main data objects without model-specific details. Which model or schema would you provide them?

conceptual

In the context of data models, which of the following models emphasize a global view of data that is independent of the database model type?

conceptual model

A _____ contains all of the attribute names and characteristics for each table in the system.

data dictionary

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

database system

When using a system functionality point of view, which attribute values can be calculated when they are needed to write reports or invoices?

derived

Laurel is designing databases and begins with an abstract view of the overall data environment. As the design comes closer to implementation, where should Laurel place her focus?

details

A(n) _____ database is used by an organization to support many users across many departments.

enterprise

A(n) _____ represents a particular type of object in the real world.

entity

You are assigned the task of reviewing the end users' view of the data environment. Which model should you review?

external model

The proper use of _____ keys is crucial to controlling data redundancy.

foreign

Comel, a student, takes four classes with her group of best friends. She sits in the front row with two friends and the others sit behind them. What type of relationship would Comel's situation be described as?

hierarchical

In a database context, the word _____ indicates the use of the same attribute name to label different attributes.

homonym

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

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?

logical design

Different views of the data are less likely to cause problems or conflicts when a database offers which of the following?

management system

A data warehouse contains historical data obtained from the _____.

operational databases

The one-to-many (1:M) relationship is easily implemented in the relational model by putting the _________of the "1" side in the table of the "many" side as a ________.

primary key, foreign key

The response of the DBMS to a query is the ___________

query result set

Most data that can be encountered are best classified as _____.

semistructured

A desktop database is a _____ database.

single-user

When a database designer determines that two entities share the same primary keys in their relationship, what can the designer infer between the two?

strong relationship

A company's business response time is reflective of the _____ of their Big Data database storage and processing.

velocity

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.

verify

Which of the databases below would you recommend for a client that supports a relatively small number of users (usually fewer than 50) or a specific department within the client's organization?

workgroup