CIS 761: Database Management Systems
Prerequisites
- some familiarity with databases, in particular basic SQL.
- a bit of mathematical background, in particular familiarity with reasoning about sets.
Knowledge and skills that should be acquired in this course
-
Mastery
-
- the relational model.
- query languages: relational algebra; SQL.
- design issues: decomposition, normalization.
-
Familiarity
-
- another data model: the Entity-Relationship (ER) model.
-
other query languages for the relational model:
Datalog; tuple relational calculus. -
implementation issues: indexing and hashing,
query processing and query optimization. -
transaction management: serializability, concurrency control &
protocols, recovery system. - data mining; data warehousing.
Address: 234 Nichols Hall, Manhattan, KS 66506
Phone: (785)532-6350; Fax: (785)532-7353; Email: webmaster@cis.ksu.edu
