Welcome to Database Management Systems.
Instructor: Dr. Vaide Narvaez
Schedule: Tuesday, Thursday 8:00-10:00am
Introduces the concepts and techniques of database management systems. Key concepts will be presented, including database design and modelling, data integrity, building a business-oriented database, security, database administration and implementation.
On successful completion of this subject, students should be able to demonstrate an understanding of fundamental database concepts, the typical database system components and functions; understand the role of high-level conceptual data modeling in database design and develop the ability to design and implement conceptual schemas for database applications; demonstrate knowledge of the relational database model and its basic characteristics and the relational algebra; develop the ability to use SQL to create a database and specify retrieval queries and develop skills in database application development.
Course Syllabus and Material
|1||Lecture 1: Introduction to DatabasesLecture 2: Database Development Process||
|2||Lecture 3&4: Conceptual data modeling||
|3||Lecture 5&6: Conceptual data modeling: EER diagrams||
|4||Lecture 7&8: Relational data model, Mapping to ER.||
|5||Lecture 9&10: Functional dependencies, Normal Forms||
|6||Lecture 11-12: Relational Algebra||
|7||ReviewIntro to basic SQL||
|10||Views, indexes, triggers and transactions in SQL|
|11 -12||SQL in a Server Environment, JDBC|
|13||Security and User Authorization in SQL|
|14||Structured, semistructured and unstructured data. XML|
- R. Elmasri, S. B. Navathe. (2004) Fundamentals of Database Systems, 4th ed., Prentice Hall, ISBN 0-321-20448-4
- H. Garcia-Molina, J.D. Ullman, J. Widom. (2009) Database Systems: The Complete Book, 2nd ed., Prentice Hall
Supplementary reading materials
- Jeffrey A. Hoffer, Mary B. Prescott and Heikki Topi. (2009) Modern Database Management, 9th ed., Prentice Hall, ISBN-10: 0132212110
- Raghu Ramakrishnan and Johannes Gehrke. (2003) Database Management Systems, 3rd ed., McGraw-Hill, ISBN:0-07-246563-8
- Abraham Silberschatz, Henry F. Korth and S. Sudarshan. (2002) Database System Concepts, 4th ed., McGraw-Hill, ISBN:0-07-228363-7