Creating a new SQL Server database
To add a new database to the project click the Project-> Add new item menu.
Select Service-based Database from the list of available templates.
Type "BaseData" in the name area, click "Add".
Database configuration help will open, but no objects will be available as this is a new database.
Click "Finish" to create the database and dataset and add them to the project.
Creating new tables in the database
To add new tables to the database open "Server Explorer / Database Explorer" by selecting "Server Explorer / Database Explorer" from the "View" menu.
Expand the "SampleDatabase.mdf" node below the "Data Connections" node. Right click on "Tables" and "Add New Table". The table designer will open.
Creating a new database diagram
In "Server Explorer," right-click "Database Diagrams" or any diagram in the folder.
Important
You can use the database diagram designer to upgrade the database in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. However, SQL Server 2012 does not support this functionality.
Choose "Add New Diagram" from the shortcut menu.
The "Add Table" day will appear.
Select the desired tables in the table list and click "Add.
The tables are shown graphically in the new database diagram.
You can continue adding or deleting tables by modifying existing tables, changing relationships until the new diagram is complete.
Sources:
link
link