Optional Topics

Intl. Baccalaureate Board > Class 11 > Computer Science (Total Videos: 240)

Show Content

Select a chapter above and press 'Show Content'. Click a video topic below to view.

Chapter 5: Optional Topics (41 videos)   (Practice Test)
5.1: Basic Concepts  (Practice Test)
  1. Data Operations
  2. Difference between Data and Information
  3. Objectives of Database
  4. Physical Database Design
  5. File Organization
  6. Database Implementation Phase
  7. DataModeling : Main Ingredients : Entity and Object
  8. Database Design : Database Development Process
  9. Introduction to Queries
  10. Planning a Query
5.2: The Relational Database Model  (Practice Test)
  1. The Database Management System
  2. Objectives of DBMS
  3. Advantages of Database System
  4. Relational Schema
  5. Keys : Primary Key
  6. Transformation of E-R Model into Relational Schema
  7. Types of Keys : Sort Key
  8. Types of Keys : Super Key
  9. Introduction to MS-Access
  10. Create Database Using Database Wizard
  11. Database Terminologies
  12. Views
  13. Cardinality and Modality of a Relation
  14. Modality
  15. Relation and Table
  16. Entity Relationship Model : Entity , Attribute and Relationship
  17. Degree of a Relationship
  18. E-R Diagram for Library Management System
  19. E-R Diagram for Student Management System
  20. E-R Diagram for Ticket Booking System
  21. Types of Queries : Select Query , Action Query
  22. Creating the Query : Using Query Design Window
  23. Using Simple Query Wizard
  24. Selecting Records by Criteria
  25. DataModeling : Main Ingredients : Entity and Object
  26. Database Design : Database Development Process
  27. Logical Database Design : Represent Entities
5.3: Further Aspects of Database Management  (Practice Test)
  1. Database Administration ( DBA)
  2. End User in Database
  3. Constraints in Relational Database
  4. Referential Integrity