Designing the actual tables and relationships


Designing the actual tables and relationships

We have proceeded towards the phase of designing the actual tables and relationships . Table creation is no problem because you are using the MMC console.It gives you everything that you want, in order to flourish

Why the know how of back end database design, stored procedures, triggers, or functions is essential? This is because you wont be able to survive longer if you are just code bounded. That’s why we want to make you learn how the back end logic has to be build before proceeding the next phase of form designing.

An important point to be noted is that, you should get absorbed in the world of databases in current job opportunities because there are lesser job opportunities due to world’s crisis. Now lets start the creation of the database area

create table

We have reached the Final steps in designing the tables. You can draw tables from Sql Server Management Studio. The process is quite easy. Whether you want to make the database or a table with sql statements or you can use designer which is suggested more by us. Lets see the advantages of sql server over other

In order to explore the added features of MS Sql Server, see the link below

My Top 5 Sql Server 2012

Microsoft SQL Server Master Data Services is a Master Data Management (MDM) product from Microsoft, which will ship as a part of the Microsoft SQL Server database.Originally code-named Bulldog, Master Data Services is the rebranding of the Structure MDM product titled +EDM, which Microsoft acquired in June 2007. Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications as well as some new features. Master Data Services first shipped with Microsoft SQL Server 2008 R2. Microsoft SQL Server 2012 improved the analytical capabilities, transactional capabilities, and integration with other software

reference http://en.wikipedia.org


We have created all the necessary tables and their relationship diagrams with their primary keys or unique keys and foreign keys and constraints.Here, we have four entities of interest. The table columns are their attributes and tables themselves are entities.

erd tables

Syed Adeel Ahmed
Syed Adeel Ahmed
Analyst, Programmer, Educationist and Blogger at Technofranchise
Computer Systems Engineer from Sir Syed University Of Engineering & Technology.I am passionate about all types of programming.

Published by

Syed Adeel Ahmed

Computer Systems Engineer from Sir Syed University Of Engineering & Technology.I am passionate about all types of programming.

Leave a Reply