Traditional Database Management
Now that you recall the basic naming conventions and design rules we should follow when
defining our tables, it??™s finally time to start building our real tables. If you are coming from
a development background in another language such as Java, PHP, Perl, or Active Server Pages
(ASP), it??™s likely that you??™ve been building database-driven applications in the traditional manner.
That is, every time you build an application, you go through steps like these:
CHAPTER 3 ?– SETTING UP YOUR DATABASE 44
1. Define and design your tables in a database management program such as SQL Server
Enterprise Manager, TOAD for Oracle, MySQL Administrator, or even in something like
batch SQL scripts.
2. Configure your development environment to work with the database details you have
just defined and set up, generally with configuration files (XML, properties, or simply
text files).
3. Start writing your application logic.
4. Load data into your testing database manually with your database administration program,
through some batch SQL scripts, or through a custom-built web or application
administration tool.
Pages:
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140