Post on 04-Jun-2018
8/13/2019 General Info Stu
1/13
IS202Data Management
General Information
2013 - 2014 Term 2
8/13/2019 General Info Stu
2/13
Celebrate a New Year 2014!
2
8/13/2019 General Info Stu
3/13
Course InformationIS202 Data Management
Faculty:
Prof. LIM Ee Peng (email: eplim@smu.edu.sg, office: SIS-RM4025, Tel 6828-0781)
Prof. Kyriakos MOURATIDIS (email: kyriakos@smu.edu.sg, office: SIS-RM4023, Tel 6828-0649)Prof. Baihua Zheng(email: bhzheng@smu.edu.sg, office: SIS-RM4039, Tel 6828-0915)
Instructor:
Ms. CHUA Hong Ngoh (email:hnchua@smu.edu.sg, office: SIS-RM4056, Tel 6828-0907)Ms. Fiona LEE (email: fionalee@smu.edu.sg, office: SIS-RM4056, Tel 6828-1982)Ms. RAMACHANDRA RAO Vandana (email: vandanarr@smu.edu.sg, office: SIS-RM4033, Tel6828-0230)
Sections:
G1 Tuesday (12:00 15:15) [SIS Seminar Room 2.1]Faculty: Baihua Zheng, Instructor: Vandana, TA: Terence CHU Tailun
G2 Wednesday (12:0015:15) [SIS Seminar Room 2.1]
Faculty: Baihua Zheng, Instructor: Fiona, TA: HENG U San
G3 Thursday (12:00 15:15) [SIS Seminar Room 2.3]Faculty: Baihua Zheng, Instructor: Hong Ngoh, TA: TAN Siying
G4 Monday (8:15 11:30) [SIS Seminar Room 3.1]Faculty: Lim Ee-Peng, Instructor: Vandana, TA: OH Peng Ho
G5 Tuesday (8:15 11:30) [SIS Seminar Room 3.1]
Faculty: Lim Ee-Peng, Instructor: Hong Ngoh, TA: Sulovna SUSANTG6 Monday (15:30 18:45) [SIS Seminar Rm 3.3]Faculty: Kyriakos MOURATIDIS, Instructor: Fiona, TA: NG Boon Thai
G7 Tuesday (15:30 18:45) [SIS Seminar Rm 2.1]Faculty: Kyriakos MOURATIDIS, Instructor, Instructor: Fiona, TA: LAM Kee Wei
G8 Wednesday (15:30 18:45) [SIS Seminar Rm 2.1]Faculty: Kyriakos MOURATIDIS, Instructor, Instructor: Vandana, TA: LIM Yi Sheng
3
mailto:eplim@smu.edu.sgmailto:kyriakos@smu.edu.sgmailto:bhzheng@smu.edu.sgmailto:hnchua@smu.edu.sgmailto:fionalee@smu.edu.sgmailto:vandanarr@smu.edu.sgmailto:terence.chu.2012@sis.smu.edu.sgmailto:usan.heng.2012@sis.smu.edu.sgmailto:siying.tan.2012@sis.smu.edu.sgmailto:pengho.oh.2012@sis.smu.edu.sgmailto:ssusant.2012@sis.smu.edu.sgmailto:boonthai.ng.2012@sis.smu.edu.sgmailto:keewei.lam.2012@sis.smu.edu.sgmailto:yisheng.lim.2012@sis.smu.edu.sgmailto:yisheng.lim.2012@sis.smu.edu.sgmailto:keewei.lam.2012@sis.smu.edu.sgmailto:keewei.lam.2012@sis.smu.edu.sgmailto:keewei.lam.2012@sis.smu.edu.sgmailto:keewei.lam.2012@sis.smu.edu.sgmailto:boonthai.ng.2012@sis.smu.edu.sgmailto:ssusant.2012@sis.smu.edu.sgmailto:pengho.oh.2012@sis.smu.edu.sgmailto:siying.tan.2012@sis.smu.edu.sgmailto:usan.heng.2012@sis.smu.edu.sgmailto:terence.chu.2012@sis.smu.edu.sgmailto:vandanarr@smu.edu.sgmailto:fionalee@smu.edu.sgmailto:hnchua@smu.edu.sgmailto:bhzheng@smu.edu.sgmailto:kyriakos@smu.edu.sgmailto:eplim@smu.edu.sg8/13/2019 General Info Stu
4/13
Course Information (contd)
Text book (optional)
Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki
Topi: Modern Database Management,
International Edition, 10thEdition, published by
Pearson Education Limited, 2011
4
8/13/2019 General Info Stu
5/13
What We will Learn from this
Course?
Understand the role of databases in integratingvarious business functions in an organization
Understand data modeling, conceptual, logical andphysical database design
Apply the fundamental techniques of data modeling toa real project
Query a database using Structured Query Language
Gain familiarity with some commercial database tools(MySQL)
Be aware of common issues of business databasedesign and maintenance: re-design requirements,requirement analysis, interview design, etc
5
8/13/2019 General Info Stu
6/13
Learning Outcome
1. Integration of Business & Technology in a sector context1.1 Business IT Value Linkage skills
2. IT architecture, design and development skills
2.1 System requirements Specification skills
2.2 Software and IT architecture and Design skills (main focus)
2.3 Implementation skills (main focus)
4. Learning to Learn skills
4.1 Search skills
4.2 Skills for developing a methodology for learning
8. Communication skills
8.1 Presentation skills8.2 Writing skills
Available at: http://sisapps.smu.edu.sg/cddr
6
http://sisapps.smu.edu.sg/cddrhttp://sisapps.smu.edu.sg/cddr8/13/2019 General Info Stu
7/13
Course Information (contd) Course work:
1 group project: 25% 1 final exam (13:00-15:00, Apr 16 2014): 35%
2 in-class personal assignments: 30%
Week 5 (19:30 - 21:00, Feb 6, 2014): ER Modeling (15%)
Week 12(19:30 21:00, Mar 27, 2014): SQL (15%)
Class participation: 10%
Pop quiz (no advance notification)
All the topics taught till the quiz will be included in these quizzes
Different groups might have different schedules Attendance
Participation in classroom discussion
Lab performance
7
8/13/2019 General Info Stu
8/13
Course Information (contd) Course schedule
Week 1: Concept of Data Management and the Database Environment
Week 2: Modeling Data in the Organization (Visio installation due)
Week 3: Enhanced E-R Model and Business Rules
Week 4: Data Modeling Exercises
Week 5: Logical Design Part 1: Relational model (ER test, WAMP/SQLQuery Browser installation due)
Week 6: SQL (project phase I due) Week 7: SQL: Join Tables
Week 8: Recess
Week 9: SQL: Subquery
Week 10: Logical Design Part 2: Data Normalization (project phase II due)
Week 11: PHP Lab 1
Week 12: PHP Lab 2 (SQL test)
Week 13: Visio Lab (project phase III due)
Week 14: No lecture, project final presentation
Week 15: Exam Week (Final Exam, week 15)
8
8/13/2019 General Info Stu
9/13
Course Policies Class starts on time (so be here early) and
ends on time Pop-quiz can pop-up at any time and no
makeup for missed pop quiz
Keep your email box open, we won't resend
messages Make sure VISIO, WAMP and MySQL are
installed before the deadline Detailed installation documents and deadline for the
installation will be distributed later
Help will be provided Part of your class participation marks will be
deducted if you have not installed them before thedeadline
9
8/13/2019 General Info Stu
10/13
Course Policies (contd)
Absence request must reach us before the startof your scheduled slot
All the deadlines are firm!
Marks will be deducted for late submissions
Ask instructors for approval for some special cases
(e.g., medical leave)
Reviewing of graded submission is allowed
Reviewing is based on the whole submission, but nota particular question
The grade after reviewing will become the final mark
of that submission
10
8/13/2019 General Info Stu
11/13
Learning Suggestions
Interest is the most important!!! Please read the text before the lecture
A reading assignment will be given to you
Please review the notes and text after the lecture
Please test and experience software as much aspossible and try to get familiar with the software
You are encouraged to discuss with your
classmates if you have any difficulties withassignment, but do not copy the answers
11
8/13/2019 General Info Stu
12/13
Learning Suggestions (contd)
Please write down all the questions andtry to find the answers by
asking lecturer, course mentors, andclassmates
searching the Internet
solving them by yourself
No question is stupid and no question is
too simple
12
8/13/2019 General Info Stu
13/13
This course ischallenging
One of the first two
courses to introduce
design process
Finish the class within 13
weeks
Learn 3 new software
We are here and ready
to help you!
13