Database design using ER modelling & Normalization technique
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | Lec: 14 | 254 MB
Genre: eLearning | Language: English

data modeling, design database, dbms,sql,er modelling,normalisation, design tables for database,database management



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 normalization technique for designing tables.
Advantageous of enrolling into this course:

You will be able to design an efficient database for any application.
You will become a pro in designing tables of a database.
Interactive videos.
Asks Questions to the instructor.
Keep the course for lifetime.
This course is absolutely for beginners.
Entity-Relationship modeling in the Database management system is a technique used to determine the graphical relationship between the entities(entity is an abstract about which we want to store the information in our database). It is used by Software companies to design and present the database model for there clients.It enables to revise and make corrections to the model as many times as possible without wasting money ,moreover it helps to create an efficient physical database design which meets the clients requirements.

E-R modeling is very important for the programmers to build extraordinary web or mobile app that requires database to just store data add by the admin .Adopting this method helps the programmers achieve great success with there application.It is a Top Down Approach.

Normalization is a bottom up approach ,where the rough table is gone through the refinement process to make it efficient,so that it enables Insert,Update,Delete operations for database and reduces duplicate data.It is used to create a database for online applications where end user can perform Insert,Update,Delete actions.