Assignment

Assignment topic is ER Model Diagram and due date is 13-04-2024.

Grades & Toppers of IAE3

RAKSHITHA B

1

PRITHIKAA RN

2

SHREYA SD

3

Grades & Toppers of IAE2

PRITHIKAA RN

1

SATHYA S

2

SREESHMA G

2

SRINITHI R

2

SAHANA M

3

SAMYUKTHA RV

3

SHREYA SD

3

Grades & Toppers of IAE1

RAKSHITHA B

1

SHREYA SD

2

PRITHIKAA RN

3

Question Bank

Dear Students the Question Bank has been uploaded for the following topics:
UNIT 4 & 5

Lecture Notes

Dear Students the Lecture Notes has been uploaded for the following topics:
Concurrency Control – Need for Concurrency,
Deadlock – Transaction Recovery,
Isolation Levels,
Data Storage and Indexes – RAID,
File organization-Indexing and Hashing –Ordered Indices,
MongoDB-Installing and Set up

Youtube Video

Dear Students the Youtube Video has been uploaded for the following topics:
INTRODUCTION
Relational data Model
Database Design

Resource Link

Dear Students the Resource Link has been uploaded for the following topics:
dbms

Question Bank

Dear Students the Question Bank has been uploaded for the following topics:
Question paper,
Question paper,
Question paper_AK,
Question_Paper,
Question_Paper_Answerkey

Lecture Notes

Dear Students the Lecture Notes has been uploaded for the following topics:
Purpose of Database System,
Database Management system - Three-schema architecture of DBMS,
Components of DBMS,
Entity –Relationship Model,
Entities, entity types, attributes,
Relationships, relationship types,
E/R diagram notations, Examples,
Views of data – Data models,
Relational Data Model - keys, referential integrity and foreign keys,
Relational Algebra,
SQL fundamentals- Introduction,
data definition in SQL, table, key and foreign key definitions,
Intermediate SQL,
Advanced SQL features,
Oracle:Database Design and Querying Tools; SQL Variations and Extensions,
Dependencies and Normal forms,
Functional Dependencies,
minimal covers-Non- loss decomposition,
First,Second,Third Normal Forms,
Dependency Preservation-Boyce/Codd Normal Form,
Multivalued Dependencies and Fourth Normal Form,
Join Dependencies and Fifth Normal Form,
Transaction Concepts – ACID Properties,
Schedules – Serializability