Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sketch an ER diagram to represent the aspects of a job - hunting website described below. Note that your diagram should not be an Extended
Sketch an ER diagram to represent the aspects of a jobhunting website
described below. Note that your diagram should not be an Extended ER EER
diagram, so there should be no inheritance, aggregation, or weak entities.
Users have unique usernames, and we also store their password hash,
name, date of birth, email, phone number, and permanent address.
Documents are identified by a unique document ID and we also store a
title, document type eg resume, letter of recommendation, etc. owner
required one of our users last update time, and file name.
Employers are identified by a unique company ID and we also store an
name, industry, address, and company description.
Positions are identified by a unique position ID and we also store a title,
description, and application deadline.
Every position will be posted by an employer, and we keep track of when
each position is posted. The same employer may post multiple positions.
Users may apply to positions. Users may apply to more than one position,
and multiple users may apply to the same position.
Users documents may be submitted for positions. The same document
could be submitted to multiple positions, and a user could submit multiple
documents for the same position
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