Instructor: Ejaz Ahmed Office: 22/124-6 Phone:1141 Lab Loc: 22/336 (
Weeks |
Lab |
Description/ Contents |
1 |
Lab01 |
Introduction to Lab and DB Architecture |
2 |
Lab02 |
Introduction to Basic SQL Select |
3 |
Lab03 |
Learning & Practice SQL |
4 |
Lab04 |
Learning & Practice SQL |
5 |
Lab05 |
Embedded |
6 |
Lab06 |
Embedded Programming PL/SQL |
7 |
Lab07 |
Learning & Practice
Forms/ Reports (GUI programming using SQL, PL/SQL) |
8 |
Lab08 |
Learning & Practice
Forms/ Reports (GUI/ JSP programming using SQL, PL/SQL) |
9 |
Lab09 |
Description of Lab Project, start up project Phase I |
10 |
Lab10 |
ERD, ER-Mapping, documentation, scripts formulation using Case Study Quiz 02 of PL/SQL, Forms/ Reports |
11 |
Lab11 |
ERD, ER-Mapping, documentation, scripts formulations using Case Study |
12 |
Lab12 |
Project progress & discussions LW2 (combined effort), |
13 |
Lab13 |
Introduction to DB connections/ Security issues. Project’s
updates and progress status |
14 |
Lab14 |
Project Submission & Final project presentation |
Marks Distribution
Lab Work |
5% |
Lab Quizzes |
5% |
Project |
15% |
Total |
25% |
Project SQL phase -
submission date
Important Notes
1. Attendance is taken at the beginning of the class.
2. Two late attendances are considered as one absence.
3. Missing three labs will result in a DN grade in the course.
4. A 0.5 mark will be deducted for every absence.
5. Official excuse for any absence of a lab must be presented not later than one week after that class.
6. Assignments must be submitted in class on the due date. No submission is accepted after due date.
7. No make up for Quiz or any other Lab work will be made.
8. No Change of section allowed unofficially.
9. Plagiarism, copying and other anti-intellectual behavior are prohibited by the university regulations. Violators may have to face serious consequences. See the attached clip from the university rules in Arabic.
Tips to the Student:
In order to do well in this Course the following points are to be noted and considered in your planning:
1. ICS334 Lab requires lots of reading, hard work and dedication. The student should make up his mind to do hard work in this lab.
2. Your attitude to learn and the effort you put in for this course alone will be the primary agents that guide you in this course
3. Emphasis is on reasoning and planned approach; regular work towards this course and not on memorization
4. Taking notes is important. Once you take a note of what you consider to be important bits and pieces of information, write it down in your notes. On the same day after the class, review the relevant material and then prepare detailed notes. Later incorporate the same into your submissions. Such regular recollection, review, revision, and documentation will turn out to be very important in grasping the material and doing well in quizzes and examinations
5. Regular interaction during the lab; during the instructor's office hours is encouraged. There is nothing like a silly question. By raising doubts and posing questions, you will be helping yourself, others in the class, and the instructor in steering the coverage towards the weak points. So keep one thing in mind during this course:
it is better to raise a doubt or pose a question, rather than suppressing it and face difficulties later on.
6. If you do not follow the instructor's pace/language, request him to slow down. Likewise, when you do not understand certain words or sentences request for an alternative explanation.
7.
8. There is no substitute for a regular (daily) preparation for this course. It will be far less effective, even if you spend two times more effort just before the examination days.
Good luck and best wishes for a good semester.