《外文文献及翻译》由会员分享，可在线阅读，更多相关《外文文献及翻译（21页珍藏版）》请在金锄头文库上搜索。
1、To connect SQL Server databaseFirst we introduce the basic knowledge of the database,be regarded as the warm-up exercise that study database weave distance front!1.warm-up exerciseNeeding first avowal is relation database that database knowledge that we here introduce all point. The so-called relati
2、on database is to mean data as that the form gather, passing to establish simple form an a kind of database for of relation to defining construction.I ignore the watch at how saving way in physics in the document in database is,it can see to make an a line for with row, with electronics form is simi
3、lar with the row.In relation database, the line were called the record, but the row then is called word segment.This form inside each an all in formations for is a record, it including particular customer, but each record then included the same type with the word segment of the quantity:Customers nu
4、mber, name etc.Form is logic set that a kind of related information that press a line of arranging with row, similar in single form in work.Each row of the word a database form inside calls a word segment. Watch is from every kind of word a definition of its containment of, each word a data for desc
5、ribing its implying. While creating to set up a database, the beard assign for each word segment a the piece belongs to the sex with the other according to the type,biggest length.The word segment can include every kind of word sign,arithmetic figure even sketch.An information of relevant customer d
6、eposits in the line of the form, is called record.By any large, arbitrarily two records for database form to create set up cant be same.Key be a certain word segment( or several words segment) of the form inside, it() for fast inspect but drive index. The key can be unique, and also can then the rig
7、ht and wrong is unique, being decided by it() whether admission repetition. Unique key can specify for main key, using each one that come to unique marking form.The norm turns the database design of mission be method that the data of buildup,but the data of buildup, should can dissolve otiose repeti
8、tion, and for have the necessary information offering to check to seek the path quickly. For attaining this kind of target but separate information to the process gone to in every kind of independent form, be called the norm turn.It is complicated process to use many appointed rules to proceed the n
9、orm with the type of the different Class that norm turn. That process studies and discuss already beyond the reach of textual scope.But,the norm of the simple database in majority turn and can use the simple experience in underneath rule completes: include the form of the information of repetition m
10、ust be divided into independent a few forms dissolve repetition.If we have chosen to learn 12 curricular 1000 students, the each curricular elucidation will show with the teacher 100 many- to choose that curricular and eachstudent repeat once.To avoid this kind of low efficiency, should to turn the
11、dichotomous and independent form in form to the norm,an is used to mean the student,the another uses mean the course.Now the form was turned by the norm, so, to changes the particular and curricular course describe or data,as long as change a record all right.Is a basic knowledge concerning database
12、 above,this is what study database plait distance must.Although the database technique is used as a course,its depth is not this space and can describe with the wide degree of,be used as the primer with simple database plait the distance should be all right already.Like,underneath we can start pract
13、icing.We usually meet the database system is to registers the system,ignoring you are in the unit,or attend what buildup,the register is to cans not help of,and it of the construction is more simple,we take a register system as an example.The analysis is once a data for involving.2. understanding th
14、e elementsFor the register, want the on the trail of information include:name、sex、native place、age、date of birth、unit、address、postal service codes、telephone、FAX. Certainly,can create to set up a form in brief,make above each piece according to item to should a word segment.Need to point the form the
15、 main key in parties now, in order to unique marking each a record,increase register number conduct and actions unique key respectively in register form,guarantee a two records like this all different.To the database after making an above analysis,we can start establishing the database.3.set up the
16、firm in campHere we study to establish the database how,needing to make sure the type that to establish the database first.Pass in Visual Basic the data interview control piece or data interview object ( DAO) can visit the following database:1)The database of JET, namely Microsoft Access2)The database of ISAM, such as: DBase, etc. of FoxPro3)The database of ODBC,every follow the standard of ODBC customer/ server database. Such as: Microsoft SQL Server,
