IST 210 Midterm

A composite key is... A. a key mad of multiple attributes B. a key made of a single attribute

A

A data warehouse can store data derived from many sources. A. True B. False

A

A desktop database is a ___________ database. A. single-user B. multiuser C. workgroup D. distributed

A

A foreign key can have NULL values. A. True B. False

A

A primary key must include all unique values. A. True B. False

A

A(n) ___________ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization. A. workgroup B. desktop C. enterprise D. transactional

A

Based on the following relationship, ISBN -> Title we would say that knowing ISBN, we know the Title of the book. This is a ___________. A. Functional Dependency B. Transitive Dependency C. Multiple Valued Attribute D. Repeating groups

A

Data constitute the building blocks of information. A. True B. False

A

Data processing can be as simple as organizing data to reveal patterns. A. True B. False

A

For the First Normal Form, you need to indicate all Primary Keys. A. True B. False

A

For the following situation, what type of dependency do we have? (ISBN, Author) -> (Title, Fiction, Publisher, Year) ISBN -> (Title, Fiction, Publisher, Year) A. partial B. transitive C. no dependency

A

For the following table: PSU_ID -> (LastName, FirstName) is a functional dependency PSU_ID - Determinant (LastName, FirstName) - Dependent A. True B. False

A

If a book has multiple authors and authors is an attribute of our table. This is not in 1st normal form. A. True B. False

A

If a group of puppies is called a litter, a group of cats is. called a chowder... what do we call a gourd of entity instances or occurrences? A. a set B. a community C. a cluster D. a model

A

If we know that Customer buys a Product and the Product costs X Dollars. This is an example of a ___________. A. transitive dependency B. partial dependency C. bilateral dependency

A

In "Business Rules for Data Models," Entities == Nouns and Relationship == ? A. Verbs B. Adjectives C. Conjunctions D. Pronouns

A

In a scenario where you are creating a database for a Pizza Company, we would say the "Orders" table is ___________, as it relates to the "TypesOfPizza" table. A. Existence-Dependent B. Existence-Independent

A

In terms of Functional Dependencies, given the following relationship: PSU_ID -> Students_Last_Name, PSU_ID is considered to be the: A. Determinant B. Dependent C. Derivative D. Detriment

A

In terms of only our classroom, IST210-008, teacher -> student is what type of relationship? A. One-to-many B. Many-to-Many C. One-to-one D. A few-to-some

A

One of the differences we discussed in class between a hierarchy model and the network model is that hierarchy...? A. has only one parent B. has multiple parents

A

Primary keys... A. can NOT contain NULL values B. can contain NULL values C. can have repeating values D. must be a number

A

Raw data is un-normalized data. A. True B. False

A

The only way to access the data in a database is through the DBMS. A. True B. False

A

To be in 3rd Normal Form, we must not have any transitive dependencies. A. True B. False

A

To be in third normal form, you must first be in second normal form. A. True B. False

A

To eliminate partial or transitive dependency, we should need to create a new table. A. True B. False

A

We spoke about the 4 V's of Big Data, one of which is veracity. Veracity specifically deals with: ___________ of data A. uncertainty B. steaming C. scale D. abstraction

A

When an entity is independent of other entities, we call this a "strong entity." A. True B. False

A

When conceptual model and the DBMS (Database management system) are combined, we get...? A. logical design B. conceptual design C. external design D. constraint design

A

When references a column of data in a table (think a column in Excel SpreadSheet), these are called: A. attributes B. constraints C. entities D. relationships

A

When viewed from the perception of the end-user, we are using: A. external models B. internal models C. conceptual models D. relational models

A

When you use another set of candidate keys that are used for data retrieval (typically, to find the primary key). We call this the... A. secondary key B. superkey C. skeleton key D. retrieval key

A

Which of the following is NOT an example of NoSQL? A. MySQL B. MongoDB C. Neo4j

A

Which of the following is an example of a repeating group (in the context of a Movie table in a Movie Database)? A. Genre B. Title C. Rating D. RunningTime

A

Which of the followings is NOT an example of one of the Entity Relationships discussed in class? A. Raven's Claw B. Crow's Foot C. Chen D. UML

A

___________ are the result of formatting disorganized data in order to facilitate storage, use and generation of information. A. Structured data B. Raw data C. Unstructured data D. Obsolete data

A

___________ data is difficult to compare (between different sources) and difficult to store efficiently. A. Unstructured B. Semistructured C. Structured D. Historical

A

___________ exists when data redundancy occurs and there is a conflict between two data sources. A. Data inconsistency B. Data Anomalies C. Structural dependence D. Conceptual dependence

A

___________ is defined as the condition in which all of the data in the data base are consistent with the real- world events and conditions. A. Data integrity B. Data anomaly C. Data ubiquity D. Data quality

A

___________ serve as the intermediary between the user and the database. A. Database Management System (DBMS) B. Operational Databases C. Metadata D. System Administrator

A

A primary key can be 1 and only 1 attribute. A. True B. False

B

A workgroup data base is a(n) ___________ database. A. single-user B. multiuser C. desktop D. distributed

B

An Entity Relation Diagram only has entities and relationships. A. True B. False

B

As discussed, what is our "marshmallow" for creating a successful Data Model? A. the data coming into the database B. our specific problem domain C. Mmmm... marshmallows D. the database architecture

B

Base on the following image, (1, 1) and (20, 100) is called...? Movie Theater --(1, 1)--Contains--(20, 100)-->Seats A. Connectivity B. Cardinality C. Weak Relationship D. Existence-Dependent

B

Constraints are used to keep outliers out of your database. A. True B. False

B

Corporations use only structured data. A. True B. False

B

Entities are typically the following, EXCEPT: A. Person B. Actions C. Event D. Place

B

For 1st normal form, we do not need to have a primary key for our table. A. True B. False

B

For Data Modeling, the most important aspect is capturing the most data related to the subject matter. A. True B. False

B

If an attribute has the following values, it is in 1st normal form: 0 0, 1, 2 3, 4 2 A. True B. False

B

In a scenario where you are creating a database for a Pizza Company, which of the following is an example of a "Multiple-Valued Attribute" in a table called "Orders?" A. phoneNumber B. toppings C. orderNumber D. firstName

B

In terms of a bank, the customers' home address is considered to be: A. an Entity B. an Attribute C. a Relationship D. a Constraint

B

In terms of the College of Information Sciences and Technology, teacher -> student is what type of relationship? A. One-to-many B. Many-to-many C. One-to-one D. 12-to-pi

B

In the "Marshmallow Challenge" and similar to optimal design, the kindergartners did better than most because: A. They enjoyed cookies and naps throughout the challenge B. They tested the marshmallow. on heir structures throughout the design to see if it worked or not C. They always set the bar low for themselves, to easily complete the task D. Prior to construction, they were told the tallest structures would receive Elmo stickers, where the shortest one would only receive Bert stickers

B

Is it typically a bad idea to limit the data coming into your database. A. True B. False

B

The best means to create a successful Data Model is to meet with the subject matter experience at the beginning of the process and then provide a finalized version of the design at the end of the process. A. True B. False

B

The conceptual model is dependent of software but independent on hardware. A. True B. False

B

What database provides localized data, but is synchronized together for a more global database system? A. desktop databases B. distributed database C. analytical databases D. centralized databases

B

When we say have a one-to-one relationship between entities, we are referring to ___________. A. cardinality B. connectivity C. weak relationship D. strong relationship

B

Which of the following is NOT part of our "Developing an Entity Relationship Diagram" spoke about in class. A. Create a narrative B. Collect data C. Identify business rules D. Iterate ober multiple versions

B

___________ refer to a type of database that is created and maintained using services such as Microsoft Azure and Amazon AWS. A. Integrated databases B. Cloud databases C. Desktop databases D. In-memory databases

B

A(n) ___________ database is used by an organization and supports many users across many departments. A. desktop B. workgroup C. enterprise D. transactional

C

Boyce-Codd Normal form is special case of ___________ Normal Form. A. 1st B. 2nd C. 3rd D. 4th

C

If we are interested in developing a very low-level view of our databases, including all the tables and all attributes (including their respective attribute types, attribute format, attribute requirements). We would develop a... A. Data Encyclopedia B. Data Model C. Data Dictionary D. Data Details

C

In a scenario where you are creating a database for a Pizza Company, which of the following is an example of an "Optional Attribute" in a table called "Orders?" A. Price B. Address C. DiscountCode D. PhoneNumber

C

When we say, we expect for every ISBN that it will be located in (0, 100) libraries. We are describing the ___________. A. transitive dependency B. repeating group C. cardinality D. connectivity

C

Which of the following is NOT true about 2nd form? A. remove all partial dependencies B. must be in first normal form C. must be in third normal form

C

___________ is the body of information and facts about a specific context. A. Validation B. A format C. Knowledge D. A database

C

___________ provide a description of the data characteristics and the set of relationships that link the data found within the database. A. Queries B. End-user data C. Metadata D. Schemas

C

If you want to change-permission within a database, this uses what feature of SQL: A. Data Manipulation Language B. Data Definition Language C. Transaction Control Language D. Data Control Language

D

It is typically assumed that a data modeler is to be good at all of the following, EXCEPT: A. Flow Charts B. Data Dictionary C. Relational Models D. Programming

D

When references each piece of data in a table (think a row in Excel SpreadSheet), we use all of the following phrases EXCEPT: A. row B. tuple C. entity occurrence D. attribute

D

When referencing ER diagram, ER stands for... A. Entity Rules B. Emergency Room C. Entity Roles D. Entity Relationship

D

When specifying a primary key either in an ER diagram or written out, we usually ___________ the primary key. A. Bold B. Italicize C. Capitalize D. Underline

D

Which of the following is NOT a reason we would want to Normalized our databases? A. Reducing redundancy B. Optimizing storage C. Optimizing retrieval D. Reduce Complexity

D

Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently? A. Data query B. Data integrity C. Data dictionary D. Data redundancy

D

___________ is the result of revealing the meaning of raw facts. A. End-user data B. An encoded sample C. An encrypted bit D. Information

D