Based on the above case study, Want-2-Work, present each of the following: 1) ER diagram 2) Relational
Fantastic news! We've Found the answer you've been seeking!
Question:
Based on the above case study, "Want-2-Work", present each of the following:
1) ER diagram
2) Relational model
3) Rules or assumptions made
4) Between 3 or 5 queries using the relational model (inclusive of join, group by and order by clauses).
Transcribed Image Text:
CASE STUDY "Want-2-Work" is a job placement agency. Like many other such agencies, their primary business is bringing applicants and employers together. There are many people with varying skills that are either unemployed and looking for a job or are currently unhappy with their current job who are looking for another job. There are also many employers with various jobs that they have within their company that they need to fill with the right applicants. The business has these two primary customer groups: employers and applicants. Employers provide position descriptions, i.e. jobs. This would include all the usual aspects such as the title of the positions, duties, required skills, required qualifications etc. etc. You may have seen position advertisements in the newspapers that provide these sorts of details. The job agency also maintains details about the applicants. All the usual personal details of course, plus details normally found in resumes, such as skills and qualifications, interests/hobbies, work experience etc. At any one time, an employer can have several positions open, and there will naturally be many applicants for each position. Applicants can be assigned to interviews for various positions, and can have first, second and even third interviews before they might be appointed to a position. The interview information needed by the Job agency includes the interview number (is it the 1st interview or 2nd...etc), who is attending the interview, the date time and location of the interview. The location can be physical or online, with appropriate adherence to the social distancing laws during the COVID-19 isolation. Therefore, location maybe at a physical location or an online invite to a communication medium that must provide audio and video capabilities (like Zoom and Skype). The success of an applicant's application in getting a job is also recorded. All this information needs to be stored in the database so that the job agency can keep track of employers, positions, applicants, applicant applications and interviews sessions. It is very important to the job agency that they have all this data so they can run regular reports on outstanding jobs and reports on applicants that have not been placed into a job. CASE STUDY "Want-2-Work" is a job placement agency. Like many other such agencies, their primary business is bringing applicants and employers together. There are many people with varying skills that are either unemployed and looking for a job or are currently unhappy with their current job who are looking for another job. There are also many employers with various jobs that they have within their company that they need to fill with the right applicants. The business has these two primary customer groups: employers and applicants. Employers provide position descriptions, i.e. jobs. This would include all the usual aspects such as the title of the positions, duties, required skills, required qualifications etc. etc. You may have seen position advertisements in the newspapers that provide these sorts of details. The job agency also maintains details about the applicants. All the usual personal details of course, plus details normally found in resumes, such as skills and qualifications, interests/hobbies, work experience etc. At any one time, an employer can have several positions open, and there will naturally be many applicants for each position. Applicants can be assigned to interviews for various positions, and can have first, second and even third interviews before they might be appointed to a position. The interview information needed by the Job agency includes the interview number (is it the 1st interview or 2nd...etc), who is attending the interview, the date time and location of the interview. The location can be physical or online, with appropriate adherence to the social distancing laws during the COVID-19 isolation. Therefore, location maybe at a physical location or an online invite to a communication medium that must provide audio and video capabilities (like Zoom and Skype). The success of an applicant's application in getting a job is also recorded. All this information needs to be stored in the database so that the job agency can keep track of employers, positions, applicants, applicant applications and interviews sessions. It is very important to the job agency that they have all this data so they can run regular reports on outstanding jobs and reports on applicants that have not been placed into a job.
Expert Answer:
Related Book For
Introduction To Chemical Engineering Tools For Today And Tomorrow
ISBN: 9780470885727
5th Edition
Authors: Kenneth A. Solen, John N. Harb
Posted Date:
Students also viewed these databases questions
-
Best Buy is losing signicant market share to online retailers. How should they promote themselves be=er to draw more people to come into the store to see/buy the products? What should they focus on...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
importance of workalike balance for women as a leader in healthcare. 1. The purpose of the research; 2. Research question/s; 3. Findings and relevant data; 4. Any recommendations and; 5. The...
-
1. Suppose that a particle moves along a straight line with acceleration a(t) =-6t+2 meters per second per second at time t seconds. Suppose that we fix the positive direction as motion to the right,...
-
Normal operating capacity of Robertson Inc. is 100,000 machine hours per month, the level used to compute the predetermined factory overhead application rate. At this level of activity, fixed factory...
-
The cumulative frequency of a category in a table is 25.5. Decide whether the statement makes sense (or is clearly true) or does not make sense (or is clearly false). Explain clearly.
-
Prepare a sales ledger control account from the following information for July 19X9, carrying down the balance at 31 July: 19X9 July 1 July 31 Sales ledger balances Sales journal 9,700 99,280 Bad...
-
Variable and fixed costs in the wine industry, decision making A Votre Sant: Product Costing and Decision Analysis in the Wine Industry3 Background A Votre Sant (AVS) is a small, independent winery...
-
Following question. TX Ltd has just paid a dividend of $1 per share. Dividends are expected to grow at 5% per annum for the future. Its shares are trading at $20. An ef?cient 11% return is...
-
The Carlson Department Store suffered heavy damage when a hurricane struck on August 31, 2003. The store was closed for four months (September 2003 through December 2003), and Carlson is now involved...
-
Which system do you use to make most decisions in your life? Which system should you use to make the most important decisions in your life? Is System 1 or System 2 more rational? Which system is the...
-
Common stock-$20 par value, 200,000 shares authorized, 80,000 shares issued and outstanding Paid-in capital in excess of par value, common stock Retained earnings Total stockholders' equity $...
-
Orwell Ltd is about to introduce a new product and hasestablished a target cost of $194 and a target margin on sales of40%. What is the target selling price (rounded to the nearest wholenumber)?
-
PSYCHOLOGY OF CULTURAL DIVERSITY QUESTIONS: 1. Discuss what you look to in order to decide whether or not someone's actions are discriminatory. At what point might you have determined that the...
-
The examination of biological evidence has changed over the last 20 years with the establishment of DNA labs within forensic science laboratory systems. An inevitable follow-up to DNA analysis is the...
-
A small, 2.00-g plastic ball is suspended by a 24.8-cm-long string in a uniform electric field as shown in the figure below. If the ball is in equilibrium when the string makes a 16.0 angle with the...
-
10. Rewrite the given logarithmic expressions: a. 27x3 1083 Vy b. log, x-3logy ---log, z 2
-
Arlington Merchants reported the following on its income statement for the fiscal years ending December 31, 2016 and 2015. 2016 2015 Sales $4,857,500 $4,752,900 Cost of goods sold 3,258,950 3,207,000...
-
Consider the gas-phase reaction How would each of the following affect the rate of that reaction? Explain each answer. a. The temperature of the reaction is increased. b. The pressure of the reaction...
-
Classify the following as either batch or continuous processes, and indicate whether each is a steady-state or an unsteadystate process: a. A "surge tank" is used when a liquid is coming from one...
-
In view of Equations 8.1 and 8.4, which describe molecular diffusion and mass convection, respectively, how would the rate of each type of transfer change if the difference in concentration of...
-
Sevilla Chemicals earned $1 billion in after-tax operating income on capital invested of $5 billion last year. The firms cost of equity is 12%, its debt-to-capital ratio is 25%, and the after-tax...
-
Stereo City is a retailer of stereos and televisions. The firm has operating income of $150 million, after operating lease expenses of $50 million. The firm has operating lease commitments for the...
-
Jeeves Software is a small software firm in high growth. The firm is all equity financed. In the current year, the firm earned $20 million in after-tax operating income on capital invested of $60...
Study smarter with the SolutionInn App