AIS Chapter 4

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

List agents who are often involved in sales transactions: _____________ and _____________ .

- salesperson, salespeople, or cashier - customer or customers

Choose the best description about a relational database.

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

In a Cash Receipt Table, which of the following attributes is a possible foreign key?

Bank account number

Which of the following is a BEST primary key for cash disbursement table?

Disbursement voucher number

What is referential integrity rule?

Foreign keys could be null.

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

Forms or Form

Select the best description of a relational data model.

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

Which of the following is not a valid link between tables?

Linking Vendor Table with Customer Table

Which of the following could be a relationship table (i.e., to link two tables)?

Purchase line-item table

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

Resources Events Agents

Which statement about enterprise systems is correct?

SAP, Oracle, and Microsoft all offer products for enterprise systems.

Which of the following is used in SQL to begin a query?

SELECT

Which of the following could be an "event" in REA data models?

Sales?

What is the main function of "Tables" in Microsoft Access?

Store data

Explain the multiplicities between the following two classes. Cash Receipt (1..*) ---- (1..1) Customer

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

True or false: A foreign key is another table's primary key.

True

The GROUP BY operator in SQL is used to:

aggregate functions on the query results based on one or more columns.

When using SQL, ________ should immediately follow the SELECT statement.

attribute names

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

data

True or false: A primary key is a unique identifier of tables.

false

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

foreign

The "ORDER BY Amount ASC" clause to the SELECT statement used in SQL suggests that:

the amount of the query result will be listed in ascending order.

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

Select a possible attribute for a class called CUSTOMER.

Customer Address

In a Sales Table, which of the following attributes is a possible foreign key?

Customer number

Match the functions in Microsoft Access with their purposes respectively.

Table <----> store data Query <----> retrieve data forms <----> enter data report <----> organize & display data

Which of the following statements describes the Referential Integrity Rule correctly?

The data value for a foreign key could be null.

Which of the following is a correct statement about primary keys?

The data values of a primary key must be different (i.e., unique).

Cloud computing:

is Internet-based computing, where shared resources, software, and information are provided to firms on demand.

Which function in Microsoft Access is used the most by a clerk whose responsibility is mainly data entry?

form

What is a data dictionary?

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

Explain what the multiplicity zero mean in the following relationship. Sales (0..&#x002A;) ----- (1..1) Salesperson

A new salesperson whose information has been entered into the Salesperson table before performing any sales transaction.

In an REA data model, the resource class, Cash, is used for both cash receipt event and cash disbursement event. Select the best attributes from the following list to be included in the Cash table.

Account type Account balance Bank account number

If you see SELECT &#x002A; in the first line of a SQL statement, what does the &#x002A; mean?

All the attributes in a table

Who is responsible for the design, implementation, repair, and security of a company's database?

Database administrator

Explain the multiplicities in the following relationship. Inventory (1..&#x002A;) ----- (0..1) Sales

Each item of inventory can be sold once only.

SAP modules available for implementation include:

Financial Accounting, Payroll, and Sales and Distribution.

What is an enterprise system?

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

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 not easy to get employees adequate training. It is too costly to implement an enterprise system.

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.

What kind of relationship does a network data model represent?

Many-to-many relationship

Refer to Figure 4.2, if Steve's Stylin' Sunglasses accepts installments without requiring a down payment, the multiplicities between Sales and Cash Receipts should be changed to:

Sales (1..1) - (0..*) Cash Receipts.

Choose the advantage(s) of using a relational database.

Scalability Reduced redundancy Flexibility also: Simplicity

Which of the following is a correct statement about entity integrity rule?

The rule requires each record's primary key cannot be blank (null).

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

database

When using Microsoft ACCESS, the main function of "Form" is to:

enter data

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: The entity integrity rule requires using foreign keys to link tables.

false

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

foreign

A database administrator is responsible for all of the following except:

networking of the database

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

order by

A class in a relational database model is defined as:

person, place, thing, transaction, or event about which information is stored.

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

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

relational

ERP means enterprise _____________ planning.

resource

The FROM clause to the SELECT statement used in SQL indicates:

the name of the table(s) from which to retrieve data.

List agents who are often involved in sales transactions: _____________ and_____________.

- salesperson, salespeople, or cashier - customer or customers

In the hierarchical data model, the mapping from parent to child is:

1:N (one-to-many)

Which of the following is a correct statement about foreign keys?

A foreign key must be another table's primary key.

Which of the following is a valid primary key for a cash receipt table?

Cash receipt number

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.

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

True

True or false: The FROM command in SQL is to indicate which tables to be used in a query.

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?

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

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

foreign

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

query or queries

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

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

When using Microsoft ACCESS, the main function of "Query" is to

retrieve data

A database is used to maintain information about

various types of: - objects - events - people - places

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

Blank 1: database or data base Blank 2: management Blank 3: system

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

True or false: In a hierarchical data model, data elements are related to each other using a notation known as one-to-many mapping.

True

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

data dictonary

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 or fields

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

mainframe

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

network

A database management system is a computer program that:

queries the database creates the database modifies the database

Advantages of relational data models generally include:

reduced information redundancy.

When using Microsoft Access, the main function of "Table" is to:

store data.

Select the correct statements about cloud computing.

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

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

network

The WHERE clause to the SELECT statement used in SQL states the criteria that must be met:

to be shown in the query result.

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

true


Kaugnay na mga set ng pag-aaral

Expressed, Concurrent, and Reserved Powers

View Set

BIO TOPIC 10 Cellular Respiration

View Set

Nursing 112 Exam #3 Ch. 16, 26, 32, 34, 36, 37

View Set

Exam 3 Things to Know, Exam 2 Things to Know, Hawkins BIO 111 Exam 1 Things to Know

View Set