DATA BASE FOR ENGINEERS
(toc)Table of Contents
UNIT –I
- Introduction to DBMS
- Data Base System Applications
- Data Base System VS File System,
- Instances And Schemas
- Data Models – The ER Model, ER Diagrams
- Attributes And Entity Sets
- Relationships And Relationship Sets
- Concept Design With The ER Model .
To Practice:
1)Practicing DDL commands: Creating tables for various relations (in SQL).
2) Practicing Hostel Management System ER Diagram, Airlines Reservation System ER Diagram.
UNIT –II
- Relational Model: Introduction To The Relational Model
- Basic Structure, Database Schema, Keys,
- Form Of Basic SQL Query
- Database Languages, DDL, DML,
- Examples Of Basic SQL Queries
To Practice:
Practicing SQL Queries of above mentioned topics
UNIT –III
- SQLoperators
- SQL functions
- JOINS, -Types of Joins
- Introduction To Nested Queries
- Set Operators
- Integrity Constraints over relations
- Introduction to Views
- Destroying / altering tables and views.
- Practice on DCL and TCL commands.
To Practice:
Practicing SQL Queries of above mentioned topics
UNIT –IV
- Pitfalls in relational databases
- Functional Dependencies
- Importance of Normalization–1NF,2NF,3NF,BCNF,4NF
To Practice:
Concepts of Normalizations and its types, Writing Assertions.
UNIT –V
- Transaction Concept- Transaction state
- ACID properties
- Concurrent executions
- Serializability
- Lock based protocols
- Log based recovery.
To Practice:
Practicing, DCL and TCL commands,( Commit, rollback, Save points, Grant, Revoke and Roles
commands on tables)
Download Notes
Unit 1 Notes 👉👉 CLICK HERE
Unit 2 Notes 👉👉 CLICK HERE
Unit 3 Notes 👉👉 CLICK HERE
Unit 4 Notes 👉👉 CLICK HERE
Unit 5 Notes 👉👉 CLICK HERE
Contact – Prakash Notes
If you have any queries, need help, or want any content to be removed or corrected, feel free to reach out.
📧 Email: jayaprakash2821@gmail.com
Your feedback helps improve Prakash Notes. Thank you for your support!
