Design database tables

[Gang944]

I finished the ERD of the traveler, I have some questions about ordering food table. So there is no order form in ERD.

[IGPD]

I think the data should be expressed in different graphs, and the tables are too single.

[Asunamm]

[Gang944]

I think the data should be expressed in different graphs, and the tables are too single.

Good idea. Which graphs do you think is a nice choose for our project?

[IGPD]

I think the data should be expressed in different graphs, and the tables are too single.

Good idea. Which graphs do you think is a nice choose for our project? According to the way of data expression to decide the choice of graphics, such as rectangle to express differences.

[Wanghaoyi123]

The relation between the tables is too single, we can find more relation in the design.

[Asunamm]

@jslemmer for example, the picture as a database table. So, if I just wanna show the NAME xxx on the website, other data is not needed, how can I code? when I code "SELECT name FROM the customer" in php file, how can I code to show the xxx in somewhere with the html code like

.

[9sa6c]

echo $row[name] ?

I do not really understand your question

[Asunamm]

@jslemmer emmmm, echo $row[name] it give all the customer name, I just want the name of customer only one, on the customer name list.

[9sa6c]

WHERE ID = 1 ?

If you want to make a selection, you need a WHERE clause

[IGPD]

Database (1).zip

[9sa6c]

What is the point of just throwing a file here without any additional comment or text?

[IGPD]

Database (1).zip

This is the database, based on ERD.

[9sa6c]

Then explain that to your group members and ask them if there is any suggestion or if they have feedback?

[IGPD]

Then explain that to your group members and ask them if there is any suggestion or if they have feedback?

Yes

[9sa6c]

Do there here in this issue, not somewhere else

On Wed, Apr 22, 2020 at 1:19 PM IGPD notifications@github.com wrote:

Then explain that to your group members and ask them if there is any suggestion or if they have feedback?

Yes

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Gang944/2020-GPW-L5K2-D/issues/1#issuecomment-617556393, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD2SKY4UMTRYHSXELQV53RTRNZ44XANCNFSM4MGY2UMA .

[Asunamm]

Still not found the chart on week20. Can teacher send us the code by email on student website？

[Wanghaoyi123]

I finished the ERD of the traveler, I have some questions about ordering food table. So there is no order form in ERD.

We should add the table for ordering food, which I will add later.

[Wanghaoyi123]

This is the ERD for ordering food

[Wanghaoyi123]

This is the Table in the database about ordering food

[9sa6c]

You have not asked me an actual question. But there is not relationship between user and food table. Where is the relationship?

Just because you draw a line does not mean you have created a relationships. And what kind of relationship should this be?

[Wanghaoyi123]

The relationship between customer and food time should be one to many. I will re-upload the relationship picture after the change