How to map ER to Relational Schema in DBMS

Steps to Draw relational schema

     Follow following steps to draw relational schema correctly,

1.       Match Regular Entities
2.       Match Weak Entities
3.       Match 1:1 Relations **
4.       Match 1:N Relations **
5.       Match N:M Relations **
6.       Match Multi-Value entities
7.       Match N'Arrays
8.       Match Recursive Relationship

Brief About Database Management System (Part - 2)

DBMS Part 2

  Here is the part 2 of DBMS. If you not yet read part 1, click here to read.

  Multi-valued Attributes

Attributes that have more than one value called "Multi -valued attributes ".

We can graphically represent Multi-valued attributes in ER-Diagram like following,

How to set Microsoft SQL server 2012 in First Time

Microsoft SQL Server - 2012 HELPS for beginners

Its is little bit hard to set things in SQL in First Time. Because you are the beginner for this software. Today i came up with new tutorial to explain step by steps How to set MS SQL server 2012 and restore your own database into it.

Brief About Database Management System (PART - 1)

DBMS 

• What is a Database?

     Database is a collection of related data. It is a collection of Schema, tables, quarries, reports, views and other objects.

• Who use Databases?

     Libraries , Banks , Military , Airlines , Supermarkets.etc

• What is DBMS?