Introduction to Database systems

This course covers database design concepts and their usage,It includes extensive coverage of the relational model, relational algebra. The course also features database design and relational design principles based on dependencies and normal forms.Many additional key database topics from the design-building perspective and also covered integrity constraints.There will be pop up quizzes and exercises to grow further knowledge in database design.

Course Outline:
  • Database concepts
    1. Basic database design concepts
  • Data models
    1. Data models and its importance
    2. Data models building blocks
    3. Business rules
    4. Translating business rules into data models components
    5. Relational model and ERM
    6. Chen, crow’s foot notations and the OO model
  • The relational database model
    1. Keys and their types
    2.  Referential Integrity and Integrity rules
    3. Relational SET operators
    4. Database relationships
    5. Quiz
  • Entity relationship modeling
    1. Entity relationship modeling concepts
    2. Connectivity, Cardinality and Relationship Participation
    3. Existence Dependence
    4. Relationship Strength
    5. Weak Entities
    6. Relationship degrees
    7. Assignment 1
  • Database normalization
    1. Normalization concepts
    2. 1NF, 2NF, 3NF (normal forms)
    3. Assignment 2

 Course Discount Link:
  • The course will be available very soon.

Recommended Book:
  • Database system design, implementation & management by Peter rob and Carios coronil (Latest Edition)

Comments

Post a Comment