Google+ PHP TUTORIALS ONLINE HELP FOR MEDICAL AND PROGRAMMING: RDBMS COURSE CONTENTS

Thursday 27 February 2014

RDBMS COURSE CONTENTS

RDBMS COURSE CONTENTS

 DATA MODELS

 Database Management Systems
Data Models
  • Object-Base Logical Model
  • Record-Based Logical Model
  • Steps for Creating an ER Diagram.
Relational Operators
  • RESTRICT
  • PROJECT
  • PRODUCT
  • UNION
  • INTERSECT
  • DIFFERENCE
  • JOIN
  • DIVIDE
DATABASE DESIGN
Conceptual Model
  • Mapping ER Diagrams to Table
Tips on Logical Database Design
  • Attributes
  • Keys
  • Entities
  • Subentities
Normalizing and denormalizing Data

 Understanding Data Redundancy
  • Definition of Normalization
Undaerstanding Denormalization
  • Definition of Denormalization
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)