Principles of Information Systems, Loose-Leaf Version
13th Edition
ISBN: 9781305971820
Author: Ralph Stair, George Reynolds
Publisher: Course Technology
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4.3, Problem 1RQ
Program Plan Intro
Proprietary software:
- Proprietary software is one-of-a-kind software.
- It is considered for a particular application and owned by the company, organization, or person that uses it.
- This software is able to offer a company competitive advantage by offering services or solving issues in a unique way better than technique used by a competitor.
Off-the-shelf software:
- Off-the-shelf software is formed by software vendors to address requests that are general across businesses, organizations, or individuals.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Clerical Temp is a company that offers temporary clerical assistance to its clients. It now employs about 1000 people and serves approximately 250 customers, but it is quickly expanding. Many activities are now carried out by hand. The company is eager to create a database system. The database system will be utilized to maintain track of payroll, accounts receivable, active worker personal information, customer records, job requests, and task assignments. However, the job must be completed in a short amount of time.
A tiny manufacturing firm is growing its operations throughout the nation by building various locations. At the moment, all databases are handled by individual staff using Microsoft Excel or, on occasion, Microsoft Access. The firm is contemplating upgrading to a central database management system composed of many modules for the purpose of managing production, inventories, workers, and accounting. You have been engaged to create a feasibility study as the first part of the SDLC cycle, which will include suggestions on the economic, operational, and technical elements of the current project.
Windsor, a small city with a population of 50,000, recently purchased several buses and hired drivers to serve multiple routes in Windsor and neighboring areas. As the city's IT Manager, we have been tasked to set up an information system and database to manage the scheduling of buses and drivers that can be easily expanded as the city grows. We directed your team to follow best practices to develop a normalized database to manage the scheduling of drivers and buses that is simple, flexible, and non-redundant.
For this scenario above, assume that drivers can be assigned to different buses, and multiple buses will run on multiple routes. We may also assume the bus service is free, so no ticket purchases are required.
Hint: Build an ERD and decompose a many-to-many relationship into one-to-many relationships using an associative entity to link the entities. Assume a many-to-many (M:N) relationship between drivers and buses. Thus, a driver can drive many buses and a bus can be driven by…
Chapter 4 Solutions
Principles of Information Systems, Loose-Leaf Version
Ch. 4.1 - Prob. 1RQCh. 4.1 - Prob. 2RQCh. 4.1 - Prob. 1CTQCh. 4.1 - Prob. 2CTQCh. 4.2 - Prob. 1RQCh. 4.2 - Prob. 2RQCh. 4.2 - Prob. 1CTQCh. 4.2 - Prob. 2CTQCh. 4.3 - Prob. 1RQCh. 4.3 - Prob. 2RQ
Ch. 4.3 - Prob. 1CTQCh. 4.3 - Prob. 2CTQCh. 4.4 - What is the primary difference between purchasing...Ch. 4.4 - What are the pros and cons of using open-source...Ch. 4.4 - What risks and start-up issues are associated with...Ch. 4.4 - Prob. 2CTQCh. 4 - Prob. 1SATCh. 4 - Prob. 2SATCh. 4 - Prob. 3SATCh. 4 - Prob. 4SATCh. 4 - Prob. 5SATCh. 4 - Prob. 6SATCh. 4 - Prob. 7SATCh. 4 - Prob. 8SATCh. 4 - Prob. 9SATCh. 4 - Prob. 10SATCh. 4 - ______ is software that makes its source code...Ch. 4 - Software ______ are an important source of...Ch. 4 - Identify and briefly discuss the three spheres of...Ch. 4 - Prob. 2RQCh. 4 - Prob. 3RQCh. 4 - What is the kernel of the operating system?Ch. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Distinguish between proprietary software and...Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - Prob. 1DQCh. 4 - Assume that you must take a computer-programming...Ch. 4 - Prob. 3DQCh. 4 - Prob. 4DQCh. 4 - Prob. 5DQCh. 4 - Prob. 6DQCh. 4 - Prob. 7DQCh. 4 - Prob. 8DQCh. 4 - Prob. 9DQCh. 4 - Prob. 10DQCh. 4 - Prob. 1PSECh. 4 - Prob. 2PSECh. 4 - Prob. 3PSECh. 4 - Prob. 1TACh. 4 - Prob. 1WECh. 4 - Do research on the Web to learn which programming...Ch. 4 - Prob. 3WECh. 4 - Prob. 1CECh. 4 - Prob. 2CECh. 4 - Think of your ideal job. Identify two existing...Ch. 4 - Prob. 1CTQ1Ch. 4 - Prob. 2CTQ1Ch. 4 - Prob. 3CTQ1Ch. 4 - Prob. 1CTQ2Ch. 4 - Prob. 2CTQ2Ch. 4 - Prob. 3CTQ2
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.arrow_forwardThe administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…arrow_forwardThe administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…arrow_forward
- Windsor, a small city with a population of 50,000, recently purchased several buses and hired drivers to serve multiple routes in Windsor and neighboring areas. As the city’s IT manager, you have been tasked to set up an information system and database to manage the scheduling of buses and drivers that can be easily expanded as the city grows. You directed your team to follow best practices to develop a normalized database to manage scheduling of drivers and buses that is simple, flexible and non-redundant. For this scenario, assume that drivers can be assigned to different buses, and multiple buses will run on multiple routes. You may also assume the bus service is free, so no ticket purchases are required. Hint: The purpose of this assignment is to demonstrate an understanding of database modeling and design concepts and techniques. First, follow the examples on pages 282-284, 292 and 295 to build an ERD and decompose a many-to-many relationship into one-to-many relationships…arrow_forwardYou are hired as a quality analyst by "COMP-FACT" manufacturing company. It's production unit produces distinct parts for the computers and assigned with concerned technicians to handle these parts. A separate database is maintained to store all the information related to the parts. The supervisor tracks a given job with job_id, technician identification number, start time and completion time. Now, to ensure the quality and satisfy the customer expectations, recommend any one of the process improvement approach with proper justifications.arrow_forwardDesign a normalized order management database with the requirements provided in the MS Excel worksheet. Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram using the MS Excel worksheet to illustrate the relationships between entities and attributes. ORDER MANAGEMENT Entity-Relationship ITEM: Customer Header · customer number · buyer name · bill-to address · buyer phone · buyer email · credit rating Customer Shipping · location number · receiver name · receiver phone · receiver email · ship-to address Order Header · order number · order date…arrow_forward
- Deep River College is a two-year school in Southern California. Twice a year, the fund-raising office at Deep River mails requests for donations to the alumni. The staff uses a word processing program and a personal information database to create personalized letters. Data on past contributions and other alumni information, however, is stored manually. The dean, Alexandra Ali, recently submitted a systems request asking the college’s IT department to develop a computerized alumni information system. The school does not have a formal systems review committee, and each department has an individual budget for information services. Eddie Bateman, a systems analyst, performed a preliminary investigation and he concluded that the system met all the feasibility tests. After reading his report, Alexandra asked him to proceed with the systems analysis phase. Eddie has scheduled an interview with her, and he has asked you to help him prepare for the meeting. Specifically, he wants you to list…arrow_forwardMemory updated Here’s a simplified yet complete response to each question: DBMS Evaluation for Data WarehousingWhen evaluating DBMS products for a data warehouse, the key things to focus on are performance (how fast it can process data), scalability (how well it handles large amounts of data), data integration (how easily it works with different types of data), security, and ease of use. You’ll also want to consider cost and vendor support. Recommendation on Prototyping the Data WarehouseI would recommend building a prototype because it helps the team learn the necessary skills and spot potential issues early. A prototype gives a smaller, testable version of the data warehouse, so the team can practice using the tools and technologies, leading to fewer mistakes when building the full version. Explaining Multidimensional Data AnalysisMultidimensional data analysis is like viewing data from multiple angles at once. Imagine looking at sales by product, region, and time all at…arrow_forwardDefine Normalization & Normalize the following table to 3NF using excelarrow_forward
- What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them? There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students. In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the contents of the…arrow_forwardPlease help me interpret this Data Flow Diagram.arrow_forwardGlobal Computer Solutions (GCS) is an information technology consulting company with many offices throughout the United States. The company’s success is based on its ability to maximize its resources—that is, its ability to match highly skilled employees with projects according to region. To better manage its projects, GCS has contacted you to design a database, so GCS managers can keep track of their customers, employees, projects, project schedules, assignments, and invoices. The GCS database must support all of GCS’s operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a middle initial, a first name, a region, and a date of hire recorded in the system. Valid regions are as follows: Northwest (NW), Southwest (SW), Midwest North (MN), Midwest South (MS), Northeast (NE), and Southeast (SE). Each employee has many skills, and many employees have the same skill. Each skill has a skill ID,…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
Information Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
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 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
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
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