Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started