Individual Assignment Manoj Kumar Reddy Mule MM99806N@pac

.docx

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
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