CS 329 Introduction to Database Management Systems

Catalog Description: 

Design and implementation of databases from a real world applications point of view. The course includes database concepts such as basic architectural issues, the relational model, query processing, logical database design and normalization theory and data protection issues.

Prerequisite: 
CS 202 or permission of the instructor.
Credits: 
3
Offered: 
Second semester
Required or Elective: 
Required for the BS in Computer Science
Level: 
Intermediate
Coordinator: 
Aijuan Dong
Current Textbook: 

Modern Database Management, 11th Edition, by Jeffrey A. Hoffer, V. Ramesh,Heikki Topi. Prentice Hall, 2012.

Topics covered: 
  • ER Modeling
  • EER Modeling
  • The Relational Model
  • Normalization
  • Implementing a database with SQL
  • SQL
  • Physical database design
  • Indexing
  • PHP/SQL
  • Query processing
  • Transaction
  • Constraints and triggers
Student Learning Outcomes: 

On completing this course, the student will be able to:

  1. Successfully apply database design principles, including E-R diagrams and database normalization, to classify and solve generally stated problems.
  2. Effectively construct simple and moderately advanced database queries using Structured Query Language (SQL)
  3. Demonstrate a basic understanding of  relatd database facilities, such as indexing, query processing, concurrency control, and security
  4. Understand software development methodology and apply modular software design.
  5. Work effectively both independently and in team
  6. Communicate effectively with technical and non-technical audiences
  7. Be aware of current trends and technologies in data management
Relation of Course Outcomes to Program Outcomes: 

 

CS 329 Student Outcomes (SOs)
Course Learning Outcomes a b c d e f g h i j k
1. Successfully apply database design principles, including E-R diagrams and database normalization, to classify and solve generally stated problems.                  
2. Effectively construct simple and moderately advanced database queries using Structured Query Language (SQL)                  
3. Demonstrate a basic understanding of related database facilities, such as indexing, query processing, concurrency control, and security.                    
4. Understand software development methodology and apply modular software design.                    
5. Work effectively both independently and in teams.                    
6.Communicate effectively with technical and non-technical audiences.                    
7. Be aware of current trends and technologies in data management                    
Role in Assessment: 

See the pages "BSCS Course Matrix" and "BSCS Courses for Assessment"

 

SO PI Strategy
b b.2

(CO 1 apply principles) Given a problem, students will analyse and construct an Entity-Relational diagram to model the data requirements.

d d.1

(CO 5 work in teams) Students, work in a team, will implement a full-fledged, web-enabled database system.

d d.2.

(CO 5 work in teams) Students, work in a team, will implement a full-fledged, web-enabled database system.

i i.1

(CO 7 trends) Students will answer questions that are related to a presentation on current trends and new technologies.

 


 

Go to top