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.
|
|
Department of Computing and Information Sciences - Kansas State University
Address: 234 Nichols Hall, Manhattan, KS 66506
Phone: (785)532-6350; Fax: (785)532-7353; Mailto: webmaster@cis.ksu.edu
|
|