|
Microsoft
SQL Server 2000
SQL - structured query language
- Operating
System:
Microsoft Windows 2003 Server
Windows Server
2003 Server meet the following requirements:
Hardware |
Minimum requirements |
Processor |
recommended minimum
speed of 550 MHz |
Memory (RAM) |
256 megabytes (MB)
of RAM recommended |
Hard disk space |
approximately 1.25
GB to 2 GB |
Monitor |
VGA or higher
resolution |
|
- Microsoft
SQL Server 2000 operates on computers
Minimum requirements...
Hardware |
Minimum requirements |
Computer |
Pentium 166 MHz or
higher. |
Memory (RAM) |
64 MB minimum |
Hard disk space |
~ 500 MB - for SQL
Server database, Analysis Services:,
English Query and Desktop Engine |
Monitor |
VGA or higher
resolution |
|
. |
|
Create SQL database file and all Tables
cooresponding, to be used by the RBT Accounting Net
application
|
1. |
Create SQL database,
(Enterprise
Manager)
- Run SQL
Server Entreprise Manager
Pic 0
- Expand a
server group, and then expand a server - Pic 0
-
Right-click
Databases, and then click New Database, Database
properties dialog appears
In the General
Tab of this dialog:
In the Name box type- RBT
In the Collation name select -
Server default
and then click OK. New Sql
database - RBT created - (This Sql database appears
after click refresh from
Action menu of
Sql Server Entreprise Manager - Pic 0)
Note:
2
types of files store this Sql database - RBT
created
- primary database
file - RBT_Data.mdf
-
transaction log file - RBT_Log.ldf
|
The initial sizes
of the database and transaction log files are the same as
the default sizes specified for the model database.
The SQL Server
Enterprise Manager
dialog box stores this new
Sql database - RBT
For more
information about this Sql database - RBT call
Properties
From SQL Server
Enterprise Manager
dialog box - Pic 1 select RBT node of the
Databases, right-click the Properties, RBT
Properties dialog box appears
This dialog box stores
many information ...
The Data Files Tab
stores the lcation of the primary database file RBT_Data.mdf
The Transaction Log
Tab stores the lcation of the transaction log file RBT_Log.ldf
|
|
|
|
2. |
Creating a New Table - product |
|
- To SQL Server
Enterprise Manager
dialog
box (Pic 1), connect to the database RBT
Right-click the Tables node of the database RBT
and choose New Table, Table Designer
dialog box appears
- Add
the columns and other details ... to the
Table Designer
Column
|
Data Type
|
Lenght
|
Allow Nulls
|
prod_id
type_cur
prod_name
quantity
cost_cur
unit_cost
unit_price |
varchar
varchar
varchar
int
float
float
float |
10
3
25
4
8
8
8 |
-
x
x
x
x
x
x |
|
To the Column prod_id add a primary Key
Save the table created and Rename it - product
-
(in the Choose Name dialog type the of the
table created)
From the Action menu of the Sql Server
Entreprise Manager - Pic 1, click refresh
- Add new records to
the table product
Select table product, right-click Open Table
and click Return all rows, Data in Table 'product'
in RBT on ... dialog box appears, in thjs dialog add new
records
|
|
3. |
Creating a New Table - chang |
|
- To SQL Server
Enterprise Manager
dialog box (Pic 1), connect to the database RBT
Right-click the Tables node of the database RBT
and choose New Table, Table Designer
dialog box appears
- Add the
columns and other details ... to the Table
Designer
Column
|
Data Type
|
Lenght
|
Allow
Nulls
|
ch_date
llrate_usd
rate_ll
rate_eur
rate_eng
rate_jap |
datetime
float
float
float
float
float |
8
8
8
8
8
8 |
-
x
x
x
x
x |
|
To the Column ch_date add a primary Key
Save the table created and Rename it - chang
From the Action menu of the Sql Server
Entreprise Manager - Pic 1, click refresh
- Add new records
to the table chang
Select table chang, right-click Open Table
and click Return all rows, Data in Table 'chang'
in RBT on ... dialog box appears, in thjs dialog add
new records
|
|
4. |
Creating a New Table - cust_comp |
|
- To SQL Server
Enterprise Manager
dialog box (Pic 1), connect to the database RBT
Right-click the Tables node of the database RBT
and choose New Table, Table Designer
dialog box appears
- Add the
columns and other details ... to the Table
Designer
Column
|
Data Type
|
Lenght
|
Allow
Nulls
|
child_ref
father_ref
type_cur
desc_name
address
phone
open_usd
db_usd
cr_usd |
varchar
varchar
varchar
varchar
varchar
varchar
float
float
float |
8
4
3
40
40
20
8
8
8 |
-
x
x
x
x
x
x
x
x |
|
To the Column prod_id add a primary Key
Save the table created and Rename it -
cust_comp
From the Action menu of the Sql Server
Entreprise Manager - Pic 1, click refresh
- Add new records
to the table
cust_comp
Select table
cust_comp,
right-click Open Table and click Return all rows,
Data in Table 'cust_comp'
in RBT on ... dialog box appears, in thjs dialog add
new records
|
|
5. |
Creating a New Table - ord_sales |
|
- To SQL Server
Enterprise Manager
dialog box (Pic 1), connect to the database RBT
Right-click the Tables node of the database RBT
and choose New Table, Table Designer
dialog box appears
- Add the
columns and other details ... to the Table
Designer
Column
|
Data Type
|
Lenght
|
Allow
Nulls
|
ord_inv
ord_date
type_cur
val_ll
child_ref
desc_name
dlv_name
disc_cur
total_cur
old_bal_cur
new_bal_cur
notes |
int
datetime
varchar
float
varchar
varchar
varchar
float
float
float
float
text |
4
8
3
8
40
40
20
8
8
8
8
16 |
-
x
x
x
x
x
x
x
x
x
x
x |
|
To the Column ord_inv add a primary Key
Save the table created and Rename it -
ord_sales
From the Action menu of the Sql Server
Entreprise Manager - Pic 1, click refresh
- Add new records
to the table
ord_sales
Select table
ord_sales,
right-click Open Table and click Return all rows,
Data in Table 'ord_sales'
in RBT on ... dialog box appears, in thjs dialog add
new records
|
|
6. |
Creating a New Table - it_sales |
- To SQL
Server
Enterprise
Manager
dialog box (Pic 1), connect to the database
RBT
Right-click the Tables node of the database RBT
and choose New Table, Table Designer
dialog box appears
- Add
the columns and other details ... to the
Table Designer
Column
|
Data
Type
|
Lenght
|
Allow
Nulls
|
ord_inv
prod_id
prod_name
quantity
unit_price
extension |
int
varchar
varchar
int
float
float |
4
8
40
4
8
8 |
-
x
x
x
x
x |
|
Save the table created and Rename it -
it_sales
From
the Action menu of the Sql Server Entreprise
Manager - Pic 1, click refresh
Add
relationships between the tables -
ord_sales and
it_sales
in the database RBT.
Select the table ord_sales, right-click
Design Table, Design Table 'ord_sales'
in RBT on ... dialog box appears, in thjs dialog
select the column ord_inv right-click
relationships ... Properties dialog box
appears, in this dialog:
Click New
From the Primary Key Table combobox,
select ord_sales and select filed
ord_inv
From the Foreign Key Table combobox,
select it_sales and select filed
ord_inv
and then click close. New relationships to be
created..
Save this modification
- Add new
records to the table
it_sales
Select table
it_sales,
right-click Open Table and click Return all
rows, Data in Table 'it_sales'
in RBT on ... dialog box appears, in thjs dialog
add new records
|
|
|
|
|
The CD-Rom -
Teach_VNet stores the analogue SQL database - RBT
created with all tables in the
folder \\C_Col_SQL_VBNet\RBT Accounting
Net\data.
This folder stores 2 files:
RBT_Data.mdf - primary database
file
RBT_Log.ldf -
transaction log file |
|
|
|
|
|