|
Last Update: Nov 24, 2008 @1905hrs Coordinates Lectures and Labs Lectures on Mondays 1600hrs – 1750hrs in Room 2503
Lab Section 1 on Tuesdays 1200hrs – 1450hrs in Room 3207
Lab Section 2 on Thursdays 1200hrs – 1450hrs in Room 3207 Instructor Andrew Lim | Email:
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
| Office: 5543 | Office hours: 1000-1145 Thurs Teaching Assistants Qi WEN (Email:
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
) Office Hours:TBA
Tel: 2358-7117 | Yanfen SHANG (Email :
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
) Office Hours:TBA
Tel: 2358-8638
| Tiger QIN (Email :
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
) Office Hours:TBA
Tel: 2358-7117 | Feng Zhen (Email :
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
) Office Hours:TBA
Tel: 2358-8963
|
Grading Criteria (tentative) Class Participation
(Max of 10% of final grade) | : | 0.1% per coup | Homeworks | : | 10% | Laboratory Exercises and Project | : | 30% | Mid Term Exam
| : | 30% | Final Exam | : | 30% |
Late Policy Scores of late assignments will be deducted at rate of 10% per late-day. For example, if your assignment is FOUR days late, your recorded score will be (100% - 4 X10%) of the score of your work Not doing your own work (“Cheating”) Cheating will not be tolerated. Appropriate action will be taken. Lesson Schedule (Room 2503)
Lesson 1
Sept 1, 2008
Slides
Project Part2 (due on Sept 22 instead of 15)
journalpapers | Topics
Course Co-ordinates;
Introduction and Motivation;
Importance of Data, Functional IT;
Introduction to project theme;
Formation of project groups: | Lesson 2 Sept 8, 2008
Slides
(Sept 15 is a public holiday)
|
Functional IT, and Process IT, and Enterprise IT;
Coceptual Modeling
| Lesson 3 Sept 22, 2008
Slides
| ER Model
| Lesson 4 Sept 29, 2008
Slides
Class Exercise | ER Model
| Lesson 5 Oct 6, 2008
Slides
| Normalization
| Lesson 6 Oct 13, 2008
Slides | Revision for Mid-Term
| Lesson 7 Oct 20, 2008 | Mid-Term Exam Covers topics from Lecture 1 to Lecture 5. | Lesson 8 Oct 27, 2008
Slides
| Relational Algebra | Lesson 9 Nov 3, 2008
Slides
world.sql.zip
Homework | SQL 1
| Lesson 10 Nov 10, 2008
| SQL 2 No new slides | Lesson 11 Nov 17, 2008
Slides | SQL 3
| Lesson 12 Nov 24, 2008
| Office Hours and Consultation
1400-1550hrs (RM 5543)
1600-1730hrs (RM 2503) | Lesson 13 Dec 1, 2008 2007 Final Exam | Final Exam
LTD 1600-1800hrs
Crypt Sheet : 4 A4 sheets
Four to Five Questions on the following topics: Database Design
Relational Algebra
SQL For practice, please use UST's digital library 24x7. |
Lab Schedule and Topics (Lab will start on Week 2) The aim of the lab sessions is to provide students with hands-on experience in the various software, database, and web technologies to as to be able to successfully complete a journal web-portal. Lab Topic 1 (9, 11 Sept) slides | Introduction to
- Web of Science,
- Journal Ranking.com
- Academic Ranking Websites
- Introduction to wink and flash | Lab Topic 2 (16,18 Sept)
slides
| Introduction to Joomla | Lab Topic 3 (23, 25 Sept)
slides | Advanced Joomla | Lab Topic 4 (30 Sept and 2 Oct) No lab on 7 and 9 of October | Website Implementation | Lab Topic 5 (14, 16 Oct) | Introduction to mysql | Lab Topic 6 (21, 23 Oct) | Introduction to mysql
| Lab Topic 7 (28, 30 Oct) | Design and Construction of database for project
| Lab Topic 8 (4, 6 Nov) | Integration to Joomla
| Lab Topic 9 (14, 16 Nov) | Project Presentation and Testing | Lab Topic 10 (21, 23 Nov) | Project Presentation and Testing | Lab Topic 11 (28, 30 Nov) | Integration across different tables
| Lab Topic 12 (2,4 Dec) | Presentation of Results
|
|
