【正文】 課程設(shè)計(jì)報(bào)告書(shū) 課程 名稱： 數(shù) 據(jù)庫(kù)應(yīng)用與實(shí)踐 題 目： 小區(qū)物業(yè) 管理信息系統(tǒng)數(shù)據(jù)庫(kù)的設(shè)計(jì) 學(xué)生姓名： 專 業(yè)： 數(shù)學(xué)與應(yīng)用數(shù)學(xué) 班 別： 學(xué) 號(hào) ： 0804401128 指導(dǎo)老師： 日 期： 2020 年 6 月 小區(qū) 物業(yè)管理 信息 系統(tǒng) 數(shù)據(jù)庫(kù)的設(shè)計(jì) 1 1 1 1 小區(qū)物業(yè) 管理信息系統(tǒng)數(shù)據(jù)庫(kù)的設(shè)計(jì) 數(shù)學(xué)與應(yīng)用數(shù)學(xué) 2020 級(jí) 指導(dǎo)教師 摘要 該文從 小區(qū)物業(yè) 管理信息系 的現(xiàn)狀出發(fā)，針對(duì) 物業(yè)管理 情況，結(jié)合 小區(qū) 的實(shí)際需求， SQL Server 2020 作為后臺(tái)數(shù)據(jù)庫(kù)進(jìn)行設(shè)計(jì)，較好的滿足了 小區(qū)物業(yè) 的 管理 需求 。 使各項(xiàng)業(yè)務(wù)的辦理迅速、準(zhǔn)確，極大的提高了小區(qū)物業(yè)管 理的工作效率。 關(guān)鍵詞 ： 小區(qū)物業(yè) ； 管理； 數(shù)據(jù)庫(kù)設(shè)計(jì) Abstract The production from the current situation of management information system for the status quo o bined with the actual needs of the production management for manufacturing information systems technology development, with Microsoft Visual Basic programming language as a front, SQL Server 2020 database system design as a background, the better to meet production needs. The main function of the system is plete the pany39。s procurement information, material information, product information and customer information management, with all kinds of information to add, modify, delete, search functions. So that all operations for rapid, accurate, and greatly improves the efficiency of residential property management. Keywords： Residential property； Management ； System； Design 小區(qū) 物業(yè)管理 信息 系統(tǒng) 數(shù)據(jù)庫(kù)的設(shè)計(jì) 2 2 2 1 目 錄 一、前言 ................................................................................................................................................ 3 二、數(shù)據(jù)流圖 ......................................................................................................................................... 3 ................................................................................................................................... 3 ................................................................................................................................... 4 設(shè)備管理 .................................................................................................................................. 4 社區(qū)清潔管理 .......................................................................................................................... 5 財(cái)務(wù)管理 .................................................................................................................................. 5 ........................................................................................................................ 6 三、數(shù)據(jù)字典 ......................................................................................................................................... 6 數(shù)據(jù)項(xiàng) ....................................................................................................................................... 6 數(shù)據(jù)結(jié)構(gòu) .......................................................................................................................... 7 數(shù)據(jù)流 .................................................................................................................................... 7 四、 概念結(jié)構(gòu)設(shè)計(jì) .................................................................................................................................. 8 分 ER 圖 ................................................................................................................................... 8 小區(qū)模塊 .......................................................................................................................... 8 樓宇信息模塊 ................................................................................................................... 8 住戶信息模塊 ................................................................................................................... 8 房間信息模塊 ................................................................................................................... 9 收費(fèi)模塊 .......................................................................................................................... 9 清潔管理模塊 ................................................................................................................... 9 周邊設(shè)施 .......................................................................................................................... 9 車位信息模塊 ................................................................................................................. 10 設(shè)備模塊 ........................................................................................................................ 10 總 ER 圖 .................................................................................................................................. 11 五、 邏輯結(jié)構(gòu)設(shè)計(jì) ................................................................................................................................ 11 ........................................................................................................................................ 11 ......................................................................................................................................... 12 物理結(jié)構(gòu)設(shè)計(jì) ....................................................................................................................