School of Computer Science

Florida International University


Database Management
COP4540 - Fall, 2000

This is the initial plan for the course, and is subject to change based on the availability of resources and other constraints.

Announcement:

The final letter grade is available now!
final_grade = (ie1+hw1+ie2+hw2+ie3+hw3+mini_proj)/5*0.3 + mid_term*0.3 + final_exam*0.4 + credit
ieX: in-class exercise No X
hwX: homework No. X

Grading scale:
A     final_grade >= 90
A-    89 >= final_grade >= 87
B+  86 >= final_grade >= 84
B    83 >= final_grade >= 80
B-   79 >= final_grade >= 77
C+  76 >= final_grade >= 74
C    73 >= final_grade >= 70
C-   69 >= final_grade >= 65
D+  64 >= final_grade >= 62
D    61 >= final_grade >= 60
F    final_grade < 60

Please use the online system to retrieve and verify your grade.
 

Final Exam Schedule:
Section 1 (T/R 14:00 - 15:15): Dec 14, Thursday, 12:30 - 15:00
Section 2 (T/R 17:00 - 18:15): Dec 14, Thrusday, 15:30 - 18:00

The revised version of the lecture notes on programming with ODBC is available now. (Nov 30)

Happy Thanksgiving!

Please find the assignment No. 4 & 5. The due date is Thursday, Dec 7. (Nov 23)
There will be a guest lecturer who is an experienced ODBC programmer giving lecture on how to program with ODBC on Nov. 28 (Nov. 23)

Please find the assignment No. 3. The due date is Tuesday, Nov 21. (Nov 9)
Please note that there will be a in-class exercise on Tuesday, Nov 7. (Nov. 6)
Due to the system error, the course syllabus page was damaged. Below, please find the links to all previous lecture notes and answers to the exercises.

Lecture Note beofore the mid-term exam (powerpoint files):
Introduction, E-R(1), E-R(2), E-R(3), ODL, EER, Relation Model, EER(ER) to relational, Functional Dependencies, Relation Normalization, Relational Algebra(1), Relational Algebra(2)

Answers to the exercises:
Answer toAssignment No. 3
Answer to in-class exercise No. 3
Answer to Assignment No. 2
Answer to in-class exercise No. 2
Answer to Assignment No. 1
Answer to in-class exercise No. 1

Instructor:

Name:   Dr. Jun Yuan
E-mail: yuanj@cs.fiu.edu
Tel:    (305) 348 - 6238
O.H.:   T/R 3:30 - 4:30 PM at ECS 252
E-mail is the preferred manner of communication.

Course Description:

Database management systems are the foundation of any information systems. In modern organizations, data management plays a crucial role in business operations, and the shear volume of business data requires sophisticated planning, design, implementation, and management of database systems. Database management systems must effectively store, access and manipulate data as well as provide data security, data sharing and data integrity. As the database technology advances rapidly, information professionals must not only understand the concepts and principles of database systems but also the associated management issues. This course introduces the fundamentals of the modern database concepts and database development skills and emphasizes on both theories and hands-on experiences.

Course Objective:

Upon successfully completing this course the student will:
  • Understand the concepts and the principles of database management systems.
  • Be familiar with the state-of-the-art database management systems.
  • Be able to develop database applications with respect to real world business requirements.
  • Understand current issues in the development of database technologies and applications.

    • Textbook:

    Fundamentals of Database Systems (Required)
    BY: Ramez A. Elmasri, Shamkant B. Navathe
    Hardcover - 960 pages 3rd edition (August 1999)
    Addison-Wesley Pub Co
    ISBN: 0805317554

    Grading:

    Exercises: 30%
    Midterm Exam: 30%
    Final Exam: 40%
    The exams are close-book tests. All materials from textbooks, assigned exercises, and class discussions may be covered in the exams. No make-up exams will be given except for exceptional cases that are approved by the instructor before the exams.
    Copied work among several students will result in a zero grade for all the parties involved.

    Class Schedule & Lecture Notes:

    Date Lecture Notes:
    10/17/00  Mid-term Exam
    10/19/00  Mid-term Exam Review
    10/24/00  Structured Query Language -- SQL (Chapter 8) (6 slides per page, 2 sildes per page, ppt file)
    10/26/00  SQL (Query against multiple tables, Chapter 8) (6 slides per page, 2 sildes per page, ppt file)
    10/31/00  SQL (Advanced Query, Chapter 8) (6 slides per page, 2 sildes per page, ppt file)
    11/02/00  SQL Query Examples(Chapter 8) ( 6 slides per page, 2 slides per page, ppt file)
    11/07/00  Constraints and Security in SQL (Chapter 8 & Chapter 23) (6 slides per page, 2 slides per page, ppt file)
    11/09/00  Database trigger (Chapter 23.3) ( 6 slides per page, 2 slides per page, ppt file)
    11/14/00  Physical Database Design 1 (Chapter 16 & Chapter 6) ( 6 slides per page, 2 slides per page, ppt file)
    11/16/00  Physical Database Design 2 (Chapter 16 & Chapter 6) ( 6 slides per page, 2 slides per page, ppt file)
    11/21/00 Oracle PL/SQL (Chapter 10.5) ( 6 slides per page, 2 slides per page, ppt file)
    11/23/00  Thanksgiving Holiday (university closed)
    11/28/00  Programming with ODBC ( 6 slides per page, 2 slides per page, ppt file)
    11/30/00  A tutorial on Microsoft Access
    12/05/00  Course Review
    12/07/00