HqMra Blog

Test: Quiz: Speaking ERDish and Drawing Relationships

Section 1

1. After looking at the diagram, choose the sentence below that could be "read" from the existing relationship (even though you're missing relationship labels!)

Mark for Review
(1) Points

Each Student must have one or more Activities.

Each Activity may be performed by one or more Students.

Each Student may participate in one or more Activities. (*)

Each Activity must belong to one and only one Student.

2. When reading a relationship between 2 entities, the relationship is only read from left to right. True or False? Mark for Review
(1) Points

True

False (*)

3. Two entities can have one or more relationships between them. True or False? Mark for Review
(1) Points

True (*)

False

Test: Quiz: ER Diagramming

Section 1

1. On an ER diagram which symbol identifies an attribute as part of a unique identifier. Mark for Review
(1) Points

# (*)

*

o

x

2. Entity names are always plural. True or False? Mark for Review
(1) Points

True

False (*)

3. Which symbol is used to indicate that a particular attribute is optional? Mark for Review
(1) Points

*

o (*)

#

&

4. Entity boxes are drawn as Mark for Review
(1) Points

Soft Boxes (*)

Hard Boxes

Bold Circles

Normal Circles

5. Attributes are written inside the entity to which they belong. True or False? Mark for Review
(1) Points

True (*)

False

6. Consider the recommended drawing conventions for ERD's. Indicate which of the following accurately describes diagramming conventions for entities and attributes: Mark for Review
(1) Points

The * means that an attribute is optional and entity names should be plural verbs

The 'o' means that the attribute is optional and entity names should be plural verbs

The * means that an attribute is mandatory or required and the entity name should be singular (*)

The 'o' means that the attribute is mandatory or required and the entity name should be a singular noun

Test: Quiz: Identifying Relationships

Section 1

1. Relationships always exist between Mark for Review
(1) Points

3 or more entities

2 entities (or one entity twice) (*)

2 attributes

3 or more attributes

2. Relationships can be either mandatory or optional. True or False? Mark for Review
(1) Points

True (*)

False

3. In a business that sells computers, choose the best relationship name from CUSTOMER to ITEM (computer, in this case). Mark for Review
(1) Points

Each CUSTOMER must be the buyer of one or more ITEMS. (*)

Each CUSTOMER must be the seller of one or more ITEMS.

Each CUSTOMER may be the maker of one or more ITEMS.

Each CUSTOMER may be the producer of one or more ITEMS.

4. What are the three properties that every relationship should have? Mark for Review
(1) Points

Transferability, degree, name

Name, optionality, degree (*)

A UID bar, a diamond, an arc

Name, optionality, arcs

Test: Quiz: Entity Relationship Modeling and ERDs

Section 1

1. Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review
(1) Points

True (*)

False

2. The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False? Mark for Review
(1) Points

True (*)

False

3. Which of the following statements are true about ERD's? (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)

A piece of information can be shown multiple times on an ERD.

A piece of information should only be found one place on an ERD. (*)

You should not model derivable data. (*)

All data must be represented on the ERD, including derived summaries and the result of calculations.

4. A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False? Mark for Review
(1) Points

True

False (*)

Test: Quiz: Entities, Instances, Attributes and Identifiers

Section 1

1. What is the purpose of a Unique Identifier? Mark for Review
(1) Points

To uniquely determine a table and columns within that table.

To identify a specific row within a table, using one or more columns and/or foreign keys.

Create an entity that is unlike any other entity aside from itself.

To identify one unique instance of an entity, by using one or more attributes and/or relationships. (*)

2. Some of the following could be attributes of an ENTITY called PERSON. Select the incorrect attributes for PERSON. (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)

Age

Freddy Wilson (*)

Name

Priya Hansenna (*)

3. Which of the following statements about attributes are true? (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)

They describe, qualify, quantify, classify, or specify an entity. (*)

They are often adjectives.

They have a data type such as a number or character string. (*)

They must be single valued unless they belong to more than one entity.

4. Unique Identifiers.... Mark for Review
(1) Points

distinguish one entity from another

distinguish one instance of an entity from all other instances of that entity (*)

distinguish all entities in a database

distinguishes nothing

5. In the following statements, find two examples of ENTITY: Instance. (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)

DAIRY PRODUCT: cow (*)

VEGETABLE: grows

BOOK: Biography of Mahatma Gandhi (*)

TRAIN: runs

6. An entity may have which of the following? Mark for Review
(1) Points

experiences

instances (*)

tables

none of the above

7. Entities are usually verbs. True or False? Mark for Review
(1) Points

True

False (*)

8. A/an _________ is a piece of information that in some way describes an entity. It is a property of the entity and it quantifies, qualifies, classifies or specifies the entity. Mark for Review
(1) Points

ERD

Process

Table

Attribute (*)

9. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points

David Jones

Male (*)

Angelina Rosalie

Grace Abinajam

10. Which of the following entities most likely contains invalid attributes? Mark for Review
(1) Points

Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built

Entity: Pet. Attributes: Name, Birthdate, Owner

Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)

Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary

11. In a physical data model, an attribute is represented as a/an Mark for Review
(1) Points

Column (*)

Row

Instance

Foreign Key

12. The word "Volatile" means.... Mark for Review
(1) Points

Changing constantly; unstable (*)

Static; unlikely to change

Large quantity

Limited quantity

Test: Quiz: Conceptual and Physical Models

Section 1

1. Examples of software are: Mark for Review
(1) Points

Data entry webpages, Spreadsheets, Google and Yahoo search Engines, SQL Developer, Oracle Application Express (*)

Microsoft Word, Microsoft Powerpoint, Microsoft Excel, Mouse pad

Mouse, Cables, Microsoft Word, Microsoft Powerpoint

Monitor, Microsoft Word, Microsoft PowerPoint, SQL Developer

2. Which of the following are reasons we create conceptual models? Mark for Review
(1) Points

It facilitates discussion. A picture is worth a thousand words.

It forms important ideal system documentation.

It takes into account government regulations and laws

It forms a sound basis for physical database design

All of the above. (*)

3. Examples of hardware are: Mark for Review
(1) Points

Data entry web pages, Mouse, Hard disk

Mouse, Hard disk, Monitor (*)

Monitor, Mouse, Printer, Printed Reports

Monitor, Mouse, Mouse pad, Cables and Wires, Hard disk

Test: Quiz: Major Transformations in Computing

Section 1

1. In the grid computing model, resources are pooled together for efficiency. True or False? Mark for Review
(1) Points

True (*)

False

2. Users would use which of the following software to access essential business applications? (Choose three) Mark for Review
(1) Points

(Choose all correct answers)

GUI Interface (*)

Internet Browser (*)

Server

Operating System (*)

3. Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points

True

False (*)

4. Databases function more efficiently as: Mark for Review
(1) Points

Multiple applications on multiple client-servers

Integrated software on fast processing servers (*)

Client-based software on client-servers

Client-based software on personal computers

5. Which of the following is NOT a type of database? Mark for Review
(1) Points

Hierarchical

Relational

SQL (*)

Network