Untitled

Unit 1 - INTRO TO DBMS

DBMS

• 1. Basic concepts of DBMS
  • 1. data vs information
• 2. Data Processing
• 3. Definition of DBMS
• 4. Characteristics of database

Database architecture

• 1. Levels of abstraction
• 2. database schema
• 3. database instance
• 4. 3 tier architecture
• 5. Data Independence
• 6. Database users
• 7. Types of DBMS

UNIT 2 - DATA MODELING

• 1. Logical data modeling
  • 1. Hierarchical data model
  • 2. Network data model
  • 3. Relational data model
• 2. Conceptual data modeling
  • 1. Entity relationship model
    • entity
      • strong entity
      • weak entity
    • Attributes
      • Types of attributes
        • single
        • Multi valued
        • composite
    • Relationships
      • degree of relationship set
    • instances, rows, tuples
    • cardinality
    • Participation - partial and total

UNIT 3

• Codd’s rules for RDBMS
• Keys
  • primary
  • foreign
  • candidate key
  • super
  • unique
  • simple
  • composite
• Normalization
  • definition
  • decomposition
    • lossy
    • lossless
  • Functional dependencies
  • Normal Forms
    • FIRST NF
    • SECOND NF
    • THIRD NF
    • Case studies

UNIT 4 -