Skip to content

Computer Applications syllabus

ITC 3515 units · 23 topicsAcademic year 2083/84
Browse the units

Computer Applications

5 units

1. Introduction to Computer Applications (8 LHs)

  1. Data and Information; definition and characteristics of DBMS
  2. File organizations: sequential and indexed sequential
  3. Information systems
  4. Transaction processing systems and office automation systems

2. Information Storage Technologies in Use (6 LHs)

  1. Data storage in flat file, unstructured and semi-structured
  2. Introduction to RDBMS
  3. Web, big data and NoSQL

3. Database Systems (10 LHs)

  1. Concepts, architecture and models
  2. Data models
  3. DBMS architecture and data independence
  4. Database environment and E-R model
  5. Relational Model

4. SQL and Database Operations (10 LHs)

  1. Introduction to SQL
  2. Queries
  3. Set operations and Null values
  4. Joined relation
  5. DDL and DML

5. Advanced Database Concepts and Operations (14 LHs)

  1. Constraints, views, triggers and transactions
  2. Security and integrity violations
  3. Access control and authorization
  4. Indexes
  5. OLAP, data cube, report generator
  6. Applications of database systems in organizations