Draw an entity relation diagram using the crows foot

Assignment Help Computer Engineering

Reference no: EM133370952

Draw an entity relation (E-R) diagram using the Crow's foot symbols that models the problem for the given case study. This will include:

Summarise the ERM's components, and names the entities and their relationship (Sample ERM component is given below)

Table 4.4	Components of the ERM
Entity	Relationship	Connectivity	Entity
SCHOOL	operates	1:M	DEPARTMENT
DEPARTMENT	has	1:M	STUDENT
DEPARTMENT	employs	1:M	PROFESSOR
DEPARTMENT	offers	1:M	COURSE
COURSE	generates	1:M	CLASS
SEMESTER	includes	1:M	CLASS
PROFESSOR	is dean of	1:1	SCHOOL
PROFESSOR	chairs	1:1	DEPARTMENT
PROFESSOR	teaches	1:M	CLASS
PROFESSOR	advises	1:M	STUDENT
STUDENT	enrolls in	M:N	CLASS
BUILDING	contains	1:M	ROOM
ROOM	is used for	1:M	CLASS

all entities, relationships (including names) and attributes that are relevant,
primary keys identified, and
include relationship participation - participation (optional / mandatory) symbols and cardinality.

The E-R diagram should be completed using the standards of this unit. Use Draw.io to create the E-R diagram.

Case Study

Temporary Employment Registers is an Australian Government service from Careers@Services (CAS) Australia that places the temporary workers in companies. Their registers are open to people how are interested in non-ongoing or irregular employment with the government services. The temporary service office manager gives you the following description of the business:

CAS has a file of candidates who are willing to work. If the candidate has worked before, that candidate 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, it is possible for more than one candidate to have earned a Bachelor of Business Administration degree or a Microsoft Network Certification. And clearly, a candidate may have earned both a BBA and a Microsoft Network Certification. CAS offers courses to help candidates improve their qualifications. Every course develops one specific qualification; however, CAS does not offer a course for every qualification. Some qualifications have multiple courses that develop that qualification. Some courses cover advanced topics that require specific qualifications as prerequisites. Some courses cover basic topics that do not require any prerequisite qualifications. A course can have several prerequisites. A qualification can be a prerequisite for more than one course. Courses are taught during training sessions. A training session is the presentation of a single course. Over time, CAS will offer many training sessions for each course; however, new courses may not have any training sessions scheduled right away. Candidates can pay a fee to attend a training session. A training session can accommodate several candidates, although new training sessions will not have any candidates registered at first. CAS also has a list of companies that request temporaries. Each time a company requests a temporary employee, CAS makes an entry in the Openings folder. That folder contains an opening number, a company name, required qualifications, a starting date, anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification. When a candidate matches the qualification, the job is assigned, and an entry is made in the Placement Record folder. That folder contains an opening number, a candidate number, and total hours worked. In addition, an entry is made in the job history for the candidate. An opening can be filled by many candidates, and a candidate can fill many openings. CAS uses special codes to describe a candidate's qualifications for an opening. The list of codes is shown in Table 1.

TABLE 1: CAS QUALIFICATION CODES

CODE	DESCRIPTION
PRG_VB	Programmer, Visual Basic
PRG_C++	Programmer, C++
DBA_ORA	Database Administrator, Oracle
DBA_DB2	Database Administrator, IBM DB2
DBA_SQLSERV	Database Administrator, MS SQL Server
SYS_1	Systems Analyst, level 1
SYS_2	Systems Analyst, level 2
NW_NOV	Network Administrator, Novell experience
WD_CF	Web Developer, ColdFusion
WD_HTML_CSS	Web Developer, HTML CSS

Reference no: EM133370952

Questions Cloud

Explain how machine learning affects our daily life : Explain how Machine Learning affects our daily life? Provide at least one example.

Create a relationship report for the sports physical therapy : create a Relationship report for the Sports Physical Therapy database for your own reference. Use Database Design Language to identify the relationships

Create two inputs and label them : Create two inputs and label them A, and B 2. Create an output called Sum - When the result of your addition overflows, put that overflow into your carry out

Stretch you google skills : Stretch you Google skills or go back to that favorite movie you just realized has a favorite clip that is about the learning this session

Draw an entity relation diagram using the crows foot : Draw an entity relation diagram using the Crows foot symbols that models the problem for the given case study.

How a health system dealt with the covid-19 pandemic : How a health system dealt with the COVID-19 pandemic. How did Kotter's eight-stage paradigm for leading change guide the leadership through the transformation?

What is the time complexity of your algorithm : false if no such key exists in the tree. Describe your algorithm in pseudocode. What is the time complexity of your algorithm

Computer stores numeric values internally : Describe three different ways the computer stores numeric values internally.

Give a sizable amount to either wwf or nrdc : give a sizable amount to either WWF or NRDC. Just based on their website user experience which site would you fund, and why

User Account

All Pages