Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Question
Database creation
Note to instructor: this problem builds on Problem 9. If you wish to focus solely on database creation without asking students to create the REAL model, copy the REAL model from the solution into the exam. Based on the REAL model you created above, specify the structure of two database tables. If a junction table is indicated by the REAL model, one of the tables must be based on it. Indicate primary keys by underlining and foreign keys with brackets.
Answer
Will vary significantly
Related questions
Q:
Process variation would be a concern in which level(s) of the capability maturity model: (i) managed, (ii) optimized.a) I onlyb) II onlyc) Both I and IId) Neither I nor II
Q:
Glenda is the membership director of her university's accounting honor society. She is interested in developing an event-driven accounting information system for the club, and has developed the REAL model below as a start. Memberships in the honor society expire at the end of each academic year; members must have their grades verified each year until they graduate. The club has at least two advisors each academic year.List three queries Glenda could construct from the club's event-driven accounting information system. Explain why the queries could not be Ansed with a view-driven system.
Q:
Glenda is the membership director of her university's accounting honor society. She is interested in developing an event-driven accounting information system for the club, and has developed the REAL model below as a start. Memberships in the honor society expire at the end of each academic year; members must have their grades verified each year until they graduate. The club has at least two advisors each academic year. List the steps (in order) Glenda should follow to develop the club's event-driven accounting information system.
Q:
Basic database table creation.
Specify the structure of all database tables indicated by the REAL model below. Indicate primary keys by underlining and foreign keys with brackets.
Q:
Within the context of REAL modeling, which of the following would best be described as decision/management events: (i) preparing a cost-benefit analysis of an event-driven accounting information system, (ii) delivering merchandise to customers.a. i only.b. ii only.c. Both i and ii.d. Neither i nor ii.
Q:
Within the context of REAL modeling, which of the following would best be described as information events: (i) preparing a cost-benefit analysis of an event-driven accounting information system, (ii) delivering merchandise to customers.a. i only.b. ii only.c. Both i and ii.d. Neither i nor ii.
Q:
Marsha is considering two accounting information systems for implementation in her organization.Which system(s) can incorporate some form of information technology?a. System A.b. System B.c. Both System A and System B.d. Neither System A nor System B.
Q:
For the "receive payment" table to be in third normal form, which of the following must be true?a. It must contain at least three fields.b. It must contain fields for drink ingredients.c. It must contain at least one calculated field.d. It must contain two foreign keys.
Q:
Which of the following fields is least likely to be necessary in the "take customer order" table?a. Drinks ordered.b. Customer name.c. Employee name.d. Transaction number.
Q:
How many tables will be required in the database for the REAL model above?a. Three.b. Six.c. Eight.d.Some other number.
Q:
In a REAL model, the main difference between "internal" and "external" agents is:a. Internal agents do not require a database table.b. External agents do not require a database table.c. Their relationship to the organization.d. Their location in the REAL model.
Q:
Which of the following types of data is least likely to be collected in an event-driven accounting information system?a. Customer name.b. Accounts to debit and credit.c. Employee name.d. Purchase order number.
Q:
A balance sheet can be produced from: (i) a view-driven accounting information system, (ii) an event-driven accounting information system.a. i only.b. ii only.c. Both i and ii.d. Neither i nor ii.
Q:
___ events can focus on both simple and complex phenomena.a. Operating.b. Information.c. Recording.d. Decision/management.
Q:
View-driven accounting information systems:a. Rely on debits and credits for transaction recording.b. Are useless for making decisions.c. Must incorporate some form of information technology.d. Capture comprehensive data, useful for many functional departments.
Q:
Paige and Piper work in the accounting departments of two different corporations in the same geographic area; the companies' sales processes are very similar. When Paige's boss asked her to document the sales process, she created the data flow diagram shown below. Interpret Paige's data flow diagram by writing a narrative description of the sales process based on it.
Q:
Database creation
AMB Corporation wants to create database tables to track its purchases of inventory. Several fields are listed below; organize them into three normalized database tables. Indicate primary keys by underlining and foreign keys with brackets. Some of the fields may be used more than once; some may not be used at all.
a. Vendor ID.
b. Units on hand.
c. Transaction ID.
d. Total amount due to vendor.
e. Selling price per unit.
f. Purchasing agent ID.
g. Number of units purchased.
h. Inventory item number.
i. Inventory description.
j. Date of purchase.
k. Beginning inventory date.
l. Average cost per unit.
Q:
A relational database contains four tables: vendor, inventory, purchasing agent and purchases. Which of the following statements is least true?a. The purchases table will have two foreign keys.b. The purchases table will have three foreign keys.c. The purchasing agent table will have a compound primary key.d. The database will also need at least one junction table.
Q:
Which symbol above would be represented in a data flow diagram with an arrow?a. Symbol a.b. Symbol b.c. Symbol c.d. Symbol d.
Q:
Which symbol above would be represented in a data flow diagram with two parallel lines?a. Symbol a.b. Symbol b.c. Symbol c.d. Symbol d.
Q:
"Customer information" enters a business process in a Level Zero data flow diagram. For the associated Level One diagram to be balanced, "customer information" must:a. Leave the last business process.b. Have a different name.c. Enter a business process with the same name.d. Be an input to the first process on Level One.
Q:
Which of the following symbols would you find in a flowchart, but not in a data flow diagram?a. Circle.b. Line.c. Triangle.d. Number.
Q:
Which of the following is not an appropriate label for an arrow in a data flow diagram?a. Customer information.b. Credit decision.c. Process application.d. Inventory database.
Q:
Flowcharts are organized in _____, while DFDs are organized in _____.a. Columns, leveled sets.b. Columns, rows.c. Rows, leveled sets.d. Rows, columns.
Q:
In a data flow diagram, lines:a. Should not be labeled.b. Should be labeled with verb phrases.c. Should be labeled with noun phrases.d. Should have arrows on both ends.
Q:
Databases in a data flow diagram are represented by:a. Parallel lines.b. Rectangles.c. Triangles.d. Circles.
Q:
Sebastian's Coffee Shop makes and sells specialty coffee drinks, sandwiches and pastries. Several risks associated with the shop's operations are listed below on the left; several internal controls are listed on the right. Match each risk with the internal control most likely to reduce it. Use each internal control only once.____ 1 Computer viruses____ 2 Damage from flood, fire or earthquake____ 3 Incorrect change given to a customer____ 4 Incorrectly prepared drinks____ 5 Insufficient inventory quantities____ 6 Power failure____ 7 Robbery____ 8 Spoiled food____ 9 Theft of cash by employees____ 10Theft of inventory by employeesa. Backup electrical generatorsb. Cash registersc. Insuranced. Monthly bank reconciliatione. Placing orders when goods reach aspecific levelf. Proper storage conditionsg. Softwareh. Video monitoring systemsi. Video surveillance and alarm systemsj. Worker training
Q:
Accounting and bookkeeping comparison
Indicate whether each of the following statements applies to: (a) accounting alone, (b) bookkeeping alone, (c) both accounting and bookkeeping or (d) neither accounting nor bookkeeping.
_____ Subject to internal controls
_____ Requires analysis
_____ Primarily involves cyclical activities
_____ Involves human judgment
_____ Focuses on economic information
_____ Defined by American Accounting Association
_____ Concerned with measuring
_____ Can incorporate computers
_____ Can be principles-based
_____ Always involves information technology
Q:
A company's adjusting entry for prepaid insurance debited insurance expense for $600. If the policy had a six-month duration, how much did it cost originally?a. $100.b. $600.c. $3,600.d. Cannot be determined from the information given.
Q:
Which of the following forms of internal control relies most heavily on human judgment?a. Preparing a trial balance.b. Enforcing transaction limits.c. Numbering documents sequentially.d. Locking a filing cabinet.