I451 - Development of Information Systems
NS 223
| Instructor: | Hossein Hakimzadeh |
| Office: | Northside 336 |
| Telephone: | 520-4517 (Office)
520-5521 (Dept. Secretary) |
| E-mail: | hhakimza @ iusb . edu |
| Home Page: | http://mypage.iusb.edu/~hhakimza |
| Office Hours: | M,W (10:00am - 12:00 Noon) T,R (2:30pm - 4:30 pm) Before or after my classes or by appointment. |
| Text: | Fundamentals of Database Systems, by Elmasri and Navathe, Fifth Edition, Addison Wesley. |
| Supplemental Text: |
|
| Software: | MySQL, XAMP |
| Course Information: | Fundamental concepts and practices in design and implementation of database management systems. Topics include data modeling, functional dependencies, normalization, relational, hierarchical, network and object oriented data models, relational algebra, data definition and manipulation languages, SQL, recovery, concurrency, security, distribution and integrity of data. The course project includes the design and implementation of a significant database system using MySQL or MS-Access database system. |
| Grading System: |
Assignments 40% (5 to 7 assignments) >= 90% A Plus and minus grades are given if an average falls within 1.5% of the cutoff score; for example, an average of 88.6% will earn a B+. |
| Attendance and Participation: | Attendance and class participation is crucial. A perfect attendance record and genuine class participation will add 2% to your final grade. |
| Make-Up Policy: | No make-up exams will be given unless an excused absence is approved BEFORE the exam is given. There are no make-ups on programs since they are assigned well before they are due. |
| Assignments: | Programs will be assigned during class time. They are due at the beginning of the class on their due dates. Don't miss class to work on your assignments. Late programs or assignments are accepted, at 50% penalty for up to 48 hours after their due date. Assignment submitted past the 48 hours will be worth up to 10%. (No exceptions.) Start your assignments early. |
| Copying Policy: | No student is permitted to copy another person's assignment. If copying has occurred, I will give both individuals a "F" for the assignment and/or course. |
| Send Copy to Instructor: | If requested by the instructor, each student must be ready to provide an electronic copy of her/his assignment (including source code of their program) to the instructor. Inability to provide the assignment as requested may result in zero points being recorded for the assignment. |
| Final Exam: | Thur, May 3, 2007 |
| Hour Exams,
In-class projects & Quizzes |
TBA |
| ADA Disability Statement | If you have a disability and need assistance,
special arrangements can be made to accommodate most needs. Contact Director of
Disabled Student Services (Administration Building, room 149, telephone number
520-4832), as soon as possible to work out the details. Once the director has
provided you with a letter attesting to your needs for modification, bring the
letter to me. For more information please visit the web site for Office of
Disabled Student Services www.iusb.edu/~sbdss/services.shtml |
| Religious Accommodations Statement | If any student will require academic accommodations for a religious observance, please provide me with a written request to consider a reasonable modification for that observance by the end of the second week of the course. Contact me after class, during my office hours, or by individual appointment to discuss the issue. If after discussion we reach no consensus, either party or both should seek the advice of the Department chair or the Dean, and if no consensus is reached, then the advice of the Vice Chancellor of Academic Affairs (“VCAA”). Either the instructor or the student may appeal the VCAA’s decision to the Office of Affirmative Action within ten business days of the determination. |
| Academic Honesty Statement | It is the responsibility of the student to know of the prohibited actions such as cheating, fabrication, plagiarism, academic, and personal misconduct, and thus, to avoid them. All students are held to the standards outlined in the code. Please reference the entire code for a complete listing ( www.dsa.indiana.edu/Code/ ). Any violation may result in serious academic penalty, ranging from receiving a warning, to failing the assignment, to failing the course, to expulsion from the University. |
| Jan. 9, 11 | Chapter 1 & 2 (Introduction / Survey) |
| Jan, 16, 18 | Chapter 3 & 4 (Data Modeling, ER, EER, UML) |
| Jan 23, 25 | Chapter 3 & 4 (Data Modeling, ER, EER, UML) Assign-1 (Paper on Database systems) |
| Jan. 30, Feb. 1 | Chapter 5 & 6 (Relational Model, Relational Algebra) Read Chapter 7 on your own. |
| Feb. 6, 8 | Chapter 5 & 6 (Relational Model, Relational Algebra) Assign-2 (ER Model) |
| Feb. 13, 15 | Chapter 8 and 9 (SQL) Test 1 |
| Feb 20, 22 | Chapter 8 and 9 (SQL) |
| Feb. 27, March 1 | Chapter 10 (Database Theory, Functional Dependencies and
Normalization) Assign-3 (ER, Relational Algebra) |
| March 6, 8 | Chapter 10 (Database Theory, Functional Dependencies and Normalization) |
| March 13, 15 | Chapter 10 (Database Theory, Functional Dependencies and Normalization) |
| March 20, 22 | Assign-4 (SQL) |
| March 27, 29 | Advanced Topics (17-Transaction Processing, 18-Concurrency Control) |
| April 3, 5 | Advanced Topics (Web Databases and PHP, 2-Tier vs. N-Tier Systems) |
| April 10, 12 | Advanced Topics (Data Mining) |
| April 17, 19 | Assign-5 (Presentation of Final Project) |
| April 24, 26 | Review for Final |
| May 3 (Thursday) | Final Exam |