Week10 – Database design

Last week, I was learning on week10 lecture and subject materials that is talking about the Advanced Databases: Modelling and SQL Joins.

According to my final project system plan, I created my database. There are sixes tables. The following diagram shows the relationships between each other.


Not only listing the relationship, but also listing the primary key and foreign key among these tables. Table tab_restaurant, tab_menu, tab_type and tab_image are used to store the information about restaurant. Table tab_order is used to record the customer's order and its status. Table tab_message is to record leaving message from customer. I'm still thinking about create the administrator account in order to better manage the web system.