The BusyB Company wants to store data about its employee skills. Each employee may possess one or more specific skills, and several employees may have the same skill. Include the following facts in the database: date hireddate of birthdate skill acquiredemployee nameemployee numberpay rateskill nameskill numbersupervisor123Required a. Design a set of relational tables to store these data. Name each table and field in accordance with good database design.b. Identify the primary key for each table, and identify any needed foreign keys.

The BusyB Company wants to store data about its employee skills. Each employee may possess one or more specific skills, and several employees may have the same skill. Include the following facts in the database: date hireddate of birthdate skill acquiredemployee nameemployee numberpay rateskill nameskill numbersupervisor123Required a. Design a set of relational tables to store these data. Name each table and field in accordance with good database design.b. Identify the primary key for each table, and identify any needed foreign keys.

Accounting Information Systems

10th Edition

ISBN:9781337619202

Author:Hall, James A.

Publisher:Hall, James A.

Chapter15: Auditing It Controls Part Ii: Security And Access

Section: Chapter Questions

Problem 13P

See similar textbooks

Similar questions

Match the term to its definition by choosing the appropriate number in the answer field. You will not use all of the terms provided. Question 8 options: A partial set of all available data items in a database that are used by a specific application, query, or report. Fields that link tables with other tables. The ability of employees at higher levels of responsibility and authority to bypass internal controls. A field which is unique to each record in a database table. The total number of transactions in a batch, used as a control total. Procedures that are put in place to remedy errors or irregularities after they have been discovered. Controls designed to enhance the control environment and strengthen the effectiveness of application controls. 1. Corrective controls 2. Preventive controls 3. General controls 4. Application controls 5. Record counts 6.…
Weat
Which one of the following is not correct in relation to database?Select one:a. Helps in creating a business power point presentationsb. A database is usually controlled by a database management system (DBMS)c. A structured set of data held in a computer, especially one that is accessible in various ways.d. Most databases use structured query language (SQL) for writing and querying data.
The database attributes that individual users have permission to access are defined in the a. operating system. b. user manual. c. database schema. d. user view. e. application listing.
Match each word or phrase with the best description of it. Descriptions Words / Phrases related tocomputerized accounting systems a. Allows multiple users to access the system at the same time. Audit trailInternal controlNetwork-compatibleEnterprise resource planning systemsEntry-level software b. Enables the tracking of all transactions. Audit trailEnterprise resource planning systemsEntry-level softwareNetwork-compatibleInternal control c. Identifies suspicious transactions or likely mistakes such as wrong account numbers or duplicate transactions. Audit trailInternal controlEntry-level softwareEnterprise resource planning systemsNetwork-compatible d. Large-scale computer systems that integrate all aspects of the organization including accounting, sales, human resource…
The XYZ Company is a geographically distributed organization with several sites around the country. Users at these sites need rapid access to common data for read-only purposes. Which distributed database method is best under these circumstances? Explain your reasoning.
As users determine new computer application needs, request must be sent to both the system programmers and the database administrator. Why is so important that these two group perform separate functions and what are these functions?
Draw Physical Data Flow Diagram (DFD) of AR System In a physical DFD, we focus on how the system operates in terms of the people and technology involved. This diagram reflects who or what is responsible for each action, such as clerks, machines, or software. Components AR Clerk: Receives payments, updates the system, and batches cheques. Cashier: Receives batches of cheques from AR. Mail System: Sends and receives physical documents like statements and cheques. Processes in Physical DFD - 1.0 AR Clerk prints and mails monthly statements. - 2.0 Customers mail payments to AR Clerk. - 3.0 AR Clerk batches cheques and sends to the Cashier. - 4.0 AR Clerk updates AR master data system. Data Stores Customer Records: A file or system holding customer information. AR Master Data: The electronic records updated with payments.
Identify each item 1 through 10 with the system component A through E that it is best associated with. A. Source documents B. Input devices C. Information processors D. Information storage E. Output devices 1. Computer keyboard 2. Printer 3. Monitor 4. Bank statement 5. Ledger software 6. Cloud storage 7. Journal software 8. Invoice from supplier 9. Computer scanner 10. Filing cabinet
Explain how the E-R diagrams is used to prepare database tables. Also, include explanation of cardinalities.
What are the four basic backup and recovery features necessary in a database management system? Briefly explain each.
Why the design of a table or a form is important? Why accountant has to have sufficient knowledge about database and data modeling?