实验一 数据库的建立和维护（The establishment and maintenance of a database）.docVIP

实验一 数据库的建立和维护（The establishment and maintenance of a database） Experiment 1: database establishment and maintenance The experiment purpose Master the ability to set up databases and tables, enter data into the database, modify data, and delete data. The experiment content, Set up database and design each table, enter multiple actual data, and realize the increase, deletion and operation of data. Experimental steps: Create a student management database called XSGL, which contains basic information about students, course information and course information. The database XSGL contains the following three tables: (l) student: basic information for students. (2) course: course information sheet. (3) sc: student selection form. The structure of each table is shown in table 1, table 2 and table 3. Table 1 student information table: student Whether the column name data type length is allowed to be null Sno character type 10 no Sname character type 10 no Ssex character type 2 no The sage integer type is Sdept character type 4 no Table 2 course information table: course Whether the column name data type length is allowed to be null Cno character type 3 no Cname character 30 no The credit integer type is Pcno character 3 is Table 3 student selection table: sc Whether the column name data type length is allowed to be null Sno character type 10 Cno character 30 no The grade integer type is 1. Establishment of database: 1. Establishment of visual interface: (a) in SQL server, enterprise manager - new database; (b) database designer in VFP; new database; 2. Establishment of command: (a) in SQL server, t-sql statements are used in the query analyzer: The CREATE DATABASE XSGL ON (NAME = XSGL_DATA, FILENAME = E: \ XSGL MDF, SIZE = 10 MB, MAXSIZE = 50 MB, FILEGROWTH = 5%) The LOG ON (NAME = XSGL_Log, FILENAME = e: \ XSGL_Log LDF, SIZE = 2 MB, MAXSIZE = 5 MB, FILEGROWTH = 1 MB) (b) use SQL statements in the command window in VFP: The CREATE DATABASE XSGL Ii. Establishment of the table: