Individual Assignment Manoj Kumar Reddy Mule MM99806N@pac.edu U01942405
docx
keyboard_arrow_up
School
Pace University *
*We aren’t endorsed by this school
Course
623
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by DukeTitanium12326
Manoj Kumar Reddy Mule MM99806N@pac.edu
U01942405
Individual Assignment
3.1 Consider the entity set Employee with attributes: empId, socSecNo, empName, jobTitle, and salary.
Employee:
Emp ID
SocSec no Emp name
Job title
Salary
Step 3.1.a – Identify all candidate keys for the Employee entity set.
Write out the candidate keys.
Candidate key :
is a super key with no redundant data.
Here Emp Id
and SocSec no
will come under the Candidate key.
Step 3.1.b – Show how the Employee entity set and its attributes would be represented on an E-R diagram.
Step 3.1.c – Identify the primary key for the Employee entity set and underline it on the
E-R diagram.
Write out the primary key and underline it on the E-R Diagram.
Employee
Job title
Emp name
SocSec No
Sedc
Salary
Emp Id
Manoj Kumar Reddy Mule MM99806N@pac.edu
U01942405
Here Emp Id will be the Primary Key for the project entity.
Step 3.2 – Assume in the same enterprise, that there is a second entity set called Project
with attributes projName, startDate,endDate, and budget.
Project:
Project Name
start Date
end Date
budget
Step 3.2.a – Show how the Project entity set and its attributes and its relationship to Employee would be represented on the E-R diagram.
Many to Many
Step 3.2.b – Identify the primary key for the Project entity set and underline it on the E-
R diagram.
Assume you want to represent the number of hours an employee is assigned
to work on a project. Show how this would be represented on the E-R diagram.
Here project Name
will be the Primary Key for the project entity.
Job title
Emp name
SocSec No
Sedc
Emp Id(Primary
Key)
Salary
Employee
Job title
Emp name
SocSec No
Sedc
Salary
Emp Id
Employee
Start date
End date
Project
Budget
Project Name
Manoj Kumar Reddy Mule MM99806N@pac.edu
U01942405
M
Many to Many
M
Step 3.2.c – Stating any necessary assumptions, make a decision about the cardinality and participation constraints of the relationship between Employee and Project, and add the appropriate symbols to the E-R diagram.
M
M
Job title
Emp name
SocSec No
Sedc
Salary
Emp Id
Employee
Hours
No.of Hours
End date
Start date
Project
Budget
Project Name(primary Key)
Project
Employee
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Manoj Kumar Reddy Mule MM99806N@pac.edu
U01942405
Step 3.3 – Assume in the same enterprise, that there is a third entity set called Department with attributes: deptNo, deptName and mrgName.
Department :
Dept No
Dept name
Manager Name
Step 3.3.a - Show how the Department entity set and its attributes and its relationship to Employee would be represented on the E-R diagram.
1
M
Step 3.3b - Identify the primary key for the Department entity set and underline it on the E-R diagram.
Assume that each employee works for only one department. Projects are not directly sponsored by a department. Show how this would be represented on E-
R diagram.
Here Dept No
will be the Primary Key for the Department entity.
1
M
M
M
Dept No
Dept Name
Manager Name
Department
Employee
Dept
No(Primary
key
Dept Name
Manager Name
Department
Dept No(Foreign Key)
Employee
Project