Experiencing MIS
8th Edition
ISBN: 9780134792736
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 2UYK
a.
Explanation of Solution
Data fields
The possible tables of data and possible data fields are
- Booth components
- Names
- Age
- Parties
- Final result
- Equipment’s
- No of equipment’s
- S...
b.
Explanation of Solution
Using a spreadsheet
“Yes”, spreadsheet can be used for tracking data.
Reason
- Spreadsheets are mainly used to store and sort data...
c.
Explanation of Solution
Relationships
- In the context of databases, a relationship is a situation that exists between two relational
database tables...
d.
Explanation of Solution
Database components
- The database components needed are data entry forms and reports.
- Data entry form is main...
e.
Explanation of Solution
Personal Database Management System (DBMS)
- This application is used for a single user at a time...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Central Pacific University:On a warm, sunny day in late October, Chip Puller parks his car and walks into his office at CentralPacific University. It feels good to be starting as a systems analyst, and he is looking forward tomeeting the other staff. In the office, Anna Liszt introduces herself. “We’ve been assigned to work asa team on a new project. Why don’t I fill you in with the details, and then we can take a tour of thefacilities?”“That sounds good to me,” Chip replies. “How long have you been working here?” “About five years,”answers Anna. “I started as a programmer analyst, but the last few years have been dedicated toanalysis and design. I’m hoping we’ll find some ways to increase our productivity,” Anna continues.“Tell me about the new project,” Chip says. “Well,” Anna replies, “like so many other organizations,we have a large number of microcomputers with different software packages installed on them. Fromwhat I understand, in the 1980s there were few personal computers and…
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…
A law firm wanted to develop an online system to archive and keep track of their legal documents. The firm have a list of clients’ details and each of these clients has one or more cases filed with the firm. A case can have unlimited number of documents uploaded. The firm has some staff that handles and uses these legal documents. The lawyers that are assigned to certain cases are allowed to access the documents related to their cases. The legal clerks have access to all these documents and are responsible to upload or update these documents in the system as per the lawyers’ instructions. Any update of documents by each clerk should be recorded for tracking purpose so that the latest document can be identified and the clerk is held responsible for any irregularity to the document management. Draw the Class diagram to illustrate the above case study. Surface all the possible entities and their associations. Each entity should have at least 2 attributes and 1 behaviour. Include at least…
Chapter 5 Solutions
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQCh. 5 - Prob. 6EGDQ
Ch. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 5 - Prob. 1ARQCh. 5 - Prob. 2ARQCh. 5 - Prob. 3ARQCh. 5 - Prob. 4ARQCh. 5 - Prob. 5ARQCh. 5 - Prob. 6ARQCh. 5 - Prob. 1UYKCh. 5 - Prob. 2UYKCh. 5 - Prob. 3UYKCh. 5 - Study Figure 5-17 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-17 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-17 into a...Ch. 5 - Prob. 9CECh. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 11CECh. 5 - Prob. 12CSCh. 5 - Prob. 13CSCh. 5 - Prob. 14CSCh. 5 - Prob. 15CSCh. 5 - Prob. 16CSCh. 5 - Prob. 17CSCh. 5 - Prob. 18CSCh. 5 - Prob. 19MMLCh. 5 - Prob. 20MLM
Knowledge Booster
Similar questions
- DIRECTION: The aim of this activity is for you to design an innovative timepiece for your own use. This could be in the form of a wristwatch, a mantelpiece clock, an electronic clock, or any other kind of clock you like. Your goal is to be inventive and exploratory. Nowadays, timepieces (such as clocks, wristwatches etc.) have a variety of functions. They not only tell the time and date but they can speak to you, remind you when it's time to do something, and provide a light in the dark, among other things. Mostly, the interface for these devices, however, shows the time in one of two basic ways: as a digital number such as 23:40 or through an analog display with two or three hands-one to represent the hour, one for the minutes, and one for the seconds. Task No. 1: (a) Think about the interactive product you are designing: what do you want it to do it for you? Find 1-3 potential users and ask them what they would want. Write a list of requirements for the clock, together with some…arrow_forwardA restaurant chain has several locations in a city (with a name and zip code stored for each), and each is managed by one manager. Each manager manages multiple restaurants. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, items can appear on multiple menus, and each menu has a price on it. A customer can visit multiple restaurants and a restaurant can have multiple customers. Represent this situation of restaurants with an E-R diagramarrow_forwardYour company urgently needs a new manager in another division, and you have been invited to apply for the position. However, one of the job requirements is competence in the use of some sophisticated CAD (computer aided design) software. Currently you do not have that competence, but you are enrolled in a CAD course, so eventually you will have that competence (but not before the deadline for filling the new job). The application form for the job requires you to state whether or not you have the necessary CAD software competence. Is it ethically permissible to claim that you have (in order to get the job for which otherwise you are well qualified), even though strictly speaking this is not true? Would your answer be any different if your current boss informally (off the record) advised you to misrepresent your qualifications in this way, giving as his/her reason that you are overall the best qualified person for the new managerial position?arrow_forward
- Project Synopsis: 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_forwardAssume the role of a new software developer in a technology company. Your team leader comes to you with a project he's been given for your team to complete. The project is in the proposal phase, and he wants you to review the information and come up with a proposal for what technology the team should use for the project. The project details are a little thin, but, essentially the company wants a web site or a web-based application (they aren't really sure which or what the difference is) to track customer complaints. They know there are tools available on the market, but they want something home-grown that will be a web-base version of the manual tracking and reporting they currently do. Access would only be from the company's network - no access via the Internet. There will need to be a login for the various users (techs and admins basically). The techs will need to be able to add and update customer complaints and the admins will need to be able to view complaint data in various…arrow_forwardAssume the role of a new software developer in a technology company. Your team leader comes to you with a project he's been given for your team to complete. The project is in the proposal phase, and he wants you to review the information and come up with a proposal for what technology the team should use for the project. The project details are a little thin, but, essentially the company wants a web site or a web-based application (they aren't really sure which or what the difference is) to track customer complaints. They know there are tools available on the market, but they want something home-grown that will be a web-base version of the manual tracking and reporting they currently do. Access would only be from the company's network - no access via the Internet. There will need to be a login for the various users (techs and admins basically). The techs will need to be able to add and update customer complaints and the admins will need to be able to view complaint data in various…arrow_forward
- What would be a good architectural design for this software system? Why?arrow_forwardThe college ground is rectangular in shape. The Management decides to build a fence around the ground. In order to help the construction workers to build a straight fence, they planned to place a thick rope around the ground. They wanted to buy only the exact length of the rope that is needed. They also wanted to cover the entire ground with a thick carpet during rainy season. They wanted to buy only the exact quantity of carpet that is needed. They requested your help. Help them by writing a C program to find the exact length of the rope and the exact quantity of carper that is required? Input Format: Input consists of 2 integers. The first integer corresponds to the length of the ground and the second integer corresponds to the breadth of the ground. Output Format: Refer Sample Input and Output for exact formatting specifications. Sample Input and Output: [All text in bold corresponds to input and the rest corresponds to output] Length: 50 Width: 20 Required length is 140m Required…arrow_forwardE3 In this project, you are asked to independently research and write a short report relating to our discussion on Biofuel Energy. Your topic selection is completely of your choosing, though the report must clearly demonstrate how the subject is relevant to the overall topic of Biofuels. This course presents introductory discussions through module content and our weekly lectures, to enhance this learning it is up to the student to further explore and independently research topics of interest. The goal of this research report is to explore what interests you, and get on paper your ideas about this area of renewables technology. The marking scheme rewards originality and uniqueness of topic selection. Students with same/similar topics will loose significant marks. Plagiarism will result in a 0 mark, and will be dealt with according to Conestoga Academic Integrity policies. As this is a research report, it is important to develop an overview or a thesis statement about the topic you wish…arrow_forward
- For this system: Airline Reservation System For Customers Book Flights Buy Tickets Make Payment Print Boarding card Cancel booking For management staff Create new Flights Modify Flights Details Flights cancel .... Write one scenario and design the corresponding Sequence Diagram that describe one of the main use cases.arrow_forwardCreate a process model for the following simple scenario using BPMN. In an online shopping application, the following steps will be followed whenever a customer places a new order. The shop receives an order from a customer to buy a product. The availability of the product will be checked. If the product is available, the order will be shipped to the customer. If the product is not available, a request for the order will be sent to the supplier, then it will be shipped to the customer.arrow_forwardDraw a Use Case Diagram where a customer will buy a Product online using credit card. Customer browses the online products catalog & selects the items to buy. Then he can do the check out. Also, customer can fill in shipping information (address, next-day or 3-day delivery). The online system shows the product details with full pricing information. When the customer selects the products then he can fill in credit card information. Then online system will authorize the purchase and confirms the sale immediately and at the same time system sends the confirmation email to the customer.arrow_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
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L