Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 2.40PAE
Program Plan Intro
To draw an ERD for Star Hoist.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Annabelle Sizemore has cashed in some treasury bonds and a life insurance policy that her parents had accumulated over the years for her. She has also saved some money in certificates of deposit and savings bonds during the 10 years since she graduated from college. As a result, she has $120,000 available to invest. Given the recent rise in the stock market, she feels that she should invest all of this amount there. She has researched the market and has decided that she wants to invest in an index fund tied to S&P stocks and in an Internet stock fund. However, she is very concerned about the volatility of Internet stocks. Therefore, she wants to balance her risk to some degree.
She has decided to select an index fund from Shield Securities and an Internet stock fund from Madison Funds, Inc. She has also decided that the proportion of the dollar amount she invests in the index fund relative to the Internet fund should be at least one-third but that she should not invest more than…
Mr Sulaiman has four kids, named Asmahan (eldest), Baraq, Dhikra, and Hamza (youngest). One day, Sulaiman brought a
new motorcycle to home. As he opened this single-seated motorbike, all the kids were excited and want to ride the
motorbike first. So, Sulaiman came up with a plan: each one will get only 9 minutes to ride and has to pass on to the next
younger sister/brother. After Hamza finishes his 6 minutes, the turn goes to Asmahan again.
Following is the time each kid ride the motorbike in total.
• Asmahan played 9 minutes.
• Baraq played 13 minutes.
• Dhikra played 17 minutes.
• Hamza played 15 minutes.
Consider this scenario in terms of Process Scheduling Algorithm and answer the following.
a) What is the suitable Process Scheduling Algorithm that can be used here?
b) Draw a Gantt chart in a paper for the above scenario capture an image, upload it in moodle
c) Find the Average Turnaround Time.
d) Find the Average Waiting Time.
Annabelle Invests in the Market
Annabelle Sizemore has cashed in some treasury bonds and a life insurance policy that her parents had accumulated over the years for her. She has also saved some money in certificates of deposit and savings bonds during the 10 years since she graduated from college. As a result, she has $120,000 available to invest. Given the recent rise in the stock market, she feels that she should invest all of this amount there. She has researched the market and has decided that she wants to invest in an index fund tied to S&P stocks and in an Internet stock fund. However, she is very concerned about the volatility of Internet stocks. Therefore, she wants to balance her risk to some degree.
She has decided to select an index fund from Shield Securities and an Internet stock fund from Madison Funds, Inc. She has also decided that the proportion of the dollar amount she invests in the index fund relative to the Internet fund should be at least one-third but…
Chapter 2 Solutions
Modern Database Management
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
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
- Computer Science The time has come to take control of your family business. After years of hard work at IE University, your parents believe you are ready to tackle the big challenge of transforming your company. They've heard that a new trend called digital transformation is here to stay; and that those companies that don't address this transformation run the serious risk of falling behind or even disappearing. Fortunately, they are counting on you, and they know that you have acquired the vision and experience to successfully meet this great challenge. The current company Your company is a chain of 10 restaurants operating in the 10 main cities of Spain (Madrid, Barcelona, Seville, Valencia, Malaga, .....). Your restaurants offer Spanish food with high quality products, but your family would like to incorporate certain changes in order to adapt to the new times and internationalize the business. The company has 150 employees and all the processes involved continue to be done in a…arrow_forwardDavid Doe is a network administrator for the ABC Company. David is passed over for promotion three times. He is quite vocal in his dissatisfaction with this situation. In fact, he begins to express negative opinions about the organization in general. Eventually, David quits and begins his own consulting business. Six months after David’s departure, it is discovered that a good deal of the ABC Company’s research has suddenly been duplicated by a competitor. Executives at ABC suspect that David Doe has done some consulting work for this competitor and may have passed on sensitive data. However, in the time since David left, his computer has been formatted and reassigned to another person. ABC has no evidence that David Doe did anything wrong. Consider the following questions: 1. What steps might have been taken to detect David’s allegedindustrial espionage?2. What steps might have been taken to prevent his perpetrating suchan offense?arrow_forwardSystem Analysis & Designarrow_forward
- Any language is OK. please help me ,thanksarrow_forwardIMMUNIZATION TRACKER SYSTEM “I’ve got the idea of the century!” proclaims Nana Gyamfua, a new systems analyst with Tricky Pee Business Inc group. “Let’s skip all this SDLC garbage and just prototype everything. Our projects will go a lot more quickly, we’ll save time and money, and all the users will feel as if we’re paying attention to them instead of going away for months on end and not talking to them.” George, an HR manager also thinks that building a prototype can mean only one thing: a nonworking scale model. He also believes that this way is too cumbersome to prototype information systems and thus is reluctant to do so. George is so intrigued with mobile apps and therefore after consultation with the other systems managers of Tricky Pee Business Inc, download a mobile app to track the immunization status of the child. The first action is to register with the child’s details and their own. The app fetches the latest immunization plan from a server and computes a schedule for the…arrow_forwardThe Bright Light Academy The Bright Light Academy is a high school that is located in Midrand. The school opened its doors for enrolment of students in 2018. They enrol from Grade R to Grade 12. As of the last quarter of 2020, the school’s enrolment has grown tremendously to 400 students and they are anticipating that their enrolment will increase further. Since its inception, the school has been using Pastel Accounting to administer its finances. The school board of trustees has made a decision to develop an in-house integrated school management system. The school is hoping that the system will help in its blended learning strategy in the beginning of the second quarter of 2021. Source: Maodza, B. (2021)Question 4You have been hired as the Lead Architect of the school. Model a detailed use case diagram for the proposed integrated school management system.arrow_forward
- Analyze and solve case study. Jimmy works in an organization as an assistant manager in the IT department and recently promoted to the designation of senior manager. Mark, Jimmy’s department head calls him to his office. Mark shares with Jimmy that the CEO has received a letter from one of the employees of the IT department. The CEO has kept the name confidential. The letter states that software installed recently does not perform well as expected and the department has not achieved the desired results. Jimmy is aware of this problem by the software installed and reported to his Department Head, Mark several times before. Mark is in favor of that software and the only supporter and has been providing positive feedback to the CEO about its performance. Mark asks Jimmy to draft a reply to the letter that should support the system. It should say that the system is performing well with the desired results. Jimmy is confused and mentally disturbed. He wants to give the true facts to the…arrow_forwardWhile mingling with neighbours at a party, Ato mentions that he is responsible for evaluating bids for a large computer software contract. A few days later, Ato receives a lunch invitation from one of his neighbours who also attended the party. Over appetizers, the conversation turns to the contract Ato is managing. Ato’s neighbour seems remarkably well informed about the bidding process and likely bidders. Ato volunteers information about the potential value of the contract and briefly outlines the criteria his firm will use to select the winner. At the end of the lunch, Ato’s neighbour surprises him by revealing that he is a consultant for several companies in the computer software market. Later that day, Ato’s mind is racing. Did Ato reveal information that could provide a supplier with a competitive advantage in the bidding process? What are the potential business risks and ethical issues in this situation? Should Ato report the conversation to someone? If so, whom should he talk…arrow_forwardRead the following case study and then answer the questions that follow:As a child, Chris Kunene took notes on the commercials that interrupted his Saturday morningcartoons. He noticed a mismatch between many shows and the products advertised during them.Chris shared his thoughts with his grade three teacher, looking for reasons. “Well,” said histeacher, “it looks like someone is not doing their job.”Today, Chris has turned his contextual marketing hobby into a career, overseeing data productand insight practices at Kargo. Kargo is a global mobile-first, editorial-led marketplace of uniquemulti-channel advertising and commerce opportunities for brands. The advertising technologycompany creates and delivers advertising campaigns to a large audience of smartphone users,using contextual advertising, without sacrificing brand safety or security against advertisementfraud.As the advertising industry moves away from third-party cookies due to privacy concerns andchanging technology, many…arrow_forward
- Read the following case study and then answer the questions that follow:As a child, Chris Kunene took notes on the commercials that interrupted his Saturday morningcartoons. He noticed a mismatch between many shows and the products advertised during them.Chris shared his thoughts with his grade three teacher, looking for reasons. “Well,” said histeacher, “it looks like someone is not doing their job.”Today, Chris has turned his contextual marketing hobby into a career, overseeing data productand insight practices at Kargo. Kargo is a global mobile-first, editorial-led marketplace of uniquemulti-channel advertising and commerce opportunities for brands. The advertising technologycompany creates and delivers advertising campaigns to a large audience of smartphone users,using contextual advertising, without sacrificing brand safety or security against advertisementfraud.As the advertising industry moves away from third-party cookies due to privacy concerns andchanging technology, many…arrow_forwardRead the following case study and then answer the questions that follow:As a child, Chris Kunene took notes on the commercials that interrupted his Saturday morningcartoons. He noticed a mismatch between many shows and the products advertised during them.Chris shared his thoughts with his grade three teacher, looking for reasons. “Well,” said histeacher, “it looks like someone is not doing their job.”Today, Chris has turned his contextual marketing hobby into a career, overseeing data productand insight practices at Kargo. Kargo is a global mobile-first, editorial-led marketplace of uniquemulti-channel advertising and commerce opportunities for brands. The advertising technologycompany creates and delivers advertising campaigns to a large audience of smartphone users,using contextual advertising, without sacrificing brand safety or security against advertisementfraud.As the advertising industry moves away from third-party cookies due to privacy concerns andchanging technology, many…arrow_forwardHere I am again with my special Omicron Juice! Here goes the story: I have three kids- Alpha, Beta and Gamma. Every morning I need to prepare them for school, serve them breakfast and say them bye. You might think that I don't like all these. But to be honest I do like it, specially I have fun serving them breakfast. Every morning I serve them Omicron Juice. But I can't always pour the juice in equal amounts. If they don't get equal amounts of juice then they start fighting. I use two other glasses to make the juice amount equal. To be more specific... There are three glasses with juice of amount A, B and C. I have two other glasses which can hold exactly K amount of drinks each and initially empty. Let's call these two extra glasses as cups to avoid ambiguity. In one operation, I pour K amount of drinks from one of the three glasses to my first cup, and from one of the two remaining glasses to my second cup. Next I pour the drink from my first cup to one of the three glasses and from…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education