Accounting Information Systems Study Set 26

Business

Quiz 4 :

Relational Databases and Enterprise Systems

Quiz 4 :

Relational Databases and Enterprise Systems

Question Type
search
arrow
Using the following Cash Table, show the SQL command that will return the sum of balance. img
Free
Essay
Answer:

Answer:

SQL used for getting data from the master table, for making queries and getting answers after calculations provided in that query and it also runs report in application.
In the given question through the use of SQL, output requires the total of balances, for such results SQL command will be,
Select- sum(Balance) From -Cash;
Here, sum of balances is the result after the calculation which is retrieved from cash table.

Tags
Choose question tag
close menu
arrow
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: a. Sales (0..1) 2 (1..*) Cash Receipts B) Sales (1..1) 2 (0..*) Cash Receipts C) Sales (1..1) 2 (1..1) Cash Receipts D) Sales (0..*) 2 (1..1) Cash Receipts E) None of the above is correct. img
Free
Multiple Choice
Answer:

Answer:

Unified Modelling Language (UML) data models
These are the representation of databases' conceptual contents in a graphical manner and not in a written manner. And this helps the database users to easily understand what the database designers are trying to convey.
Referring to the figure (Figure 4.2), it can be seen that the UML model is given for the sales process of company S. Looking at the multiplicities in the diagram, a few associations can be seen between the classes.
Inventory and sales, sales and salesperson, cash and cash receipt, sales and cash receipt, sales and customer, cash receipt and cashier are all associated with a one-to-many relationship.
Considering all the options to know which option is the correct option is done below:
a.
The multiplicity allotted to the sales is 0..1 which means that there are zero or more sale transaction, and cash receipt is allotted the multiplicity of 1..*, which means that one or more cash receipt is associated to the sale. The '1' in the multiplicity means the necessity of down payment.
So, option a is incorrect.
b.
Multiplicity allotted to the sales is 1..1, which means that all the cash receipts associate to one sale only. Multiplicity allotted to cash receipt is 0..*, which means that there should be zero or more cash receipts in the transaction. But, the multiplicity of 1..1 to the sales suggest that there should be at least one cash receipt, which means that there will be a necessity of down payment.
So, option b is also incorrect.
c.
According to the multiplicities, the association between the two classes, that is, sales and cash receipt is one-to-one, which means that only one cash receipt is associated to one sales. Only one payment is made and no installments is created.
So, option c is also incorrect.
e.
Since, option d is the correct option out of all the options. The option that says that none of the above options is correct cannot be the correct option.
So, option e is also incorrect.
d.
Multiplicity allotted to the cash receipt is 1..1 which means that only one cash receipt can be made. The multiplicity allotted to the sales is 0..*, which means that there could be zero or more sales and the '0' suggests that no down payment is required.
So, option d is the correct option.

Tags
Choose question tag
close menu
arrow
A class in a relational database model is defined as: a. The sum of a whole B) Characteristics or properties of a table C) Person, place, thing, transaction, or event about which information is stored D) Being or existence, especially when considered as distinct, independent, or self-contained
Free
Multiple Choice
Answer:

Answer:

Relational data models
It is the data model in which information is stored in the tabular form. It allows the relationships to be identified by the users at the time of creation of database or anytime when the data model is modified. This is most popular data model due to its simplicity, flexibility, and reduction of duplication of data.
In relational data model, class is defined as attributes about which the information is stored, the sum of whole does not show that any information about anything is being stored. In relational data model class is defined as attributes about which the information is stored, the characteristics, and properties of table are the records in the model and hence, it is not class. In relational data model class is defined as attributes about which information is stored, and being or existence, especially when considered as distinct, self-contained, or dependent is apparently and clearly not the class of a relational database model. Hence option a, b and d are incorrect.
In relational data model class is defined as attributes about which information is stored , the place, person, thing, transaction or event about which information is stored is appropriate class of relational database model.
Hence, option c is the correct option.

Tags
Choose question tag
close menu
arrow
Which statement about enterprise systems is correct? a. Most the enterprise systems are designed mainly for accounting and finance functions. B) SAP, Oracle, and Microsoft all offer products for enterprise systems. C) Most enterprise systems are designed for the service industry. D) Small companies do not use enterprise systems at all.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What are the basic requirements of a relational database?
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Using the following Cash Table, show the output if the following SQL command is given: Select Account#, Balance From Cash Where Balance 50000; img
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Explain the differences among hierarchical, network, and relational data models. What makes the relational data model the most popular data model in use today?
Essay
Answer:
Tags
Choose question tag
close menu
arrow
The FROM clause to the SELECT statement used in SQL indicates: a. The name of the table(s) from which to retrieve data B) The name of the column(s) from which to retrieve data C) The name of the database(s) from which to retrieve data D) The name of the query from which to retrieve data
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Structured Query Language (SQL) is used to retrieve data from a database. Why would an accountant need to learn SQL?
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Figure 4.32 lists the modules available from SAP. List and explain which modules would be most appropriate for either Maytag or a manufacturing company you are familiar with. img
Essay
Answer:
Tags
Choose question tag
close menu
arrow
List three classes whose information is stored in database that might be used by NetFlix. a. What are five possible attributes that might be associated with each class (table)? b. Can you describe the data dictionary associated with these attributes, including field description, field length, field type, etc.? c. Why would NetFlix be interested in storing and tracking these five attributes in a table (i.e., to enhance customer service or future customer sales, to sell more affiliated products to customers, etc.)?
Essay
Answer:
Tags
Choose question tag
close menu
arrow
The WHERE clause to the SELECT statement used in SQL states the criteria that must be met: a. To run a query B) To be included as an attribute in the table C) To be included in the database D) To be shown in the query result
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The hierarchical data model, the mapping from parent to child is: a. 1:1 (one-to-one) B) 1:N (one-to-many) C) N:N (many-to-many) D) N:1 (many-to-one)
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Using the following Cash Table, show the SQL command that will return Type with only checking accounts. img
Essay
Answer:
Tags
Choose question tag
close menu
arrow
The "ORDER BY Amount ASC" clause to the SELECT statement used in SQL suggests that the: a. Amount of the query result will be listed in ascending order B) Amount of the query result will be listed in descending order C) The data attribute ASC be shown in order D) None of the above
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Using the following Cash Table, show the output if the following SQL command is given: SELECT Account#, Balance FROM Cash WHERE Bank 5 'Boston5 'ORDER BY Amount DESC; img
Essay
Answer:
Tags
Choose question tag
close menu
arrow
If Steve's Stylin' Sunglasses (SSS) sells famous, brand-name sunglasses, not custom sunglasses, modify the UML diagram in describing Steve's sales process.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Advantages of relational data models generally include: a. Flexibility and scalability B) Low cost C) Ease of implementation D) Most reliable
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Given the description of Hershey's failed enterprise system implementation from the chapter, which of the four challenges of the enterprise described in the chapter seem to best explain what happened? Use Google or Yahoo! to get more details on this case to help answer this question.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Cloud computing has plenty of appeal for many firms, especially those that have immense computing needs. Why do you think some might be reluctant to have their data and computing power originating from the cloud?
Essay
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 22