计算机软件工\实操试题\试题\第三套解答二、SQL程序设计

要求：将本题的每步操作的SQL语句输入到windows的记事本，保存在m:\sql003目录下面。文件名为MySql.txt。并在sql2000环境中执行这些sql语句。(25分)



一、　　请在企业管理器中创建以下数据库：（2分）(提示，可以使用企业管理器建立数据库和下面的表格，也可以使用sql语句)

数据库名称：学生管理

-Computer Software Engineering \ practical operation of papers \ papers \ third set of answers to the second, SQL programming requirements: to the theme of the SQL statement for each step input to windows Notepad, save in the m: \ sql003 directory. File name MySql.txt. Environment in sql2000 sql statement to execute these. (25 points) A, in the Enterprise Manager create the following databases: (2 points) (Hint, you can use Enterprise Manager to establish a database and the table below, you can also use the sql statement) the database name: Student Management