RDBMS & ER Model Training Course

RDBMS & ER Model Training CoursesWhat is ER

The Entity Relationship model works around the real world entities and the relationships among them. The ER model was developed by Peter Chen in the year 1976. This model is very much useful for designing databases. ER Model is a way of graphically representing the logical relationship of the entities in order to create a database. Entity here refers to real world object and entity set refers to a collection of similar entity types. The properties of entities are called attributes and each attribute has a value for them. The association between the entities are called relationship.

What is RDBMS

RDBMS stands for Relational Database Management System. RDBMS forms the fundamental for SQL and for most of the modern databases like MS SQL Server, IBM DB2 and others. RDBMS is based on relational model where data is represented by means of rows or tuples. Relational databases is a collection of organized set of tables where each table has its own primary key.

Pre Requisites for taking this course

Person who is taking this course should have basic knowledge about SQL and database concepts.

Target Audience for this course

The target audience of this course are

• Database developers
• Database administrators
• Professionals
• And anyone who wants to get a certification in RDBMS and ER Model

Course Objectives

After completion of this course you will be able to

• Know about the concept of data and database
• Understand the difference between DBMS and RDBMS
• Learn about the database management system and its benefits
• Know in detail about the components of ER model
• Describe the ER diagram and find out the various relationships
• Understand what is SQL server, its features, models and architecture

Course Description

Section 1: RDBMS Concepts

Introduction to Database

A database is a collection of similar data which is organized in a way that is easy to access, manage and update. Data here means any piece of information and facts that are recorded. Database is actually a store place where data in stored and various operations can be performed on the data. This chapter contains a brief introduction to Database.

Disadvantages of File based systems

File processing system are good only when there is limited number of data and files. It becomes more difficult when the data is growing very fast and at a huge rate. The disadvantages of file processing system are discussed under the following topics

• Data Mapping and Access
• Data Redundancy
• Data Dependence
• Data Inconsistency
• Data Sharing
• Data Isolation
• Security
• Integrity
• Atomicity
• Concurrent Access

What are Database Systems?

To overcome all the disadvantages of file processing system the database system was developed. In database the files are called as tables and the contents of the files are called as records of the tables. The column values are knows as attribute and the information are known as record. Each record in a database system has a unique key known as the primary key. These keys are used to access the data faster. Thus this chapter deals with the introduction and features of database system along with an example. The components of the database system are

• Users
• Database Application
• DBMS
• Database

Database Management Systems (DBMS)

A DBMS is a software that lets you to create, define and manipulate database. DBMS is actually a tool which lets you to perform various operations on the data in the database. The data stored in DBMS is easy to retrieve, manipulate and generate new information. The characteristics of the DBMS are explained in detail in this lesson. The other topics included in this chapter are

• Functions of DBMS
• Characteristics of DBMS
• Users of DBMS
• Advantages and Disadvantages of DBMS

Database Models

Data models are the logical structure of a database. A data model helps to put the real world requirement into a design. The data models define the relationship between the data and how they are processed and stored in the system. Based on the levels of data considered for modelling, the data model is divided into three types – Object based, Physical and Record Based. The object data model and Record based model are based on the data at the application and user level. They are further divided into the following categories

• Object Based – Entity Relationship Data Model, Object Oriented Data Model
• Record Based – Hierarchical Data Model, Network Data Model, Relational Data Model

Database Models- Relational Data Model

Relational data model is the most commonly used data model for data storage and processing. This model is very simple. The other topics explained in this chapter are

• Concepts – Table, Tuple, Relation Instance, Relation Schema, Relation Key, Attribute Domain
• Constraints – Key Constraints, Domain Constraints and Referential Integrity Constraints
• Advantages and Disadvantages of Relational Data Model

Relational Database Management Systems

Relational Database Management Systems is a program which allows you to create, update and manage a relational database. In RDBMS the data is in the form of tables, fields and records. RDBMS is based on the relational model. Most of the RDBMS uses SQL to access the database. The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL. This section also explains what is a table, field, record, column and NULL value in RDBMS with examples.

Entities and Tables

An entity is a collection of tables and a table contains information about an object, person or a thing. The relationship and the differences between the entities and tables are listed in this chapter

Section 2: ER Model and Normalization

Data Modelling

Data Modelling is the first and foremost step in database design and OOPS. Data Modelling helps the designers to first create a conceptual model of how data can be related to each other. Data modelling is the representation of the data structures in the form of a table. Data models are used for various purposes like conceptual models to physical data models.

Entity Relationship: One-to-many

When more than one instance of an entity is associated with a relationship then it is One-to-Many entity relationship. This chapter contains pictorial representation of this relationship with an example.

Normalization

Normalization is a set of rules or guidelines used when designing a database in order to avoid the redundancies or anomalies. Normalization helps to remove all the anomalies in a database and helps in equal distribution of data effectively and efficiently. This chapter deals with the different types of Normal forms as mentioned below

• First Normal Form
• Second Normal Form
• Third Normal Form
• Boyce-Codd Normal Form
• Forth Normal Form
• Fifth Normal Form

These normal forms are explained in detail with examples

Relational Operators

Relational algebra in DBMS is a query language which uses certain operators to perform the query. These operators are called relational operators. The relational set operators are used in DBMS to join or delete the records. The basic relational operators which are discussed in this chapter are

• Select
• Project
• Union
• Set Different
• Cartesian Product
• Rename

The notation, example and output for each operation is discussed in detail in this chapter

Currently there are no Q&As for this course. Be the first to ask a question.

Certificate of completion

Digital certificate - Included