ACCT 3303 Test2

Select all that apply Which of the following are true about the purpose of structure models? Tools for documenting Tools for planning Tools for showing process sequence Tools for implementing databases

- Tools for planning - Tools for documenting - Tools for implementing databases

Match the UML class diagram multiplicity options with the corresponding ERD cardinality options. 0..1 0..* 1..1 1..* (0,1) (1,N) (0,N) (1,1)

0..1 <---> (0,1) 0..* <---> (0,N) 1..1 <---> (1,1) 1..* <---> (1,N)

Match the described situation with the correct multiplicity. 0..1 or 0..* 1..1 or 1..* 0.. or 1.. 0..1 or 1..1 participation is optional maximum is more than one participation is mandatory maximum is one

0..1 or 0..* <---> participation is optional 1..1 or 1..* <---> participation is mandatory 0.. or 1.. <---> maximum is more than one 0..1 or 1..1 <---, maximum is one

Specify the order of the steps in mapping a UML class diagram to a relational database schema by matching the step to the order number. 1 2 3 4 map associations to foreign keys map classes to tables map class attributes to table fields create new tables for many-to-many relationships

1 <---> map classes to tables 2 <---> map class attributes to table fields 3 <---> map associations to foreign keys 4 <---> create new tables for many-to-many relationships

Which of the following cardinality symbols (placed on the association between two classes/entities) is the equivalent of the multiplicity 0..* in information engineering notation? A small line and three crow's feet A circle and a small line A circle and three crow's feet A circle

A circle and three crow's feet

What is a data dictionary? A data dictionary is the design, implementation, repair, and security of a firm's database. A data dictionary describes the data fields in a database such as field type and field length. A data dictionary contains many most useful words in a database. It is very useful for spelling checks.

A data dictionary describes the data fields in a database such as field type and field length.

Choose the best description about a relational database. A relational database is centralized and does not have flexibility. A relational database often has redundant data. A relational database is simple for the users to understand the design.

A relational database is simple for the users to understand the design.

__________ relationships describe classes that are often considered together.

Aggregation

If you see SELECT * in the first line of a SQL statement, what does the * mean? All the attributes in a table All the non-key attributes in a table All the tables in a database

All the attributes in a table

Which of the following things can be represented by classes on a UML class diagram? People Assets Start events Business rules

Assets, people

Classes A and B are linked. The multiplicities on the association next to A are 1..1 and next to B are 0..*. In this case, post the foreign key in class __________ .

B

In a Cash Receipt Table, which of the following attributes is a possible foreign key? Purchase order number Inventory ID Bank account number Vendor ID

Bank account number

How is a many-to-many relationship implemented in a relational database? By creating a new table with primary keys of both tables. By creating a new table with the primary key of one table. By adding a foreign key in the primary key table. By adding a primary key in the foreign key table.

By creating a new table with primary keys of both tables.

Select all that apply Which of the following is true about primary keys? Should be controlled by the assigning organization Can change over time Cannot be blank (null) Is the foreign key of another table Uniquely identifies instances of a class

Cannot be blank (null) Uniquely identifies instances of a class Should be controlled by the assigning organization

Which of the following is a good example of a primary key for the Cash Receipt table? Customer check number Sales order number Cash receipt number

Cash receipt number

Which of the following is a composition relationship? Subsidiaries in a conglomerate company Chapters in a book Teams in a league Players on a team

Chapters in a book

Match the symbol with the thing that the symbol represents in UML. Class is what symbol? Associations is what symbol? Answer Choices. lines;rectangle

Class <-> rectangles Associations <-> lines

Select all that apply Select the correct statements about cloud computing. The major concern of using cloud computing is issues on privacy and security. Most ERP systems cannot be host in the cloud. Companies using cloud computing often share resources and applications. Cloud computing is Internet-based.

Companies using cloud computing often share resources and applications. Cloud computing is Internet-based. The major concern of using cloud computing is issues on privacy and security.

Examples of an external database used in a data warehouse might include which data source? Sales database Inventory database Competitor information

Competitor information

Select a possible attribute for a class called CUSTOMER. Product unit price Sales dollar amount Customer Address Invoice number

Customer Address

In a Sales Table, which of the following attributes is a possible foreign key? Customer number Sales dollar amount Invoice number Sales date

Customer number

Select all that apply Which of the following are examples of associations between classes in UML. Employees "work for" supervisors One student "is" Joe Customers "participate" in sales Instructors "teach" classes

Customers "participate" in sales Instructors "teach" classes Employees "work for" supervisors

For a grocery store chain, answering a question like, how much cranberry sauce did we sell last Thanksgiving would be a good question for which type of data source? Data mart Data warehouse Customer relationship management software

Data mart

Who is responsible for the design, implementation, repair, and security of a company's database? Controller Chief Information Security Officer IT Staff Database administrator

Database administrator

Select all that apply Criteria for selection of primary keys include which of the following? Cannot be blank Preferable uses sequential values Links to foreign keys Does not change over time

Does not change over time Cannot be blank Preferable uses sequential values

Which of the following statements correctly describes the basic requirements of tables in a database? The data value for a foreign key in a table cannot be null. For data entry, we do not have to have a data value entered in the primary key field. Each column of a row may contain multiple data values. For example, a sales order may include different types of inventory. Each attribute in a table must have a unique name and the values of a specific attribute must be of the same type.

Each attribute in a table must have a unique name and the values of a specific attribute must be of the same type.

Explain the multiplicities in the following relationship. Inventory (1..*) ----- (0..1) Sales Each item of inventory can be sold once only. In each sales transaction, only one item of inventory could be sold. Each item of inventory can be sold many times.

Each item of inventory can be sold once only.

Select all that apply Which of the following are true about business rules? Written in text Influence model structure Establish multiplicities Describe punishment Set criteria for branching

Establish multiplicities Influence model structure Written in text Set criteria for branching

True or false: The organization that maintains the standard for Business Rules is the object management system.

False

True or false: The specification for UML (unified modeling language) is maintained by the Object Management Guild.

False

_____________ in Microsoft Access is an object to be used for data entry.

Form

Select the best description of a relational data model. It is widely used in the mainframe database management systems. It requires relationships to be formed at the database creation and the relationships should not be changed later. It stores information in the form of related two-by-two tables. It allows users to identify relationships at the database creation or later whenever new information or requirements are desired.

It allows users to identify relationships at the database creation or later whenever new information or requirements are desired.

Select all that apply All types of challenges emerge both from a technical and organizational perspective when implementing an enterprise system. Which of the following are examples of the challenges? It is too costly to implement an enterprise system. The system does not provide enough functions to be used in one department. It is not easy to get employees adequate training.

It is not easy to get employees adequate training. It is too costly to implement an enterprise system.

Select all that apply What is an enterprise system? It is rarely used by the accounting/finance department. It often uses a database in establishing the system. It is also known as ERP. It is an integrated information system to be used across different functional areas of an organization.

It often uses a database in establishing the system. It is also known as ERP. It is an integrated information system to be used across different functional areas of an organization.

Choose the best answer to explain a hierarchical data model. It organizes data into a tree-like structure that allows repeating information using defined parent/child relationships. It is most commonly used to manage many-to-many relationships so it is the best model to represent the structure of today's network. It stores data in the form of two-by-two tables.

It organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.

The __________ ___________ __________ (OMG) published a standard to formalize the statement of business rules, titled "Semantics of Business Vocabulary and Business Rules."

Object Management Group

Select all that apply Which of the following are valid business rules? Payment is defined as a customer's monetary offering Payment may be made by credit card if the card is American Express Payment cannot be made by check Payment may be made by credit card

Payment may be made by credit card Payment cannot be made by check Payment may be made by credit card if the card is American Express

Select all that apply Which of the following are valid obligatory business rules? Payment must be made in cash Payments must be recorded by the cashier Payments cannot be made by check Credit card payments are allowed if the card is American Express

Payment must be made in cash Payments must be recorded by the cashier

Select all that apply Business rules can be enforced using which of the following enforcement levels? Post-override Strict enforcement Pre-override Optional enforcement

Pre-override Strict enforcement Post-override

When users want to find answers to questions in a Microsoft Access database such as the balance of accounts receivable, which function do they use? Query Table Report

Query

Select all that apply Business rules are valuable because of which of the following? Tied to outdated technology Reveal unnecessary constraints Make modeling easier Limit options

Reveal unnecessary constraints Limit options Make modeling easier

Select all that apply Choose the advantage(s) of using a relational database. Reduced redundancy Scalability Flexibility Complexity

Scalability Reduced redundancy Flexibility

Structure models should be able to describe all except: Relationships among things Sequence of activities Cardinalities Things of interest

Sequence of activities

Which of the following would NOT be part of a decision table? Set of inputs Table name Set of decisions Set of rules

Set of decisions

Select all that apply ERD is short for entity-relationship diagram. Which of the following is true about ERDs? Similar to BPMN activity diagrams Graphic representation of logical data structure Similar to UML class diagrams Originally proposed by Peter Chen

Similar to UML class diagrams Originally proposed by Peter Chen Graphic representation of logical data structure

Why are data warehouses kept separate from a company's main operational database? So that they can run queries without affecting the performance of the company's operational systems. So that different systems can be easily integrated. So that they can speed up the performance of the company's operational systems.

So that they can run queries without affecting the performance of the company's operational systems.

Select all that apply What information would a human resources data mart include? Staffing levels at competitor firms Staffing levels in the supply chain Operational payroll information Salaries for workers each year for the past five years

Staffing levels at competitor firms Staffing levels in the supply chain Salaries for workers each year for the past five years

Select all that apply Aggregation relationships include which of the following examples? Stocks in a stock index Teams in a league Books in a book store Players on a team

Stocks in a stock index Players on a team Teams in a league

What is the main function of "Tables" in Microsoft Access? Store data Calculate data Enter and display data

Store data

Explain the multiplicities between the following two classes. Cash Receipt (1..*) ---- (1..1) Customer The (1..1) means each customer pays once only. The (1..1) means each cash receipt is from one and only one customer. The (1..*) means each cash receipt is from many customers.

The (1..1) means each cash receipt is from one and only one customer.

Select all that apply What are the disadvantages of using cloud computing? The company that provides service in the cloud may not be reliable. Companies must ensure that sensitive data stored in the cloud are secure. The Internet connection may not be always available. Cloud computing is too slow to host an enterprise system.

The company that provides service in the cloud may not be reliable. Companies must ensure that sensitive data stored in the cloud are secure. The Internet connection may not be always available.

Which of the following statements describes the Referential Integrity Rule correctly? Each attribute in a table must have a unique name. The data value for a foreign key could be null. The primary key of a table must have data values.

The data value for a foreign key could be null.

Select all that apply Which of the following statements is true about a list of tables based on a UML class diagram and associated attributes? (Check all that apply). Some classes don't need to have corresponding tables in the table list The list should contain at least as many tables as classes on the UML diagram The table name should be the same as the class name Every table should have a primary key identified

The table name should be the same as the class name Every table should have a primary key identified The list should contain at least as many tables as classes on the UML diagram

What is the purpose of using the command WHERE in SQL? To select tables to be used in a query To select attributes to be used in a query To state the criteria to be met in getting the query result

To state the criteria to be met in getting the query result

True or false: A primary key is a unique identifier of a specific row in a table.

True

True or false: When using SQL to retrieve data, the WHERE clause can be used to indicate how tables are linked.

True

In order to link tables in Access, you often use a foreign key. Which of the following statement is correct in creating a relationship in Access? The names of the primary key in one table and the foreign key in the other table must be the same. In general, we do not enforce referential integrity when linking tables. We must create links between the primary and foreign keys in Access's Relationship window.

We must create links between the primary and foreign keys in Access's Relationship window.

Classes A and B are linked. The multiplicities on the association next to A are 1..* and next to B are 0..1. In this case, post the foreign key in class __________.

a

A depiction of the relationship between two classes is a(n) _____. association class instance multiplicity

association

An __________ depicts the relationship between two classes in UML

association

The relationship between two classes is depicted by a(n) class symbol class name association attribute

association

When using SQL, ________ should immediately follow the SELECT statement. foreign keys primary keys table names attribute names

attribute names

Data elements which describe the instances in a class are called primary keys relationships attributes foreign keys

attributes

A primary key field cannot be null be sequential be controlled be unique

be null

A class diagram serves as the _____ from which the database is implemented. ERD source blueprint network

blueprint

A class diagram serves as the __________ from which the database is built.

blueprint

A _____ rule establishes multiplicities in class models and set criteria for branching in activity models. constraint standard business decision

business

Select all that apply A constraint can be modeled in each of the following ways: by placement with notes by a line drawn between the objects by a rectangle

by placement with notes

A __________ is an object which is implemented as a table in a relational database.

class

A separately identifiable collection of things about which the organization wants to collect and store information is a _____. model diagram class row

class

Attributes are data elements that describe instances in a __________.

class

Data warehouses use a ______________ data model for all data in the warehouse. common relational dynamic

common

The Object Management Group is a consortium of __________ industry members.

computer

A business rule is a statement of a _____ on a business process. query design constraint decision

constraint

A business rule is a succinct statement of a __________ on a business process.

constraint

Converting _____ from existing legacy systems to the newly implemented enterprise systems is often complicated and time consuming.

data

A _____ ______ describes the data fields in each database record such as field description, field length, and field type (e.g., alphanumeric, numeric).

data dictionary

What is the main purpose of the function FORM in Microsoft Access? data security data extraction data storage data entry

data entry

Structure models describe the __________ and __________ structure of a business process or processes.

data, information

A _____________ is a collection of related data used by businesses to maintain information about various types of objects, events, people and places.

database

A computer program that creates, modifies and queries the database is called a _____________ _____________ _____________, or DBMS.

database or data base management system

Class diagrams are similar to _____. entity relationship diagrams attributes in tables relationships between tables instances of tables

entity relationship diagrams

A data warehouse is a collection of information gathered from an assortment of ______ and internal databases to facilitate reporting for decision making.

external

Information regarding competitors, the industry and the general economy would be examples of _____ databases. external internal

external

True or false: A many-to-many relationship between classes A and B (where the maximum multiplicity on both sides of the association is *) is implemented by posting foreign keys in both A and B.

false

True or false: Composition relationships are a form of generalization relationships.

false

True or false: In a hierarchical data model, data elements always have a one-to-one relationship. In a network data model, data elements always have MANY-to-MANY relationships.

false

True or false: In an REA data model, the Cash Receipt table is often linked to Cashier table only.

false

True or false: In today's business world, we use the network data model only in designing databases.

false

True or false: The SELECT statement in SQL is used to create a table.

false

True or false: generalization relationships allow grouping of things with varied characteristics.

false

When designing a table using Microsoft Access, we use validation rules to provide input control such as requiring a field being numerical with a fixed length. We also enter information called validation text to tell the user what went wrong when entering data. All these features can be found in ______ properties

field

A __________ key is an attribute or combination of attributes that allows relational tables to be linked together.

foreign

In order to implement a relationship in Access, you must use a ____ key

foreign

Tables are linked by the use of _______ keys, forming an interconnected network of records that taken together are the relational database.

foreign

An attribute that allows tables to be linked together is called a(n) primary key association data type foreign key

foreign key

Data warehouses often serve as a repository of the firm's (historical/forecast) data.

historical

A model of logical database structures must be able to describe all of the following except relationships entities attributes keys cardinalities

keys

An ERD is a graphical representation of the __________ data structure of a database.

logical

Hierarchical data models organize data into a tree-like structure and are widely used in _____________ database management systems.

mainframe

The first step in mapping a ULM class diagram to a relational database schema is map class attributes to table fields map associations to foreign keys assign primary keys map classes to tables.

map classes to tables.

Select all that apply Valid multiplicity options are shown in which of the following? minimum many and maximum many (asterisk..asterisk) minimum zero and maximum zero (0..0) minimum zero and maximum many (0..asterisk) minimum zero and maximum one (0..1)

minimum zero and maximum one (0..1)minimum zero and maximum many (0..asterisk)

Multiplicities describe the __________ and __________ number of times that instances of one class can be associated with instances of another class.

minimum, maximum

A _____________ data model is a flexible model representing objects and their relationships and allows M:N mapping.

network

The structure of a _____________ data model connecting records in a database looks like a mesh.

network

A database administrator is responsible for all of the following except: design of the database repair of the database networking of the database security of the database implementation of the database

networking of the database

When using SQL, we use the command _____________ _____________ to sort the query result.

order; by

Business rules can inhibit process improvements when they are tied to __________ technology.

outdated

An attribute or combination of attributes that uniquely identifies each instance in a class (or row in a table) is a __________ key.

primary

When designing a table using Microsoft Access, we must choose the Required field as "Yes" and the Indexed field as "Yes (No Duplicates)" in the field properties box for the ______ key.

primary

Select all that apply A database management system is a computer program that: networks the database uses the database creates the database queries the database modifies the database

queries the database creates the database modifies the database

When calculating and sorting data, the users often use the _______ object in Microsoft Access.

query or queries

An entity is represented by the ____ symbol in an ERD.

rectangle

The symbol used to represent a class is the _____. circle rectangle diamond arrow

rectangle

The _____________ data model stores data in the form of related two-dimensional tables.

relational

Among the different types of data models, ______ data models are the dominant one in use today, because they offer advantages over other data models, including: flexibility and scalability, simplicity, and reduced information ________

relational redundancy

Best practices in preparation of UML diagrams suggests that classes should be linked only when there is a clear business purpose for that _____

relationship

Generalization __________ allow groupings of things that share common characteristics.

relationships

One of the Microsoft Access objects,_____________ is used to integrate data from one or more tables or queries to provide organized information to decision makers.

report or reports

ERP means enterprise _____ planning.

resource

In an REA data model, R means ___ , E means ___, and A means ___.

resource, events, agents

When employees have different responsibilities, such as when employees work on a project and one employee supervises the project, those __________ can be modeled with multiple associations between the employee class and the linked class.

roles

When employees have different responsibilities, those ______ can be modeled with multiple associations between the employee class and the linked class. responsibilities relationships attributes classes roles

roles

Classes in UML are implemented as tables in a relational database and individual instances of the class are implemented as __________ in the table.

rows

Individual instances of objects are represented as _____ in a table. rows fields relationships models

rows

List agents who are often involved in sales transactions: _____ and _____

salesperson, customer

Best practices in preparation of UML diagrams suggests that the modeler should opt for _____ over complexity

simplicity

A class is any separately identifiable collection of objects about which the organization wants to collect and _____________ information.

store

True or false: Class diagrams are one type of UML diagram.

true

True or false: A list of tables associated with a UML class diagram would include attributes, primary keys, and any foreign keys for each table.

true

True or false: Constraints on an association can be modeled with a text statement of the constraint near the constrained end of the association.

true

True or false: decision tables can include multiple business rules.

true

A database is used to maintain information about types of objects. types of businesses. types of models. types of networks.

types of objects.

What is the minimum cardinality in an ERD if the relationship is optional? one many zero two

zero