Stuff Sector
Prepared by
S.Santhosh (Admin)
Important questions
share it a link alone
Don't waste my hardwork and valuable time
Don't share as screenshot kind request
most viewed dept will get update at first So Dont screenshot and share
UNIT -1 1. Database requirement,development cycle **Don't share as screenshot2. UML , Enchanced ER modelUNIT-21.SQL Data manipulation,programming very imp2.AIntegrity constraints **UNIT-31.Properties of relational decomposition , NormalizationDon't share as screenshot2.ER and EER-to-Relational mapping
UNIT-41. .Serializability** full topic 2.Concurrency control, two phase looking techniquesDon't share as screenshotUnit -5
1.UDT 2. No-SQL: CAP theorem,MongoDB data model and CRUD 3. Hbase data model Don't share as screenshotDon't share as screenshot -Stuff sector
**Very important questions are bolded and may be asked based on this topic
PART-C
1.Compulsory Questions {a case study where the student will have to read and analyse the subject }mostly asked from unit 2, 5(OR) a situation given and you have to answer on your own
1.UDT
Don't share as screenshot -Stuff sector
**Very important questions are bolded and may be asked based on this topic
don't waste my hardwork and valuable time
Contact uS for more updates
*These questions are expected for the exams This may or may not be asked for exams All the best.... from admin Santhosh
Thanks for your love and support guys keep supporting and share let the Engineers know about Us and leave a comment below for better improvements If there is any doubt feel free to ask me I will clear if I can or-else I will say some solutions ..get me through WhatsApp for instant updates ~$tuff$£ctorSYllabuSUNIT I CONCEPTUAL DATA MODELING
Database environment - Database system development lifecycle - Requirements collection
Database design - Entity-Relationship model - Enhanced-ER model - UML class diagrams
UNIT II RELATIONAL MODEL AND SQL
Relational model concepts - - Integrity constraints -- SQL Data manipulation - SQL Data definition - Views -- SQL programming.
UNIT III RELATIONAL DATABASE DESIGN AND NORMALIZATION
ER and EER-to-Relational mapping - Update anomalies - Functional dependencies - Interence rules - Minimal cover - Properties of relational decomposition - Normalization (upto BCNF).
56
UNIT IV
TRANSACTION MANAGEMENT
Transaction concepts - properties - Schedules - Serializability - Concurrency Control - Two-phase locking techniques
UNIT V OBJECT RELATIONAL AND NO-SQL DATABASES
Mapping EER to ODB schema - Object identifier - reference types - rowtypes - UDTs - Subtypes and supertypes - user-defined routines - Collection types - Object Query Language: No-SQL: CAP theorem - Document-based: MongoDB data model and CRUD operations; Column-based: Hbase data model and CRUD operations.
UNIT I CONCEPTUAL DATA MODELING
Database environment - Database system development lifecycle - Requirements collection
Database design - Entity-Relationship model - Enhanced-ER model - UML class diagrams
UNIT II RELATIONAL MODEL AND SQL
Relational model concepts - - Integrity constraints -- SQL Data manipulation - SQL Data definition - Views -- SQL programming.
UNIT III RELATIONAL DATABASE DESIGN AND NORMALIZATION
ER and EER-to-Relational mapping - Update anomalies - Functional dependencies - Interence rules - Minimal cover - Properties of relational decomposition - Normalization (upto BCNF).
56
UNIT IV
TRANSACTION MANAGEMENT
Transaction concepts - properties - Schedules - Serializability - Concurrency Control - Two-phase locking techniques
UNIT V OBJECT RELATIONAL AND NO-SQL DATABASES
Mapping EER to ODB schema - Object identifier - reference types - rowtypes - UDTs - Subtypes and supertypes - user-defined routines - Collection types - Object Query Language: No-SQL: CAP theorem - Document-based: MongoDB data model and CRUD operations; Column-based: Hbase data model and CRUD operations.