search

Hilary777 / 2020-GPW-L5K1-D

The Chengdu Bus Company Project
0 stars 0 forks source link

design database tables #1

Open 9sa6c opened 4 years ago

9sa6c commented 4 years ago

Please create an ERD and share here

Hilary777 commented 4 years ago

Beck and I completed the ERD design and we uploaded it to github

9sa6c commented 4 years ago

You can also upload it in this issue as a picture, so your group members can see it easily and comment on it

Hilary777 commented 4 years ago

ERD2 Thishis is ERD for project

9sa6c commented 4 years ago

I suggest you to pay more attention to "bus route". A route usually has stations or stops. What kind of relationship would that be? Can a route have multiple stations/stops and can a station/stop be part of multiple routes?

Also you do not have to save the ticket price. From the requirements you can see that it needs to be calculated. Please review that aspect.

beckyzhang123 commented 4 years ago

ERD2 Thishis is ERD for project

~A7LB3T`DYQLNOZ`MXSAJAO

Hilary777 commented 4 years ago

ERD3 New ERD

Lizzy-Pan commented 4 years ago

The new one is much better than the old one. It's clearer.

RichardLliu commented 4 years ago

I suggest that we create another table for all stations, as Jons mentioned, one route could have several stations.

RichardLliu commented 4 years ago

ERD