数据库工程师-(34)

81 1 A B C D 2 A B C D 3 A B C D 4 UML A B C D 5 A B C D 6 A B C D 7 ID A B C D 8 R U U X Y Z U Z U X Y A X Y T Y X T B X Y X Z C X Y X Y D Z X Z 9 SQL student CREATE TABLE student NO CHAR 20 NOT NULL NAME CHAR 8 NOT NULL SEX CHAR 2 AGE INT A 1031 23 B 1031 NULL NULL C NULL 23 D 1031 NULL 23 10 A B C D 11 IDEF0 A B C D 12 A B C D 13 SQL Server 2000 A B C D 14 2 5 A B C D I 15 A B C D 16 A B C D 18 ID ID A B C D 19 A B C D 20 A B C D 21 A B ER C D 22 E R A B C D 23 T1 T2 data SLOCK data data S UNLOCK data data T1T2 SLOCK data data 20 SLOCK data data 20 data 50 COMMIT A A 30 A 50 COMMIT UNLOCK data UNLOCK data A B C T1 X D T2 data 24 A B C D 25 C S A DBAS B C D 26 A DBMS N A A B C D 27 A B C D 28 A B C D 29 A db owner B db denydatawriter C db denydatawriter D sysadmin 30 A B C D 31 Employee employeeID name age tel departID departID Empolyee 32 33 SQL Server 2000 U SEL ECT C1 C2 INTO T1 FROM T2 U T2 34 35 SQL Server 2000 u1 u1 EXEC sp addrolemember 11 12 36 3 S Sno Sname Sage Ssex SC Sno CNo Grade C CNo CName Teacher SQL WANG Maths 5 38 ER 39 1 2 A Z 3 7 0 9 6 6 0 8 13 SQL SQL 1 C 2 C 3 A 4 A A 5 D 6 D D 7 A 8 A 9 B A SEX C NO D NAME 10 B 11 C IDEF0 C B D DFD A DFD IDEF0 12 C 13 C 14 C 15 B 16 D 18 B Clastering Index Nonclustering Index Dense Index Sparse Index Primary Index Secondary Index 19 B 20 B 21 D 22 D E R 23 C T1 A S T2 A S T1 A T2 18 X 24 D 25 D 26 A A DBMS A 27 C C 28 A X Y Y X Y X X Y 29 B 30 A 31 TEL cmployreeID 32 CPU I O 33 34 35 db datareader u1 37 DELETE FROM SC WHERE Sno IN SELECT Sno FROM S WHERE Sname WANG UPDATE SC SET Grade NULL WHERE Grade 60 AND CNo IN SELECT CNo FROMC WHERE Cname Maths UPDATE SC SET Grade Grade 1 05 WHERE Sno IN SELECT Sno FROM S WHERE Ssex F AND Grade SELECT AVG Grade FROM SC 38 39 Create table char 7 Not NULL CHECK like A Z 0 9 0 9