free relational database management systems

The Relational Model: Relational database design using ER to relational mapping, Relational algebra and relational calculus, Tuple Relational Calculus, Domain Relational Calculus, SQL.ĭatabase design theory and methodology: Functional dependencies and normalization of relations, Normal Forms, Properties of relational decomposition, Algorithms for relational database schema design.

Familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B tree, and hashing.ĭatabase System- concepts and architecture: Data modelling using the Entity Relationship (ER) modelling and Enhanced Entity Relationship (EER) modelling, Specialization and Generalization.

Improve the database design by normalization.

Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data.

Design ER-models to represent simple database application scenarios.

Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.

Describe the fundamental elements of relational database management systems.

Upon successful completion of this course, students should be able to:

Free relational database management systems