Quiz 1 - quiz 1 PDF

Preview

Summary

quiz 1...

Description

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

My Bb Learn Courses

All Learn Courses

MET CS669 A3/E1 Database Design and Implementation for Business (2019 Fall)

Mujun Liu

Student Services

Assessments

Review Test Submission: Quiz 1

Review Test Submission: Quiz 1

User

Mujun Liu

Course

MET CS669 A3/E1 Database Design and Implementation for Business (2019 Fall)

Test

Quiz 1

Started

9/20/19 8:12 AM

Submitted

9/20/19 8:46 AM

Due Date

9/20/19 6:00 PM

Status

Completed

Attempt Score

96.83333 out of 100 points 

Time Elapsed

34 minutes out of 1 hour and 30 minutes

Instructions Handling Technical Diculties: If you experience technical diculties while taking this quiz, the quickest and easiest resolution is to immediately logout, then login using a dierent browser, then resume taking the quiz in the new browser. Logging out or logging in does not cancel or submit the in-progress quiz, and the answers you have already saved will remain saved. Simply reopen the quiz in the new browser and click the "Continue Assessment" button to resume taking the quiz. Though many technical diculties can be resolved using this method, in the event you experience the same issues in the new browser, please complete the quiz as best as you can, then immediately contact technical support at (888)243-4596 and email your facilitator. Results Displayed

All Answers, Submitted Answers, Correct Answers, Feedback, Incorrectly Answered Questions

Question 1

3.33333 out of 5 points

Select all statements that correctly describe a reason why data modeling is important. Selected b. Answers: A data model provides a blueprint or abstraction by which the database can be constructed. c. A data model is a communication tool which can facilitate interaction between those who create and maintain the database and the end users. Answers:

a.

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 1/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

Application programmers usually need a data model to help build the applications that use the database. b. A data model provides a blueprint or abstraction by which the database can be constructed. c. A data model is a communication tool which can facilitate interaction between those who create and maintain the database and the end users. d. A good data model only describes the highest layers in the database. e. A good data model only describes the lower layers in the database. Response Feedback:

The importance of data models is covered in section 2-2 of the textbook, editions 12 and 13.

Question 2

5 out of 5 points

Suppose that you are designing a transaction processing database that is not accessed from the Internet. Which of the following information is critical to your design? (Check all that represent critical design inputs for typical transaction processing databases.) Selected Answers:

b. The expected use of the database c. The types of entities that need to be represented in the database and the relationships between the entities

Answers:

a. The precise size of the database in bytes b. The expected use of the database c. The types of entities that need to be represented in the database and the relationships between the entities d. The precise number of entity instances of each type.

Response Feedback:

The concepts are introduced in section 1-4 of the textbook, editions 12 and 13.

Question 3

5 out of 5 points

Select all statements that correctly describe the diagram below. 

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 2/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

Selected Answers:

The diagram includes three one-to-many relationships. The diagram is notated using Crow’s foot notation. This diagram could be part of a conceptual model for a relational database.

Answers:

The diagram asserts that each Hotel is associated with zero to many hotel chains. The diagram includes three one-to-many relationships. The diagram has a one-to-one relationship. The diagram is notated using Crow’s foot notation. This diagram could be part of a conceptual model for a relational database.

Response Feedback:

Question 4

The concepts are covered in section 2-5c of the textbook, 12th and 13th editions.

5 out of 5 points

From the statements below, select all that correctly describe a type of database. Selected a. Answers: A distributed database has data which is spread across dierent sites. c. A workgroup database is typically used by fty or fewer people who work together, usually in a department. d. An enterprise database is a database that is used by many users (more than fty, usually hundreds) across many departments. Answers:

a. A distributed database has data which is spread across dierent sites. b. A data warehouse is primarily used to support a company's day-to-day operations such as sales.

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 3/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

c. A workgroup database is typically used by fty or fewer people who work together, usually in a department. d. An enterprise database is a database that is used by many users (more than fty, usually hundreds) across many departments. Response Feedback:

The concepts are introduced in 1-3b of the textbook, editions 12 and 13.

Question 5

5 out of 5 points

Select all statements that correctly describe the diagram below. 

Selected Answers:

a. The diagram is notated using Crows Foot notation. b. A business rule inferred by this diagram could correctly be, "A customer makes one or many payments." e. The diagram has a one-to-many relationship.

Answers:

a. The diagram is notated using Crows Foot notation. b. A business rule inferred by this diagram could correctly be, "A customer makes one or many payments." c. The diagram notated using Chen notation. d. The diagram has a many-to-many relationship. e. The diagram has a one-to-many relationship.

Response Feedback:

Question 6

The concepts are covered in section 2-5c of the textbook, 12th and 13th editions.

5 out of 5 points

Choose all statements that correctly describe terms in the relational model and in relational databases. Selected Answers:

b. A table row corresponds to a tuple in the relational model. c. A table column corresponds to an attribute in the relational model. d. A table corresponds to a relation in the relational model.

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 4/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

Answers:

a. A table corresponds to a tuple in the relational model. b. A table row corresponds to a tuple in the relational model. c. A table column corresponds to an attribute in the relational model. d. A table corresponds to a relation in the relational model. e. A table row corresponds to a relation in the relational model.

Response Feedback:

The concepts are introduced in 2-5b of the textbook, editions 12 and 13.

Question 7

5 out of 5 points

An employee has the following le to record customer names, phone numbers, items purchased, and the amount charged for each item. The employee has no other le to record this data except what is illustrated below.



Assume that "Mr. Eli Jordan" returns the ashlight and the employee deletes the record associated with that name. Select all answers that are results of this modication. Selected Answers:

a deletion anomaly loss of information

Answers:

a deletion anomaly data independence an update anomaly loss of information

Response Feedback:

Question 8

The concepts are covered in section 1-6c of the textbook, editions 12 and 13.

5 out of 5 points

Select the alternative that correctly identies the relationship classication described by the two business rules below. https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 5/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

Each student takes one or more classes. Each class may be taken by one or more students. Selected Answer:

b. M:N (many to many) a. 1:5 (one to ve)

Answers:

b. M:N (many to many) c. 1:M (one to many) d. 0:1 (zero to one) e. 1:1 (one to one) Response Feedback:

Question 9

The concepts are covered in sections 2-3 and 2-4 of the textbook, editions 12 and 13.

5 out of 5 points

Which of the following correctly describe the relationships between data in databases and the real world? (Check all that are true.) a. Selected Answers: A column stores the same attribute from multiple entity instances such as the dates of dierent sales. b. An entity instance for an entity, such as a specic person for Person entity, can be represented as a record or database row, and that record or row may contain multiple attributes. c. A relational database stores data from related entities and their relationships, such as customers and the products that they have purchased. d. A database table may store information about entities of a single type such as customers, products, or sales. Answers:

a. A column stores the same attribute from multiple entity instances such as the dates of dierent sales. b. An entity instance for an entity, such as a specic person for Person entity, can be represented as a record or database row, and that record or row may contain multiple attributes. c. A relational database stores data from related entities and their relationships, such as customers and the products that they have purchased. d. A database table may store information about entities of a single type such as customers, products, or sales.

Response https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 6/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

Feedback: An entity represents a type, and an entity instance represents an instance of that type. A database table typically represents an entity type, and table rows typically represent entity instances. Table columns represent individual attributes within an entity type.

The concepts are introduced in sections 2-3 and 2-5c of the textbook, editions 12 and 13.

Question 10

5 out of 5 points

Select all statements that correctly describe the ramications of important features supported by modern DBMS. Selected c. Answers: The support of data types helps prevent storage of inappropriate data, for example, support of a DATE data type that requires dates and excludes character strings or numbers. d. The support of security constraints helps prevent unauthorized modication of data. Answers: a. The ability to run on dierent types of hardware such as PCs and Sun Microsystems servers help guarantee the integrity and consistency of data in the database. b. The ability for a database to grow large helps guarantee the integrity and consistency of data in the database. c. The support of data types helps prevent storage of inappropriate data, for example, support of a DATE data type that requires dates and excludes character strings or numbers. d. The support of security constraints helps prevent unauthorized modication of data. Response Feedback:

DBMS Functions are covered in section 1-7b of the textbook, 12th and 13th editions.

Question 11

5 out of 5 points

What type of relationship is expressed with the business rules? Each store is managed by one employee Each employee manages at most one store Selected Answer: Answers:

c. 1:1 (one to one) a. 1:M (one to many)

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 7/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

b. M:N (many to many) c. 1:1 (one to one) d. 1:5 (one to ve) Response Feedback:

Business rules are covered in section 2-4 of the textbook, editions 12 and 13.

Question 12

5 out of 5 points

Select all statements that correctly describe modern relational DBMS such as Oracle or Microsoft SQL server. Selected Answers:

The DBMS allows retrieval of information by using a query language. The DBMS helps enforce data security and privacy. The DBMS allows retrieval of information by using a query language.

Answers:

To manipulate data in a DBMS, a user must know which other users are concurrently using the database. The DBMS helps provide data integrity and data consistency by allowing only one user at a time to access the data. To manipulate data in a DBMS, users must know in detail how the data is stored on disk. The DBMS helps enforce data security and privacy. Response Feedback:

Question 13

The concepts are introduced in section 1-7b of the textbook, editions 12 and 13.

5 out of 5 points

Which aspects of database design are important? (Check all which correctly describe the importance of dierent aspects of database design?) Selected a. Answers: A poorly designed database could have performance problems and dicult-to-trace errors that could cause the application software to behave incorrectly. b. A database design must be scalable in order to continue to meet an organization's changing needs. c. Designing a database so that it will perform well as the amount of data grows is important, because poor performance cannot always be corrected by moving the database to faster hardware. d. A poorly designed database may have redundant data and may exhibit data anomalies. https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 8/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

Answers:

a. A poorly designed database could have performance problems and dicult-to-trace errors that could cause the application software to behave incorrectly. b. A database design must be scalable in order to continue to meet an organization's changing needs. c. Designing a database so that it will perform well as the amount of data grows is important, because poor performance cannot always be corrected by moving the database to faster hardware. d. A poorly designed database may have redundant data and may exhibit data anomalies.

Response The concept is covered in section 1-4 of the textbook, 12th and 13th Feedback: editions, and in Module 1, Lecture 1, section 2-3 of the online lectures.

Question 14

5 out of 5 points

Select all that are true of object-oriented data models. (Check all that are true.) Selected b. Answers: In object-oriented data models, both data and their relationships are contained in a single structure known as an object. c. In an object-oriented data model, an object can represent any physical or abstract thing. d. Object-oriented models are based on objects that share similar characteristics grouped in classes. Answers: a. Object-oriented data models are typically depicted using entityrelationship class diagrams. b. In object-oriented data models, both data and their relationships are contained in a single structure known as an object. c. In an object-oriented data model, an object can represent any physical or abstract thing. d. Object-oriented models are based on objects that share similar characteristics grouped in classes. Response Feedback:

The concepts are covered in section 2-5d of the textbook, editions 12 and 13.

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 9/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

3.5 out of 5 points

Question 15

Which of the following correctly describe an entity? (Check all that apply.) Selected Answers:

a. A single entity typically represents many dierent objects and abstractions. c. An entity represents a particular type of object (such as a product) or shared abstraction (such as an account). d. An entity may have several attributes. e. An entity must represent something concrete, such as a physical object.

Answers:

a. A single entity typically represents many dierent objects and abstractions. b. An entity is the equivalent of a eld in a le system. c. An entity represents a particular type of object (such as a product) or shared abstraction (such as an account). d. An entity may have several attributes. e. An entity must represent something concrete, such as a physical object.

Response Feedback:

Question 16

The concept is covered in section 2-3 of the textbook, 12th and 13th editions.

5 out of 5 points

An employee keeps track of her customers using a CUSTOMER le containing the following data: 



https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_i…

10/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...

The le is updated by the employee to: 1. Change Mrs. Jane Homan's phone number to "865-433-4235". 2. Add customer named “Mr. Yaron Hether” with a phone number of “555-9991212”, the item purchased as “Compass”, and the amount charged as “19.99” After modication, the le contains the following: 

 Select all answers that are errors that the employee made during modication. Selected Answers:

Created data inconsistencies because of the dierent phone numbers for Jane Homan Update anomaly

Answers:

Deletion anomaly Created data inconsistencies because of the dierent phone numbers for Jane Homan Structural independence Update anomaly The concepts are covered in section 1-6c of the textbook, editions 12 and 13.

Response Feedback:

Question 17

5 out of 5 points

When changes are made to some but not all copies of redundant data in a database, which of the following can result? (Check all that can result.) Selected Answers:

a. inconsistent data b.

https://learn.bu.edu/webapps/assessment/review/review.jsp?attempt_id=_12626556_1&course_id=_57804_1&content_id=_7228311_1&outcome_id… 11/15

9/20/2019

Review Test Submission: Quiz 1 – MET CS669 A3/E1 ...
...