WEEK 2.2 1 ASSIGNMENT

docx

School

Bellevue University *

*We aren’t endorsed by this school

Course

535

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by Manojmanu7

Report
CIS 535-T301 MANAGEMENT AND DESIGN OF DATA BASE WEEK 2 ASSIGNMENT STUDENT NAME: MANOJ KUMAR MARRIBOYINA STUDENT ID: 21430414 PROFESSOR: PATRICK NIELAND
Problem 1: For each table in the database above, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. Use the following format to show your answers. TABLE PRIMARY KEY FOREIGN KEY EMPLOYEE EMP_ID JOB_ID BENEFIT BENEFIT_ID EMPLOYEE_ID+PLAN_ID JOB JOB_ID NONE PLAN PLAN_ID NONE 2.Create   Crow's foot   to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
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

Related Documents

Lab - Financial Statements.docx
CYB_230_Module_Two_Lab_Bailey_Holly.docx
Annie CRM Assignment.doc
CYB_240_Module_One_Bailey_Holly.docx
CYB_240_Module_Four_Lab_Bailey_Holly.docx
CYB_240_Module_Seven_Project_Two_Bailey_Holly.docx
CYB_240_Module_Three_Project_Two_Bailey_Holly.docx
CYB_240_Module_Three_Lab_Bailey_Holly.docx
Lab Activity Measuring Species Diversity Spring 2022.pdf
Assignment_III (1).pdf
ValenciaA_BUSN600week5.docx
Comp 1 Pre test essay questions - PSCI 2306.docx
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
SEE MORE TEXTBOOKS