3.1
, , ,
:
- . . :
: 27.04.2005
: 15.00
: . -, , .1
: 1515
: 2000
: 1990
: 0,5 %
:
:
.
:
1) , , , ;
2) ;
3) , , :
(--, --, --, --) | |||
(, ) Word .
:
1 2 - :
1:
: /, , , , , .
2: /
: /
: ( ) :
, / - ;
, , / , ..
3:
: , ,
: , , ,
4:
:
5:
: , , , ,
3:
(--, --, --, --) | |||
/ | -- | ||
-- | |||
-- | |||
-- |
3.2 Microsoft Visio for Enterprise Architects
|
|
Visio, Database Model Diagram, SQL Server Visio
:
1) Measures Database Model Diagram Visio for Enterprise Arhitects. C:\measures.vsd.
2) MeasuresDB SQL Server.
3.2 Microsoft Visio for Enterprise Architects
:
1: Visio:
1) Programs Microsoft Visio.
2) File New -> Database -> Database Model Diagram. .
3) (, 100 %), Shapes Entity. Database Properties. .
4) Categories , Definition :
Physical name - Measures
Conceptual name - Measures
5) Columns, , Physical Data Type (Microsoft SQL Server) :
( Notes , ).
(Primary ID ..) .
6) Entity. Physical Name Conceptual Name MeasuresDateTime, :
7) Address
8) - Station
9) - Employee
10) , Entity , . :
Connector Tool Standard ( );
(, MeasuresDateTime). ;
(Measures). , .
. . , . , , , ( ).
:
11) c:\measures.vsd.
2 - SQL Server:
1) Programs -> Microsoft SQL Server Enterprise Manager -> Databases.
2) Databases New database MeasuresDB. OK.
|
|
3) Measures.vsd Visio Database Generate. Generate a Database Schema :
4) Establish a connection to a database Installed Visio drivers Microsoft SQL Server. Database already exists.
5) New. ODBC. System Data Source Next.
6) SQL Server ( ) Next, _ Finish.
7) Name MeasuresDSN, Server Next.
8) With Windows NT Authentification Next.
9) Change the default database to MeasuresDB. Next, - Finish OK.
10) MeasuresDB Next. Next, - Finish.
11) DDL OK. .
12) Enterprise Manager MeasuresDB.