Knowledge in Database Management System
Database Management System Text Book.
Here in this document it is explaining about the DBMS (Database management system). All chapters in a clearly way.
Simran Fathima
database management system
database management system is the subject that dealts with tables,queries,structured query language,primary key and foreign keys.
Prabhanshi Dhankar
A book of Database Management System for (C.S) Students
Study Material for Database Management System for all the Students of Computer Science & Engineering. According to me this is very helpful for us.
Mohit Kumar
DBMS labs related material.
Study Material of DBMS labs for B.Tech 3th semester students of Jaypee University Anoopshahr.
Database Management Systems
The content will provide the reader with the knowledge of almost every main and basic aspect of database management system
Muskan Mehrotra
Introduction To Database System (MYSQL) and Ramakrishana Database Management System 3rd edition
Here are the proper handwritten notes of database system (MYSQL) covering the syllabus of 2nd semester of Generic elective computer science (Introduction to Database System) of delhi university. If you are going to pursue B.Sc honors at delhi university then in 1st,2nd, 3rd and 4th semester you need to choose one subject of your choice as generic elective. If you choose computer science as generic elective in your second semester then these notes are going to help you a lot. The software used for the practicals in lab is mysql (oracle).
Neetesh Gupta
Redis Database
Gives a perfect overview of Redis database system. Gives an perfect overview of how to create and manage a Redis databse.
Aditya Sethi
Introduction to NoSQL
Following document giver a basic idea of how a Nosql database was created and how it can easily help us in managing a database system.
Ramakrishnan Database Management System 3rd Edition
Here is the most preferred book of database system (MYSQL) covering the syllabus of 2nd semester of Generic elective computer science (Introduction to Database System) of delhi university. If you are going to pursue B.Sc honors at delhi university then in 1st,2nd, 3rd and 4th semester you need to choose one subject of your choice as generic elective. If you choose computer science as generic elective in your second semester then these notes are going to help you a lot. The software used for the practicals in lab is mysql (oracle).
SYSTEM SOFTWARE
There are two main types of software: systems software and application software. Systems software includes the programs that are dedicated to managing the computer itself, such as the operating system, file management utilities, and disk operating system (or DOS). System software is a software that provides platform to other softwares. Some examples can be operating systems, antivirus softwares, disk formating softwares, Computer language translators etc. These are commonly prepared by the computer manufacturers. These softwares consists of programs written in low-level languages, used to interact with the hardware at a very basic level. System software serves as the interface between the hardware and the end users. The most important features of system software include : 1. Closeness to the system 2. Fast speed 3. Difficult to manipulate 4. Written in low level language 5. Difficult to design Operating System An operating system (OS) is a type of system software that manages computer’s hardware and software resources. It provides common services for computer programs. An OS acts a link between the software and the hardware. It controls and keeps a record of the execution of all other programs that are present in the computer, including application programs and other system software. The most important tasks performed by the operating system are 1. Memory Management: The OS keeps track of the primary memory and allocates the memory when a process requests it. 2. Processor Management: Allocates the main memory (RAM) to a process and de-allocates it when it is no longer required. 3. File Management: Allocates and de-allocates the resources and decides who gets the resources. 4. Security: Prevents unauthorized access to programs and data by means of passwords. 5. Error-detecting Aids: Production of dumps, traces, error messages, and other debugging and error-detecting methods. 6. Scheduling: The OS schedules process through its scheduling algorithms. Compiler : A compiler is a software that translates the code written in one language to some other language without changing the meaning of the program. The compiler is also said to make the target code efficient and optimized in terms of time and space. A compiler performs almost all of the following operations during compilation: preprocessing, lexical analysis, parsing, semantic analysis (syntax-directed translation), conversion of input programs to an intermediate representation, code optimization and code generation. Examples of compiler may include gcc(C compiler), g++ (C++ Compiler ), javac (Java Compiler) etc.
Shantha Kumar . V
DATABASE MANAGEMENT SYSTEM
Querying Relational Databases Relational Algebra SQL (in some depth) Contraints Attribute and tuple constraints Referential Integrity General constraints (assertions) Triggers Universal Modeling Language (for conceptual database design) Relational Design Theory Functional Dependencies Normal Forms Design by Decomposition Views Indexing Transactions Non-relational JSON Data mining (e.g., association rules)
SYSTEM SOFTWARE
There are two main types of software: systems software and application software. Systems software includes the programs that are dedicated to managing the computer itself, such as the operating system, file management utilities, and disk operating system (or DOS). System software is a software that provides platform to other softwares. Some examples can be operating systems, antivirus softwares, disk formating softwares, Computer language translators etc. These are commonly prepared by the computer manufacturers. These softwares consists of programs written in low-level languages, used to interact with the hardware at a very basic level. System software serves as the interface between the hardware and the end users. The most important features of system software include : 1. Closeness to the system 2. Fast speed 3. Difficult to manipulate 4. Written in low level language 5. Difficult to design Operating System An operating system (OS) is a type of system software that manages computer’s hardware and software resources. It provides common services for computer programs. An OS acts a link between the software and the hardware. It controls and keeps a record of the execution of all other programs that are present in the computer, including application programs and other system software. The most important tasks performed by the operating system are