计算机专业英语教案--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。