Course Content

Other Courses

Tribhuvan university BCA BCA Curriculum Database Administration

Database Administration - Syllabus

Course Overview and Structure
Syllabus Notes Old Questions Unit Wise Questions Question Bank

Embark on a profound academic exploration as you delve into the Database Administration course () within the distinguished Tribhuvan university's BCA department. Aligned with the BCA Curriculum, this course (CACS405) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 100 marks system, coupled with a challenging passing threshold of , propels students to strive for excellence, fostering a deeper grasp of the course content.

This 6 credit-hour journey unfolds as a holistic learning experience, bridging theory and application. Beyond theoretical comprehension, students actively engage in practical sessions, acquiring valuable skills for real-world scenarios. Immerse yourself in this well-structured course, where each element, from the course description to interactive sessions, is meticulously crafted to shape a well-rounded and insightful academic experience.


Course Description
This course provides the comprehensive knowledge about relational database management
system in administrative approach to integrate in enterprise levelof database in network
environment which encompasses with oracle database instances Management, database
installment in network environment, implementing user role and privileges, multitenant database
management, back and recovery.
Objectives: The general objectives of this course is to provide core knowledge of administrative
works on relational database management system

Units

Key Topics

  • Introduction to Computers
    IN-01

    An overview of computers and their significance in today's world. This topic sets the stage for understanding the basics of computers.

  • Digital and Analog Computers
    IN-02

    Understanding the difference between digital and analog computers, their characteristics, and applications.

  • Characteristics of Computers
    IN-03

    Exploring the key characteristics of computers, including input, processing, storage, and output.

  • History of Computers
    IN-04

    A brief history of computers, from their inception to the present day, highlighting key milestones and developments.

  • Generations of Computers
    IN-05

    Understanding the different generations of computers, including their features, advantages, and limitations.

  • Classification of Computers
    IN-06

    Categorizing computers based on their size, functionality, and application, including desktops, laptops, and mobile devices.

  • The Computer System
    IN-07

    An in-depth look at the components of a computer system, including hardware and software.

  • Applications of Computers
    IN-08

    Exploring the various applications of computers in different fields, including business, education, and healthcare.

Key Topics

  • Introduction to Matrices
    MA-1

    This topic introduces the concept of matrices, including their definition, notation, and basic operations. It lays the foundation for further study of matrices and their applications.

  • Types of Matrices
    MA-2

    This topic covers the different types of matrices, including square matrices, diagonal matrices, identity matrices, and zero matrices. It explains their properties and characteristics.

  • Equality of Matrices
    MA-3

    This topic defines and explains the concept of equality of matrices, including the conditions for two matrices to be equal and the rules for comparing matrices.

  • Algebra of Matrices
    MA-4

    This topic covers the basic algebraic operations of matrices, including addition, subtraction, multiplication, and scalar multiplication. It explains the rules and properties of these operations.

  • Determinants
    MA-5

    This topic introduces the concept of determinants, including their definition, calculation, and properties. It explains the importance of determinants in matrix theory and their applications.

  • Transpose, Minors, and Cofactors of a Matrix
    MA-6

    This topic covers the concepts of transpose, minors, and cofactors of a matrix, including their definitions, calculations, and properties. It explains their relationships and applications.

  • Properties of Determinants
    MA-7

    This topic explains the various properties of determinants, including the multiplication property, addition property, and scalar multiplication property. It highlights their importance in matrix theory.

  • Singular and Non-Singular Matrices
    MA-8

    This topic defines and explains the concepts of singular and non-singular matrices, including their properties and characteristics. It highlights their importance in matrix theory and applications.

  • Adjoint and Inverse of Matrices
    MA-9

    This topic covers the concepts of adjoint and inverse of matrices, including their definitions, calculations, and properties. It explains their relationships and applications.

Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing online redo logs and control files, database archiving.

Assigning Quotas to Users, Applying the Principle of Least Privilege, Creating and Assigning Profiles, Administering User Authentication Methods, Managing Oracle Database Users, Privileges, and Roles.

Understanding the Multitenant Architecture, Pluggable Architecture; Creating CDB; Creating Pluggable Databases (PDBs) within a CDB; Manage CDBs and PDBs, Backup and Duplicate, Manage Security in Multitenant databases

Key Topics

  • Nature of Internship
    CO-1

    The internship work should be relevant to the field of computer science and information technology, with a minimum duration of 180 hours or ten weeks.

  • Phases of Internship
    CO-2

    The internship evaluation consists of three phases: Proposal Submission, Mid-Term Submission, and Final Submission.

  • Provision of Supervision
    CO-3

    A regular faculty member of the college is assigned as a supervisor to supervise the students throughout the internship period.

  • Provision of Mentorship
    CO-4

    A regular employee of the intern providing organization is assigned as a mentor to guide the students throughout the internship period.

  • Evaluation Scheme
    CO-5

    The evaluation scheme consists of Proposal Defense, Midterm, and Final Defense, with a total of 200 marks.

  • Report Contents
    CO-6

    The internship report should contain prescribed content flow, including introduction, problem statement, objectives, and references.

  • Citation and Referencing
    CO-7

    The citation and referencing standard should be APA referencing standard, with proper citation and referencing in the document.

  • Report Format Standards
    CO-8

    The report format standards include page number, page size and margin, paragraph style, text font, section headings, figures and tables.

  • Final Report Binding and Submission
    CO-9

    The final report should be submitted in three copies, with a golden embracing and black binding, to the Dean Office, Exam Section, Institute of Science and Technology, Tribhuvan University.

  • Programmable Array Logic (PAL)
    CO-10

    A type of digital integrated circuit that can be programmed to perform a specific digital function, similar to PLA but with some differences.

Backup and Recovery Concepts, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery option; Data Dump; User-Managed Backup and Recovery; Configuring RMAN; RMAN Backups, Restore and Recovery, Perform CDB and PDB flashback.

Introduction to the Scheduler, Access Rights, Scheduler Components and Workflow, create a Job, Job Classes, Use Time Based, Event-Based Schedules, Create an Event-Based Schedule.