123 SQL Management Studio Maha Khaled Yacoub
1234-
How to Create Data Base Using SQL Server Management Studio How to Attach Database to SQL Server How to cut/copy your Data Base from its location How to create .BAK file
Chapter 1: How to Create Data Base Using SQL Server Management Studio
1
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
2- Go to Microsoft SQL Server 2008 ďƒ SQL Server Management Studio
1- Start, all programs
2
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
3- Connect to your server by clicking on the connect Button
3
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
4- To start creating new database, right click by the mouse on Data Base and click on New DataBase
4
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
5- Write the Database Name
*Database location on your hard disk
6- If you want to add extra database 7- Then click ok
5
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
8- This is the location where you can find the database you created
6
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
9- To create new table, right click by the mouse on the Tables
7
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
11- Then select the primary key attribute
8
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
10- Start typing your attributes titles and their data types
13- Select the primary key attribute
9
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
15- Yes, means it will be generated auto
10
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
Write the name of your table
11
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
16- Save the table (file , save table) OR (CTRL+S form the key board)
17- To create other table ,, re-do same steps
12
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
18- Write the table name and save It
13
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
19- To create the relation between table you have to create a diagram
14
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
20- yes
15
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
21- Select tables you created
22- Add
16
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
23- Close
17
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
24- To create a link between tables click on the attribute from the 1st table -ďƒ drag it and drop it on the attribute in the other table
18
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
25- Confirm the relation
26- Then click ok
19
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
27- Your relation shows here 28- Then click ok
20
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
29- Type your diagram name and click ok
21
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
30- Yes
22
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
31- To add new table in the diagramďƒ right click anywhere in the empty space and click right click
23
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
32- Enter the table name and click ok
24
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
33- Yes to confirm
25
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
35- Primary key icon
34- Start typing your attributes and don’t forget to create your primary key attribute
26
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
36- Start crating the relation between your tables as shown before, confirm and click ok
27
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
37- Confirm relation
38- Then click ok
28
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
39- To view your table in different ways, select the table, right click and select the table view you prefer
29
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
30
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub
To be continued‌
31
How to create database using SQL server 2008 Faculty of Business Information System Information System Department Maha Yacoub