¡¶Êý¾Ý¿âÔ­Àí¼°Ó¦Óá·Óʵç¶þ°æ Ï°Ìâ²Î¿¼´ð°¸£¨×ÜÌ壩

¡¤21¡¤

3£® Ð޸ĵÚ1Ì⣨4£©¶¨ÒåµÄÊÓͼ£¬Ê¹Æä²éѯÿ¸öѧÉúµÄѧºÅ¡¢×Üѧ·ÖÒÔ¼°×ܵÄÑ¡¿ÎÃÅÊý¡£ ´ð£º Alter view v4 As

Select sno,sum(credit) as total_credit,count(*) as total_cno

From sc join course c on c.cno = sc.cno Group by sno

4£® д³öʵÏÖÏÂÁвÙ×÷µÄSQLÓï¾ä£¬Ö´ÐÐÕâЩÓï¾ä£¬²¢ÔÚSSMS¹¤¾ßÖй۲ìÓï¾äÖ´Ðнá¹û¡£ £¨1£© ÔÚStudent±íµÄSdeptÁÐÉϽ¨Á¢Ò»¸ö°´½µÐòÅÅÐòµÄ·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£ºIdx_Sdept¡£ ´ð£ºCreate index Idx_Sdept on student(Sdept DESC)

£¨2£© ÔÚStudent±íµÄSnameÁÐÉϽ¨Á¢Ò»¸öΨһµÄ·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£ºIdx_Sname¡£ ´ð£ºCreate unique index Idx_Sname on student(Sname)

£¨3£© ÔÚCourse±íÉÏΪCnameÁн¨Á¢Ò»¸ö·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£º Idx_Cname ´ð£ºCreate index Idx_Cname on Course(Cname)

£¨4£© ÔÚSC±íÉÏΪSnoºÍCno½¨Á¢Ò»¸ö×éºÏµÄ·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£ºIdx_SnoCno¡£ ´ð£ºCreate index Idx_SnoCno on SC(Sno,Cno)

£¨5£© ɾ³ýÔÚSnameÁÐÉϽ¨Á¢µÄIdx_SnameË÷Òý¡£ ´ð£ºdrop index Idx_Sname on Student

21

¡¤22¡¤

µÚ6Õ ¹ØϵÊý¾ÝÀíÂÛ

Ò»£®Ñ¡ÔñÌâ

1£®¶Ô¹Øϵģʽ½øÐй淶»¯µÄÖ÷ҪĿµÄÊÇ

A£®Ìá¸ßÊý¾Ý²Ù×÷ЧÂÊ C£®¼ÓÇ¿Êý¾ÝµÄ°²È«ÐÔ

B

B£®Î¬»¤Êý¾ÝµÄÒ»ÖÂÐÔ

D£®ÎªÓû§Ìṩ¸ü¿ì½ÝµÄÊý¾Ý²Ù×÷

2£®¹ØϵģʽÖеIJåÈëÒì³£ÊÇÖ¸ D

A£®²åÈëµÄÊý¾ÝÎ¥·´ÁËʵÌåÍêÕûÐÔÔ¼Êø

B£®²åÈëµÄÊý¾ÝÎ¥·´ÁËÓû§¶¨ÒåµÄÍêÕûÐÔÔ¼Êø C£®²åÈëÁ˲»¸Ã²åÈëµÄÊý¾Ý

D£®Ó¦¸Ã±»²åÈëµÄÊý¾Ý²»Äܱ»²åÈë

3£®Èç¹ûÓк¯ÊýÒÀÀµX¡úY£¬²¢ÇÒ¶ÔXµÄÈÎÒâÕæ×Ó¼¯X¡¯£¬¶¼ÓÐX¡¯Y£¬Ôò³Æ C

A£®XÍêÈ«º¯ÊýÒÀÀµÓÚY B£®X²¿·Öº¯ÊýÒÀÀµÓÚY C£®YÍêÈ«º¯ÊýÒÀÀµÓÚX D£®Y²¿·Öº¯ÊýÒÀÀµÓÚX 4£®Èç¹ûÓк¯ÊýÒÀÀµX¡úY£¬²¢ÇÒ¶ÔXµÄij¸öÕæ×Ó¼¯X¡¯£¬ÓÐX¡¯¡úY³ÉÁ¢£¬Ôò³Æ B A£®YÍêÈ«º¯ÊýÒÀÀµÓÚX B£®Y²¿·Öº¯ÊýÒÀÀµÓÚX C£®XÍêÈ«º¯ÊýÒÀÀµÓÚY D£®X²¿·Öº¯ÊýÒÀÀµÓÚY 5£®ÈôX¡úYºÍY¡úZÔÚ¹ØϵģʽRÉϳÉÁ¢£¬ÔòX¡úZÔÚRÉÏÒ²³ÉÁ¢¡£¸ÃÍÆÀí¹æÔò³ÆΪ C A£®×Ô·´¹æÔò B£®Ôö¹ã¹æÔò C£®´«µÝ¹æÔò D£®Î±´«µÝ¹æÔò 6£®Èô¹ØϵģʽRÖÐÊôÐÔA½ö³öÏÖÔÚº¯ÊýÒÀÀµµÄ×󲿣¬ÔòAΪ A A£®LÀàÊôÐÔ B£®RÀàÊôÐÔ C£®NÀàÊôÐÔ D£®LRÀàÊôÐÔ 7£®Èô¹ØϵģʽRÖÐÊôÐÔAÊÇNÀàÊôÐÔ£¬ÔòA D A£®Ò»¶¨²»°üº¬ÔÚRÈκκòÑ¡ÂëÖÐ

B£®¿ÉÄÜ°üº¬Ò²¿ÉÄܲ»°üº¬ÔÚRµÄºòÑ¡ÂëÖÐ C£®Ò»¶¨°üº¬ÔÚRµÄij¸öºòÑ¡ÂëÖÐ D£®Ò»¶¨°üº¬ÔÚRµÄÈκκòÑ¡ÂëÖÐ

8£®ÉèFÊÇij¹ØϵģʽµÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯¡£ÏÂÁйØÓÚFµÄ˵·¨£¬´íÎóµÄÊÇ

A£®FÖÐÿ¸öº¯ÊýÒÀÀµµÄÓÒ²¿¶¼±ØÐëÊǵ¥¸öÊôÐÔ B£®FÖÐÿ¸öº¯ÊýÒÀÀµµÄ×󲿶¼±ØÐëÊǵ¥¸öÊôÐÔ C£®FÖв»ÄÜÓÐÈßÓàµÄº¯ÊýÒÀÀµ

D£®FÖÐÿ¸öº¯ÊýÒÀÀµµÄ×󲿲»ÄÜÓÐÈßÓàÊôÐÔ

B

9£®ÓйØϵģʽ£ºÑ§Éú£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬ÏµÖ÷ÈΣ©£¬ÉèÒ»¸öϵֻÓÐÒ»¸öϵÖ÷ÈΣ¬Ôò¸Ã¹ØϵģʽÖÁÉÙÊôÓÚ B

A£®µÚÒ»·¶Ê½ B£®µÚ¶þ·¶Ê½ C£®µÚÈý·¶Ê½ D£®BC·¶Ê½

22

¡¤23¡¤ 10£®ÉèÓйØϵģʽR(X, Y, Z)£¬ÆäF={Y¡úZ, Y¡úX, X¡úYZ}£¬Ôò¸Ã¹ØϵģʽÖÁÉÙÊôÓÚ

A£®µÚÒ»·¶Ê½ B£®µÚ¶þ·¶Ê½ C£®µÚÈý·¶Ê½ D£®BC·¶Ê½ 11£®ÏÂÁйØÓÚ¹ØϵģʽÓ뷶ʽµÄ˵·¨£¬´íÎóµÄÊÇ D A£®ÈκÎÒ»¸öÖ»°üº¬Á½¸öÊôÐԵĹØϵģʽһ¶¨ ÊôÓÚ3NF B£®ÈκÎÒ»¸öÖ»°üº¬Á½¸öÊôÐԵĹØϵģʽһ¶¨ ÊôÓÚBCNF C£®ÈκÎÒ»¸öÖ»°üº¬Á½¸öÊôÐԵĹØϵģʽһ¶¨ ÊôÓÚ2NF D£®ÈκÎÒ»¸öÖ»°üº¬Èý¸öÊôÐԵĹØϵģʽһ¶¨ ÊôÓÚ3NF

D

12£®ÓйØϵģʽ£º½èÊ飨ÊéºÅ£¬ÊéÃû£¬¿â´æÁ¿£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£¬»¹ÊéÈÕÆÚ)£¬ÉèÒ»¸ö¶ÁÕß¿ÉÒÔ¶à´Î½èÔÄͬһ±¾Ê飬µ«¶ÔÒ»ÖÖÊ飨ÓÃÊéºÅΨһ±êʶ£©²»ÄÜͬʱ½è¶à±¾¡£¸Ã¹ØϵģʽµÄÖ÷ÂëÊÇ A

A£®£¨ÊéºÅ£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£© B£®£¨ÊéºÅ£¬¶ÁÕߺţ© B£® £¨ÊéºÅ£© D£®£¨¶ÁÕߺţ©

¶þ£®Ìî¿ÕÌâ

1£®ÔÚ¹ØϵģʽRÖУ¬ÈôÊôÐÔAÖ»³öÏÖÔÚº¯ÊýÒÀÀµµÄÓÒ²¿£¬ÔòAÊÇ_____ÀàÊôÐÔ¡£ R 2£®Èô¹ØϵģʽR¡Ê2NF£¬ÔòRÖÐÒ»¶¨²»´æÔÚ·ÇÖ÷ÊôÐÔ¶ÔÖ÷ÂëµÄ_____º¯ÊýÒÀÀµ¡£ ²¿·Ö 3£®Èô¹ØϵģʽR¡Ê3NF£¬ÔòRÖÐÒ»¶¨²»´æÔÚ·ÇÖ÷ÊôÐÔ¶ÔÖ÷ÂëµÄ_____º¯ÊýÒÀÀµ¡£ ´«µÝ

4£®ÉèÓйØϵģʽX(S, SN, D)ºÍY(D, DN, M)£¬XµÄÖ÷ÂëÊÇS£¬YµÄÖ÷ÂëÊÇD£¬ÔòDÔÚ¹ØϵģʽXÖб»³ÆΪ_____¡£ ÍâÂë

5£®ÉèÓйØϵģʽR(U, F)£¬U={X, Y, Z, W}£¬F={XY¡úZ, W¡úX}£¬Ôò(ZW)+ = _____£¬RµÄºòÑ¡ÂëΪ_____£¬¸Ã¹ØϵģʽÊôÓÚ_____·¶Ê½¡£XZW YW µÚÒ»

6£®ÔÚ¹ØϵģʽRÖУ¬ÈôÊôÐÔA²»ÔÚÈκκ¯ÊýÒÀÀµÖгöÏÖ£¬ÔòAÊÇ_____ÀàÊôÐÔ¡£ N

7£®ÔÚ¹ØϵģʽRÖУ¬ÈôÓÐX¡úY£¬ÇÒZ?Y£¬ÔòX¡úZÔÚRÉÏÒ²³ÉÁ¢£¬¸ÃÍÆÀí¹æÔòΪArmstrong¹«ÀíϵͳÖеÄ_____¡£·Ö½â¹æÔò

8£®¸ù¾ÝArmstrong¹«ÀíϵͳÖеÄ×Ô·´¹æÔò£¬¶Ô¹ØϵģʽRÖеÄÊôÐÔ¼¯X£¬ÈôY?X£¬ÔòÒ»¶¨ÓÐ_____¡£X¡úY

9£®¹ØϵÊý¾Ý¿âÖеĹØϵ±íÖÁÉÙ¶¼Âú×ã_____·¶Ê½ÒªÇó¡£ µÚÒ»

10£®¹Øϵ¹æ·¶»¯µÄ¹ý³ÌÊǽ«¹Øϵģʽ´ÓµÍ·¶Ê½¹æ·¶»¯µ½¸ß·¶Ê½µÄ¹ý³Ì£¬Õâ¸ö¹ý³Ìʵ¼ÊÉÏÊÇͨ¹ý_____ʵÏֵġ£ ģʽ·Ö½â

11£® Èô¹ØϵģʽRµÄÖ÷ÂëÖ»°üº¬Ò»¸öÊôÐÔ£¬ÔòRÖÁÉÙÊôÓÚµÚ_____·¶Ê½¡£ ¶þ

12£®Èô¹ØϵģʽRÖÐËùÓеķÇÖ÷ÊôÐÔ¶¼ÍêÈ«º¯ÊýÒÀÀµÓÚÖ÷Â룬ÔòRÖÁÉÙÊôÓÚµÚ_____·¶Ê½¡£ ¶þ

Èý£®¼ò´ðÌâ

1£® ¹Øϵ¹æ·¶»¯ÖеIJÙ×÷Òì³£ÓÐÄÄЩ£¿ËüÊÇÓÉʲôÒýÆðµÄ£¿½â¾öµÄ°ì·¨ÊÇʲô£¿ 2£®µÚÒ»·¶Ê½¡¢µÚ¶þ·¶Ê½ºÍµÚÈý·¶Ê½¹ØϵģʽµÄ¶¨Òå·Ö±ðÊÇʲô£¿ 3£®Ê²Ã´ÊDz¿·Öº¯ÊýÒÀÀµ£¿Ê²Ã´ÊÇ´«µÝº¯ÊýÒÀÀµ£¿Çë¾ÙÀý˵Ã÷¡£ 4£®µÚÈý·¶Ê½µÄ¹ØϵģʽÊÇ·ñÒ»¶¨²»°üº¬²¿·Öº¯ÊýÒÀÀµ¹Øϵ£¿ 5£®ÉèÓйØϵģʽR(A, B, C, D)£¬F={D¡úA, D¡úB}

+

£¨1£©ÇóD¡£

£¨2£©ÇóRµÄÈ«²¿ºòÑ¡Âë¡£

+

´ð£º£¨1£©D=DAB

£¨2£©ÒòΪDÊÇLÀàÊôÐÔ£¬Òò´ËDÒ»¶¨³öÏÖÔÚRµÄÈκκòÑ¡ÂëÖУ» ÒòΪCÊÇNÀàÊôÐÔ£¬Òò´ËDÒ»¶¨³öÏÖÔÚRµÄÈκκòÑ¡ÂëÖУ»

23

¡¤24¡¤ +

(CD) = CDAB = RµÄÈ«²¿ÊôÐÔ£¬Òò´ËRµÄΨһºòÑ¡ÂëÊÇCD¡£

6.ÉèÓйØϵģʽR(W, X, Y, Z)£¬F={X¡úZ, WX¡úY}£¬¸Ã¹ØϵģʽÊôÓÚµÚ¼¸·¶Ê½£¬Çë˵Ã÷ÀíÓÉ¡£

½â£ºRÊÇ1NF£¬RµÄºòÑ¡ÂëΪWX,Òò´ËY,ZÊÇ·ÇÖ÷ÊôÐÔ£¬ÓÖÓÉÓÚ´æÔÚX¡úZ£¬Òò´ËFÖдæÔÚ·ÇÖ÷ÊôÐÔ¶Ô

Ö÷ÂëµÄ²¿·Öº¯ÊýÒÀÀµ£¬Òò´ËR²»ÊÇ2NF¡£

7£®ÉèÓйØϵģʽR(A, B, C, D)£¬F = {A¡úC, C¡úA, B¡úAC, D¡úAC} £¨1£©ÇóB+£¬(AD)+¡£

£¨2£©ÇóRµÄÈ«²¿ºòÑ¡Â룬ÅжÏRÊôÓÚµÚ¼¸·¶Ê½¡£ £¨3£©ÇóFµÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯Fmin¡£ ´ð£º

£¨1£© B+ = BAC

(AD)+ = ADC

£¨2£© ÓÉÓÚB¡¢DÊÇLÀàÊôÐÔ£¬Òò´ËB¡¢D»áÔÚÈκκòÑ¡ÂëÖУ»

(BD)+ = BDAC = RµÄÈ«²¿ÊôÐÔ£¬Òò´ËRµÄºòÑ¡ÂëÊÇBD¡£ RÊǵÚ1·¶Ê½£¬ÒòΪ´æÔÚ²¿·Öº¯ÊýÒÀÀµ£º

£¨3£©¢Ù ½«ËùÓк¯ÊýÒÀÀµµÄÓұ߸ÄΪµ¥¸öÊôÐÔ£¬µÃµ½£ºB¡úAC, D¡úAC

F1 = { A¡úC, C¡úA, B¡úA, B¡úC, D¡úA, D¡úC }

¢Ú È¥µôº¯ÊýÒÀÀµ×󲿵ĶàÓàÊôÐÔ£º¸Ã¹ØϵģʽµÄÈ«²¿º¯ÊýÒÀÀµ¼¯×󲿾ùΪһ¸öÊôÐÔ£¬Òò´Ë

²»´æÔÚ×ó²¿ÓжàÓàÊôÐÔµÄÇé¿ö¡£ ¢Û È¥µô¶àÓàµÄº¯ÊýÒÀÀµ¡£

È¥µôA¡úC£¬µÃµ½F2 = { C¡úA, B¡úA, B¡úC, D¡úA, D¡úC }

A+F2 = AC£¬°üº¬C£¬Òò´ËΪ¶àÓຯÊýÒÀÀµ£¬Ó¦È¥µô£»

È¥µôC¡úA£¬µÃµ½F3 = { B¡úA, B¡úC, D¡úA, D¡úC }

C+F3 = C£¬²»°üº¬A£¬Òò´ËC¡úA²»ÊǶàÓຯÊýÒÀÀµ£»

È¥µôB¡úA£¬µÃµ½F4 = { C¡úA, B¡úC, D¡úA, D¡úC }

B+F4 = BCA£¬°üº¬A£¬Òò´ËB¡úAÊǶàÓຯÊýÒÀÀµ£¬Ó¦È¥µô£»

È¥µôB¡úC£¬µÃµ½F5 = { C¡úA, D¡úA, D¡úC }

B+F5 = B£¬²»°üº¬C£¬Òò´ËB¡úC²»ÊǶàÓຯÊýÒÀÀµ£»

È¥µôD¡úA£¬µÃµ½F6 = { C¡úA, B¡úC, D¡úC }

D+F5 = DCA£¬²»°üº¬A£¬Òò´ËD¡úAÊǶàÓຯÊýÒÀÀµ£¬Ó¦È¥µô£»

È¥µôD¡úC£¬µÃµ½F7 = { C¡úA, B¡úC }

D+F5 = D£¬²»°üº¬C£¬Òò´ËD¡úC²»ÊǶàÓຯÊýÒÀÀµ¡£ ×îÖÕFmin =£ûC¡úA, B¡úC, D¡úC£ý ËÄ£® Éè¼ÆÌâ

1£® ÉèÓйØϵģʽ£ºÑ§ÉúÐ޿Σ¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬ÐԱ𣬿γ̺ţ¬¿Î³ÌÃû£¬Ñ§·Ö£¬³É¼¨£©¡£ÉèÒ»

¸öѧÉú¿ÉÒÔÑ¡¶àÃſγ̣¬Ò»Ãſγ̿ÉÒÔ±»¶àÃûѧÉúÑ¡¡£Ò»¸öѧÉúÓÐΨһµÄËùÔÚϵ£¬Ã¿ÃſγÌÓÐΨһµÄ¿Î³ÌÃûºÍѧ·Ö¡£Ã¿¸öѧÉú¶ÔÿÃſγÌÓÐΨһµÄ³É¼¨¡£ £¨1£© ÇëÖ¸³ö´Ë¹ØϵģʽµÄºòÑ¡Âë¡£

£¨2£© д³ö¸Ã¹ØϵģʽµÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯¡£

£¨3£© ¸Ã¹ØϵģʽÊôÓÚµÚ¼¸·¶Ê½£¿²¢¼òµ¥ËµÃ÷ÀíÓÉ¡£

£¨4£© Èô²»ÊǵÚÈý·¶Ê½µÄ£¬Ç뽫Æä¹æ·¶»¯ÎªµÚÈý·¶Ê½¹Øϵģʽ£¬²¢Ö¸³ö·Ö½âºóµÄÿ¸ö¹Øϵģʽ

µÄÖ÷ÂëºÍÍâÂë¡£ ´ð£º£¨1£©ºòÑ¡Â룺£¨Ñ§ºÅ£¬¿Î³ÌºÅ£©

24

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ì滻Ϊ@)