ACC: ??????? ??????? ?????

?????? ????????? ?????? ?????????
???? ???????: 100139 - ??? ???????? ???? ????? ????? ??? ???????.
???????: ????? ????? ????? ???????? ??? ????? ????????? ???????? ??????.

????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ?????? ??????? ????????? ??????? ????? ????????. ??? ?????? ????????? ??? ?????? ??? ?????? ????? ????? ???????? ?????????.

??????: ???? Microsoft ????? ?????? ?????? ??????? ??????? ????? ????????. ???? ??? ?????? ?????? ????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/servicedesks/webcasts/wc060600/wc060600.asp?fr=1
??????: ?????? ??? ????????? ?? Microsoft Access 2000 ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
209534ACC2000: ??????? ??????? ?????

??????? ????

??? ???????

??????? ?? ????? ????? ???????? ?? ????? ??????. ????? ??? ????? ??????? ? ????? ?????? ??? ??? ??????? ????? ?????? ????? ?? ?????? ???????? ???? ????? ???????? ???? ????? ?? ???? ????? ????? ?????: ??????? ? ??????? ??? ???????.

???????? ??????? ???? ????? ????? ?????? ????? ???????. ??? ??? ??? ????? ???????? ????? ?? ???? ???? ?? ???? ? ??? ????? ???????? ???? ??????? ?????? ?? ???? ???????. ????? ????? ??????? ???? ????? ?????? ??? ?? ????? ???????? ?? ???? "???????" ? "nowhere ??? ?? ????? ????????.

?? ?? "??? ??????? ?????" ? ????? ??????? ???????? ????? ?? ???? "???????" ????? ?????? ????? ??? ?? ?? ???? ?? ???? ???????? ????? ??? ??? ??????. ???? ?????? ????? ??? ? ?? ??? ?????? ?? ???????? ??? ?? ??? ??? ??? ???? ????????. ?????? ??? ??????? ???? ????? ???????? ???? ??????; ?? ???? ???? ????? ?? ???????? ???????? ?? ???????.

???? ??? ????? ??????? ????? ????????. ?? ????? ???? "form ????". ??? ??? ??? ?????? ??????? ?????? ????? ???????? ???? ?? ???? ?? "????? ?????? form." ??? ??? ??? ?????? ????? ??????? ?????? ????? ????? ???????? ?? "?????? ?????? form." ??? ????? ?? ?? ??????? ???? ?? ??????? ???????? ????? ??????? ?????? ?????? ??????? ?????? ?????? ?? ??? ???? ?????????.

??? ?? ????? ?? ?????? ?? ??????? ????? ? ??????? ? ?????? ?????????? ?? ????? ???? ??????? ??????. ????? ???? ????? ??????? ????? ?????? ?????? ??? ??????? ??? cumbersome. ??? ???? ????? ???? ??????? ??????? ?????? ?? ??????? ???? ?? ?? ??????? ????? ?? anticipates ??? ?????? ?? ???? ??, ??? ???????? ??????? ? ?????? ??? ???????.

??????: ??????? ???? ????? ???????.

????? ???? ?????

  • ????? ??????? ????? ?? ??????? ???????.
  • ????? ???? ????? ??? ?????? ?? ???????? ????????.
  • ????? ?? ?????? ?? ???????? ???????? ?? ????? ?????.
?? ?????? ???? ?????? ?? ???? ???? ?????? ???????? ?????????. ??? ???? ??????? ????? ???? ????? ?? ???? ?? ????? ???????? ??? ????? ?? ????? ??? ???? ?????? ??? 1 ? 2 ??? ??????.

???? ???? ???? ??? ????? ???? ???? ? ????? ??? "??? ???????; ????? ????????? ???????? ????? ? ?? ????? ??? ????? ?? ????? ????? ??????. ????? ?? ???? ?? ???? ??????? ?????? ?? ???? ????? ???? ????? ?? ??????? ???????? ??? ???????? ?? ????? ??? ???? ?? ?????? ???? ?? ????? ??? ????.

??????? ?????? ????

  • ????? ????? ?????? ?? ??????? ?? ????? ???? ????? ??? ????? ??????.
  • ??? ??? ??????? ?? ????? ?????.
??? ??? ???? ??????? ??? ?? ??? ??? ??? ????? ????? ?????? (????? ????? ??? ??? ?????). ??? ???? ??????? ??? ?????? ????? ??? ??????? ?? ???? ??????. ????? ??????? ?????? ???? ??????? ???? ??? ?????? ??????? ????? ????? ? ?????? ? ?????? ????????? ? ?????????. ????? ?? ????? ????? ?????? ?????? ????? ?? ?? ?? ??? ??????? ? ???????? ?? ???? ???? ??? ?? ???? ??????? ?? ?? ???? ?????? ?????.

????? ???? ??????

  • ????? ?????? ???? ?? ????? ??? ???????.
?? ????? ??? ?? ??? ????? ???? ???? ????? ?? ????? ??? ????? ?? ??????. ???? ???? ?? ??? ?? ????? ??????? ?????? ???? ??? ???? ?? ??? ???? ?? ??????? ?? ????? ??? ??? ?????? ?? ???? ?????.

??? ???? ??????? ?? ???? "??????? ??????" ????? ???? ????? ???? ???? ?? ???? ?????. ???? ????? ??? ????? ????? universities ????????? ????????. ?? ???? ????? ????????? ?? ???? ???????? ???? ????? ??? universities ??????? ?? ?? ???????? ??????. ????? ???? ????? Universities ????? ??? ???? ???????? ?? ????? ????????? ?????? ?????.

?????????: Adhering ??? ??????? ?????? ?????? ????? ?????? ??????? ??? ????? ??????. ??? ??? ???? ???? ??????? ???? ?????? ?? ???? ???????? interfield ???????? ??? ???? ????? ????? ?????? ?? ?? ????? ???? ??????? ??????? ???????? ???? ??????? ?? ???? ???? ?? ???? ????? ?? ????? ??????. ?? ????? ? ??????? ????? ??????; ??? ???? ?? ?????? ?? ??????? ???? ?????? ?????? ?? ?????? capacities ??????? ???????? ????????.

?? ???? ???? feasible ?????? ??????? ?????? ?????? ??? ??? ???????? ???? ???? ???? ?????. ??? ??? ???? ??? ?????? ??????? ????? ??????? ????? ?? ??????? ???????? ??????? ?? ???? ???????? ?????? ??? ????? ??.

????? ???? ???????

????? ?????? ?????? ???? Boyce Codd ???? ????? (BCNF) ? ?????? ?????? ?????? ?????? ???? ????? ????? ?? ????? ??????. ?????? ??? ??????? ?? ???? ?? ????? ????? ???????? ??? ?? ?????? ???? ??? ?? ?? ???? ??? ?????? ???????.
               **********************************
                 Examples of Normalized Tables
               **********************************

 Normalization Examples:

 Unnormalized table:

    Student#   Advisor   Adv-Room  Class1   Class2   Class3
    -------------------------------------------------------
    1022       Jones      412      101-07   143-01   159-02
    4123       Smith      216      201-01   211-02   214-01
				
  1. ????? ???? ?????: NO REPEATING ???????

    ??? ?? ????? ??????? ??? ?????. ??? ?????? ???? ????? ??? ??? ???? ??? ?? ??? ??? ??? ?????? ?? ???? ?????. ???? Class1 ? Class2 ? & Class3 ?? ????? ????? ?? indications ????? ?? ???????.

    ?????? ????? ???????? ????? ????? ?????? ???? ??? ?? ???????. ???? ????? ???? ????? ?? ??? ???????: ????? ????? ???? ????? ?? ??? ?? ??????? "?" ?? ???? ???? ?? ??? ??????. ????? ?? ???? ????? ???? ??? ?? ??????? ????? ?????? ?? ???? ????? ?????? ????? (??? #) ? ??? ?? ???? ?????:
           Student#   Advisor   Adv-Room    Class#
           ---------------------------------------
           1022      Jones      412       101-07
           1022      Jones      412       143-01
           1022      Jones      412       159-02
           4123      Smith      216       201-01
           4123      Smith      216       211-02
           4123      Smith      216       214-01
    					
  2. ????? ???? ??????: ?? ?????? ???????? ???????

    ???? ?????? ??? # ????? ??? ???? # ???? ?? ?????? ?????. ??? # ??? functionally ????? ??? ?????? # (??????? ???????) ? ???? ???? ??? ??????? ??? ??????? ?????? ??????.

    ??? ?????? ??????? ??????? ?????? ??????:
        Students:   Student#    Advisor   Adv-Room
                    ------------------------------
                    1022        Jones       412
                    4123        Smith       216
    
        Registration:   Student#    Class#
                        ------------------
                        1022        101-07
                        1022        143-01
                        1022        159-02
                        4123        201-01
                        4123        211-02
                        4123        214-01
    					
  3. ????? ???? ??????: ?????? ???????? ??? ??????? ?? ?????

    ?? ?????? ?????? ???? Adv (??? ???? ????? ????????) functionally ????? ??? ????? ????. ???? ??? ??? ????? ?? ???? ?????? ??? ???? ??? ??? ?? ???? ?????:
        Students:   Student#    Advisor
                    -------------------
                    1022        Jones
                    4123        Smith
    
        Faculty:    Name    Room    Dept
                    --------------------
                    Jones   412     42
                    Smith   216     42
    					

?????

?????? ??? ??????? ?????? ??? ????? ????? ?????? "? ???? ??? ??? ??????? ????? ?????? ??" ????? ??????? ?? Microsoft:
234208ACC2000: "??? ????? ????? ???????? ?????????" ????? ???????? ?? ???? ???????
"FoxPro 2 A ?????? ????" Hamilton ?????? Ahlo Jr. ???? al. ? ??????? 220 ??? 225 ????? M & T 1991

"???????? Access ????? Windows ?" Roger Jennings ??????? 799-800 Que Corporation? ????

???????

???? ???????: 100139 - ????? ??? ??????: 28/?? ?????/1427 - ??????: 2.1
????? ???
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
????? ??????: 
kbmt kbinfo kbusage KB100139 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????100139
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com