Getting Started with the database series-Tip 1

Skills | data | Database In this lecture, we will first introduce the basic methods of database design, and attach an example of designing a Ms-sql server database. Then take Delphi5 as the development tool, the standard Paradox table for the background database, to explain how to do the simplest database programming.

In this case, we'll implement the ability to add, modify, delete, and query data in a table. The computer hardware and software environment used in this example is: Windows NT 4.0 server,ms-sql server7.0,borland Delphi 5,piii550,256m memory. Of course, the general friends in the WIN98 environment or Win2000 environment can be programmed according to the steps of this example. The author's machine is mainly used as a server, so it's on the server. Cut the crap and start now:

First, the basic method of database design

Database design is the core and foundation of establishing database and its application system, it requires to construct a better database mode for the specified application environment, set up database application system, and make the system can store the data effectively, satisfy the user's various application needs. Generally according to the standardized design method, the database design is often divided into several stages ...

Second, Ms-sql server database Design Example

Below, the author has also prepared a set of database for each Netizen feast, this is under the MS-SQL server Client/server structure Programming example ...

Three, database programming example

In this lecture, we take the Delphi5 as the development tool, the standard Paradox table is the backstage database, introduces how to carry on the simplest database programming. In this case, we'll implement the ability to add, modify, delete, and query data in a table ...

Four, large database design principles

A good database product is not equal to have a good application system, if can not design a reasonable database model, not only will increase the client and Server section program programming and maintenance of the difficulty, and will affect the actual performance of the system operation. Generally speaking, in a MIS system analysis, design, testing and commissioning phase, because of the small amount of data, designers and testers often only notice the implementation of the function, but it is difficult to notice the weak performance, wait until the system put into actual operation for a period of time, only to discover the performance of the system is reduced ...