Database Administration - Syllabus

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

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

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

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

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

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

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

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

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.

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

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.

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.

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.

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.

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.

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.

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

Understanding the concept of tablespaces and data files, and learning how to create and add them to a database.

Managing control files, including creating, modifying, and maintaining them to ensure database integrity.

Understanding the role of online redo logs, and learning how to create, manage, and maintain them for database recovery.

Learning how to manage archive logs, including creating, storing, and maintaining them for database recovery and auditing.

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.

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

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.

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.

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.

Introduction to multiple correlation, its concept, and application in statistics. Exploring the relationship between multiple variables.

Understanding partial correlation, its concept, and application in statistics. Analyzing the relationship between two variables while controlling for other variables.

Basic concepts and principles of multiple linear regression, including model formulation and estimation. Understanding the relationship between multiple independent variables and a dependent variable.

Testing hypotheses in multiple regression, including significance testing and confidence intervals. Evaluating the overall fit and significance of the regression model.

Testing the overall significance of the regression model, including F-test and p-value interpretation. Determining whether the regression model is a good fit to the data.

Testing the significance of individual regression coefficients, including t-test and p-value interpretation. Evaluating the contribution of each independent variable to the regression model.

Evaluating the goodness of fit and adequacy of the multiple regression model, including residual analysis and diagnostic plots. Identifying potential issues and limitations of the model.

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.

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

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

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

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

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

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

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

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.

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

This topic introduces the concept of backtracking, a problem-solving strategy that involves recursively exploring all possible solutions and backtracking when a dead end is reached. It also compares and contrasts backtracking with recursion.

This topic covers various backtracking algorithms, including those for solving the subset-sum problem, zero-one knapsack problem, and N-queen problem, along with their analysis.

This topic covers the instruction format, instruction set completeness, and the control unit of a basic computer. It explains how the control unit retrieves and executes instructions.

This topic explains the instruction cycle of a basic computer, including determining the type of instruction, memory reference instructions, input-output instructions, and program interrupts. It also covers the interrupt cycle and how it affects computer operation.

This topic provides a detailed description and flowchart of a basic computer, illustrating how the different components work together to execute instructions and perform tasks.

Concept of pointers in programming, including their use in data structures and memory management.

This topic covers the functions of each pin on the 8085 microprocessor, including their roles in input/output operations.

This topic discusses the process of demultiplexing buses in the 8085 microprocessor, including its importance in improving system performance.

This topic explains how control signals are generated in the 8085 microprocessor, including their role in controlling the flow of data.

The proximal nodes mode is a retrieval model that uses the proximity of terms in a document to improve the retrieval of relevant documents.

Understanding flashback technology, including performing flashback on Container Database (CDB) and Pluggable Database (PDB).

An overview of the importance of understanding audience and purpose in technical writing, and how it sets the foundation for effective communication.

Understanding the audience's requirements, expectations, and preferences to tailor the content and ensure it meets their needs.

Defining the purpose of the document, including its goals, objectives, and key takeaways.

Determining the boundaries and limitations of the document to ensure it stays focused and relevant.

Choosing the most suitable medium for the document, such as print, digital, or online, based on the audience and purpose.

The Needham-Schroeder scheme is a protocol for secure communication that provides authentication and key exchange between two parties. It is a widely used protocol in secure communication systems.

The Kerberos protocol is a secure authentication protocol that uses tickets and symmetric-key cryptography to provide secure authentication and communication between clients and servers.

This topic provides a hands-on guide to creating an event-based schedule in the Scheduler, including defining the event trigger and schedule settings.