酒店客房管理系统 外文文献翻译 精品.docx

1、酒店客房管理系统 外文文献翻译 精品学校代码： XXX学 号：XXX （本科毕业外文文献翻译学生姓名：XXX 学 院：信息工程学院系 别：计算机系专 业：软件工程班 级：软件06指导教师：XXX 讲师 二一年六月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

2、 avowal is relation database that database knowledge that we here introduce all point. The so-called relation database is to mean data as that the form gather, passing to establish simple form an a kind of database for of relation todefining construction.I ignore the watch at how saving way in physi

3、cs in the document in database is, it can see to make an a line for with row, with electronics form is similar 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 partic

4、ular customer, but each record then included the same type with the word segment of the quantity: Customers number, 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

5、a word segment. Watch is from every kind of word a definition of its containment of, each word a data for describing 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

6、 segment can include every kind of word sign, arithmetic figure even sketch.An information of relevant customer deposits 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 se

7、gment) of the form inside, it() for fast inspect but drive index. The key can be unique, and also can then the right 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 datab

8、ase design of mission be method that the data of buildup, but the data of buildup, should can dissolve otiose repetition, and for have thenecessary 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

9、of independent form, be called the norm turn.It is complicated process to use many appointed rules to proceed the norm 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 tur

10、n and can use the simple experience in underneath rule completes: include the form of the information of repetition must 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

11、many- to choose that curricular and each student repeat once. To avoid this kind of low efficiency, should to turn the 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 particu

12、lar and curricular course describe or data, as long as change a record all right.Is a basic knowledge concerning database 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,

13、 be used as the primer with simple database plait the distance should be all right already.Like, underneath we can start practicing. 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 th

14、e construction is more simple, we take a register system as an example. The analysis is once a data for involving.2. understanding the 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.Certa

15、inly, 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 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

16、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 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 intervi

17、ew 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, Or

18、acleBy any large, if develop the personal small scaled database system, use Access database comparison accommodation, to develop the big and medium-sized database system uses the database of ODBC fester. But dBase with the database of FoxPro because of already dated, unless special circumstance, do

19、not use otherwise. In our example, chose to use the database of Access certainly. Establish the database of Access contain two kinds of methods: While establishing the database in Microsoft Access. Click new set up button can establish the new form. Here we main introduction the second method: The u

20、sage can see to turn the data management machine, do not need to weave the distance and then can create to set up the database. Can see to turn the data management machine is the applied procedure of a great use, it is a VB business enterprise version is supplementary with the profession version, in

21、 the catalogue. Devastation vb samples the Visdata is next, its interface is as follows the diagram.Click the menu document item is next new set up son item Microsoft ACCESS son item of edition 7.0 MDB item. Input the new setting up the name of the database in flick window way open register, appear

22、the underneath show the window way:Want the born and new form, the single shot in right key database window way flicks the menu open, then the choice new form ordinaries, establishing in watch construction dialog box appeared later on a word for wanting segment. The every time faces to join in the f

23、orm new word segment, single shot increment word segment button, will appear of increment word segment dialog box.Increment word a type for options in the dialog box, according to word segment. In our the register database that establish, the type of the each word segment.Want to notice of is, becau

24、se the word segment registers the number be used unique marking record of, therefore, it cant be inputted by customer. So while defining the words segment need to be defined for Long data type, the automatic born word segment item is valid, and picks out this item. Be the customer like this to input

25、 to record with other the different value every input a new record, system would on the words segment automatically.In ACCESS database, the key word realizes with the index of, conduct and actions plait distance personnel at gather to weave the distance to the record of the form type, needs to adjus

26、t to use index. While searching, the technique of Rushmore uses the index information the excellent turning the search automatically. After completing the form definition, click increment index button, flick such aspen figure 5 show the window way.In window way the right side contain three optioned,

27、 its meaning, such as table,12.Increase the index dialog box options.After completing such as figure 6.Certainly, the academic association database establishes too not a dynasty the business of the one night, the reader no harm much practices once.Visit databases design and the development of the ap

28、plication procedures of MS Visual Basics of the databases of the SQL Server. When design a system, the customer still needs to comprehend to use to come to visit the plait distance of ask the data of SQL Server to connect. The origin was detailed to elaborate that the usage open type database conjun

29、ction (the Open Database Connectivity, ODBC) adjusts to connect the objects to connect with the class, still having the data interviews object (the Data Access Objects, the DAO) and the long-range data objects. Design and weave to write large and complicated and applied procedures database design fo

30、r the software developer is a challenge, need to choose to weave the distance language and tools, do an accommodation for the SQL Server, choose the calculate way and the data structures, still need to design the sketch customer interface and the application procedures to connect. The decision withi

31、n the most important software design is applied fixed position of the procedure. In other words, design must specify the system of which parts are data, business rule, and the data entrance procedure and used for circulating the code of other part. The MS Visual Basic supports the plait distance tha

32、t some databases manage the systems connect, especially SQL Server. Adjust to connect to include the ODBC and DB-Libraries to connect the, object to connect to include the data interview object (DAO), long range data object (the RDO), the OLE DB and the ActiveX Data Objects (ADO) with the class, the SQL that returns the capable SQL Server to manage the mission distributes to manage the object (the SQL Distributed management Objects, SQL-DMO) to connect. Connect the oculars right choice can improve the whole function of system and the development speed biggest.