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.
Create an ER Diagram for the following scenario. Please state any assumptions you have madein your answer.A university offers a Mathematics program. This program can offer any amount ofcourses in a semester. Each course has a roster limit, location and time slot. A studentcan be registered for any number of courses in a semester but to register for a coursethey must have a valid student ID and address. Each course is assigned a singleprofessor. Only on completion of a course, a student receives a final grade for thatcourse.
Draw 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.
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
- 1 Suppose you are a manager of an event management company. Your team is responsible for running various events. Each event, depending on its nature, runs for varied lengths. Your company policy is such that you charge a flat amount for each event your team is managing (irrespective of the duration a particular event). The size of the team that you are running is such that your team can manage to run one event at a particular time i.e. your company is unable to run multiple events at a particular time. More formally, if there are two events i and j, the events are mutually compatible (i.e. you can select both i and j) if s>f, or s,>f, where s, and f, are the start and finish time of the event i. You are required to select events that your team is going to manage so that you can maximize the profit for your company. The following table shows some candidate events for your company to manage for a particular day. Find out which events would you select such that you can maximize the profit…arrow_forwardCreate 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_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 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_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_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 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_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_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_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
- QUESTION 1 Create a Use Case Diagram for the below scenario: In The University of Technology and Applied Sciences Sur Library Systems, whenever a new books arrives to the university that books information will be entered by the inventory officer into the inventory. Library staff will allow the students to borrow the books and also return the books. Students in the university can search the books and reserve that book automatically to borrow. Also there is a Library manager who will have permission to print the books titles, delete the book copy information, view overdue or books which are not returned on time and also view who has reserved the books in advance. Now draw the use case diagram by identifying actors, use cases etc.arrow_forwardGiven the following business scenario, create a Crow’s Foot ERD usinga specialization hierarchy if appropriate for this case study. Our website manages software projects for downloads to users. Eachsoftware project has a unique project id (8 characters long), can be assigned one ormore categories (the categories are A, B ,C and D), has a status (D or P), and has adescription (text of at most 256 characters). Some projects may depend on otherprojects and we keep track of the dependency. Each project is developed and owned bya single developer (who is our subscriber), and uploaded to our website in one or moretransactions.Our users are identified by name (at most 20 characters), email (at most 20 characters),and a unique user id (8 characters long). They can be either guest users or subscribedusers (subscribers for short). The subscribers have passwords (at most 8 characters) andwe keep the date of the subscription. They need the password to access our website tofile bug reports or…arrow_forwarddraw an ER diagram for a policy-holder may have a number of policies with the insurance company. Each policy is given a policy number and relates to a single policy-holder. The company has insurance products and may put together a range of products to form a policy. Brokers sell policies for commission and any one policy may have commission payable to more than one broker. Claims are made against policies. A claim relates to only one policy.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning