Category: General Competition

Appendix of CS and IT in Cyber Programming Tutorial

Appendix of CS and IT in Cyber Programming Tutorial Famous Scientists and their Discoveries Wil Vander Aalst Business process management, process mining Hal Abelson Intersection of computing and teaching Serge Abiteboul Database theory Samson Abramsky Game semantics Leonard Adleman RSA, DNA

Tagged with: , , , ,

File Organisation Techniques in DBMS Tutorial Study Notes with Examples

File Organisation Techniques in DBMS Tutorial Study Notes with Examples File Organisation The database is stored as a collection of files. Each file is a sequence of records. A record is a sequence of fields. Data is usually stored in the

Tagged with: , , , ,

File Structures in DBMS Tutorial Study Material Notes with Examples

File Structures in DBMS Tutorial Study Material Notes with Examples File Structures File structure or organisation refers to the relationship Of the key of the record to the physical location of that record in the computer file.                                                                                 Disk Storage Databases

Tagged with: , , , ,

Concept of Schedule in DBMS Tutorial Study Material Notes with Example

Concept of Schedule in DBMS Tutorial Study Material Notes with Example Schedule A schedule (or history) is a model to describe execution of transactions running in the system. When multiple transactions are executing concurrently in an interleaved fashion, then the

Tagged with: , , , ,

Transaction Management in DBMS Tutorial Notes with Examples

Transaction Management in DBMS Tutorial Notes with Examples Transaction Management A sequence of Many actions which are considered to be One atomic unit  work. A transaction is a collection of operations involving data items  in a database, There are four

Tagged with: , , , ,

Concurrency Control Techniques in DBMS Tutorial Notes with Examples

Concurrency Control Techniques in DBMS Tutorial Notes with Examples Concurrency Control Process of managing simultaneous execution of transactions in a shared database, is known as concurrency control. Basically, concurrency control ensures that correct results for concurrent operations are generated, while

Tagged with: , , , ,

Joins in SQL with Example Study Material Notes for Beginners

Joins in SQL with Example Study Material Notes for Beginners JOINS  Joins are needed to retrieve data from two tables’ related rows on the basis of some condition which satisfies both the tables. Mandatory  conditions to  join is that at-least

Tagged with: , , , ,

SQL Tutorial for Beginners Study Material Notes with Examples

SQL Tutorial for Beginners Study Material Notes with Examples SQL Structured Query Language (SQL) is a language that provides an interface to relation database systems. SQL was developed by IBM in the 1970, for use in system R and is

Tagged with: , , , ,

Normalization in Database Tutorial Study Material Notes With Examples

Normalization in Database Tutorial Study Material Notes With Examples Normal forms/Normalization In relation database design, the normalization is the process for organizing data to minimize redundancy. Normalization usually involves dividing a data base into two or more tables and defining

Tagged with: , , , ,

Memory Hierarchy in Computer Organization Tutorial Notes with Examples

Memory Hierarchy in Computer Organization Tutorial Notes with Examples Memory Hierarchy The memory unit is used for storing programs and data. It fulfills the need of storage of the information. The additional storage with main memory capacity enhance the performance

Tagged with: , , , ,
Top
Show Buttons
Hide Buttons