Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

OVERVIEW This lab requires that you use Microsoft Visio to complete an Entity Relationship Diagram. Microsoft Visio is available to you in VLABS or you

OVERVIEW

This lab requires that you use Microsoft Visio to complete an Entity Relationship Diagram.

Microsoft Visio is available to you in VLABS or you may decide to obtain the software for your own personal use. Microsoft Visio software is available free of charge through Penn States subscription of Microsoft Imagine. If you are interested in obtaining your own free copy of Visio, please refer to the link Microsoft Imagine under Lesson 00: Orientation.

Assignment: Case # 12 from Chapter 4 of the textbook. The case study is Temporary Employment Corporation.

With the use of Microsoft Visio, draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, dependencies, and resolved M:N relationships..

In addition, be sure to include a heading on your ERD with a brief descriptive title, your name, and a date.

image text in transcribed

image text in transcribed

ities, and participations. 12. During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC's manager gives you the following description of the business: TEC has a file of candidates who are willing to work. Any candidate who has worked before has a specific job history. (Naturally, no job history exists if the candidate has never worked.) Each time the candidate works, one additional job history record is created Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, more than one candidate may have earned a Bachelor of Business Administration degree or a Microsoft Net- work Certification, and clearly a candidate may have earned both a BBA and a Microsoft Network Certification.) TEC offers courses to help candidates improve their qualifications. Every course develops one specific qualification; however, TEC does not offer a course for every qualification. Some qualifications are developed through multi ple courses. Some courses cover advanced topics that require specific qualifications as pre- requisites. Some courses cover basic topics that do not require any prerequisite ities, and participations. 12. During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC's manager gives you the following description of the business: TEC has a file of candidates who are willing to work. Any candidate who has worked before has a specific job history. (Naturally, no job history exists if the candidate has never worked.) Each time the candidate works, one additional job history record is created Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, more than one candidate may have earned a Bachelor of Business Administration degree or a Microsoft Net- work Certification, and clearly a candidate may have earned both a BBA and a Microsoft Network Certification.) TEC offers courses to help candidates improve their qualifications. Every course develops one specific qualification; however, TEC does not offer a course for every qualification. Some qualifications are developed through multi ple courses. Some courses cover advanced topics that require specific qualifications as pre- requisites. Some courses cover basic topics that do not require any prerequisite

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

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

More Books

Students also viewed these Databases questions

Question

Explain the forces that influence how people handle conflict

Answered: 1 week ago