ER-Diagram: Stn_ID Station Stn_NAME 1 has Pid Name Tr No M Train M has Passsengers Tr id Stn ID Tr id Stop_id Stop_Name Stop 1 has has Tr id Route_id |Schedule has Route Sedl id) Sedl Route Route_Name...


Create a Crow's Foot ERD Model for a Train Station with these entities. I already did the ERD Diagram!


What are the Cardnitalities in the Diagram and give me an explanation for the Relationship?


Entities:



  •  Train

  •  Station

  •  Schedule

  •  Passengers

  •  Route

  •  Stop


ER-Diagram:<br>Stn_ID<br>Station<br>Stn_NAME<br>1<br>has<br>Pid<br>Name<br>Tr No<br>M<br>Train<br>M<br>has<br>Passsengers<br>Tr id<br>Stn ID<br>Tr id<br>Stop_id<br>Stop_Name<br>Stop<br>1<br>has<br>has<br>Tr id<br>Route_id<br>|Schedule<br>has<br>Route<br>Sedl id)<br>Sedl Route<br>Route_Name<br>Sedl_date<br>Route id<br>

Extracted text: ER-Diagram: Stn_ID Station Stn_NAME 1 has Pid Name Tr No M Train M has Passsengers Tr id Stn ID Tr id Stop_id Stop_Name Stop 1 has has Tr id Route_id |Schedule has Route Sedl id) Sedl Route Route_Name Sedl_date Route id

Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here