I have created the ER diagram. If there is anything wrong please leave messages. We have to find time to discuss. If there is nothing wrong, we should start to create tables and insert values and do some query testings.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2015-04-09
Hi everyone, I have written the SQL queries for creating tables and I have uploaded it here. Kindly have a look. If any changes, do let me know.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I found out the pictures should save as url not the picture it self. So I changed the pictures' type to varchar. And some of the attributes settings not long enough for the values. I already corrected them.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We should discuss the project ASAP. When you guys have time to meet and discuss?
Last edit: Xinyu Hu 2015-03-31
I have created the ER diagram. If there is anything wrong please leave messages. We have to find time to discuss. If there is nothing wrong, we should start to create tables and insert values and do some query testings.
Hi everyone, I have written the SQL queries for creating tables and I have uploaded it here. Kindly have a look. If any changes, do let me know.
Hi, I found out the pictures should save as url not the picture it self. So I changed the pictures' type to varchar. And some of the attributes settings not long enough for the values. I already corrected them.
--no text body--
Yue Shen and I finished the insert values part. I am working on the test queries part.
Hi everyone, when should we meet for the final presentation?