实验1-1
MySQL数据库的安装与配置。
下载后的MySQL安装文件是mysql-5.5.12-win32.msi，运行该程序可以进行MySQL安装，在安装完成后会显示如图4-2，在图4-2中选中Launch the MySQL Instance
Configuration Wizard复选框，单击Finish按钮，进行配置，显示如图4-3所示的对话框。
选择使用哪种配置方式在图4-3中，选中Detailed Configuration进行详细配置，单击Next按钮，下一界面选中Developer Machine（开发者机器）单选按钮，单击Next按钮；继续选中Multifunctional Database（多功能数据库），单击Next按钮；选择InnoDB表空间保存位置，单击Next按钮；下一界面中选择服务器并发访问人数；设置端口号和服务器SQL模式（MySQL使用的默认端口是3306，在安装时，可以修改为其他的，如3307，但是一般情况下，不要修改默认的端口号，除非3306端口已经被占用）；选中Manual Selected Default Character Set/Collation（设置默认字符集编码为utf8），单击Next按钮，选中Install As Windows Service和Include Bin Directory in Windows
PATH复选框，针对Windows系统设置，单击Next按钮，打开如图4-4所示的对话框；在图4-4中输入数据库的密码“111”，单击Next按钮（注意：在安装MySQL数据库时，一定要牢记在上述步骤中设置的默认用户root的密码，这是我们在访问MySQL数据库时必须使用的），打开如图4-5所示的对话框。
图4-4
输入数据库的密码图
图4-5 确认配置对话框
在图4-5中单击Execute按钮，执行前面进行的各项配置，配置完成后的效果如图4-6所示。
第一次 “数据库原理及应用”课程作业
开发一个房产信息管理系统实现居民的房产信息管理。在该房产信息管理系统中，设计一个数据库EstateDB，其中包括业主表（Owner）、房产表（Estate）、产权登记表（Registration）。各数据表的字段结构定义见表3-14到表3-16所示。
表3-14 业主表（Owner）
字段名称 字段编码 数据类型 字段大小 必填字段 备注
身份证号 PersonID Char 18 是 主键
姓名 Name Varchar 20 是
性别 Gender Char 2 是
职业 Occupation Varchar 20 是
身份地址 Addr Varchar 50 是
电话 Tel Varchar 11 是
表3-15 房产表（Estate）
字段名称 字段编码 数据类型 字段大小 必填字段 备注
房产编号 EstateID Char 15 是 主键
房产名称 EstateName Varchar 50 是
房产楼盘 EstateBuildName Varchar 50 是
房产地址 EstateAddr Varchar 60 是
房产城市 EstateCity Varchar 60 是
房产类型 EstateType Char 4 是 取值范围：住宅、商铺、车位、别墅
产权面积 PropertyArea Numeric (5,2) 是
使用面积 UsableArea Numeric (5,2) 是
竣工日期 CompletedDate
Date 是
产权年限 YearLength Int 是 默认值70
备注 Remark Varchar 100 否
表3-16 产权登记表（Registration）
字段名称 字段编码 数据类型 字段大小 必填字段 备注
登记编号 RegisterID Int 是 主键
身份证号 PersonID Char 18 是 外键
网上书店系统
目录
摘要 .............................................................................................................2
第一章 绪论 ..............................................................................................3
1.1设计思想 .......................................................................................................... 3
1.2开发工具的选用及介绍 .................................................................................. 4
1.3系统开发环境及配置 ...................................................................................... 4
第二章 需求分析 ......................................................................................5
2.1开发该系统的依据及意义 .............................................................................. 5
2.2网上书店的现状 .............................................................................................. 6
guarantee for the great struggle. This aspects XI General Secretary of speech main including exercise thrift, against extravagance mass line is party of lifeline and fundamental work route accurate grasp party of mass line education practice activities of guideline and target requirements set and develop "three strict three real" of style put power shut into system of cage in using history wisdom advance anti-corruption construction in-depth advance style clean government and anti-corruption struggle develop nail nail of spirit, a Zhang good of blueprint worked to... 9. other aspects. 18 big yilai, XI General Secretary also respectively on diplomatic, and military, and ecological construction, aspects published has important speech, covers has construction ecological civilization, and advance defense and army modern, and rich "one country, two systems" practice and advance country unified, and go peace development road, and promoted building new powers relationship, and go good around diplomatic work, and strengthening and developing countries solidarity cooperation, and active participation multilateral affairs, and science of thinking and work method, many aspects. XI Jinping, Secretary of a series of important speeches, and further enrich and develop the party's theory, line, principles and policies, the party puts forward new requirements for more contemporary features, the latest achievement of Marxism in China, is a guide to persisting and developing socialism with Chinese characteristics. Four methods. To address the relationship between comprehensive and focused on science. In the process of learning, we should follow as a good study and carry out the "wise men" to conduct a comprehensive collaborative learning; and with their own jobs, focus research and understanding spirit, grasp the potential requirements. For example, every party member should be according to the various branches of learning program, an article does not go into a link, no leakage of conducting a comprehensive study, and combined with their own duties and responsibilities, be focused and targeted Geoscience. Like, leaders to highlight learning XI on ruling acting political know of deep love of cut dry in practice go in forefront of river new language out poverty XI on coordination advance "four a full" strategy layout discusses excerpts XI on full deepening reform discusses excerpts XI on full law ruling discusses excerpts 18 big yilai XI on major economic problem discusses excerpts, discipline to highlight learning XI on strict party of discipline and rules discusses excerpts XI Jinping, on the construction of clean and honest Government and fight against corruption discussed excerpts, technology to highlight the learning of the XI Jinping on technological innovation and discusses excerpts, XI Jinping, education should highlight the important excerpts of work on education and so on. To address the relation between stage and often science. Phase has the advantage of time to focus on fast, to highlight the theme, focused, result; often learn the advantages of flexible fit, form, subtle, continues to
