AIS Chapter 4
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..*) ----- (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 * in the first line of a SQL statement, what does the * 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..*) ----- (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