Database Systems Analysis and Design

Description

Database Systems Analysis and Design

Database Systems Analysis and Design CICT Section 3 is a KASNEB course. It prepares students to administer and manage databases.

Download free Database Systems Analysis and Design CICT Section 3 PDF notes and past papers now. Get CICT PDF notes and past papers for the new KASNEB CICT syllabus 2021.

KASNEB CICT Section 3 Database Systems Analysis and Design New Syllabus 2021 covers the following topics:

• Introduction to databases – Files, records, files and databases – History of database systems – Traditional file systems versus the database approach – Characteristics, importance and limitations of database systems – Database components and architecture
• File organization techniques – Storage structures and blocking – Unordered files – Sequential files – Indexing
• Database models – The role of data modeling – The hierarchical model – The relational model – The object-oriented model – The object-relational model
• Database development life cycle – Data and user requirements specification – Stages of database development – Conceptual, logical and physical database design – Writing database requirements specifications
• Relational database model – Relational database concepts and properties – E-R database design – Database design anomalies – Normalization – Relational algebra – Creating database design – Implementing database design in mysql /oracle /DB2
• Structured query language (SQL) – Data definition language – Data manipulation language – Structure of SQL statements – Data control – In-built functions – Writing SQL statements – Using SQL functions
• Transaction management and concurrency control – Transaction management – Properties of a transaction – Serializability and concurrency control – Lock-based and timestamp-based protocols – Types of failures – Database recovery concepts and mechanisms
• Database administration – Database users – Data administration – Functions and roles of database administrators – Monitoring database performance
• Database security and integrity – Security and integrity concepts – Social, ethical and legal database issues – Threats to database security and integrity – Managing threats – Establishing data backup procedure
• Distributed database systems – Introduction of concepts – Distribution methods – fragmentation and replication – Concurrency control mechanisms in distributed systems – Two-tier database architecture – Three-tier database architecture
• Data warehousing and data mining – Overview of data warehousing – Characteristics of a data warehouse – Components of a data warehouse – Types of data warehouses – Elements of a data warehouse – Over view of data mining – Techniques of data mining
• Integrating databases to other applications – Importance of integrating databases to other applications – Integrating databases to other applications (visual basic.net, C++, Java, C# among others) – Developing web enabled database applications

Anyone aspiring to become systems analyst, computer techie, etc will find this course vital. We encourage the KASNEB students to prepare for CICT Section 3 exams adequately.

Many students and colleges have benefited from the resources offered by the Pass Exams Team.

We are the largest and best repository offering free PDF KASNEB study materials in Kenya.

Other units or courses in CICT Section 3 include:

• Systems Analysis and Design
• Structured Programming

After completion of KASNEB CICT Section 3, the student advances to CICT Section 4 which has the following units:

• Object Oriented Programming
• Web Design and e-Commerce
• Data Communication and Computer Networks-Practical

Get free KASNEB CICT Section3 PDF notes and Past Papers. Download free CICT Section 4 PDF notes and past papers now.