Notes for DBMS

Ahamed Yaseen 09:11
1 .How do we select  DISTINCT  values from a table? DISTINCT keyword is used to return only distinct values.Below is syntax:SELECT DIST... Read More
Notes for DBMS Notes for DBMS Reviewed by Ahamed Yaseen on 09:11 Rating: 5

DBMS Query

Ahamed Yaseen 08:59
1.I have an employee salary table how do we find the second highest from it? Table name->EmployeeSalary Salary ——— 100 200      <... Read More
DBMS Query DBMS Query Reviewed by Ahamed Yaseen on 08:59 Rating: 5

Types of Statements-DBMS

Ahamed Yaseen 08:58
Types of Statements 1.DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples... Read More
Types of Statements-DBMS Types of Statements-DBMS Reviewed by Ahamed Yaseen on 08:58 Rating: 5

CODD RULES

Ahamed Yaseen 08:53
Difference between DBMS & RDBMS:- DBMS provides a sysmatic and organized way of storing,managing and retriving from collection of lo... Read More
CODD RULES CODD RULES Reviewed by Ahamed Yaseen on 08:53 Rating: 5

Normalization

Ahamed Yaseen 07:37
De- Normalization Denormalization is the process of putting one fact in numerous places(its vice-versa of normalization).Only one valid r... Read More
Normalization Normalization Reviewed by Ahamed Yaseen on 07:37 Rating: 5
Powered by Blogger.