B.Sc.in Management and Information Technology (Interim)

BACHELOR OF SCIENCE IN MANAGEMENT AND INFORMATION TECHNOLOGY

IMIT 12043

Database Management Systems

Status : Core Pre-requisite : G.C.E. (A/L) Co-requisite : None

 

On completion of this course, the student should be able to:

  • Describe various logical database architectures
  • Design & develop databases using relational models
  • Manipulate data & prepare forms and reports using Structured Query Language.

The role of DBMS in organizations. The database approach. Database fundamentals. Data modeling. Entity Relationship Diagram. Relational database architecture. Logical modeling. Data independence. Data dictionary. Data manipulation and Structured Query Language (SQL). Historical database architectures and comparison with relational architecture.
Lectures, supervised hands on practical sessions on SQL, tutorials and group work.
End-of- semester examination and continuous assessment.

  1. Fred R. McFadden, Jeffrey A. Hoofer, and Mary B. Prescott, “Modern Database Management”, 7the Edition, Addison-Wesley Pub Co.
  2. CJ Date, “Introduction to Database Systems”, 8th Edition, 2004, Addison Wesley.
  3. Elmira R. and Navathe S. B., “Fundamentals of Database Systems”, 4rd Edition, 2003, Addison Wesley

Back