TSU

COLLEGE OF ENGINEERING, TECHNOLOGY & COMPUTER CIENCE

DEPARTMENT OF COMPUTER SCIENCE

 

COURSE DESCRIPTION FOR COMP 3710:    Relational Databases

 

COURSE PREREQUISITE:          COMP 320 (Discrete Mathematics)

                                                                                                    BACK

COURSE OBJECTIVES

Course objective is to introduce students to concepts of relational databases and a relational database management system.

 

COMPETENCIES STUDENTS ARE EXPECTED TO MASTER

By the end of this semester the student should:

1.         Understand basic concepts and definitions of databases.

2.         Be familiar with basics of relational databases.

3.         Be able to design and implement databases.

4.         Be able to create queries, forms, and reports.

5.         Maintain a database.

 

MAIN TOPICOMP COVERED

1.         Basic database definitions

2.         Mathematical Relations

3.         Relational Data Model

4.         Relational Algebra

5.         Relational Databases and related definitions

6.         Relational Database Architectures and Design

7.         Entity-Relationship Data Model

8.         Normalization of relations and normal forms

9.         The Structured Query Language (SQL)

10.     Relational Database Management Systems

11.     Design and implementation of a number of databases

12.     Creating views, queries, forms and reports

13.     Introduction to database administration