| Class Time: | 2:00 PM-3:15 PM Tuesday and Thursday. | |
| Location: | 119 McAdams Hall | |
| Instructor: | Dr. James Z. Wang | |
| Office: | 305 McAdams Hall | |
| Phone: | 864-656-7678 | |
| Email: | jzwang@cs.clemson.edu | |
| Office Hours: | 1:00 PM-2:00 PM Tuesday and Thursday. | |
| Syllabus: | http://www.cs.clemson.edu/~jzwang/0901462/syllabus.pdf |
| Date | Teams |
| 04/14/2009 | Team 1, 2, 3, 4 |
| 04/16/2009 | Team 5, 6, 7, 8 |
| 04/21/2009 | Team 9, 10, 11, 12 |
| 04/23/2009 | Team 13, 14 |
Thursday, April 30, 9:00AM to 10:30AM
| 01/07: | Introduction | |
| 01/12: | ER Model and Database Design | |
| 01/20: | Relational Model | |
| 02/02: | SQL and MySQL | |
| 02/10: | Relational Schema and SQL Queries | |
| 02/24: | Relational Algebra | |
| 03/03: | HTML Basics | |
| 03/05: | HTML Forms | |
| 03/10: | PHP Programming | |
| 03/26: | Views, Constraints, Triggers and Index | |
| 03/31: | Stored Procedure | |
| 04/2: | PHP MySQL Functions |
| 01/07: | Project Description | |
| 01/07: | Please form your project team by January 15, 2009. You need to select a team leader who should email me all names in your team and their contact information. | |
| 01/25: | Project phase #1: ER diagram is due by 11:59PM on Sunday, February 8, 2009. Your submission must include a cover page listing the team number and member names. You should submit your ER diagram in PDF file format and name the file as "p1tX.pdf" in which "X" is your team number. That is, team 4 should name their file as "p1t4.pdf". Please submit your project using Digital Dropbox in blackboard.
Each team member must also evaluate the other teammates the project is submitted. However, each team member should send me his/her evaluation on his/her teammates through email, not via digital dropbox. Please download the evaluation form here, and finish one evaluation for each of your teammates. Here is a sample evaluation. Please rename the file to include the team number and the member name when you submit your evaluation. |
|
| 02/02: | A extremely simple MeTube system can be downloaded from here. You can use the sample code as your project's starting point. | |
| 02/13: | Project phase #2: Database Schema is due by 11:59PM on Tuesday, February 24, 2009. You can describe your database schema by table format, that is, desribe each relational table using the same format as given by the MySQL DESCRIBE statement. You can also use mysqldump (run through unix shell) or use phpMyAdmin's export function to dump the database schema into a text file. You need to add necessary comments for all tables of your database schema. Your comments should simply describe the purpose of the table and the degree of the normalization. You must try your best to convert all tables into 5NF. If a table is better to stay at the lower degree of normalization, please state the reasons. You may need to revise your ER diagram during the creation of your database schema. If you revise your ER diagram, please submit your ER diagram with your database schema. Please ZIP all your files into one single file before submission. Your submission must include a cover page indicating the team number and member names. You should name the file as "p2tN.xxx" in which "N" is your team number. That is, team 4 should name the file as "p1t4.xxx", where "xxx" is the file extension. Please submit your project using Digital Dropbox in blackboard. Each team member must also evaluate your teammates when you submit your project. However, you should email me your evaluation forms instead of submitting them using digital dropbox. Please download the evaluation form here, and finish one evaluation for each of your teammates. Here is a sample evaluation. Please rename the file to include the team number and the member name when you submit your evaluation. |
|
| 03/04: | Project phase #3: SQL Queries is due by 11:59PM on Thursday, March 26, 2009. You are required to study YouTube and project description carefully to identify all functions that will be provided by your MeTube system. For each function, please write the necessary MySQL queries and test them with dummy data. You need to add necessary comments for all queries you write. Your comments should describe the relationship between the qureies and the related MeTube functions. If one MeTube function requires more than one MySQL queries to complete, please state the reason. Please also list the MeTube functions that do not require MySQL queries and state why no database access is needed for such queries. You may need to revise your ER diagram and database schema when you design the MySQL queries. If you revise your ER diagram or DB Schema, please submit the new ER diagram and database schema with your queries. Please ZIP all your files into one single file before submission. Your submission must include a cover page indicating the team number and member names. You should name the file as "p3tN.xxx" in which "N" is your team number. That is, team 4 should name the file as "p3t4.xxx", where "xxx" is the file extension. Please submit your project using Digital Dropbox in blackboard. Don't send it by email. Each team member must also evaluate your teammates when you submit your project. However, you should email me your evaluation forms instead of submitting them using digital dropbox. Please download the evaluation form here, and finish one evaluation for each of your teammates. Here is a sample evaluation. Please rename the file to include the team number and the member name when you submit your evaluation. |
|
| 03/31: | Project phase #4: Final Report and Demonstration are due by 9:00AM on Friday, April 24, 2009. You should have completed your project by then. You are required to submit your source code, a technical report and presentation slides. Your technical report should include system design, ER diagram, database schema, function design, implementation details, test cases, testing results, and user manual or instruction.
You must zip all your files into a single ZIP file. Your submission must include a cover page indicating the team number and member names. You should name the file as "p4tN.xxx" in which "N" is your team number. That is, team 4 should name the file as "p4t4.xxx", where "xxx" is the file extension. Please submit your document using Digital Dropbox in blackboard. Don't send it by email. Each team member must also evaluate your teammates when you submit your project. However, you should email your evaluation forms to the instructor instead of submitting them using digital dropbox. Please download the evaluation form here, and finish one evaluation for each of your teammates. Here is a sample evaluation. Please rename the file to include the team number and the member name when you submit your evaluation. You also need to sign up a time to demonstrate your project on or before April 24, 2009. In your demonstration, you will be asked to go through most of your test cases. The instructor may also ask you to test certain functions with certain input. |
| Team 1: | Gent Kepuska, Harold Gray, John Benton (Undergraduate) | |
| Team 2: | Cody Gentry, Steve Shay, Thomas Henry (Undergraduate) | |
| Team 3: | Varun Madan, Rahul Sharma, Austin Davis (Undergraduate) | |
| Team 4: | Shalika Jain, Ankit Yadav, Mahak Jain (Undergraduate) | |
| Team 5: | Wallace O'Rear, Sumedha Jain, Vaibhav Jain (Undergraduate) | |
| Team 6: | Joshua Canter, Matthew Woodruff, Brandon Kagey (Undergraduate) | |
| Team 7: | Ross Broyles, Richard Harris, Micah Lee (Undergraduate) | |
| Team 8: | Akshay Vats, Shruti Biradar, Troy Witthoeft (Undergraduate) | |
| Team 9: | Nupur Bindal, Naveen Gakhar, Joshua Toney (Undergraduate) | |
| Team 10: | Subha Arulselvam, Srikanth Gadde (Graduate) | |
| Team 11: | Venkata Sai Krishna MAJETI, Varun MANNAR (Graduate) | |
| Team 12: | Manas Karekar, Sumanth Lingala (Graduate) | |
| Team 13: | Prudhviraj Karumanchi, Bhanu kishore kamapantula (Graduate) | |
| Team 14: | Ameet Gadvi, Prakhyath Rajanna (Graduate) |
“As members of the Clemson University community, we have inherited Thomas Green Clemson’s vision of this institution as a “high seminary of learning.” Fundamental to this vision is a mutual commitment to truthfulness, honor, and responsibility, without which we cannot earn the trust and respect of others. Furthermore, we recognize that academic dishonesty detracts from the value of a Clemson degree. Therefore, we shall not tolerate lying, cheating, or stealing in any form. In instances where academic standards may have been compromised, Clemson University has a responsibility to respond appropriately and expeditiously to charges of violations of academic integrity.”
“When, in the opinion of a faculty member, there is evidence that a student has committed an act of academic dishonesty, the faculty member shall make a formal written charge of academic dishonesty, including a description of the misconduct, to the Associate Dean for Curriculum in the Office of Undergraduate Studies. At the same time, the faculty member may, but is not required to, inform each involved student privately of the nature of the alleged charge.”