E-R Model Quiz
Find Four types of Cardinality and set Cardinality.
Find one-to-one, many-to-many and one to many Relationship
Also set Cardinality.
Structured Query Language
Structured Query Language.
SQL Stands for Structure Query
Language. SQL is not full-featured Programming
language. It is English like language. SQL has
language statements for database definition and
processing (query and updatin
A collection of raw fact and figure is
The word raw means that the facts
have not yet been processed to get their
exact meaning. Data is collected from
different sources. It is collected for
Three tier architecture
The standard planning and
Requirement committee of America National
Standards Institute (ANSI) developed and
published a three level architecture in 1975.
Three Level architectures based on
Note: Total Marks is 100 and Total time is 1.5 hour.
Structure Query Language Questions.(20*3)
Final Model Paper
Note: Total Marks is 100 and Total time is 2.00 hour.
All concept from the databases also includi
Select is used to select or get data from a table.
Insert is used to enter a new row in a table.
Update is user to edit one or more columns in a table.
Delete is used to delete a row from the table.
Truncate is used to delete all rows from the t
Relational Data Integrity.
Data integrity means reliability and accuracy of data. Integrity rules are designed to keep the
data consistent and correct. It is very important that a database maintains the quality of the data stored
in it. Data integrity is
The process of producing a simpler and more reliable database structure or relations is called normalization. It is used
to create a suitable set of relation for storing data. This process works through different stages known as normal form
Client-server architecture is a network of computers. It consists of two types of
computers known as Client and Server. The client computers process applications and server
computers provide services to that client computer such
Self Work For Students
Detail of SQL :
TYPES OF SQL
SELECT: SINGLE COLUMN SELECTION
MULTI COLUMN SELECTION
ALL COLUMNS SELECT
ARTHEMATIC OPERATORS (+, - ,*, /,
10. COMPARISON OPERATORS
Element of E-R Model
An entity is a person, place, thing or event for which the data is collected and maintained. Some
example of entity is as follow
Person: Teacher, Student, Doctor
Place: Country, City, Province
Object: Vehicle, Toy, Furn
A data model is a collection of concepts that can be used to describe the structure of a
database whereas structure of a database means the data types, relationships and constraints
that should hold on the data.
A database model determines in