Answered step by step
Verified Expert Solution
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
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
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