优化myschool数据库设计（Optimization design of myschool database）.doc

优化myschool数据库设计（Optimization design of myschool database） Chapter 1 database design Database design is the process of planning and structuring the relationships between the data entities in the database and the data entities. Project development needs to be analyzed by requirement analysis, outline design, detailed design, code compiling, running test and package release. In the requirements analysis phase, the general steps for designing a database are as follows. 1 collect information. 2 identifier entity. 3 identifies the properties of each entity. 4 identifies relationships between entities. In the outline design phase and the detailed design phase, the general steps for designing the database are as follows. 1 draw E-R diagram. 2, E-R diagram is translated into database model diagram. 3 application of three paradigms normalization table design. Three paradigms The goal of the first paradigm is to ensure atomicity of each column. The second paradigm is based on the first paradigm, with the goal of ensuring that each column in the table is related to the primary key. The third paradigm is based on the second paradigm, with the goal of ensuring that each column is directly related to the primary key column. The process of removing redundant data from relational database tables is called normalization. The second chapter is the realization of database Create database grammar Create dataBase database name On primary ( Data file details ) Log on ( Log file details ) The specific parameters of the file are as follows. Name= logical file name, FileName = filename in room, Size = size, MaxSize = maximum capacity FileGrowth = growth Delete the syntax of the database. Drop dataBase database name Create table grammar Create table table name ( Column 1 data type column features Column 2 data type column features ) The column features include whether the column is empty, whether it is an identity column, whether it has default values, and whether it is a primary key. Delete