Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help make an ER-Diagram of the following entities and their relationships? Cardinality and participation would be highly appreciated. Thanks Person(per_id, name, address*, zip_code,

Can someone help make an ER-Diagram of the following entities and their relationships? Cardinality and participation would be highly appreciated. Thanks

image text in transcribed

Person(per_id, name, address*, zip_code, email, gender, {phone}) where per_id is a the primary key. Job_category(cate_code, title, description, pay_range_high, pay_range_low, {core_skill}, parent_cate) where cate_code is a unique identifier, and core_skill refers to one or multiple skills represented by k_code. Parent_cate is a cate_code representing a higher level category that the current one belong to. Position(pos_code, emp_mode, {required_skill}, pay_rate, pay_type, cate_code, company, more ...). where pos_code is a unique identifier, emp_mode can be full-time, part-time, and pay_type can be wage or salary, pay_rate is the hourly rate for wage or annual pay for salary. When the position belongs to multiple cate_codes in a hierarchy, you should choose the most specific one, the one that is closest to a leaf node. Company(comp_id, address*, zip_code, primary_sector, {speciality}, website) Where primary_sector refers to the business sector the company belongs to, such as tourism, oil and mining, entertainment, service, education, technology. Specialities can be construction, logistics service, computer hardware, software, electronics, basic materials, IT consulting, transportation. Course (c_code, title, level, description, status, retail_price) where c_code is a unique identifier, and status is either active or expired. Secion(c_code, sec_no, complete_date, year, offered_by, format, price) Where the triple (c_code, sec_no, year) form a unique identifier for every section, format can be (classroom, online-sync, online-selfpaced, or correspondence), offered_by refers to a university or a training company. Knowledge_Skill(ks_code, title, description, level) where ks_code is a unique identifier (you may use the skill code defined by the Department of Labor), and level can be beginner, medium or advanced. In addition, many relationships are needed. A few of them are listed below. Works(per_id, pos_code, start_date, end_date) where start_date

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

Expert Oracle Database Architecture

Authors: Thomas Kyte, Darl Kuhn

3rd Edition

1430262990, 9781430262992

More Books

Students also viewed these Databases questions