i am planning to install sql server 2012 advanced series , do i get all the feautures such as e-r diagram designer tools , forward engineer & reverse engineer options??

Hello,

Maybe you meen Features Supported by the Editions of SQL Server 2012

SQL server 2012 does not need to get any additional feautures sach as oracle need.

 

>> sql server 2012 advanced series 

Did you mean SQL SERVER 2012 express with advanced services? Express editions have limited features  

yes , SQL SERVER 2012 express with advanced services.

you can compare the SQL Editions here

http://www.microsoft.com/en-in/sqlserver/product-info/compare.aspx

e-r diagram designer tools , forward engineer & reverse engineer options??

for this you can use the free tool SSDT = Microsoft SQL Server Data Tools; they work with every edition of SQL Server.