计算机专业英语教案--35[3页]

教材名称：《计算机专业英语》

主编：来永春

出版时间：

电子教案

An example might be Product ID or Order ID. 8. Set up table relationships Look at each table and decide how data in one table is related to data in other tables. Add fields to tables or create new tables to clarify the relationships. 9. Refine the design Analyze design errors. Create tables and add a few sample records. Make sure the resalts are right. If not, modify your design. e standard rules Use standard rules to examine your tables, if they’re not right, you need to modify them. Task Two Use SQL to Create Database for the Goods 1. In this task, first of all, students can operate Microsoft SQL Server to create database. Secondly, the students can use some of the SQL tools. Thirdly, they can use SQL to design query view.

2. Operate Microsoft SQL Server to create database Step 1. Open Microsoft

SQL Server Management Studio. Depending on how you installed SQL

Server, if you have an icon on your desktop, click it. Otherwise, click

“Start”, choose “All Programs”, then select “Microsoft SQL

Server”.

3. Step 2. Click the plus sign next to your server name. Then right-click

“Databases”.

4. Step 3. Click “New Database”, open a New Database options screen.

5. Step 4. Input a name for your database in the “Database name” text

box. To make programming easier, you can use one of the following name

formats: a single-word name such as Database, a multiple-word name

without space such as NewDatabase or a multiple-word name with

underscore such as My_New_Database.

6. Step 5. Click “OK” to create a database. You can change the

database’s properties at any time by right-clicking the name of the

database and choosing “Properties”. All objects you c reate for your

new database will be listed out when you click the plus sign beside

your database name.

7. Use some of the SQL tools Now we can use SQL to create database for

the goods.

8. There a re a few examples, let’s look at some of the “tools” that

SQL provides for building queries.

9. ou can use this sort of summary of SQL language tools as a reference.

You first need to decide what you want, then use these tools to produce

your output.

10. This is usually not an easy task. The design view can help you get

what needs to be done, but you may also find it necessary to use

the SQL view to finally get what you need. Here are some examples.

11. The resulting table will contain:

●all columns from each of the source tables

●an instance of each row of the data from each source table16.

45分钟Task

Two