18計算機專業(yè)相關(guān)有關(guān)外文文獻(xiàn)翻譯成品高校大學(xué)宿舍管理系統(tǒng)研究

1、<p>　　外文標(biāo)題：Research on Dormitory Management System in Colleges and Universities</p><p>　　外文作者：LINGFANG HUANG</p><p>　　文獻(xiàn)出處：International Conference on Arts and Design,Education and Social S

2、ciences, 2017</p><p>　　英文2276單詞， 12887字符，中文3796漢字。</p><p>　　此文檔是外文翻譯成品，無需調(diào)整復(fù)雜的格式哦！下載之后直接可用，方便快捷！只需二十多元。</p><p>　　原文：Research on Dormitory Management System in Colleges and Universit

3、ies</p><p>　　LINGFANG HUANG</p><p><b>　　ABSTRACT</b></p><p>　　Through constant communication and survey of university dormitory management personnel, continuous practice

4、 and improvement in system function, and continuous</p><p>　　data analysis, we finally developed the "student dormitory management system"</p><p>　　which dormitory administrators and s

5、tudents two client are satisfied with.</p><p><b>　　KEYWORDS</b></p><p>　　Student dormitory management system; friendly interface.</p><p>　　INTRODUCTION</p><p&

6、gt;　　Research Status</p><p>　　Many different kinds of student dormitory management systems has developed on the Internet at present, although the function is relatively complete, the interface give a person

7、a kind of very complicated feeling, dormitory management personnel in our school do not have great advantages to learn new knowledge relatively at the age, need some time to learn and adapt for new dormitory management m

8、ode as well, although students as another kind of end user with the ability to quickly learn new knowle</p><p>　　Research Content and Goals</p><p>　　Main features of dormitory management system

9、include the following points:</p><p>　　The system is divided into two identities to log in, one is the dormitory personnel, and the other is student, function of each identity is slightly different after log

10、in.</p><p>　　The dormitory management personnel can mainly realize the inquiry about the</p><p>　　students and dormitory information as well as the addition, deletion and modification of their i

11、nformation after login.</p><p>　　Users can check express information</p><p>　　Users can submit and inquire about repair information;</p><p>　　Students can add or delete their own in

12、formation on leaving and returning to school.</p><p>　　User can change user's own password.</p><p>　　This dormitory management system emphasizes the completeness of functions and</p>

13、<p>　　the friendliness of the interface, which has made a lot of efforts in convenience of use, in order to make the content seem simple and easy to understand without losing the functional integrity, I have designe

14、d many different kinds of window layout, finally choose one of the most satisfactory layout to achieve the object of simple interface.</p><p>　　DEMAND ANALYSIS</p><p>　　Feasibility Analysis of S

15、ystem Development</p><p>　　Technical feasibility: with the development of computer technology, the life and work of people have involved in computer field more or less, now it is hard for people to break awa

16、y from a convenient science and technology, on the whole, the popularization of the computer makes people's life efficiency have a leap. Dormitory management system store is management software which stores a lot of

17、information on students and dormitory, including students and dormitory information' inquiry, addition, </p><p>　　Feasibility of organization and management: a lot of conservative state have got rid of i

18、n the concept of modern people, if the developed management software function is strong enough, it can bring to life, so it can get school logistics support, because no one will give up a chance which can do things easie

19、r, and conservative do inefficient things.</p><p>　　It can be seen from the above feasibility that developing such a management system can make the management of the dormitory more convenient and fast, and c

20、an make the whole management mode improve one step. Therefore, it is necessary to develop dormitory management system.</p><p>　　Users' Needs Analysis</p><p>　　The system's end users are

21、dormitory managers and students. According to my daily experience in the dormitory, investigate the dormitory management teachers in my school and the students in the same dormitory; I come to the practical needs of the

22、following user terminal:</p><p>　　Students live in dormitory, daily life of many dormitory management personnel in</p><p>　　dormitory building.</p><p>　　Student's basic informat

23、ion:</p><p>　　After the students entering the school, the school will automatically generate for each student a primary key, which is the only student ID as well, and it is assigned to the specified dormitor

24、y buildings and dormitory. Each dormitory has a unique dormitory house number; student registration time is the time when students enter school. In addition, students generally with the same college live in the same buil

25、ding ,in order to facilitate the management; there are corresponding department names i</p><p>　　Basic information of dormitory:</p><p>　　Each dormitory has a primary key dormitory number; each

26、dormitory has a phone, it is corresponding to the dormitory phone number.</p><p>　　Basic information of dormitory property project:</p><p>　　The school's public property includes light bulbs

27、, beds, tables and chairs, etc. in order to make better distinction for different items, and item numbers are assigned for each item. The main purpose is to be more conducive to repair and manage dormitory public items.&

28、lt;/p><p>　　Basic information of express:</p><p>　　There is express management in each dormitory. When students have a letter on the building, the arrival time of the letter will show corresponding

29、ly, and accept the letter with student's name and the house number of his dormitory. A student can have several express at one time, it is necessary have column that show the number of express. When the express arriv

30、es, there will be an arrival time. After the student has successfully received express mail, it shows successful receipt.</p><p>　　Basic information of public repair:</p><p>　　The public propert

31、y of dormitory often need to be repaired due to damage, at this time, the students should number the item, item name, and the cause of the damage, and report to the dormitory management system, management will see it thi

32、s time, notify the relevant personnel to repair dormitory property. The report will generate an report time, and have a successful repair time after the repair is completed.</p><p>　　Basic information of nig

33、ht return:</p><p>　　Students sometimes are over the closing time of dormitory because of some things, at this time, dormitory management personnel should make corresponding record on the system, for example:

34、 time of night return, personnel's name of night return, student number, the reason for return late and so on, in order to verify later.</p><p>　　Basic information for leaving school:</p><p>

35、;　　Every year when the school in winter vacation, summer vacation, and all kinds of small holidays, in order to facilitate the students' safety management and know where the students are going, they should do their b

36、est to record where the students are, when they leave and when they return to school.</p><p>　　User's requirements for the system:</p><p>　　Dormitory management personnel:</p><p&g

37、t;　　Information requirements:</p><p>　　The dormitory management personnel can check all the above information, including any information in the student's dormitory, the receipt information of the express

38、, the information of the property, etc., so as to manage the whole dormitory.</p><p>　　processing requirements:</p><p>　　Dormitory management personnel not only can inquire the relevant informat

39、ion, and have the right to change a lot of information, such as the change of students' information changes, which is mainly modified by dormitory management personnel, when students' express arrive, the manageme

40、nt personnel record it, after the express is successfully received, and the dormitory management personnel confirm and receive.</p><p>　　When the student reports the damaged property for repair, dormitory ma

41、nagement personnel can inquire the fixed time, that is to say, the dormitory management</p><p>　　personnel cannot only inquire the students' information, but also have authority to add and remove informa

42、tion.</p><p>　　Safety and integrity requirements:</p><p>　　Safety requirements:</p><p>　　The system has two different users' ID to login, and different user id login has differe

43、nt system window, and should ensure that the users' name and password are legal.</p><p>　　The system has the same access to the same data set, and users can inquire and handle the types and contents of a

44、ll information of the access rights.</p><p>　　The system sets different authorities for administrators and students. Users with different authorities have different access rights and change authorities for d

45、ifferent data, which are divided into dormitory personnel' authorities and students' rights.</p><p>　　Integrity requirements:</p><p>　　All kinds of information records must have data; th

46、e completeness of information must be ensured:</p><p>　　Meticulously linked all kinds of data;</p><p>　　The same data record should be consistent, no matter which page is the same.</p>&l

47、t;p>　　Students in this dormitory:</p><p>　　Information requirements:</p><p>　　The students live in this dormitory can inquire dormitory they live in, students' express, their dormitory pr

48、operty repair conditions and so on, and can change their information for leaving and returning for school.</p><p>　　processing requirements:</p><p>　　The students can inquire, and report dormito

49、ry property need to be repaired in the</p><p>　　system according to the requirements. After the repair, the personnel can see it and send relevant personnel to repair it.</p><p>　　During the fes

50、tival and holiday, students need to record their whereabouts on the</p><p>　　system when they are away from school or return to school.</p><p>　　Second part: The design and division of system fu

51、nction</p><p>　　According to the above analysis, the user's requirements can be obtained, and the functions of the system are divided into the following parts, the student management part and administrat

52、or management part, respectively:</p><p>　　The functions completed by all parts are as follows:</p><p>　　User management part</p><p>　　Handle user registration</p><p>　

53、　Handle user login</p><p>　　Students can query the student information.</p><p>　　Students can query the express information.</p><p>　　Students can submit and search repair informati

54、on.</p><p>　　Students can increase and modify students' own return or leaving for school information.</p><p>　　Students can change their passwords.</p><p>　　Administrators’ mana

55、gement part</p><p>　　Handle administrator login</p><p>　　Administrators can query students' information.</p><p>　　Administrators can issue and update express information.</p&

56、gt;<p>　　Administrators can add, modify, query and delete student warranty information. Administrators can add and query students for their information for night return. </p><p>　　The administrator ca

57、n query information whether the student is in school or not.</p><p>　　Administrators can modify the administrators ' password.</p><p>　　Flow Diagram of System Data</p><p>　　STRU

58、CTURAL DESIGN OF SYSTEM CONCEPT</p><p>　　The instruction book is analyzed in accordance with the demand, according to the structural design idea; the local E-R graph is designed through data abstract design.

59、</p><p>　　The set of relational schemata is the relational data model, and the relationship</p><p>　　among entity and attribute and other entities constitutes E-R diagram. So transforming E-R di

60、agrams into relational data models is to transform the relationships among entities, attributes, and entities into relational schemas.</p><p>　　The database logic design can be divided into three phases: use

61、r' demand, establish E-R model and database pattern design. I have designed the E-R diagram of system before, meantime I have made some users' demand survey before the development, place myself in users' posi

62、tion, truly feel how to do products better, and more convenient in use, interface is friendlier. Based on this, the direction and emphasis of this system are clear, and the design of the database model is emphasized. It

63、can be di</p><p>　　Relational schema</p><p>　　Dormitory student (student number, name, gender, major, dormitory number, check-in time)</p><p>　　Dormitory (dormitory number, dormitor

64、y telephone)</p><p>　　Dormitory property (item number, item name)</p><p>　　Mail express (name, dormitory number, arrival time, receipt time, number of mail) Report (item number, dormitory number

65、, submission date, settlement date, reason</p><p>　　for repair)</p><p>　　Night return (student number, dormitory number, late return time, the reason late return)</p><p>　　Departure

66、 (student number, dormitory number, departure time, return time)</p><p>　　(The underlined attribute is the primary code)</p><p>　　The above relationship mode is BCNF.</p><p>　　In or

67、der to facilitate program query, the following user views are established: Student information view (student number, name, gender, department, dormitory</p><p>　　number, dormitory telephone)</p><p

68、>　　View of property report for repair (dormitory number, property name, time for repair, processing time, reasons for repair)</p><p>　　Student night view (student number, name, gender, department, dormito

69、ry</p><p>　　number, time, the reason for night return)</p><p>　　View for student leaving school (student number, name, gender, department, dormitory number, departure time, return time)</p>

70、;<p>　　View for student in school (student number, name, gender, department, dormitory</p><p>　　number, and dormitory telephone)</p><p>　　SYSTEM IMPLEMENTATION AND MAIN CODES</p>&

71、lt;p>　　The module codes of "student information management" are as follows:</p><p>　　TESTING PROCESS AND IMPROVEMENT</p><p>　　The students experience different user terminal after c

72、ompletion of the system, all kinds of situations are set to realize each function of system, after the use of different user terminal for a period of time, this system has many affirmations and valuable opinions from exp

73、erienced people. The highlight of this system is the friendliness of the interface, meanwhile maintaining relatively complete functions.</p><p>　　REFERENCES</p><p>　　1. (US) Weiss. Data Structur

74、e and Algorithm Analysis in JAVA Language Description, Beijing,</p><p>　　China Machine Press .2013.6.</p><p>　　Zhang Guangshun. You Should Learn JAVA Like This, Beijing, China Railway Publishing

75、 House,</p><p><b>　　2015.4.</b></p><p>　　Guo Lin. The First Line of Code, Beijing, Posts & Telecom Press, 2015.6.</p><p><b>　　譯文：</b></p><p>

76、;　　高校大學(xué)宿舍管理系統(tǒng)研究</p><p>　　LINGFANG HUANG</p><p><b>　　摘要：</b></p><p>　　經(jīng)過持續(xù)不斷地與大學(xué)宿舍管理人員進(jìn)行溝通與調(diào)查以及不斷的實踐和完善系統(tǒng)功能，并結(jié)合長時間的數(shù)據(jù)分析，我們終于開發(fā)出宿舍管理員用戶和學(xué)生用戶都滿意的“學(xué)生宿舍管理系統(tǒng)”。</p><

77、p><b>　　關(guān)鍵詞</b></p><p>　　學(xué)生宿舍管理系統(tǒng)；友好的用戶界面.</p><p><b>　　引言</b></p><p><b>　　研究現(xiàn)狀</b></p><p>　　目前,在互聯(lián)網(wǎng)上已經(jīng)開發(fā)出各種不同類型的學(xué)生宿舍管理系統(tǒng)，雖然它們的功能比較

78、齊全，但用戶界面給人一種很復(fù)雜的感覺，我們校學(xué)生宿舍管理人員由于其年齡問題在學(xué)習(xí)接受新知識方面沒有很大優(yōu)勢，因此需要一些時間來學(xué)習(xí)和適應(yīng)新的宿舍管理模式，盡管學(xué)生作為能夠快速學(xué)習(xí)新知識的終端用戶，但是他們習(xí)慣于原始的紙質(zhì)管理，他們也需要一些適應(yīng)時間。 所以，管理系統(tǒng)不但保證了功能的完整，更讓人們在界面的視覺感知中輕松辨別，同時考慮到了界面友好、使用方便的重要性。 本文高度重視此問題，并提出了較為完善的解決方案。</p>&

79、lt;p><b>　　研究的內(nèi)容和目標(biāo)</b></p><p>　　宿舍管理系統(tǒng)的主要特點包括以下幾點：</p><p>　　管理系統(tǒng)分為兩個身份進(jìn)行登錄，一個是宿舍人員，另一個是學(xué)生，登錄后每個身份的功能略有不同。</p><p>　　宿舍管理人員主要可以實現(xiàn)對以下該問題的查詢：</p><p>　　學(xué)生和宿舍信

80、息以及登錄后添加、刪除和修改他們的信息。</p><p>　　用戶可以檢查專門的信息</p><p>　　用戶可以提交和查詢修改的信息;</p><p>　　學(xué)生可以在離開和返回學(xué)校時添加或刪除自己的信息。</p><p>　　用戶可以更改自己的密碼。</p><p>　　這個宿舍管理系統(tǒng)強調(diào)功能的完整性以及界面的友好

81、性，在使用方便性上做了很多努力，為了使內(nèi)容看起來簡單易懂而不失功能完整性，我設(shè)計了許多不同類型的窗口布局，最后選擇了其中的一種最令人滿意的布局來實現(xiàn)簡單的界面設(shè)計。</p><p><b>　　需求分析</b></p><p>　　系統(tǒng)開發(fā)的可行性分析</p><p>　　技術(shù)可行性：隨著計算機技術(shù)的發(fā)展，人們的生活和工作或多或少地都涉及計算機

82、領(lǐng)域，現(xiàn)在人們很難擺脫這種方便的科學(xué)技術(shù)，總的來說，計算機的普及使人們的生活效率有了飛躍。宿舍管理系統(tǒng)存儲是管理軟件，它存儲了大量學(xué)生和宿舍信息，包括學(xué)生和宿舍信息的查詢、添加、刪除、更改等操作、學(xué)生遲到的記錄、宿舍物品的維修登記以及查詢并輸入學(xué)生的信件等。這樣的管理體系的發(fā)展使得對學(xué)生生活方式的了解變得更容易。該系統(tǒng)使用Eclipse和數(shù)據(jù)庫技術(shù)，Eclipse安全且易于使用，如上所述，數(shù)據(jù)庫使用起來更為方便和簡單，因此開發(fā)管理系統(tǒng)在

83、技術(shù)方面完全沒有問題。</p><p>　　經(jīng)濟可行性：開發(fā)這個系統(tǒng)只需要將軟件安裝到計算機上，并且可以隨時隨地進(jìn)行，因此開發(fā)這樣的軟件并不是很大的經(jīng)濟壓力。</p><p>　　組織管理的可行性：很多保守國家已經(jīng)擺脫了現(xiàn)代人的概念，如果開發(fā)的管理軟件功能足夠強大，那它可以被帶入到生活中去，所以它可以得到學(xué)校后勤部門的支持，因為沒有人會放棄一個可以使事情變得更容易的機會，而不會保守地做一些

84、無效的事情。</p><p>　　從上述可行性可以看出，開發(fā)這樣的管理系統(tǒng)可以使宿舍管理更加方便快捷，并且可以使整個管理模式向前邁進(jìn)一步。因此，有必要開發(fā)這種宿舍管理系統(tǒng)。</p><p><b>　　用戶需求分析</b></p><p>　　管理系統(tǒng)的最終用戶是宿舍管理員和學(xué)生。根據(jù)我在宿舍的日常經(jīng)驗，調(diào)查我學(xué)校的宿舍管理員老師和同宿舍的學(xué)生

85、;我發(fā)現(xiàn)了以下用戶終端的實際需求：</p><p>　　學(xué)生住在宿舍，許多宿舍管理人員在宿舍樓的日常生活。</p><p><b>　　學(xué)生的基本信息：</b></p><p>　　學(xué)生進(jìn)入學(xué)校后，學(xué)校會自動為每個學(xué)生配備一個數(shù)字代碼，這是唯一的學(xué)生ID，并被分配到指定的宿舍樓和宿舍。每個宿舍都有獨特的宿舍號碼;學(xué)生注冊時間是學(xué)生入學(xué)的時間。另

86、外，通常學(xué)生是與同一院系的學(xué)生住在同一棟大樓里，以方便管理;信息中有相應(yīng)的部門名稱。</p><p><b>　　宿舍基本信息：</b></p><p>　　每個宿舍都有一個主要的宿舍號碼;每個宿舍都有一部電話，它對應(yīng)著宿舍的電話號碼。</p><p>　　宿舍物業(yè)項目基本情況：</p><p>　　學(xué)校的公共財產(chǎn)包括燈

87、泡、床、桌椅等，為方便更好地區(qū)分不同的項目，為每個項目分配項目編號。主要目的是更有利于維修和管理宿舍公共物品。</p><p><b>　　快遞郵件基本信息：</b></p><p>　　每個宿舍都有快遞郵件信息管理。當(dāng)學(xué)生有信件要簽收時，信件的到達(dá)時間將相應(yīng)顯示，并接受帶有學(xué)生姓名和他宿舍的門牌號的信件。一個學(xué)生一次可以有幾個快遞信件，需要表示信件快遞的數(shù)量。當(dāng)快遞

88、到達(dá)時，會有一個到達(dá)時間。學(xué)生成功收到快件后，會顯示收到成功。</p><p>　　公共維修的基本信息：</p><p>　　宿舍的公共財產(chǎn)往往因損壞需要修復(fù)，此時學(xué)生應(yīng)對項目、項目名稱和損壞原因進(jìn)行編號，并上報宿舍管理系統(tǒng)，那么相關(guān)管理人員將會看到，并通知相關(guān)人員修理宿舍物業(yè)。該報告將生成報告時間，并在修復(fù)完成后獲得修復(fù)成功的時間。</p><p>　　學(xué)生夜間返

89、回的基本信息：</p><p>　　學(xué)生有時因某些事情超過了宿舍關(guān)閉的時間，此時宿舍管理人員應(yīng)該對系統(tǒng)做出相應(yīng)記錄，例如：夜間返回時間、夜間返回人員姓名、學(xué)生人數(shù)、返回遲到原因等等，以便進(jìn)行驗證。</p><p><b>　　離校的基本信息：</b></p><p>　　每年學(xué)校都有寒假、暑假和各種小長假，為了方便學(xué)生的安全管理并了解學(xué)生的去向

90、，他們應(yīng)該盡全力記錄學(xué)生在哪里、何時離開和他們回到學(xué)校的情況。</p><p><b>　　用戶對系統(tǒng)的要求：</b></p><p><b>　　2.宿舍管理人員：</b></p><p><b>　　A.信息要求：</b></p><p>　　宿舍管理人員可以查看以上所有信

91、息，包括學(xué)生宿舍內(nèi)的任何信息、快遞簽收信息、物業(yè)信息等以管理整個宿舍。</p><p><b>　　B.處理要求：</b></p><p>　　宿舍管理人員不僅可以查詢相關(guān)信息，而且有權(quán)更改很多信息，如學(xué)生信息變化，這些信息主要由宿舍管理人員修改，當(dāng)學(xué)生明確到達(dá)時，管理人員可以記錄下來，快遞成功收到后，由宿舍管理人員確認(rèn)并簽收。</p><p>

92、;　　當(dāng)學(xué)生上報損壞的房屋需要進(jìn)行維修時，宿舍管理人員可以查詢固定的時間，也就是宿舍管理人員不僅可以查詢學(xué)生的信息，還可以添加和刪除信息。</p><p>　　C.安全和完整性要求：</p><p><b>　　3）安全要求：</b></p><p>　　系統(tǒng)有兩個不同的用戶ID登錄，不同的用戶ID登錄有不同的系統(tǒng)窗口，應(yīng)確保用戶的用戶名和密碼

93、可行。</p><p>　　系統(tǒng)對同一數(shù)據(jù)集具有相同的訪問權(quán)限，用戶可以查詢和處理訪問權(quán)限的所有信息的類型和內(nèi)容。</p><p>　　系統(tǒng)為管理員和學(xué)生設(shè)置不同的權(quán)限。擁有不同權(quán)限的用戶擁有不同的訪問權(quán)限，并針對不同的數(shù)據(jù)有不同的更改權(quán)限，這些數(shù)據(jù)分為宿舍人員權(quán)限和學(xué)生權(quán)限。</p><p><b>　　4）完整性要求：</b></p&

94、gt;<p>　　各種信息記錄必須有數(shù)據(jù);必須確保信息的完整性：</p><p>　　詳細(xì)地關(guān)聯(lián)各種數(shù)據(jù);</p><p>　　不管頁面是否相同的，相同的數(shù)據(jù)記錄應(yīng)該是一致的。</p><p>　　2.學(xué)生在宿舍的情況：</p><p><b>　　C.信息要求：</b></p><p&

95、gt;　　住在這個宿舍的學(xué)生可以查詢他們住的宿舍、學(xué)生的快遞郵件、他們的宿舍物業(yè)修理情況等等，并且可以更改他們的上學(xué)和返校信息。</p><p><b>　　D.處理要求：</b></p><p>　　學(xué)生可以在宿舍物業(yè)系統(tǒng)根據(jù)要求去查詢并報告需要修復(fù)的項目。維修完成后，管理人員可以看到并派出相關(guān)人員進(jìn)行維修。</p><p>　　在節(jié)日和假期

96、期間，學(xué)生需要記錄他們的位置、他們離開學(xué)?；蚧氐綄W(xué)校的時間。</p><p>　　第二部分：系統(tǒng)功能的設(shè)計與分工</p><p>　　根據(jù)以上分析，可以得到用戶的需求，系統(tǒng)的功能分為以下幾部分，分別是學(xué)生管理部分和管理員管理部分：</p><p>　　各部分完成的功能如下：</p><p><b>　　3）用戶管理部分</b&

97、gt;</p><p><b>　　處理用戶注冊</b></p><p><b>　　處理用戶登錄</b></p><p>　　學(xué)生可以查詢學(xué)生信息。</p><p>　　學(xué)生可以查詢快遞信息。</p><p>　　學(xué)生可以提交和搜索維修信息。</p><

98、p>　　學(xué)生可以增加和修改學(xué)生自己返?；螂x開學(xué)校信息。</p><p>　　學(xué)生可以更改他們的密碼。</p><p>　　4）管理員的管理部分</p><p><b>　　處理管理員登錄</b></p><p>　　管理員可以查詢學(xué)生的信息。</p><p>　　管理員可以發(fā)布和更新快遞信息

99、。</p><p>　　管理員可以添加、修改、查詢和刪除學(xué)生保修信息。管理員可以添加和查詢學(xué)生的夜間返校信息。</p><p>　　管理員可以查詢學(xué)生是否在學(xué)校。</p><p>　　管理員可以修改管理員的密碼。</p><p>　　系統(tǒng)數(shù)據(jù)流程圖 2873</p><p><b>　　系統(tǒng)概念結(jié)構(gòu)設(shè)計<

100、;/b></p><p>　　根據(jù)需求分析來說明該指示，按照結(jié)構(gòu)設(shè)計思路;通過數(shù)據(jù)抽象設(shè)計對本校E-R圖進(jìn)行設(shè)計。</p><p>　　關(guān)系圖解集就是關(guān)系數(shù)據(jù)模型，并且也是實體和屬性等實體之間構(gòu)成的E-R圖的關(guān)系。因此，將E-R圖轉(zhuǎn)換為關(guān)系數(shù)據(jù)模型就是將實體、屬性和實體之間的關(guān)系轉(zhuǎn)換為關(guān)系模式。</p><p>　　數(shù)據(jù)庫邏輯設(shè)計可以分為三個階段：用戶需求，建

101、立E-R模型和數(shù)據(jù)庫模式設(shè)計。我之前設(shè)計過系統(tǒng)的E-R圖，同時我在開發(fā)前做了一些用戶的需求調(diào)查，從用戶的角度出發(fā)，真正感受到如何做得更好，使用得更方便，用戶界面更友好?；诖耍鞠到y(tǒng)的方向和重點是明確的，并強調(diào)數(shù)據(jù)庫模型的設(shè)計?？梢苑譃閮刹綄崿F(xiàn)數(shù)據(jù)庫模式下邏輯設(shè)計的設(shè)計階段，第一步是將ER圖轉(zhuǎn)換為關(guān)系模型，第二步是優(yōu)化設(shè)計，調(diào)整和改進(jìn)模式。我想強調(diào)的是，在邏輯設(shè)計的第三步中，即將E-R圖像關(guān)系模型轉(zhuǎn)化為關(guān)系模型。實體轉(zhuǎn)換的關(guān)系模式如下：

102、</p><p><b>　　關(guān)系模式</b></p><p>　　學(xué)生宿舍信息（學(xué)號、姓名、性別、專業(yè)、宿舍號、入住時間）</p><p>　　宿舍（宿舍號碼、宿舍電話）</p><p>　　宿舍物業(yè)（物品編號、物品名稱）</p><p>　　郵件快遞（姓名、宿舍號碼、到達(dá)時間、收件時間、郵件數(shù)

103、量）報告（項目號碼、宿舍號碼、提交日期、）</p><p>　　夜宿（學(xué)生號碼、宿舍號碼、延遲回校時間、延遲理由）</p><p>　　離校（學(xué)生號碼、宿舍號碼、出發(fā)時間、回校時間）</p><p>　　（帶下劃線的屬性是主要代碼）</p><p>　　上述關(guān)系模式是BCNF。</p><p>　　為了便于程序查詢，建

104、立了以下用戶視圖窗口：學(xué)生信息視圖（學(xué)號、姓名、性別、院系、宿舍號碼、宿舍電話）</p><p>　　查看維修的物業(yè)報告（宿舍號碼、物業(yè)名稱、維修時間、處理時間、維修原因）</p><p>　　學(xué)生夜晚巡查（學(xué)號、姓名、性別、部門、宿舍數(shù)量、時間、夜晚返回的原因）</p><p>　　查看學(xué)生離校（學(xué)號、姓名、性別、院系、宿舍號、出發(fā)時間、回程時間）</p&g

105、t;<p>　　查看在校學(xué)生（學(xué)號、姓名、性別、院系、宿舍號碼和宿舍電話）</p><p><b>　　測試過程和提升</b></p><p>　　學(xué)生在完成系統(tǒng)后，體驗了不同的用戶終端，設(shè)置了各種情境來實現(xiàn)系統(tǒng)的各項功能，經(jīng)過一段時間不同的用戶終端使用后，本系統(tǒng)得到了所有體驗用戶的許多肯定和寶貴意見。該系統(tǒng)的亮點是界面友好，同時保持相對完整的功能。&l

106、t;/p><p><b>　　參考文獻(xiàn)</b></p><p>　　1. (US) Weiss. Data Structure and Algorithm Analysis in JAVA Language Description, Beijing,</p><p>　　China Machine Press .2013.6.</p>

107、<p>　　Zhang Guangshun. You Should Learn JAVA Like This, Beijing, China Railway Publishing House,</p><p><b>　　2015.4.</b></p><p>　　Guo Lin. The First Line of Code, Beijing, Post