DAY 1
Thursday, July 16, 2020 9:35 AM
SQL ( STRUCTURED QUERY LANGUAGE )
DATABASE
What is DATA ?
"Data is a raw-fact which describes the attributes of an Entity ".
Properties or Attributes
I am creating an account for myself :
Attributes
Laptop Laptop
First name : Rohan
Surname : Singh Brand : Dell Brand : Apple
Phone number : 9876543210 RAM : 8gb RAM : 16gb
Password : Rohan@123 Touch : no Touch : yes
Dob : 14-MAY-199X
Gender : MALE Height : 20cms
Contacts
Name : Dinga
Color : blue Phone : 108
Example : Water Bottle
DOB: 14-feb-95
Entity
Capacity : 500ml
Attributes
DATABASE :
Online DAY 1 Page 1
,"Database is a place or a medium in which we store the data in a
Systematic and organized manner "
STUDENT : YOU HAVE TO PRESENT
Database
PPT
Dinga PPT
HARD DISK
PEN DRIVE
➢ The basic operations that can be performed on a database are
▪ CREATE / INSERT
▪ READ / RETRIEVE
▪ UPDATE / MODIFY
▪ DELETE / DROP
➢ These operations are referred as "CRUD" Operations .
DATABASE MANAGEMENT SYSTEM ( DBMS ) :
"It is a software which is used to maintain and manage
The database "
➢ Security and authorization are the two important features that
DBMS provides .
Software
Data
QUERY
LANGUAGE Database
DBMS
➢ We use query language to communicate or interact with DBMS
➢ DBMS stores the data in the form of files .
A D E
B C
RELATIONAL DATABASE MANAGEMENT SYSTEM
( RDBMS ):
"It is a type of DBMS software in which we store the data
In the form of Tables ( rows & columns ) ".
Online DAY 1 Page 2
, In the form of Tables ( rows & columns ) ".
Software
Data
STRUCTURED
QUERY Database
LANGUAGE
RDBMS
• We use SQL to communicate or interact with RDBMS
• RDBMS stores the data in the form of Tables.
Names
Example :
A
B
C
D
E
Notes link : bit.ly/roSQLQCDM34
Mail ID :
Instagram : ro_sql_helpmate
Online DAY 1 Page 3
, DAY 2
Friday, 17 July 2020 8:59 AM
RELATIONAL MODEL :
Relational Model was designed by E.F CODD .
In Relational Model we can store the data in the from of tables .
Any DBMS which follows Relational Model becomes RDBMS .
DBMS. Relational Model RDBMS
Any DBMS which follows rules of EF CODD becomes RDBMS .
TABLE : "It is a logical organization of data which consists of
Columns &Rows .
Columns / Attribute / Fields
Rows
/ Cell
Records
/
Tuples
Example : Emp ( Entity )
- Eid
Employee : - Ename
EID ENAME SALARY
- Salary
1 SMITH 1000
2 ALLEN 1500
3 CLARK 2000
RULES OF E.F CODD :
1. The data entered into a cell must always be a single valued data .
Example :
Thursday, July 16, 2020 9:35 AM
SQL ( STRUCTURED QUERY LANGUAGE )
DATABASE
What is DATA ?
"Data is a raw-fact which describes the attributes of an Entity ".
Properties or Attributes
I am creating an account for myself :
Attributes
Laptop Laptop
First name : Rohan
Surname : Singh Brand : Dell Brand : Apple
Phone number : 9876543210 RAM : 8gb RAM : 16gb
Password : Rohan@123 Touch : no Touch : yes
Dob : 14-MAY-199X
Gender : MALE Height : 20cms
Contacts
Name : Dinga
Color : blue Phone : 108
Example : Water Bottle
DOB: 14-feb-95
Entity
Capacity : 500ml
Attributes
DATABASE :
Online DAY 1 Page 1
,"Database is a place or a medium in which we store the data in a
Systematic and organized manner "
STUDENT : YOU HAVE TO PRESENT
Database
PPT
Dinga PPT
HARD DISK
PEN DRIVE
➢ The basic operations that can be performed on a database are
▪ CREATE / INSERT
▪ READ / RETRIEVE
▪ UPDATE / MODIFY
▪ DELETE / DROP
➢ These operations are referred as "CRUD" Operations .
DATABASE MANAGEMENT SYSTEM ( DBMS ) :
"It is a software which is used to maintain and manage
The database "
➢ Security and authorization are the two important features that
DBMS provides .
Software
Data
QUERY
LANGUAGE Database
DBMS
➢ We use query language to communicate or interact with DBMS
➢ DBMS stores the data in the form of files .
A D E
B C
RELATIONAL DATABASE MANAGEMENT SYSTEM
( RDBMS ):
"It is a type of DBMS software in which we store the data
In the form of Tables ( rows & columns ) ".
Online DAY 1 Page 2
, In the form of Tables ( rows & columns ) ".
Software
Data
STRUCTURED
QUERY Database
LANGUAGE
RDBMS
• We use SQL to communicate or interact with RDBMS
• RDBMS stores the data in the form of Tables.
Names
Example :
A
B
C
D
E
Notes link : bit.ly/roSQLQCDM34
Mail ID :
Instagram : ro_sql_helpmate
Online DAY 1 Page 3
, DAY 2
Friday, 17 July 2020 8:59 AM
RELATIONAL MODEL :
Relational Model was designed by E.F CODD .
In Relational Model we can store the data in the from of tables .
Any DBMS which follows Relational Model becomes RDBMS .
DBMS. Relational Model RDBMS
Any DBMS which follows rules of EF CODD becomes RDBMS .
TABLE : "It is a logical organization of data which consists of
Columns &Rows .
Columns / Attribute / Fields
Rows
/ Cell
Records
/
Tuples
Example : Emp ( Entity )
- Eid
Employee : - Ename
EID ENAME SALARY
- Salary
1 SMITH 1000
2 ALLEN 1500
3 CLARK 2000
RULES OF E.F CODD :
1. The data entered into a cell must always be a single valued data .
Example :
