【正文】 要求的顯示結(jié)果 SELECT ,Sname,Cname,mark FROM students,courses,marks WHERE = and = and =‘ 2021001’ 3．程序應(yīng)用題 接第五題第 2小題，某教學管理系統(tǒng)包括課程信息錄入功能，程序運行界面如圖 2 所示，其中 Text1為課程號、 Text2為課程名。教師編號和課程號分別是上述兩個關(guān)系的主鍵，請用 SQL語句創(chuàng)建教師數(shù)據(jù)表 T。 6．利用 SQL語句進行查詢 在上題的基礎(chǔ)上，如果要查詢?張紅老師承擔的所有課程?，請寫出對應(yīng)的 SQL 查詢語句。 Private Sub Command1_Click() ‘ 聲明一個記錄集對象 Dim ADOrs As New Recordset ‘ 將記錄集對象與已建立的數(shù)據(jù)庫聯(lián)接對象 ADO綁定 =ADO ‘ 第一步：在學生成績表中查詢是否存在關(guān)鍵字相同的記錄 （ 1）拼寫查詢字符串 strSQL=? Select * From 學生成績表 Where 學號 =‘? ++? ’ And 課程號 =‘?++? ’ ? （ 2）執(zhí)行查詢語句 StrSQL ‘ 第二步：如果關(guān)鍵字重復，則退出程序 If Not Then MsgBox ? 記錄已存在，不能繼 續(xù)增加 ? Exit Sub End If ‘ 第三步：將結(jié)果插入到學生成績表中 StrSQL=? Insert Into 學生成績表 (學號 ,課程號 ,成績 ) Values(‘? ++? ’ ,‘? ++ ? ’ , ?+Str(Val())+? )? StrSQL （本小點 2分） End Sub 8. 用 SQL 語句創(chuàng)建簡單數(shù)據(jù)表 設(shè)有職工數(shù)據(jù)表 T，包括職工編號 TNo，姓名 TN，出生年月日 TD 等字段。 Cn為數(shù)值型 (帶小數(shù) )。 10. 程序應(yīng)用題 設(shè)物資臺賬數(shù)據(jù)表的結(jié)構(gòu)為 (物資編碼、物資名稱、計量單位、單價、期初庫存 )，程序運行界面如圖 1 所示，其中 Text1 為控件數(shù)組，Text1(0), Text1(1), Text1(2), Text1(3), Text1(4)分別表示物流編碼、物資名稱、單價、期初庫存、期初金額。進 入 界 面后 ，用 戶 首先 選 擇職 工編 號（ Combo1）、工資項編號 (Combo2)，職工姓名(Text1)和工資項名稱 (Text2)從數(shù)據(jù)庫中自動讀入；然后，用戶修改對應(yīng)的工資數(shù)（ Text3），點擊?確認?按鈕后，將結(jié)果更新到學生成績表中。s games measures in (7576 cm) in circumference, and a women39。s five basic principles center on the ball, which was described as large, light, and handled with the hands. Players could not move the ball by running alone, and none of the players was restricted against handling the ball. The playing area was also open to all players, but there was to be no physical contact between players。 England in 1894。s basketball. Until World War II, basketball became increasingly popular in the United States especially at the high school and college levels. After World War II, its popularity grew around the world. In the 1980s, interest in the game truly exploded because of television exposure. Broadcast of the NCAA Championship Games began in 1963, and, by the 1980s, cable television was carrying regular season college games and even high school championships in some states. Players like Bill Russell, Wilt Chamberlain, and Lew Alcindor (Kareem AbdulJabbar) became nationally famous at the college level and carried their fans along in their professional basketball careers. The women39。s basketball league in the United States was the National Basketball League (NBL), which debuted in 1898. Players were paid on a pergame basis, and this league and others were hurt by the poor quality of games and the everchanging players on a team. After the Great Depression, a new NBL was anized in 1937, and the Basketball Association of America was anized in 1946. The two leagues came to agree that players had to be assigned to teams on a contract basis and that high standards had to govern the game。s World Basketball Association, before the WNBA debuted in 1997 with the support of the NBA. James Naismith, originally from Almonte, Ontario, invented basketball at the International YMCA Training School in Springfield, Massachusetts, in 1891. The game was first played with peach baskets (hence the name) and a soccer ball and was intended to provide indoor exercise for football players. As a result, it was originally a rough sport. Although ten of Naismith39。s professional leagues were attempted and failed, including the Women39。s game. Television interest followed the women as well with broadcast of NCAA championship tourneys beginning in the early 1980s and the formation of the WNBA in 1997. Internationally, Italy has probably bee the leading basketball nation outside of the United States, with national, corporate, and professional teams. The Olympics boosts basketball internationally and has also spurred the women39。 and Japan in 1900. From 1891 through 1893, a soccer ball was used to play basketball. The first basketball was manufactured in 1894. It was 32 in (81 cm) in circumference, or about 4 in (10 cm) larger than a soccer ball. The dedicated basketball was made of laced leather and weighed less than 20 oz (567 g). The first molded ball that eliminated the need for laces was introduced in 1948。 smaller gyms used five players on a side, and the larger gyms allowed seven to nine. The team size became generally established as five in 1895, and, in 1897, this was made formal in the rules. The YMCA lost interest in supporting the game because 1020 basketball players monopolized a gymnasium previously used by many more in a variety of activities. YMCA membership dropped, and basketball enthusiasts played in local halls. This led to the building of 7 / 8 basketball gymnasiums at schools and colleges and also to the formation of professional leagues. Although basketball was born in the United States, five of Naismith39。s bounce. Inside the covering or casing, a rubber bladder holds air. The ball must be inflated to a pressure sufficient to make it rebound to a height (measured to the top of the ball) of 4954 in ( m) when it is dropped on a solid wooden floor from a starting height of 6 ft ( m) measured from the bottom of the ball. The factory must test the balls, and the air pressure that makes the ball legal in keeping with the bounce test is stamped on the ball. During the intensity of high school and college tourneys and the professional playoffs, this inflated sphere mands considerable attention. Basketball is one of few sports with a known date of birth. On December 1, 1891, in Springfield, Massachusetts, James Naismith hung two halfbushel peach baskets at the opposite ends of a gymnasium and outlined 13 rules based on five principles to his students at the International Training School of the Young Men39。 圖 2?修改記錄?窗體運行界面 Private Sub Command1_Click() ‘ 聲明一個字符串變量 Dim strSQL AS String ‘ 第一步：拼寫 Update語句 strSQL =? Up