logo

Data Modeling Part B: Entity Relationship Diagram

11 Pages608 Words156 Views
   

Added on  2021-06-15

About This Document

Part B- Data Model Relational Database Design Person (FldPersonID, FldName, FldAddress, FldPhone, FldEmail, FldDOB, FldDrivingLicense, FldExpiryDate) Children (FldChildID, FldParentID, FldDestination, FldDriverID, FldParentPermission, FldDriverPermission) Foreign Key (FldDriverID) references Person (FldPersonID) TaxiTrip (

Data Modeling Part B: Entity Relationship Diagram

   Added on 2021-06-15

ShareRelated Documents
Student ID –Date -Assessment Item 2 - Assignment 2Module Tutor –1 | P a g e
Data Modeling Part B: Entity Relationship Diagram_1
ReportContentsPart A: Entity Relationship Diagram.........................................................................................3Part B- Data Model Transformation..........................................................................................4References................................................................................................................................112 | P a g e
Data Modeling Part B: Entity Relationship Diagram_2
Part A: Entity Relationship Diagram (Oracle. 2000)AssumptionsFollowing assumptions are sued while making the database design of RideShare--The taxi trip may be treated as optional trip.-The capacity of the car trip should be mentioned to adjust for optional trips in future.-The parents may be the driver of the trip.-The trip schedule for all week days should be saved into the database.-The permission of driver and parent in each trip is necessary.-In optional trip both driver’s permission is necessary i.e. old and new both. The taxi trip will be treated as optional trip and the parent will be treated as old driver. 3 | P a g e
Data Modeling Part B: Entity Relationship Diagram_3
Part B- Data Model TransformationRelational Database DesignPerson (FldPersonID, FldName, FldAddress, FldPhone, FldEmail, FldDOB, FldDrivingLicense, FldExpiryDate)Children (FldChildID, FldParentID, FldName, FldDOB, FldRelation)Foreign Key (FldParentID) references Person (FldPersonID)Trip (FldTripD, FldOrigin, FldDestination, FldDriverID, FldParentPermission, FldDriverPermission)Foreign Key (FldDriverID) references Person (FldPersonID)TaxiTrip (FldTripD, FldOptionalDriverID)Foreign Key (FldOptionalDriverID) references Person (FldPersonID)CarTrip (FldTripD, FldCapacity)TripMember (FldTripD, FldChildID, FldParentID)Foreign Key (FldTripD) references Trip (FldTripD)Foreign Key (FldChildID, FldParentID) references Children (FldChildID, FldParentID)TripSchedule(FldTripD, FldTripDay, StartTime, EndTime)Foreign Key (FldTripD) references Trip (FldTripD)AssignNewDriver (FldTripD, FldPermissionOriginalDriver, FldPermissionNewDriver, FldTripDate)Foreign Key (FldTripD) references TaxiTrip (FldTripD) (Guru99. 2016)4 | P a g e
Data Modeling Part B: Entity Relationship Diagram_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Entity Relationship Diagram and Data Model Transformation for RideShare Database
|10
|609
|489

ISYS1055 - Database Concepts | Assignment
|14
|1619
|106

Document on Entity Relationship Diagram (ERD)
|15
|3548
|37

Database Design in Oracle for Pet Net Online Library
|30
|4417
|90

Database Design
|30
|2273
|61