Fundamentals of Information Systems
8th Edition
ISBN: 9781305082168
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 2PSE
Program Plan Intro
To develop a table listing five popular Internet sites for a job search using a
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
QUESTION 1
The OMCA club operations
When members join OMCA health club, they pay a fee for a certain length of time. Most memberships are for 1 year, but memberships for short periods are available. Due to various promotions throughout the year, it is common for members to pay different amounts for the same length of membership. The club wants to e-mail reminders to members to ask them to renew their memberships one month before their memberships expire. Some members have been angry with staff when asked to renew at a much higher rate than their original membership contract. So, the club needs staff to keep track of the price paid so that the managers can override the regular prices with special prices when members are asked to renew. The system must keep track of these new prices so that renewals can be processed accurately. One of the problems in the health club industry is the high turnover rate of members. Although some members remain active for many years, about half of the…
SQL-programming language
Oracle SQL Devloper-Tool
The database schema
Employee (Lastname, FirstName, MidInitial, gender, street, city)
Works (Lastname, FirstName, MidInitial, company-name, salary) company (company-name, city)
company (company-name, city)
Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date)
Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date)
employee_table (you should define three attributes for employee and manager names)
Name street city gender
--------------------------------------------------------
Anderson, Susan L 108th Omaha F
Brady, Dan L P street Lincoln M
Chen, Peter K 124th Omaha M
Clemson, Ann M O Lincoln F
Dale, Mary K 132th Omaha F
Gill, Mary L P street Lincoln F
Harrison, Susan M…
Database Management
Jill Bill Marketplace is a business located in Florida. Within the JBM compound, you can purchase many types of products that are related to a specific category, for example, books or antiques. JBN does not own any of the stalls that sell products, rather they rent them out to small vendors. Each vendor has to pay a monthly fee to use the Marketplace. JBM products are available to different customers who sell their products daily. Each category type (e.g. books ) is managed by a particular supervisor. A customer will order their selected product in terms of the amount from that vendor, who is also free to apply discounts on any product in his store. Other than category supervisors there are other staff that manages different departments in the mall, but they all report to two marketplace managers. The small vendors will report to the category managers on the nature of their stock and if and when restocking is required. All category managers report to the third…
Chapter 1 Solutions
Fundamentals of Information Systems
Ch. 1 - Prob. 1LOCh. 1 - Prob. 2LOCh. 1 - Prob. 3LOCh. 1 - Prob. 4LOCh. 1 - Identify and briefly describe two change models...Ch. 1 - Prob. 6LOCh. 1 - Prob. 7LOCh. 1 - Prob. 8LOCh. 1 - Prob. 1.1DQCh. 1 - Prob. 1.2DQ
Ch. 1 - Prob. 1.1CTQCh. 1 - Prob. 1.2CTQCh. 1 - Prob. 2.1DQCh. 1 - Prob. 2.2DQCh. 1 - Prob. 2.1CTQCh. 1 - Prob. 2.2CTQCh. 1 - Prob. 1SATCh. 1 - The ________________ of information is directly...Ch. 1 - Prob. 3SATCh. 1 - Prob. 4SATCh. 1 - Prob. 5SATCh. 1 - Prob. 6SATCh. 1 - Prob. 7SATCh. 1 - Prob. 8SATCh. 1 - Prob. 9SATCh. 1 - Prob. 10SATCh. 1 - Prob. 11SATCh. 1 - Prob. 12SATCh. 1 - The information system worker functions at the...Ch. 1 - Prob. 14SATCh. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Prob. 5RQCh. 1 - Prob. 6RQCh. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - Prob. 9RQCh. 1 - Prob. 10RQCh. 1 - Prob. 11RQCh. 1 - Prob. 12RQCh. 1 - Prob. 13RQCh. 1 - Prob. 14RQCh. 1 - Prob. 1DQCh. 1 - Prob. 2DQCh. 1 - What are the two basic types of software? Give...Ch. 1 - Prob. 4DQCh. 1 - Prob. 5DQCh. 1 - Prob. 6DQCh. 1 - Prob. 7DQCh. 1 - Prob. 8DQCh. 1 - Prob. 9DQCh. 1 - Your manager has asked for your input on ideas for...Ch. 1 - Prob. 11DQCh. 1 - Prob. 12DQCh. 1 - Prob. 13DQCh. 1 - Prob. 14DQCh. 1 - Prob. 1PSECh. 1 - Prob. 2PSECh. 1 - Prob. 3PSECh. 1 - Prob. 1WECh. 1 - Prob. 2WECh. 1 - Prob. 3WECh. 1 - Prob. 1CECh. 1 - Prob. 2CECh. 1 - Prob. 3CECh. 1 - Prob. 1.1CSCh. 1 - Prob. 1.2CSCh. 1 - Prob. 1.1aCSCh. 1 - Prob. 1.2aCSCh. 1 - Prob. 2.1CSCh. 1 - Prob. 2.2CSCh. 1 - Prob. 2.1aCSCh. 1 - Prob. 2.2aCS
Knowledge Booster
Similar questions
- Church Information System XYZ Church is a fast-growing church in Grand Rapids area. Over the past three years, since the popular Reverend Timothy Becker has taken over leadership of the congregation, the church has more than doubled in size. It now has approximately 400 registered households. Reverend John Howard has also recently been added as a second minister. Since the Church was rather small in the past, most of its records have been kept on paper forms. However, the Church’s Business Manager, Margie Roberts, has suggested to Reverend Becker that a computerized system might help the Church better meet its information needs and manage its activities. In addition to Ms. Roberts, the Church employs a part-time administrative assistant, Mabel McGregory. Mabel performs clerical duties such as filing, record keeping, answering phone calls, and typing the weekly church bulletin using WordPerfect for Windows on the Church’s only personal computer. A retiree, Leroy Stricty, is employed…arrow_forwardCharity management system using SQL Language needed for Projectarrow_forwardAsking as I want to join is it worthy?arrow_forward
- Product is the specific item or service a company is selling such as quality, design, features, characteristics, and packaging. O True O Falsearrow_forwardDATABASE MANAGEMENT ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a…arrow_forwarddatabase management ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a…arrow_forward
- Please help redrawarrow_forwardNo matter what changes are made to the data or the parameters, the formulae in a well constructed spreadsheet will never need to be updated again. True Falsearrow_forwardY8 Most Excel projects start by choosing the most appropriate and useful data to enter into the workbook in a way that will help make meaning of the gathered data. Practise entering data into a new Excel workbook by creating a thorough itinerary for your dream vacation.Your workbook should include the following information: - Travel dates - Modes of transport (car rental reservations, bus or flight tickets, taxi hire, etc.) - Travel routes (main stops in towns, cities, airports, bus stations, etc.) - Travelling time - Accommodation arrangements - Sightseeing stops and other activities - Reservations (for restaurants, amusement parks, etc.) - Any other useful information Use the following tips to create a well-organised itinerary: - Carefully plan what headings to include in the columns and rows. - Format the cells so that the headings are made clear, and that similar data is easy to identify. - Summarise data by using the SUM, COUNT, and AVERAGE formulas. For example, you can work…arrow_forward
- System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…arrow_forwardSystem Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…arrow_forwardcompany(co_name, govt_id, ceo_ssn, hq_loc) division(co_id, div_name, subdiv_of, dir_ssn, div_hq) site(co_id, div_name, loc) product(prod_id, manuf_co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co_id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod_id, manuf_co) Write the query in SQL using a GROUP BY but no HAVING clause. (You may not use any of the following operators: IN, NOT IN, EXISTS, NOT EXISTS, ALL, ANY, ) For each division (of any company) that employs at least 200 people, find the average salary of all the people the division employsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning