DSA 2019

DSA year 2019 Group A A queue is an ordered collection of items where the addition of new items happens at one end, called the “rear,” and the removal of existing items occurs at the other end, commonly called the “front Big-O notation is the language we use for talking about how long an algorithm […]

Continue Reading

DBMS pre board 2019 Solution

Asian cab Hetauda IMS Morgan Nagarjuna NCC Asian What are the advantages of DBMS ? [Chapter – 1] => The advantages of DBMS are : It is consistent . It has high security measures.  Write down the basic SQL syntax to update a relation. [Chapter – 3] => The basic syntax to  update a relation […]

Continue Reading

UNIT 3: SQL

History IBM Sequel language developed as part of System R project at the IBM San Jose Research Laboratory Renamed Structured Query Language (SQL) ANSI and ISO standard SQL: SQL-86 SQL-89 SQL-92 SQL:1999 (language name became Y2K compliant!) SQL:2003 Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and […]

Continue Reading

Normalization

First Normal Form (1NF) Each column is unique in 1NF. As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values. Example: 1 Sample Employee table, it displays employees are working with multiple departments. Employee Age Department Melvin 32 Marketing, Sales Edward […]

Continue Reading