Convert the following E-R diagram to relational database model. Supply your expl
ID: 3857172 • Letter: C
Question
Convert the following E-R diagram to relational database model. Supply your explanations along with the diagram
WorkRecord PK WorkNum ServiceRequest Techlnitials WorkDate StartTime FinishTime WorkDescription PK ReqNum Is Performed On ReportDate ResolutionDate ProblemDescription ReportedBy Client PK ClientID EquipType has PK Equip Type ClientName ContactLastName ContactFirstName Address City State Zip Phone Email Equipment Configuration PK EquipName InserviceDate ---Has- Equipment InfoName InfoValues EquipmentComponentIs Composed Of ls Comsed Of ComponentType Quantity Datelnstalled DateRemoved PK ComponentTypeH-is-e Inventory PK Barcode ModelNunm Description DatePurch VendorExplanation / Answer
Please find below relational model for the ER diagram mentioned above:
We have created relations between tables by making foreign keys according to relationships (many to one) depicted in diagram.
Since no primary key was mentioned in table EquipmentComponent ,therefore we have created the primary key in table named as EquipCompNum.
Primary key is unique key that is used to identify a table. Foreign keys are used to build the relationships between tables.
We have build the relationships between tables as per depicted in diagram.
Primary key of one table used in other table as foreign key like ClientID primary key in table Client but foreign key in tables Configuration, Equipment and ServiceRequest.
Likewise, EquipNum primary key in table Equipment but foreign key in tables ServiceRequest and EquipmentComponent.
And likewise many more foreign keys are there in tables as per diagram.