ALL DBMS PPTS

http://www.cse.iitb.ac.in/~sudarsha/db-book/slide-dir/index.html

EXPERIMENT NUMBER 5

http://www.wctmgurgaon.com/data/lab_manual/dbms_file.pdf

ER Model to Relational Model Maping

Lecture Series on Database Management System by Dr.S.Srinath, IIIT Bangalore. For more details on NPTEL visit http://nptel.iitm.ac.in

Data Modelling - ER Diagrams, Mapping

Lecture Series on Software Engineering by Prof.N.L. Sarda, Prof. Umesh Bellur,Prof.R.K.Joshi and Prof.Shashi Kelkar, Department of Computer Science & Engineering ,IIT Bombay . For more details on NPTEL visit http://nptel.iitm.ac.in

Introduction of DBMS

Lecture Series on Database Management System by Prof.D.Janakiram, Department of Computer Science & Engineering ,IIT Madras. For more details on NPTEL visit http://nptel.iitm.ac.in

ER Model vs. Relational Model

• Both are used to model data
• ER model has many concepts
– entities, relations, attributes, etc.
– well-suited for capturing the app. requirements
– not well-suited for computer implementation
– (does not even have operations on its structures)
• Relational model
– has just a single concept: relation
– world is represented with a collection of tables
– well-suited for defining manipulations on data