Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Davis, Temple & Ute Temporary Employment Services (DTU) finds temporary job placements for applicants in the accounting, actuarial science, and supply chain fields. DTUs manager

  1. Davis, Temple & Ute Temporary Employment Services (DTU) finds temporary job placements for applicants in the accounting, actuarial science, and supply chain fields. DTUs manager gives you the following description of their business, with the hope that you will be able to convert their error-prone manual record keeping to a database-driven one:
  • DTU maintains a file of applicants who are willing to work.
  • If the applicant has worked before, that applicant has a specific job history. (Naturally, no job history exists if the applicant has never worked.) Each time the applicant works, one additional job history record is created. Job history records include work the applicant performed prior to joining DTU.
  • To be more in demand in the job market, applicants obtain qualifications. To be eligible for DTU placement, every applicant must have earned at least one qualification. Each qualification may be earned by more than one applicant. (For example, it is possible for more than one applicant to have earned a BBA degree or a Microsoft Certification. And clearly, an applicant may have earned both a BBA and a Microsoft Certification.). The date the qualification was earned is recorded as a detail associated with the qualification.
  • DTU offers training courses to help applicants obtain more qualifications.
  • Every course develops one specific qualification; however, DTU does not offer a course for every qualification. Some qualifications require multiple courses to be able to obtain that qualification (e.g. to be qualified in a foreign language beginner, intermediate, and advance courses are required).
  • Courses are taught during training sessions. A training session is the presentation of a single course. Over time, DTU will offer many training sessions for each course; however, new courses may not have any training sessions scheduled right away.
  • A training session can accommodate several applicants, although new training sessions will not have any applicants registered at first.
  • DTU also maintains a list of their clients, the companies that request temporary employees.
  • Each time a client requests a temporary employee, DTU makes an entry in an Openings folder. That folder contains an opening number, a client name, one required main qualification (Each opening requires only one specific or main qualification), a starting date, an anticipated ending date, and hourly pay.
  • When an applicant matches the desired qualification, the job is assigned, and an entry is made in the Placement folder. That folder contains an opening number, an applicant number, start date, end date and expected hours. In addition, an entry is made in the Job History folder for the placed applicant. An applicant can have multiple placements and each placement applies to only one applicant.

DTUs management wants to keep track of the following entities (hint: you will find that you also need to add additional associative entities - anywhere you initially have N:M relationships between entities):

  • CLIENT
  • OPENING
  • QUALIFICATION
  • APPLICANT
  • JOB_HISTORY
  • PLACEMENT
  • COURSE
  • TRAINING_SESSIO
  1. Draw a Crows Foot ERD, using proper notation, for the above scenario.
    1. Identify all possible relationships
    2. Identify the connectivity for each relationship. The relationship line should connect PK to FK and show the proper cardinality. The keys attribute name may be named in the problem narrative, or you may need to use a surrogate PK (e.g. ApplicantID)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems A Practictioner Emphasis

Authors: Cynthia D. Heagy, Constance M. Lehmann

10th Edition

1891002821, 9781891002823

More Books

Students also viewed these Accounting questions

Question

Why and how are people different from one another?

Answered: 1 week ago