Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Give ER diagram and entity type that correspond to this relational representation. Your ER model should include just four entity types, namely, Staff , CompanyProject

Give ER diagram and entity type that correspond to this relational representation. Your ER model should include just four entity types, namely, Staff, CompanyProject, Machine and MachineTraining. The information as below.

image text in transcribed

image text in transcribed

model Engineering Company domains StaffNumbers = {S0001...S9999} Projectlds = {P0001...P9999) Machinelds = {M000...M999} Names = String Descriptions = String Grades = {1...5) Dates = standard dates relation Staff StaffNo: StaffNumbers Name: Names Grade: Grades AppointmentDate: Dates primary key StaffNo relation Company Project Projectld: Projectlds StartDate: Dates Estimated FinishDate: Dates Manager: StaffNumbers primary key Projectld alternate key Manager foreign key Manager references Staff constraint ((project Company Project over Projectld) difference (project WorksOn over Projectld)) is empty constraint ((project Company Project over Projectld) difference (project Machine over Projectld)) is empty relation Works On Projectld: Projectlds StaffNo: StaffNumbers primary key (Projectid, StaffNo) foreign key Projectld references Company Project foreign key StaffNo references Staff relation Machine Machineld: Machinelds Description: Descriptions DateOfLastService: Dates Projectld: Projectlds primary key Machineld foreign key Projectld references Company Project relation Machine Training Machineld: Machinelds StaffNo: StaffNumbers Date Of Training: Dates primary key (Machineld, StaffNo) foreign key Machineld references Machine foreign key StaffNo references Staff

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions

Question

What is conservative approach ?

Answered: 1 week ago

Question

What are the basic financial decisions ?

Answered: 1 week ago