vont请进, 寻求帮忙

杂烩饭. · 发表于 2014-6-18 21:54:21

lz学生？我housemate一个学生也是学会计的，上半年做过一个，要求设计一些酒店订房的表和显示房间情况的report。

zhaokai. · 发表于 2014-6-18 22:59:55

是啊我是学生, 读会计好痛苦的.
VONT你受到我的EMAIL 了吗?

vont. · 发表于 2014-6-18 23:43:17

I have a quick look. Have you designed the tables?
The idea is to design the tables first. You should have several tables.
For example:
Table: Customer
Customer ID(pk), name, address,email, CC
Table: Meal
Meal ID,(pk) name, price, description
Table: Delivery
Delivery Method(PK), Price
Table: Order
Cusomter ID(FK),Meal ID(FK), quantity, Date, Delivery Method(FK)
Now, when you want to do any queries, just join the tables together according to the primary keys. For example, you could creat a view(quiey) called Delivery Cost by joining table Delivery and Order.
Well, you could have other structures for different tables. I did not read your assignment in details. It is just the idea about how to do that.