This course covers the fundamental topics in database management systems including ANSI/SPARC architecture, data abstraction, data independence; data definition and manipulation languages; entity-relationship and relational data models, integrity constraints, query languages like SQL, relational algebra and calculus, functional dependencies, normal forms, transaction processing recovery and concurrency control, data structure for database management systems such as indices, B-trees, hashing.
Database Systems (CS 306)
Programs\Type | Required | Core Elective | Area Elective |
BA- Political Science | |||
BA-Cultural Studies | |||
BA-Cultural Studies | |||
BA-Economics | |||
BA-Economics | |||
BA-International Studies | |||
BA-International Studies | |||
BA-Management | |||
BA-Management | |||
BA-Political Sci.&Inter.Relat. | |||
BA-Political Sci.&Inter.Relat. | |||
BA-Social & Political Sciences | |||
BA-Visual Arts&Visual Com.Des. | |||
BA-Visual Arts&Visual Com.Des. | |||
BS-Biological Sci.&Bioeng. | * | ||
BS-Computer Science & Eng. | * | ||
BS-Computer Science & Eng. | * | ||
BS-Electronics Engineering | * | ||
BS-Electronics Engineering | * | ||
BS-Industrial Engineering | * | ||
BS-Manufacturing Systems Eng. | * | ||
BS-Materials Sci. & Nano Eng. | * | ||
BS-Materials Science & Eng. | * | ||
BS-Mechatronics | * | ||
BS-Mechatronics | * | ||
BS-Microelectronics | |||
BS-Molecular Bio.Gen.&Bioeng | * | ||
BS-Telecommunications | * |
CONTENT
OBJECTIVE
To supply the students with the theory and practice of database management systems, and database application development.
LEARNING OUTCOME
After this course, the student will be able to develop a database application starting with the conceptual design leading to logical and physical designs.
After the course, the student will be competent on relational model and SQL.
After the course, the student will be able to implement a database application based on a given design.
After the course, the student will be able explain the concept of functional dependency and will be able to avoid redundancies and other problems causing by bad designs.
After the course, the student will be able to explain how a DBMS concurrently handles the transactions and what happens after a system crash.
After the course, the student will be able to explain how the data is physically stored, managed, and queried within the database.
Update Date:
ASSESSMENT METHODS and CRITERIA
Percentage (%) | |
Final | 35 |
Midterm | 30 |
Participation | 15 |
Individual Project | 20 |
RECOMENDED or REQUIRED READINGS
Readings |
Ramakrishnan and Gehrke, Database Management Systems, McGraw Hill |