Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. Create the ERD in Crow's foot notation to show the relationship between EMPLOYEE and JOB. 6. Create the relational diagram to show the relationship
5. Create the ERD in Crow's foot notation to show the relationship between EMPLOYEE and JOB. 6. Create the relational diagram to show the relationship between EMPLOYEE and JOB. 7. Describe the type(s) of relationship(s) between EMPLOYEE and PROJECT. (hint: there are 8. Create the ERD in crow' s foot notation to show the relationships among EMPLOYEE, 9. Write expressions in the Relational Algebra language to answer the following queries. two relationships between them: participate and manage)- ASSIGNMENT, and PROJECT. 1) Find EMP_NUM of the employees who participate the project with PROJ_NUM-15+ 2) Find FNAME, LNAME, and JOB_DESCRIPTIONM of the employee with EMP NUM-108 3) Find FNAME, LNAME, JOB_DESCIPTION, and JOB_CHG_HOUR of the manager of the project 'Rolling Tide'. system analyst') analysts (hint: use the answers from 1) and 4))- 4) Find EMP_NUM of the employees who are system analysts (Hint: job description is 5) Find EMP_NUM of the employees who participate PROJ NUM-15, but not system
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