EBK USING MIS
10th Edition
ISBN: 8220103633635
Author: KROENKE
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 7, Problem 7.9CE7
Explanation of Solution
Analyzing newly drawn figures:
If the county changed the system, the answer from the question 7-8 is better than 7-7.
Figure:
Explanation:
The above figure contains three applications. They are:
Receiving permit: This application receives permit from the applicants or county and store that in the
Department application: The department application contains three departments, engineering department, health department, and highway department. These departments get the permit application and review those permits and send the feedback to the database whether it is approved or not...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Given the following case you are to answer the two questions on the following pages.
Bob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to have assigned an identifying number.
1. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attrIbutes take on.
2. Create the database design for this case below using an Entity-Relationship Diagram.
One hundred students were asked whether they had taken courses in any of the three
subjects, Mathematics, Computer Science and Information Technology. The results
were given below. 45 had taken Mathematics; 18 had taken Mathematics and Computer
Science; 38 had taken Computer Science; 21 had taken Information Technology; 9 had
taken Mathematics and Information Technology.; 4 had taken Computer Science and
Information Technology and 23 had taken no courses in any of the subjects. Draw a
Venn diagram that will show the results of the survey.
Would the answer be B or C based on the information given?
Chapter 7 Solutions
EBK USING MIS
Ch. 7.4 - Prob. 1WPQCh. 7.4 - Prob. 2WPQCh. 7.4 - Prob. 3WPQCh. 7.4 - Prob. 4WPQCh. 7.4 - Prob. 5WPQCh. 7.4 - Prob. 1EGDQCh. 7.4 - Prob. 2EGDQCh. 7.4 - Prob. 3EGDQCh. 7.4 - Prob. 4EGDQCh. 7.4 - Prob. 5EGDQ
Ch. 7.8 - Prob. 1SGDQCh. 7.8 - Prob. 2SGDQCh. 7.8 - Prob. 3SGDQCh. 7.8 - Prob. 4SGDQCh. 7.8 - Prob. 7.1ARQCh. 7.8 - Prob. 7.2ARQCh. 7.8 - Prob. 7.3ARQCh. 7.8 - Prob. 7.4ARQCh. 7.8 - Prob. 7.5ARQCh. 7.8 - Prob. 7.6ARQCh. 7.8 - Prob. 7.7ARQCh. 7.8 - Prob. 7.8ARQCh. 7 - Prob. 7.1UYKCh. 7 - Prob. 7.2UYKCh. 7 - Prob. 7.3UYKCh. 7 - Prob. 7.4UYKCh. 7 - Prob. 7.5UYKCh. 7 - Prob. 7.6CE7Ch. 7 - Prob. 7.7CE7Ch. 7 - Prob. 7.8CE7Ch. 7 - Prob. 7.9CE7Ch. 7 - Prob. 7.1CE7Ch. 7 - Prob. 7.11CS7Ch. 7 - Prob. 7.12CS7Ch. 7 - Prob. 7.13CS7Ch. 7 - Prob. 7.14CS7Ch. 7 - Prob. 7.15CS7Ch. 7 - Prob. 7.16CS7Ch. 7 - Prob. 7.17CS7Ch. 7 - Prob. 7.18MMLCh. 7 - Go to www.microsoft.com and search for Microsoft...
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
- Using a decision table simplifies the process of associating conditions with responses. Explain?arrow_forwardDamon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income would be $50,000. When he tallied the columns on the Balance Sheet, the totals were as follows: debit, $400,000; and credit, $300,000. What was the most likely reason for this discrepancy? If this was not the case, how should he proceed to determine the source of the error?arrow_forwardFor this assignment you are to find 3 real-world examples of identity theft, preferably medical id theft, but any type will be accepted. One of the examples should be your own if you were an id theft victim (I personally have been a financial id theft victim twice) or someone you know. This will allow you to know the details of how the theft occurred and how it was handled. One of the examples must come from research news stories and other resources found on the Web. Provide a link to each website in your report.. The final example may be personal or a news story. For each case, identify the type of ID theft that occurred, and answer these questions: what did the thief do (if known) to acquire the information, how was it discovered, what were the damages incurred, how long did it take to resolve the problems caused by the id theft?.arrow_forward
- Do not use any Al to do this question. Please show the diagram at the end. Question Lekker Living is a new backpackers that recently opened close to Stellenbosch. They have a limited number of staff (including a receptionist, a cook, and a housekeeper) since they have limited rooms available. If foreign travelers are looking for a place to stay a few nights while exploring the wonderful wine farms and hiking trails in Stellenbosch, they need to check availability on the website. If there is space, they must call reception to book a room. Orice they arrive, they check in at the front desk. In the evenings, they have the option to enjoy an assortment of dishes, prepared by a cook. Guests can also request for the room to be cleaned by a housekeeper in the mornings, while they are out and about exploring. Once their stay is over, they can check out with the receptionist. If a guest can no longer make their stay, they have the option to cancel their booking 24 hours before. Draw the use…arrow_forwardSolve 7arrow_forwardQuestion 7: Build a table to show the frequency of each offence category. Arrange the frequency in descending order. Which two categories have the most offences issued q7 * COffence category) *>* q7 The highest two frequency of offences are and Question 8: Draw a suitable plot to show the same information as in Question 7 but just restricted it to the highest 5 categories. Look at the lasi line of coding, what this coding is trying to do? It is just to make the label more visible by rotating the label. q7 *>* top_n(5) %>* ggplot (aes (x --- y = theme (axis. text.x - element_text (angle=45, hjust = 1))arrow_forward
- List 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_forwardHow does denormalization differ from normalization, and what are the scenarios where denormalization is appropriate?arrow_forward1. Using Rstudio, Create a factor, based on the information given: Out of 27 respondents considered in the survey, the respondents specify that their favorite subjects are mathematics, statistics, and science with 12, 5, and 10 of the total respondents, respectively. Create a factor, based on the information given. 2. Using the given Rstudio in the picture, select students with grades in mathematics at most 85 and at least 85 in statistics.arrow_forward
- You are interested in looking at how competition affects gas prices, where you think that if a gas station has more competitors nearby, it will tend to have lower prices. To test this, you decide to use a natural experiment in which a chain of gas stations ("Thrifty") suddenly closed. This closure occurred between June and October of 2012, and meant that gas stations that were previous close to a Thrifty station experienced less competition than before. On the other hand, those stations that were not close to a Thrifty station did not experience any change in competition. You decide to use a differences in differences design, in which gas stations located near a Thrifty station at the start of 2012 are the treatment group and those that were not located near a Thrifty at the start of 2012 are the control group. You look at how prices change before and after the exit of Thrifty. This is plotted in the below graph, where the solid line represents the average price of stations that were…arrow_forwardStudents: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79 Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate: The Average Grade of each student; this average should be a vector. The average of the class; this average is a scalar vector. The highest grade among the Average Grade of Each Student The lowest grade among the Average Grade of Each Student Show a table with each student's name, average grade and letter score using A, B, C, D, F…arrow_forwardThe term "bridge/joint table" describes exactly what it is. Is there another option? In what way is the other option inferior?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
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