Section outline


    • Welcome to the Database Systems course! In this course, we will be using SQL Server to learn about administering a database, as well as the basics of the SQL language.  In this course, we will learn about database management the system, database languages, data models, database design. This course will focus on how to use the SQL language in order to view and manipulate data. This will include creating and deleting various database objects, adding and altering data within tables, and viewing and sorting data. After completing this course, you will have hands-on experience in administering a database know how to use the SQL language in order to manage it.

    • Course Objective:

      Upon successful completion of this course, students should be able to:

      • Describe the fundamental elements of relational database management systems.
      • Explain  the  basic  concepts  of  relational  data  model,  entity-relationship  model,  relational  database design, relational algebra and SQL.
      • Design ER-models to represent simple database application scenarios
      • Convert  the  ER-model  to  relational  tables,  populate  relational  database  and  formulate  SQL  queries on data.
      •  Improve the database design by normalization.
      •  Familiar   with   basic   database   storage   structures   and   access   techniques.

    • Course Objective:


    • resource icon
      OBE Course outline File

    • Course Assessment:

      Final grade in each course will be given on the basis of performance in class attendance, in-
      course examinations, assignments, midterm test and final examination is shown in Table.


    • Text Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney



      Database System Concept, Silbertz, Korth and Sudarshan


    • Reference Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney


      Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.