C
craig
I have just finished modeling a preliminary database schema in Visio and I
have two quick questions...
1. Are there any generally accepted standards regarding field types and
field lengths that are in use today? For instance, is there a standard way
of configuring a field that is to hold a phone number, and address, a name,
etc??
2. Would it be better to do all final database schema definition within
Visio, and then use this to generate the actual SQL database, or is it
better to build the actual database in SQL directly? If the former is done,
is it possible to incorporate changes that are made to the Visio database
into the SQL database, even after data is entered into the tables?
Thanks!! Any insight is appreciated.
have two quick questions...
1. Are there any generally accepted standards regarding field types and
field lengths that are in use today? For instance, is there a standard way
of configuring a field that is to hold a phone number, and address, a name,
etc??
2. Would it be better to do all final database schema definition within
Visio, and then use this to generate the actual SQL database, or is it
better to build the actual database in SQL directly? If the former is done,
is it possible to incorporate changes that are made to the Visio database
into the SQL database, even after data is entered into the tables?
Thanks!! Any insight is appreciated.