Connect with LearnSmart Access Card for Business Driven Technology
7th Edition
ISBN: 9781259852183
Author: Paige Baltzan, Amy Phillips
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 6, Problem 6MBD
Explanation of Solution
Integrating Information:
The firm has constantly been facing a delay in extracting, collecting and receiving the required information. The information at times also includes some crucial information like the quarterly balance sheets. The major issues in obtaining the information are mentioned below:
- Several departments need to be contacted in order to attain the required information.
- Then they proceed to extract the information from their
database (like Microsoft Excel, Microsoft Access, etc) and at times that databases differ. - Departments often assign different codes to data which involves synchronization steps.
- There is the added burden of aggregating the data.
The public transport department can implement a dataware house which gathers all the information from all the related databases of the firm then aggregates it and stores it in a common location. This action will facilitate the obtaining of information...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
As a recent Albany BBA graduate, you have been directly recruited by the new CEO of ABC – a major multinational firm to assist with implement her vision. Before starting the internal reorganization, the CEO wants to understand the structure of the company and assigns you to the project. The IT person in charge is on long term leave but he emails you the EER diagram of the employees database along with the user id and password of the MySQL database of the company.
NOTE: You only need the employees, salaries and dept_emp tables for the queries.
Write a query to get the number of employees in the company by gender.
As a recent Albany BBA graduate, you have been directly recruited by the new CEO of ABC – a major multinational firm to assist with implement her vision. Before starting the internal reorganization, the CEO wants to understand the structure of the company and assigns you to the project. The IT person in charge is on long term leave but he emails you the EER diagram of the employees database along with the user id and password of the MySQL database of the company.
NOTE: You only need the employees, salaries and dept_emp tables for the queries.
The company faced some lean times during the years 1990 and 1991. The CEO wants to get the list of employees who joined during the years 1990 and 1991 to compare their productivity to those who joined during other years.
a). Write a query to get the list of employees who joined during the years 1990 and 1991.
As a recent Albany BBA graduate, you have been directly recruited by the new CEO of ABC – a major multinational firm to assist with implement her vision. Before starting the internal reorganization, the CEO wants to understand the structure of the company and assigns you to the project. The IT person in charge is on long term leave but he emails you the EER diagram of the employees database along with the user id and password of the MySQL database of the company.
NOTE: You only need the employees, salaries and dept_emp tables for the queries.
Write a query to get the total salary paid to all employees since the start of the company.
Chapter 6 Solutions
Connect with LearnSmart Access Card for Business Driven Technology
Knowledge Booster
Similar questions
- As a recent Albany BBA graduate, you have been directly recruited by the new CEO of ABC – a major multinational firm to assist with implement her vision. Before starting the internal reorganization, the CEO wants to understand the structure of the company and assigns you to the project. The IT person in charge is on long term leave but he emails you the EER diagram of the employees database along with the user id and password of the MySQL database of the company. NOTE: You only need the employees, salaries and dept_emp tables for the queries. Write a query to get the First and Last Names of all employees who earned more than $70,000 in any year. Use subquery in the WHERE clause.arrow_forwardsolve the questions: Tony and his team identified some risks during the first month of the Recreation and Wellness Intranet Project. However, all they did was document the risks in a list. They never ranked the risks or developed any response strategies. Because the project has had several problems, such as key team members leaving the company, users being uncooperative, and team members not providing good status information. Tony has decided to be more proactive in managing risks. He also wants to address positive risks as well as negative risks. the quation is : 1- Plot the six risks on a probability/impact matrix. 2- assign a numeric value for the probability and impact of each risk on meeting the main project objective.arrow_forwardTravelBiz is a nationwide travel agency that specializes in business travel. It has decided to expand into the vacation travel market by launching a new business division called TravelFun. The IT director assigned two systems analysts to create a flexible and an efficient information system for the new division. One analyst wants to use traditional analysis and modeling techniques for the project, while the other analyst wants to use an O-O methodology. Which approach would you take/suggest and why? Why should others take your approach instead?arrow_forward
- Which of the following is not a true statement regarding the use of virtual teams? a. Virtual teams enable the organization to enlist the best people in different geographical regions to solve important organizational problems. b. The use of virtual teams provides the ability to staff a team with people who have a wide range of experience and knowledge that stems from a variety of professional experiences and cultural backgrounds. c. It is usually easy and convenient for all members of a virtual team to meet at the same time and physical location. d. Members of a virtual team may feel that their work day never ends.arrow_forwardOrganizational change is presented 345-352 of the textbook. In this video, Organizational Change Management (OCM) is the investment by the leadership to bring about the desired individual and organizational performance levels during the change phase. It helps organizations to build clarity in visions, goals, roles, and processes. OCM addresses the critical people-related issues arising as a result of different business decisions that lead to business challenges. Although this video is an infomercial, and it does not present specific solutions, it raises many important issues in relation to managing change. People must adapt to change in organizations because change is a constant. Many workers have difficulty in managing unpredictability. When change is not manager well the results can be attrition, lower quality, and customer complaints. Change specialists brought into an organization can identify barriers to accepting change, and can also identify roadmaps for accepting change. The…arrow_forwardPersonal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centershave done well, and the company is planning an international expansion by opening a new “supercenter” in the Toronto area. Personal Trainer’s president, Cassia Umi, hired an IT consultant,Susan Park, to help develop an information system for the new facility. During the project, Susanwill work closely with Gray Lewis, who will manage the new operation.BackgroundSystem changeover and data conversion were successful for the new PersonalTrainersystem.Thethe post-implementation evaluation indicated that users were pleased with the system. The evaluationalso confirmed that the system was operating properly. Several users commented, however, thatsystem response seemed slow. Susan Park, the project consultant, wants to meet with you to discuss the operation, maintenance, and security issues affecting the new system.Tasks1. What might be causing the slow response time? Prepare a brief memo…arrow_forward
- Pine Valley FurniturePine Valley Furniture’s customer trackingsystem project is now ready to move intothe systems design phase. You are excitedbecause this phase involves designing thenew system’s forms, reports, and databases.During this morning’s meeting with Jim Woo,he asked you to design several forms and reports for the new customer tracking system.During the requirements determinationphase, Jackie Judson requested that a customer profile be created for each customer.The customer profile is established whennew customers place their first order. Customers will have the option of not completinga profile; however, to encourage customerparticipation, a 10 percent discount on thecustomer’s total order will be given to eachcustomer who completes a profile. In thebeginning, existing customers will also begiven the opportunity to participate in thecustomer profiling process. Customer profileinformation will be collected via a customerprofile form.Gracie Breshers, a marketing executive,has…arrow_forwardComputer Science You have finally made it! This week, you will submit the last piece of your project. Identify if there are any business process changes, provide a high-level timeline, write up a recommendation, and provide your proposed solution. These are items 8, 9, 10, and 11 of your template. You should also complete the overview of your project (there is a heading at the template, under which you should write your project overview). The overview should include what you found out from your analysis and if you think you should proceed. The findings you have come up with will be fluid and will evolve but giving your management team or whoever you are presenting to an idea of what to expect, always helps get funding approved faster.arrow_forward1. TravelBiz is a nationwide travel agency that specializes in business travel. It has decided to expand into the vacation travel market by launching a new business division called TravelFun. The IT director assigned two systems analysts to create a flexible and an efficient information system for the new division. One analyst wants to use traditional analysis and modeling techniques for the project, while the other analyst wants to use an O-O methodology. Which approach would you suggest and why? 2. You were hired by Hilltop Motors as a consultant to help the company plan a new information system. Hilltop is an old-line dealership, and the prior owner was slow to change. A new management team has taken over, and they are eager to develop a first-class system. Right now, you are reviewing the service department, which is going through a major expansion. You decide to create a model of the service department in the form of a use case diagram. The main actors in the service operation are…arrow_forward
- The headquarters of Hill Crest Corporation, a private company with $15.5 million in annual sales, is located in California. Hill Crest provides for its 150 clients an online legal software service that includes data storage and administrative activities for law offices. The company has grown rapidly since its inception 3 years ago, and its data processing department has expanded to accommodate this growth. Because Hill Crest’s president and sales personnel spend a great deal of time out of the office soliciting new clients, the planning of the IT facilities has been left to the data processing professionals.Hill Crest recently moved its headquarters into a remodeled warehouse on the outskirts of the city. While remodeling the warehouse, the architects retained much of the original structure, including the wooden-shingled exterior and exposed wooden beams throughout the interior. The minicomputer distributive processing hardware is situated in a large open area with high ceilings and…arrow_forwardThe Vegan Garden is a small restaurant in the quiet city of Dawnsville. The restaurant has been operating for the past five years. Currently manual systems such as cash registers are being used for capturing sales and old filing cabinets are used for storing the sales reports for each month and other business documents such as employee and supplier information. The owner of Vegan Garden has decided to implement an information system. He sought the services of an IT company to build an information system that would align to the current business processes of the Vegan Garden. You are the appointed project manager for the development of the Vegan Garden information system. As the project manager of the development project, educate the owner of Vegan Garden on the security concerns regarding the information systems. Explain ANY FIVE (5) common security threats affecting information systems. Elaborate on the security measures for the FIVE (5) threats mentioned previouslyarrow_forwardThe Vegan Garden is a small restaurant in the quiet city of Dawnsville. The restaurant has been operating for the past five years. Currently manual systems such as cash registers are being used for capturing sales and old filing cabinets are used for storing the sales reports for each month and other business documents such as employee and supplier information. The owner of Vegan Garden has decided to implement an information system. He sought the services of an IT company to build an information system that would align to the current business processes of the Vegan Garden. You are the appointed project manager for the development of the Vegan Garden information system. The staff at Vegan Garden are currently using traditional methods of capturing and storing sales information at the restaurant. What could be some of the problems stated to you (the project manager) by the owner of Vegan Garden regarding the storing and managing of information currently. List and explain at least TEN…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Information Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningManagement Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning