DBMS detail syllabus RAJASTHAN Basic Computer Teacher rsmssb
Details Syllabus (Course content)
* Introduction to DBMS (Data, Database, DBMS)
*File System introduction
* File System V/S DBMS
*2-tier Architecture, 3-tier Architecture
*3- level of Abstraction (3-schema Architecture)
*Representation of Data == Bit(character) , field Record, File, Database.
*Data, information, knowledge
* Groals of DBMS.
* Advantage of DBMS
* Application of DBMS
* Types of Data model
→ Hierarchical Database model
→ Network Database model
→Relational Database model
* Object-Oriented database model
*Database Design
↳ER model(Entity Relationship model)
↳ Mapping Cardinality Constraints
↳ One to one
↳One to many
↳Many its many.
*Keys
→ what is key ?
→ use of Key.
→ Candidate key.
→ Primary Key
→ Secondary Key ( Alternate Key )
→ Super key
→Foreign Key
→ Prime attribute
→ Non-Prime Attribute
*Normalization
↳Insert Anomalies
↳Delete Anomalies
↳Update Anomalies.
* Function dependency (FD)
* Normal form
↳ 1NF
↳ 2NF
↳ 3 NF
↳ 4NF
↳ BCNF
* Transaction [ACID] (ACID=Atomicity Constancity Isolation Durability) Properties
CH ==2
Relational Algebra (Projection Selection, Cross, Product).
SQL (structure Query language)
DDL( Data Defination language)
↳Create table,
↳ after table
↳ drop,
↳ truncate
DML (Data manipulation language).
DCL (Data Control language)
↳Grant
↳ Revoke
TCL (Transaction Control language)
↳ Commit
↳ Rollback
↳Savepoint.
DQL
↳Select
0 Comments