CS405G Introduction to Database Systems

University of Kentucky
Department of Computer Science
CS 405G  Introduction to Database Systems
 
 
1.  Course Number/Name:  CS 405G, Introduction to Database Systems
 
2.  Credits and Contact Hours:  3 credits, 3 contact hours
 
3.   Instructor:  assigned by department
 
4.   Textbook:   Database Management Systems, Third Edition, R. Ramakrishnan and J. Gehrke
 
5.   a.  Catalog Description:  Study of fundamental concepts behind the design, implementation and application of
database systems. Brief review of entity-relationship, hierarchical and network database models and an in-depth coverage of the relational model including relational algebra and calculi, relational database theory, concepts in schema design and commercial database languages.
     
      b.  Prerequisites:  CS 315 and graduate or engineering standing
  
      c.  Required course:   Elective
 
 
6.  a.   Outcomes of InstructionAt the conclusion of the course, the successful student will be able to:

1.    understand and appreciate the theoretical foundation of database systems
2.    write SQL queries of moderate complexity
3.    create a web front end to a database application
4.    use sound design principles when designing a database
5.    understand through hands-on experience the management techniques used by database systems
 
b.   Contributions to Student Outcomes from Criterion 3
           

Outcome

a

b

c

d

e

f

g

h

i

j

k

CS 405G

3

3

3

 

3

 

 

 

 

 

 

3- Strongly supported   2 – Supported   1 – Minimally supported
 
 7.   List of Topics Covered:

            1.      Entity-relationship database models
            2.      Relational algebra and calculi
  3.      Relational database theory
  4.      Schema design
  5.      Commercial database languages