数据库思考题答案

1(Data)(Database)(DBMS)(DBS)1(Data):2(DataBase;DB):3(DataBaseManagementSystem;DBMS):4(DataBaseSystem;DBS):23124()5123(RelationalModel)4(ObjectOrientedModel5(ObjectRelationalModel)6(semistructuredatamodel)161234DBMS712DBMSDBMSDBMS389122DBMS101234/5//111//231231Candidatekey2Primarykey41Homogeneous2345656nn78491==.251SQLCREATE\ALTER\DROP(SELECT)(INSERT\UPDATE\DELETE)(GRANT\REVOKE)2SQL3SQLSERVERCharnncharnUnicodevarcharnnvarcharnUnicode4UNIQUE5HAVINGWHERE12WHERE,3HAVING,6SQL7LEFTOUTERJOINRIGHTOUTERJOINFULLOUTERJOIN812691011121234571231TCSEC()2CC()345DAC1261C227SQLSERVERSQLServer200XWindows88SQLSERVER1WindowsSQLServer29123DBMS1ARA24SQL56StudentSC////71SKsF2810123123453NFBCNF4NFBCNF3NF3NFBCNF6XYYZYXYX7BCNF3NFBCNFX3NF8R3NFRRBCNF111/23E-R124E-R5E-RE-R67E-R1.2812121SQL2SQL1SQL(SQLCA)233ODBC*ODBC41SQLServerTransact-SQL,SQLServer25*6*CREATE/ALTER/DROPTRIGGER7inserteddeleted*1DeletedDELETEUPDATEDELETEUPDATEdeleted2InsertedINSERTUPDATEinserted13123124why5?1267REDO814