As far as microsoft access is concerned, there are no n:m relationships.

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 1 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

2014 Fall Database Systems SEC.01

Assignments Take Test: 5451 Q2H

Take Test: 5451 Q2Take Test: 5451 Q2

Description Instructions This exam is due October 12th.

Multiple Attempts Not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later.

Save All AnswersSave All Answers Save and SubmitSave and Submit

A dashed line between entities indicates: a unique identifier. a minimum cardinality of zero. a minimum cardinality of one. an identifying relationship. a nonidentifying relationship.

Question 1 2.5 points Save AnswerSave Answer

After a 1:1 relationship has been created between two tables in Microsoft Access, the Relationship Type of One-To-One appears:

in the Relationship Type property of the primary key column in table Design View. in the Relationship Type property of the foreign key column in table Design View. in the table object in the Relationships window. in the Show Table dialog box. in the Edit Relationships dialog box.

Question 2 2.5 points Save AnswerSave Answer

An ID-dependent entity is: a special type of weak entity. an entity in which the identifier of the entity includes the identifier of another entity. a strong entity.

an entity with a maximum cardinality of one. Both a special type of weak entity and an entity in which the identifier of the entity includes the identifier of another entity

Question 3 2.5 points Save AnswerSave Answer

As far as Microsoft Access is concerned, there are no: 1:1 relationships. 1:N relationships. N:1 relationships. N:M relationships. recursive relationships.

Question 4 2.5 points Save AnswerSave Answer

A use case can be used to perform which of the following tasks? Transform the data model into the database design Validate the data model Fill the database with data Implement business rules Develop applications

Question 5 2.5 points Save AnswerSave Answer

??

https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null#

https://nccu.blackboard.com/webapps/blackboard/execute/courseMain?course_id=_1410180_1

https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null#contextMenu

https://nccu.blackboard.com/webapps/blackboard/content/listContent.jsp?course_id=_1410180_1&content_id=_1673778_1&mode=reset

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 2 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

By default, when Microsoft Access creates a relationship between two tables, it creates a(n): 1:1 relationship. 1:N relationship. N:M relationship. association relationship. recursive relationship.

Question 6 2.5 points Save AnswerSave Answer

Given only the excerpt of an E-R model shown above, which of the following is known to be true?

There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment. A single instance of ENTITY B may be related to many instances of ENTITY A. A single instance of ENTITY A must be related to many instances of ENTITY B. ENTITY A has a minimum cardinality of zero. The degree of the relationship is "many."

Question 7 2.5 points Save AnswerSave Answer

Given only the excerpt of an E-R model shown above, which of the following is known to be true?

A single instance of ENTITY A must be related to one instance of ENTITY B. Many instances of ENTITY A may be related to one instance of ENTITY B. ENTITY B has a degree of many. ENTITY B is a weak entity. Both A single instance of ENTITY A must be related to one instance of ENTITY B and ENTITY B has a degree of many are true.

Question 8 2.5 points Save AnswerSave Answer

Given the PRODUCT and SUPPLIER entities in the figure below, which of the following would represent the correct placement of foreign keys?

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID) PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber)PRODUCT_SUPPLIER (ProductID, SupplierID) PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber)PRODUCT_SUPPLIER (ProductID, SupplierID)

Question 9 2.5 points Save AnswerSave Answer

Given the entities PRODUCT and SUPPLIER shown in the figure below, which of the following would represent the correct placement of foreign keys?

Question 10 2.5 points Save AnswerSave Answer

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 3 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT (ProductID, Description, Cost)SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID) PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID) PRODUCT (ProductID, Description, Cost, ContactName)SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT (ProductID, Description, Cost, SupplierID)SUPPLIER (SupplierID, ContactName, PhoneNumber)

Given the generic relation: GENERIC (PKey1, PKey2, Attribute1, Attribute2, Attribute3), and the functional dependencies:(PKey1, PKey2) Attribute1 and PKey2 (Attribute2, Attribute3), which of the following is true?

GENERIC is not fully normalized. PKey1 is a determinant. PKey2 is a candidate key. GENERIC is in DK/NF. All of these

Question 11 2.5 points Save AnswerSave Answer

Given TABLE_A (Attribute1, Attribute2, Attribute3) and TABLE_B (Attribute4, Attribute5, Attribute6) shown in the figure below, which of the following would display the correct placement of foreign keys in the relational model?

TABLE_A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)TABLE _B (Attribute4, Attribute5, Attribute6) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4)TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1) TABLE _A (Attribute1, Attribute2, Attribute3)TABLE _B (Attribute4, Attribute5, Attribute6) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6)TABLE _B (Attribute4, Attribute5, Attribute6)

Question 12 2.5 points Save AnswerSave Answer

If one instance of ENTITY B must be related to one and only one instance of ENTITY A, and one instance of ENTITY A may be related to many instances of ENTITY B, which of the following should be written in the relationship symbol of the figure above?

0:1 1:1 1:N N:1 N:M

Question 13 2.5 points Save AnswerSave Answer

In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates:

a minimum cardinality of zero. a minimum cardinality of one. a maximum cardinality of one. a maximum cardinality of many. Both a minimum cardinality of one and a maximum cardinality of one

Question 14 2.5 points Save AnswerSave Answer

Question 15 2.5 points Save AnswerSave Answer

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 4 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates:

a minimum cardinality of zero. a minimum cardinality of one. a maximum cardinality of one. a maximum cardinality of many. Both a minimum cardinality of one and a maximum cardinality of one

Question 15

In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates:

a minimum cardinality of zero. a minimum cardinality of one. a maximum cardinality of one. a maximum cardinality of many. Both a minimum cardinality of one and a maximum cardinality of one

Question 16 2.5 points Save AnswerSave Answer

In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent:

a strong entity relationship. an ID-dependent weak entity relationship. a non-ID-dependent weak entity relationship. a supertype / subtype relationship. a recursive entity relationship.

Question 17 2.5 points Save AnswerSave Answer

In the Entity-Relationship data model, all instances of an entity of a given type are grouped into:

entity objects. class objects. entity classes. identifiers. entity attributes.

Question 18 2.5 points Save AnswerSave Answer

Microsoft Access can be used to prototype databases for which of the following DBMS products?

Microsoft Access SQL Server MySQL Oracle Database All of these

Question 19 2.5 points Save AnswerSave Answer

Microsoft Access is a good tool for creating mock-ups of forms and reports because: the form and report generators do not exist within Access itself. Access forms and reports are very simplistic. Access wizards make it easy to create the forms and reports. Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets.

Question 20 2.5 points Save AnswerSave Answer

The fundamental rule of normalization can be stated as: every table must meet the definition of a relation. every determinant must be a candidate key. every domain must be a logical consequence of the constraints. every key must be a candidate key. every constraint must be a determinant.

Question 21 2.5 points Save AnswerSave Answer

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 5 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

every constraint must be a determinant.

The number of entity classes involved in a relationship is known as the relationship's: maximum cardinality. minimum cardinality. ordinality. degree. class.

Question 22 2.5 points Save AnswerSave Answer

The representation of the content, relationships, and constraints of the data needed to support the system requirements is the:

relation design. implementation. data model. data view. application program.

Question 23 2.5 points Save AnswerSave Answer

To create a 1:1 relationship between two tables in Microsoft Access: the Indexed property of the foreign key column must be set to No. the Indexed property of the foreign key column must be set to Yes (Duplicates OK). the Indexed property of the foreign key column must be set to Yes (No Duplicates). the Data Type of the foreign key column must be set to AutoNumber. the Smart Tag property of the foreign key column must be set to Foreign Key.

Question 24 2.5 points Save AnswerSave Answer

What relationship pattern is illustrated in the following schema?

ProductID in PRODUCT_SUPPLIER

must exist in ProductID in PRODUCT SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT

Association relationship Intersection relationship Recursive relationship Strong entity relationship Supertype/subtype relationship

Question 25 2.5 points Save AnswerSave Answer

What relationship pattern is illustrated in the following schema?

VehicleID in CAR must exist in VehicleID in

VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE Association relationship Intersection relationship Recursive relationship Strong entity relationship Supertype/subtype relationship

Question 26 2.5 points Save AnswerSave Answer

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:

degree. recursive cardinality. minimum cardinality. maximum cardinality. ordinality.

Question 27 2.5 points Save AnswerSave Answer

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 6 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

Which of the following activities is not performed during the implementation phase of developing a database system?

Filling the database with data Transforming the data model into a database design Writing application programs Creating forms Creating reports

Question 28 2.5 points Save AnswerSave Answer

Which of the following is the correct technique for representing a 1:N relationship in the

relational model? The key of the entity on the one side is placed into the relation for the entity on the many side. The key of the child is placed into the relation of the parent. The key of either relation can be placed into the other relation. The key of the entity on the many side is placed into the relation for the entity on the one side. An intersection relation is created, and the keys from both parent entities are placed as keys in the intersection relation.

Question 29 2.5 points Save AnswerSave Answer

Which of the following is the correct technique for representing a M:N relationship using the relational model?

An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation. An intersection relation is created with a surrogate key, which is placed in each of the parent entities. An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation. The key from either relation is placed as a foreign key in the other relation. None of these

Question 30 2.5 points Save AnswerSave Answer

Which of the following is the first step in representing entities using the relational model? Define a table for each entity. Determine identifiers. Determine foreign keys. Examine the entity against normalization criteria. Define a primary key.

Question 31 2.5 points Save AnswerSave Answer

Which of the following is true about identifiers of entities? Identifiers must be unique. Identifiers are not normally used in a naming role. The value of an identifier may identify a set of entity instances. Identifiers may not be more than two attributes. An identifier in the E-R model is equivalent to a key in the relational model.

Question 32 2.5 points Save AnswerSave Answer

Which of the following is true about representing a weak entity with the relational model? If the weak entity is existence-dependent, the key of the parent must be part of the key of the weak entity. If the strong entity has a minimum cardinality of 1, the key of the weak entity must be part of the strong entity. If the weak entity is ID-dependent, the key of the weak entity must be part of the key of the parent entity. If the weak entity is ID-dependent, the key of the parent entity must be part of the key of the weak entity. If the parent entity is existence-dependent, then the minimum cardinality of the weak entity is zero.

Question 33 2.5 points Save AnswerSave Answer

Question Completion Status:

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 7 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

Which of the following is true when representing a 1:1 binary relationship using the relational model?

The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key. The key of each entity must be placed in the other as a foreign key. The key of either entity is placed in the other as a foreign key. The key of the entity with the most attributes must be placed in the other entity as a foreign key. Both entities must have the same primary key.

Question 34 2.5 points Save AnswerSave Answer

Which of the following is not a basic element of the E-R Model? Identifiers Entities Cardinalities Use cases Relationships

Question 35 2.5 points Save AnswerSave Answer

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

Business rules User interviews Forms Use cases All of these are sources for user requirements.

Question 36 2.5 points Save AnswerSave Answer

Which of the following is not a stage in the development of a database system? Requirements analysis Validation Component design Implementation All of these are stages in the development of a database system.

Question 37 2.5 points Save AnswerSave Answer

Which of the following is not necessarily true of a relation that is in 4NF? It is in 2NF. It is in DK/NF. It has no multivalued dependencies. It is in Boyce-Codd Normal Form. All of these are true.

Question 38 2.5 points Save AnswerSave Answer

Which of the following would be a reason to denormalize a relation? Relax security Lack of design time End user preference Improve performance None of these

Question 39 2.5 points Save AnswerSave Answer

Which of the following would not be contained in a use case? Inputs provided to the system to perform a task A description of a task the user wants to perform A prototype of the system performing a given task Outputs generated by the system in performing a given task All of these would be contained in a use case.

Question 40 2.5 points Save AnswerSave Answer

10/9/14, 8:52 AMTake Test: 5451 Q2

Page 8 of 8https://nccu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_123787_1&course_id=_1410180_1&content_id=_1741567_1&step=null

Click Save and Submit to save and submit. Click Save All Answers to save all answers.

Save All AnswersSave All Answers Save and SubmitSave and Submit

Save and Submit

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com