Questions and Answers of Accounting Information Systems

Consider the following narrative describing the process of preparing an income tax return:Each year before April 15, you file your income taxes. You collect multiple W-2 and 1099 documents. You
Consider the following narrative describing the process of registering a car with the DMV:Heide lives in California and it is time to renew her automobile registration. The California DMV sends her a
1. Which of the following is not an objective of a structure model?a. Designate things of interest in the business domain.b. Describe characteristics of things of interest in the business domain.c.
Consider the following one-to-one association between classes. You are mapping the diagram to a set of relational tables. Where would you post the foreign key? Why would you post it there?
Consider the sale and cash receipt classes shown in Discussion Question 1. What kind of business is this (in terms of its payment requirements from customers)? How would the multiplicities change if
Consider the following model and corresponding relational tables. Describe the meaning of the diagram in words. Assume that Students are identified by Student ID Number and Courses are identified by
How would the following model look if you used a composition relationship? Which is more descriptive? 1.1 1.* Chapters Book
Consider the diagram in Discussion Question 4. Identify some examples of classes that would be modeled with a compostion model. Identify some examples of classes that would be modeled with an
Think about the last time that you purchased something over the Internet. What did the checkout page look like? What categories of operational decisions do you think were made by the website
Think about the process you went through to enroll in this class. What business rules do you think applied to the enrollment process? Are all of these rules written? Why or why not?
Compare the UML class diagram shown in Figure 3.3 with the entity-relationship diagram shown in Figure 3.A2. Describe the differences and the similarities. FIGURE 3.3 Multiplicities Each Person owns
In your college career, you may have attended several universities. Draw a simple UML class diagram or an entity-relationship diagram showing your relationship with those universities. Now add the
Describe some real-world examples of(a) One-to-one relationships,(b) One-to-many relationships, and(c) Many-to-many relationships. Which do you think is most common? Which does a relational database
Identify the classes and associations in the following narrative, and draw a class diagram with multiplicities:Dr. Franklin runs a small medical clinic specializing in family practice. She has many
Identify the classes and associations in the following narrative, and draw a class diagram with multiplicities:Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix
Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 1. Identify primary and foreign keys.In Problem 1,Dr. Franklin runs a small medical clinic
Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 2. Identify primary and foreign keys.In Problem 2,Paige runs a small frozen yogurt shop. She
Develop a UML class diagram with classes, associations, and multiplicities based on the following narrative:The Multnomah County Library provides a variety of services to citizens of the county.
This problem continues Problem 8. Use the Access_Practice.accdb database that you have been working on to complete the following tasks.a. Go to the Relationships screen and connect the five tables,
Use the Access_Practice.accdb database to complete the following tasks in Access.a. The database contains three tables containing information about this company’s sales process: Inventory, Sales,
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
Consider the UML diagram used to model Steve’s Stylin’ Sunglasses’ (SSS) sales data. Draw a new UML diagram assuming that SSS sells mass-produced brand-name sunglasses instead of custom
Think about data collected and used by Netflix.a. Identify three tables that would contain customer or subscription data.b. For each table identified in a, list five attributes (you may include
Use the Cash table above to write a SQL query to show the total of all of the balances.Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7 Checking Shawmut 48,000 Shawmut 75,000 BA-8 Draft
Use the Cash table above to write a SQL query to show a list of checking accounts?Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7 Checking Shawmut 48,000 Shawmut 75,000 BA-8 Draft 950
Use the Cash table above to show the output for the following SQL query:SELECT Account#, BalanceFROM CashWHERE Bank = â€˜Boston5â€™ORDER BY Amount DESC;Cash Account# Type Bank Balance
Use the Cash table above to show the output for the following SQL query:SELECT Account#, BalanceFROM CashWHERE Balance < 50000;Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7
1. In 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).2. Advantages of relational data models
Use the UML class diagram you created for Problem 5 to create an Access database for the library. Make up at least three fields for each table, including one field that will be the primary key?

Showing 2900 - 3000 of 2929