1118010920171445151 (1).pdf - DATABASES AND SQL CLASS XII RITU JAIN COMPUTER SCIENCE FACULTY DARBARI LAL DAV MODEL SCHOOL SHALIMAR BAGH Database It is a

1118010920171445151 (1).pdf - DATABASES AND SQL CLASS XII...

This preview shows page 1 - 8 out of 50 pages.

DATABASES AND SQL CLASS XII RITU JAIN, COMPUTER SCIENCE FACULTY DARBARI LAL DAV MODEL SCHOOL, SHALIMAR BAGH
Image of page 1
It is a collection of related information that is organized(Tables) in such a way that supports for easy access, modify and maintain data. Database Ritu Jain, Computer Science Faculty
Image of page 2
Databases and SQL The software required to handle/manipulate these tables/relations is known as Database Management System (DBMS) Oracle, Sybase, DB2, MS SQL Server, MYSQL, etc. Ritu Jain, Computer Science Faculty
Image of page 3
IMPORTANT TERMS Domain: It refers to all the possible unique values of a particular column. For example : The domain of gender column has a set of two possible values i.e, Male or Female. Table/Relation: Table is the collection of related data entries which means that the table should consists of columns and rows. For example : Relation/Table : Student Ritu Jain, Computer Science Faculty
Image of page 4