Database Design Using Er Modelling and Normalization Technique

Database design using ER modelling & Normalization technique

Learn Database design using examples in a very short period of time.

What you will learn

E-R Modelling and Physical database design

Description

All the explanations in this course are carried out by considering real-world examples.

What you will learn in this course:

• Basic concepts and definitions.

• Build an E R model

• Transform a model into physical database design

• Learn the normalization technique for designing tables.

Benefits of enrolling into this course:

• You will be able to design an efficient database for any application.

• You will learn the concepts easily as I have explained every topic using an example.

• You can start this course even if you are a beginner.

• You can ask questions to me at any time.

• You can keep the course for a lifetime.

Screenshots

Content

Introduction

Course map

Why E R modelling

Entity Relationship modelling

Introduction

Entity and Relationship

Cardinality of a relationship

E R diagram notations

Steps for creating a model

Practising what we have learnt with examples

Introduction

Creating an example model

Transforming model into a physical database design

Creating an Example model 2 lec -1

Creating an example model 2-lec 2

Normalization

Introduction to Normalization

Anomalies

Basic definations

Types of normal forms

Reviews

Some of the definitions and explanations were still confusing. Overall I can tell that the instructor knows what he is teaching, but he seems to need a little more practice on teaching in general. I definitely did learn a good amount about creating databases, though.

This course was valuable for historical and diverse database building information. It wasn't easy because databases are somewhat obtuse to start with. However, Een took on a very tough job and provided a creditable presentation. Kudos to him!

The course moves at a perfect pace. I'm able to understand a lot because of the good use of examples alongside the theory

The basics of the information in the course are good. However real world situations are the best means of presenting information. The banking scenario is not presented correctly, but the modeling for the information as presented is correct and useful. In addition, spell check to eliminate run-on words would eliminate errors. I took this course as a refresher and found the use of terminology strong. Overall, this is a very good course for beginners.

Good course for beginners but can be better. Feedback-Explanations for some concepts are not very clear or maybe the examples are not perfect due to which understanding them becomes hard. For example , what to do with relationship based tables in case of one to one or one to many is not very clear as the examples does not show the final result.

This course is very basic. I assume this course is for someone who doesn't know or heard of anything about Database.

It's a pretty good course for the people who are having a hard time understanding the concept of ER modelling and normalization. Nice representation. Before implementing an actual database, designing a conceptual database and logical schema is necessary. And this course can teach you how to do that.

So far okay. But speech is not 100% clear as expected & some better example could've been more helpful.

This was a great starter course for me to get familiar with some of the terminology. This is great course to get you started as it is not that long. Some explanations could be explained a bit more precise, concrete. Overall this is a great course to get you started with E-R diagrams and modeling, I learned a lot from this course!

This course is better than the University Database course. This is the first step and then the sql query comes.

i think it was a great course for the beginners and the instructor has a good accent which makes it easy to understand.

Harshavarthini

October 10, 2017

Could have even more real time example. Introduction part and relation ship between attributes is too slow.

Charts

Price

Rating

Enrollment distribution

Related Topics

8/3/2017

course created date

11/22/2019

course indexed date

Database Design Using Er Modelling and Normalization Technique

Source: https://comidoc.net/udemy/data-modeling

Share this post