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 3PSE
Program Plan Intro
Create a table that lists ten or more possible career areas − including estimated annual salaries and brief job descriptions. Rate how much you think you would like each potential career area on a scale from one to ten. Sort the careers from high to low rating and print the results. Sort the table according to annual salaries, from high to low, and then print the resulting table. Sort the table from the most liked to the least liked, and then print the results.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Write a SQL statement to get the list of all the tasks that started after 2022-05-10. Include all the columns from the task table.
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.
Create a sample list of owners and properties. Your list will be similar in structure to
that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing
address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to
maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate…
Write a SQL statement that returns a list of the team members with all their tasks. Include the team member’s name and the description of the task in the results.
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
- T Shirt Sales t-shirt price quantity sold total revenue $15 400 $6,000 50 100 150 200 250 300 350 400 $10 $15 $17 $25arrow_forwardSelect the best answer from the given choices: Using the company schema, when creating the "works_on" table, the primary key should be specified as All of the answers are correct primary key (essn, pno) primary key (essn), primary key(pno) primary key (essn) and primary key(pno)arrow_forwardThe Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information:arrow_forward
- Make a list of all course offerings. Provide the course code, start date, course duration, and trainer's name. 4.2 List the course code, start date, and number of attendees for all course offerings. Sort your results based on the number of attendees, from most to least. 4.3 Which workers took the same course more than once? 4.4 Provide the name of all trainers, the number of courses they taught, the total number of students in their classes, and the average assessment rating. The evaluation ratings should be rounded to one decimal place. 4.5 Who took the same courses as employee with eid = 2002?arrow_forwardNormalize the below given Student Course Plan to First Normal Form, Second NormalForm and Third Normal Form.arrow_forwardPlease prepare task as instructed by picture below.i will also add another picture as reference and guide to how it should be done Please prepare figures correctly, thank youarrow_forward
- Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and so on.)arrow_forwardList the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.arrow_forwardWhen part of the data in a table depends on a field in the table that isn’t the table’s primary key, it’s known as: transitive dependency partial dependency psychological dependency a foreign keyarrow_forward
- A table can have a maximum of how many PRIMARY KEY constraints?arrow_forwardFrom the employee table, calculate the average compensation for each job category where the employee has 16 or more years of education. Display the job and average compensation in the result set. Exclude people who are clerks Make sure to include salary, commission and bonus when looking at employee compensation Order the output by the average salary in ascending orderarrow_forwardBased on the ERD below, display all columns in the JOB table for those job descriptions that have both analysts and engineers within the description name. (Hint: You will use a “Like” phrase.)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
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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
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