CMPT 354-3 Eve Database Systems and Structures
Instructor: O. Zaïane
T 1730-2020 Final Exam: Aug 5 - 19:00
To provide an introduction to data models, database systems, the structure
and use of relational database systems and relational languages, indexing
and storage management, query processing in relational databases, and the
theory of relational database design. The course concentrates on the
relational model, with a brief introduction to entity-relationship,
hierarchical and network data models as well. Assignment work will include
the design and implementation of a database using the Microsoft SQL Server
relational database management system.
- An introduction to Database Systems.
- The Entity-Relationship Model.
- The Relational Model and Query Languages.
- Commercial Relational Languages.
- Integrity Constraints.
- Relational Database Design.
- File and System Structure.
- Indexing and Hashing.
- Query Processing and Optimization.
- Databases and the World-Wide Web
- Hierarchical, Network, and Object-Oriented Databases.
- Case studies.
- Students will be expected to do some programming in C++
Assignments 40%, Midterm Exam 25%, Final Exam 35%
There are 4 assignments 10% each.
- Database System Concepts, 3nd edition., Korth, Silberschatz and Sudarshan, McGraw
- on line material at http://www.cs.sfu.ca/CC/354/zaiane/
- Database Management Systems, Raghu Ramakrishnan, McGraw Hill 1998,
- An introduction to Database Systems, 6th ed, C. J. Date, Addison
- Database:Principles,Programming,Performance, P. O'Neil, Morgan
- Principles of Database and Knowledge-Base Systems, , J.D. Ullman,
Computer Science ,
- Fundamentals of Database Systems 2nd ed., R. Elmasri and S.B. Navathe,
Benjamin Cummings 1994,
- Special Edition Using Microsoft SQL Server 6.5, B.Branchek, P.
Hazlehurst, S.Wynkoop, S.L. Warner, Que Corp 1996,
CMPT 201, MACM 201
Distributed: March 10, 1998. Updated: May 14, 1998
Academic Honesty plays a key role in our efforts to maintain a high
standard of academic excellence and integrity. Students are advised that
ALL acts of intellectual dishonesty are subject to disciplinary action by
the School; serious infractions are dealt with in accordance with the Code
of Academic Honesty (T10.02)
(http://www.sfu.ca/policies/teaching/t10-02.htm). Students are encouraged
to read the School's Statement on Intellectual Honesty