Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3) Use the following scenario to create an ERD in Visio. Then: a) Copy the drawing and paste it into the space provided below the

3) Use the following scenario to create an ERD in Visio. Then: a) Copy the drawing and paste it into the space provided below the scenario. b) Convert the ERD into a set of tables (make sure to use solid underline for primary keys and dashed underline for foreign keys.) St. Pete Head Hunter (SPHH) places temporary workers in companies. SPHH has a file of candidates who are willing to work. For each candidate there is a unique number, name, address, phone, and email. If the candidate has worked before, that candidate has a specific job history. (Therefore, no job history exists if the candidate has never worked.) Each time the candidate works, one additional job history record is created. For each job history, SPHH wants to record a unique number, start date, end date, and cost. The database must capture information about the types and descriptions of different qualifications. Each candidate has one or more qualifications. Each qualification may have been earned by more than one candidate. (For example, it is possible for more than one candidate to have earned a Bachelor of Business Administration degree or a Microsoft Network Certification.) If a candidate has a qualification, the date on which the qualification earned must be captured. SPHH offers courses for several qualifications. A course develops exactly one qualification. A qualification can be obtained by different courses, and not all qualifications can be obtained by courses. For each course, the unique course number, name, description, and duration must be recorded. Courses are taught during training sessions. A training session is characterized by a session number, start date, and fee. A training session is the presentation of a single course. Over time, SPHH offers many training sessions for each course; however, new courses may not have any training sessions scheduled right away.

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

Database And Transaction Processing

Authors: Philip M. Lewis, Arthur Bernstein, Michael Kifer

1st Edition

0201708728, 978-0201708721

More Books

Students also viewed these Databases questions

Question

Why did ancient cultures study the constellations? Discuss.

Answered: 1 week ago

Question

6-5 How will MIS help my career?

Answered: 1 week ago

Question

=+ Who is the negotiation partner at company level?

Answered: 1 week ago

Question

=+Which associations exist?

Answered: 1 week ago