J.N.T.U.H. COLLEGE OF ENGINEERING
KUKATPALLY, HYDERABAD – 500 085
CERTIFICATE
This is to certify that _____________________of B.Tech III year I
Semester bearing the Hall-Ticket number ___________ has fulfilled
his/her DATABASE MANAGEMENT SYSTEMS LAB record for the
academic year 2018-2019.
Signature of the Head of the Department Signature of the staff member
Date of Examination_________________________
Internal Examiner External Examiner
,TABLE OF CONTENTS
Sno. Date Page no. Sign
Name of the experiment
1. Conceptual Design with E-R 22/06/18
Model
2. 06/07/18
Relational Model
3. Normalization 13/07/18
4. Practicing DDL commands 20/07/18
5. Practicing DML Commands 03/08/18
6. Querying using ANY, ALL, IN, 24/08/18
EXISTS, NOT EXISTS, UNION,
INTERSECT, CONSTRAINTS etc
7. Queries using Aggregate Functions 31/08/18
, GROUP BY, HAVING
8. Triggers Usage 08/08/18
9. Usage of cursors 06/10/18
.
, Topic 1: Conceptual Design with E-R Model
❖ Entity-relationship model is a model used for design and representation of relationships
between data.
❖ The main data objects are termed as Entities, with their details defined as attributes,
some of these attributes are important and are used to identity the entity, and different
entities are related using relationships.
❖ An Entity is generally a real-world object which has characteristics and holds
relationships in a DBMS.
❖ If a Student is an Entity, then the complete dataset of all the students will be the Entity
Set.
❖ An attribute is a property or descriptor of an entity. Attributes Define Entities.
❖ When an Entity is related to another Entity, they are said to have a relationship. For
example, A Class Entity is related to Student entity, because students study in classes,
hence this is a relationship.
Components Of E-R diagram.
• Entity: Represented by a Rectangle.
ENTITY_NAME
• Relationships between Entities - Weak and Strong
STRONG WEAK
STRONG ENTITY WEAK ENTITY
• Attributes for any Entity
KUKATPALLY, HYDERABAD – 500 085
CERTIFICATE
This is to certify that _____________________of B.Tech III year I
Semester bearing the Hall-Ticket number ___________ has fulfilled
his/her DATABASE MANAGEMENT SYSTEMS LAB record for the
academic year 2018-2019.
Signature of the Head of the Department Signature of the staff member
Date of Examination_________________________
Internal Examiner External Examiner
,TABLE OF CONTENTS
Sno. Date Page no. Sign
Name of the experiment
1. Conceptual Design with E-R 22/06/18
Model
2. 06/07/18
Relational Model
3. Normalization 13/07/18
4. Practicing DDL commands 20/07/18
5. Practicing DML Commands 03/08/18
6. Querying using ANY, ALL, IN, 24/08/18
EXISTS, NOT EXISTS, UNION,
INTERSECT, CONSTRAINTS etc
7. Queries using Aggregate Functions 31/08/18
, GROUP BY, HAVING
8. Triggers Usage 08/08/18
9. Usage of cursors 06/10/18
.
, Topic 1: Conceptual Design with E-R Model
❖ Entity-relationship model is a model used for design and representation of relationships
between data.
❖ The main data objects are termed as Entities, with their details defined as attributes,
some of these attributes are important and are used to identity the entity, and different
entities are related using relationships.
❖ An Entity is generally a real-world object which has characteristics and holds
relationships in a DBMS.
❖ If a Student is an Entity, then the complete dataset of all the students will be the Entity
Set.
❖ An attribute is a property or descriptor of an entity. Attributes Define Entities.
❖ When an Entity is related to another Entity, they are said to have a relationship. For
example, A Class Entity is related to Student entity, because students study in classes,
hence this is a relationship.
Components Of E-R diagram.
• Entity: Represented by a Rectangle.
ENTITY_NAME
• Relationships between Entities - Weak and Strong
STRONG WEAK
STRONG ENTITY WEAK ENTITY
• Attributes for any Entity
