Fundamentals of Information Systems
9th Edition
ISBN: 9781337097536
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 4.1RQ
Program Plan Intro
Tasks performed by employees to create influence in the personal sphere.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Develop an entity-relationship model for the following scenario.
A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. The manufacturer has piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by one or more technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate for one case study.1. Two-Bit Drilling Company holds information about employees and their insurance dependents. Every employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be connected with one and only one employee. Some employees will not have dependents, while others will have many dependents.
Read the following scenario and answer the questions given bellow.• A car rental company has its offices in three major cites of the area. Acostumer once registered with the company, can avail its services from anynearby office. Every office keeps record of the vehicles, their drivers andrenting details. Salaries of administrative staff are controlled at a single sitewhile the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered.
1. Identify the entities involved in the database designed for thecompany.2. Draw GCS for the system.3. Give details of any of the relations replicated on more than one sites
Chapter 2 Solutions
Fundamentals of Information Systems
Ch. 2 - Identify and briefly describe the functions of the...Ch. 2 - Prob. 2LOCh. 2 - Prob. 3LOCh. 2 - Prob. 4LOCh. 2 - Prob. 5LOCh. 2 - Define the term ‘sphere of influence,” and...Ch. 2 - Prob. 7LOCh. 2 - Prob. 8LOCh. 2 - Identify programming languages commonly in use...Ch. 2 - Identify several key software issues and trends...
Ch. 2 - Prob. 1.1RQCh. 2 - Prob. 1.2RQCh. 2 - Prob. 1.1CTQCh. 2 - Prob. 1.2CTQCh. 2 - Prob. 2.1RQCh. 2 - Prob. 2.2RQCh. 2 - Prob. 2.1CTQCh. 2 - Prob. 2.2CTQCh. 2 - Prob. 3.1RQCh. 2 - Prob. 3.2RQCh. 2 - Prob. 3.1CTQCh. 2 - Prob. 3.2CTQCh. 2 - Prob. 4.1RQCh. 2 - Prob. 4.2RQCh. 2 - Prob. 4.1CTQCh. 2 - Prob. 4.2CTQCh. 2 - Prob. 5.1RQCh. 2 - Prob. 5.2RQCh. 2 - Prob. 5.1CTQCh. 2 - Prob. 5.2CTQCh. 2 - Prob. 6.1RQCh. 2 - Prob. 6.2RQCh. 2 - Prob. 6.1CTQCh. 2 - Prob. 6.2CTQCh. 2 - What is the primary difference between purchasing...Ch. 2 - What are the pros and cons of using open-source...Ch. 2 - What risks and start-up issues are associated with...Ch. 2 - Prob. 7.2CTQCh. 2 - The computer hardware industry is rapidly changing...Ch. 2 - Prob. 2SATCh. 2 - Prob. 3SATCh. 2 - Prob. 4SATCh. 2 - Prob. 5SATCh. 2 - Prob. 6SATCh. 2 - Prob. 7SATCh. 2 - Prob. 8SATCh. 2 - Prob. 9SATCh. 2 - Prob. 10SATCh. 2 - Prob. 11SATCh. 2 - Prob. 12SATCh. 2 - Prob. 13SATCh. 2 - Prob. 14SATCh. 2 - Prob. 15SATCh. 2 - Prob. 16SATCh. 2 - Prob. 17SATCh. 2 - Prob. 18SATCh. 2 - Prob. 19SATCh. 2 - Prob. 20SATCh. 2 - Prob. 21SATCh. 2 - Prob. 22SATCh. 2 - Identify four fundamental components of every...Ch. 2 - Prob. 2RQCh. 2 - Prob. 3RQCh. 2 - Prob. 4RQCh. 2 - Prob. 5RQCh. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Identify and briefly describe the various classes...Ch. 2 - Prob. 10RQCh. 2 - Prob. 11RQCh. 2 - Identify and briefly discuss the three spheres of...Ch. 2 - Prob. 13RQCh. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Distinguish between proprietary software and...Ch. 2 - Prob. 20RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 23RQCh. 2 - Prob. 1DQCh. 2 - Prob. 2DQCh. 2 - Prob. 3DQCh. 2 - Prob. 4DQCh. 2 - Prob. 5DQCh. 2 - Prob. 6DQCh. 2 - Prob. 7DQCh. 2 - Prob. 8DQCh. 2 - Assume that you must take a computer-programming...Ch. 2 - Prob. 10DQCh. 2 - Prob. 11DQCh. 2 - Prob. 12DQCh. 2 - Prob. 13DQCh. 2 - Prob. 14DQCh. 2 - Prob. 15DQCh. 2 - Prob. 1PSECh. 2 - Prob. 2PSECh. 2 - Prob. 3PSECh. 2 - Prob. 1WECh. 2 - Prob. 2WECh. 2 - Prob. 3WECh. 2 - Prob. 1CECh. 2 - Prob. 2CECh. 2 - Prob. 3CECh. 2 - Prob. 1.1CSCh. 2 - Prob. 1.2CSCh. 2 - Prob. 1.3CSCh. 2 - Prob. 2.1CSCh. 2 - Prob. 2.2CSCh. 2 - Prob. 2.3CS
Knowledge Booster
Similar questions
- Read carefully the following case:Imagine that you work as an internal auditor for a company that owns several pharmacies throughout the city. Based on your audit plan, the first cycle to audit will be revenue. The first thing you do is document the processes related to receiving and processing the various sources of income. On your initial visit, you were able to observe the following:Once customers have the items to purchase, they head to the register, where a clerk processes the sale. The pharmacy has three cash registers, but does not have an employee who specifically works as a cashier at each one. This provides flexibility in the operation because, of the three employees that the business has, one can collect at any of the cashiers when available. By not having to leave a single person as a cashier, the cashier can focus on providing more direct customer service, refilling merchandise on the shelves, and even assisting in receiving or dispatching merchandise from the store.At the…arrow_forwardDraw the ER diagram of the following requirements: A City Hall wants to manage the members of its entertainment centers. Each center has an address, a district, a unique name. Each center offers several animations. An animation is provided by only one center. Each animation has a unique name and semi-annual cost. A member has a unique id, name (first, middle, last), several contact phone numbers and an address. A member may enroll only in one center and the date of registration is maintained. The member can practice many animation activities.arrow_forwardConsider the scenario described by the statement “A customer can make many payments,but each payment is made by only one customer.” Use this scenario as the basis for anentity relationship diagram (ERD) representation using either Chen, Crow’s Foot or UMLClass Diagram.arrow_forward
- Create an ER diagram for a reservation system of hotel rooms considering the following facts. You should indicate some attributes and the primary key for each entity. ■ Hotel contains several rooms Customer can reserve one or more rooms One room contains one, two, or three beds ⚫ Bed can be normal (for one person), double, or spare (less expensive)arrow_forwardA derived attribute can be stored in a table or calculated on each occasion that it is required. An example of a derived attribute is your Grade Point Average which is calculated by adding together a score for each unit (e.g., HD=4, D=3, C=2, P=1, N=0) and dividing that by the number of units you have completed. Explain how the decision as to whether the Grade Point Average would be stored in a table or calculated would be made. You are administering a database in a large retail company that records sales at each of the company’s stores. Tuning the database to improve performance by adding indexes and optimising query execution is an important ongoing aspect of the physical database design. Which attributes in a database such as this (apart from the primary key) are likely to BENEFIT from being indexed? Which attributes would you generally avoid indexing, and why?arrow_forwardGiven the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments in which they work. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission…arrow_forward
- Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments in which they work. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and…arrow_forwardGiven the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy, if appropriate. Granite Sales Company keeps information on employees and the departments in which they work. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee’s name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and…arrow_forward(1) Draw an ER Diagram for the scenario below Temporary Employment Corporation (TEC) places temporary workers in companies during peak periods. TEC's manager gives you the following description of the business: TEC has a file of candidates who are willing to work. • If the candidate has worked before that candidate has a specific job history. • Each candidate has several qualifications. TEC also has a list of companies that request temporaries. Each time a company requests a temporary employee, TEC makes an entry in the openings folder. The folder contains an opening number, company name, required qualifications, starting date, anticipated ending date, and hourly pay. • • Each opening requires only one specific or main qualification. When a candidate matches the qualification, he/she is given the job, and an entry is made in the Placement Record folder. This folder contains an opening number, candidate number, total hours worked, and so on. In addition, an entry is made in the job…arrow_forward
- Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and certification renewal date should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.arrow_forwardGiven the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and certification renewal date should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents. Please give reasoning for any selection that you make. Providing only ERD is not enough.arrow_forwardDo not use any Al to do this question. Please show the diagram at the end. Question Lekker Living is a new backpackers that recently opened close to Stellenbosch. They have a limited number of staff (including a receptionist, a cook, and a housekeeper) since they have limited rooms available. If foreign travelers are looking for a place to stay a few nights while exploring the wonderful wine farms and hiking trails in Stellenbosch, they need to check availability on the website. If there is space, they must call reception to book a room. Orice they arrive, they check in at the front desk. In the evenings, they have the option to enjoy an assortment of dishes, prepared by a cook. Guests can also request for the room to be cleaned by a housekeeper in the mornings, while they are out and about exploring. Once their stay is over, they can check out with the receptionist. If a guest can no longer make their stay, they have the option to cancel their booking 24 hours before. Draw the use…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning