²ÍÒû¹ÜÀíϵͳµÄÊý¾Ý¿âÉè¼Æ ÏÂÔØ±¾ÎÄ

ÄÚÈÝ·¢²¼¸üÐÂʱ¼ä : 2025/9/8 10:33:46ÐÇÆÚÒ» ÏÂÃæÊÇÎÄÕµÄÈ«²¿ÄÚÈÝÇëÈÏÕæÔĶÁ¡£

¹ã ¶« ÉÌ Ñ§ Ôº ´ð Ìâ Ö½£¨¸ñʽ¶þ£© ----------------------- ¿Î³Ì Êý¾Ý¿âϵͳÉè¼Æ 2010 £­2011 ѧÄêµÚ 2 ѧÆÚ ³É¼¨ ÆÀÔÄÈË -- -- - -- - -- - - --- - Ïß- - - -- - -- - -- - -- - -- - -- - -- ---ºÅ ---ѧ - -- - -- - -- - -- - ¶© -- - -- - -- - - -- ---Ãû ---ÐÕ - -- - -- - -- - -- - -- - -- - -- - -- ×° - -- - -- - ---¼¶ ---°à --- --- --- --- --- --- -- - --- --- --- ---ÇëѡȡÊý¾Ý¿âϵͳÉè¼Æ¿Î³ÌÉè¼ÆÏà¹ØÖ÷Ì⣬ÔÚij¸öRDBMSÈí¼þ»ù´¡ÉÏÀûÓúÏÊʵÄÓ¦ÓÃϵͳ¿ª·¢¹¤¾ßΪij¸ö²¿ÃÅ»òÕßµ¥Î»¿ª·¢Ò»¸öÊý¾Ý¿âϵͳ¡£ÒªÇó¸ø³öÊý¾Ý¿âÉè¼Æ¸ÅÄîÉè¼Æ¡¢Âß¼­Éè¼Æ¡¢ÎïÀíÉè¼Æ¡¢¿ª·¢Óë±àÂë¡¢²âÊÔ¸÷¸ö½×¶ÎµÄÏêϸÉè¼Æ£ºÐ´³öϵͳµÄÖ÷Òª¹¦ÄܺÍʹÓÃ˵Ã÷£»Ìá½»ÔËÐеÄϵͳ¡£Íê³ÉµÄÖ÷Òª¹¦ÄܰüÀ¨Â¼Èë¡¢Ð޸ġ¢²éѯ¡¢Êä³öµÄÐÅÏ¢¹ÜÀí¹¦ÄÜ¡£»ù±¾ÒªÇ󣺣¨1£©Íê³ÉÎÊÌâ³ÂÊöÖÐËùÌáµ½µÄËùÓÐÐèÇó¹¦ÄÜ£»£¨2£©ÒªÇó׫д²»ÉÙÓÚ3000¸öÎÄ×ÖµÄÎĵµ£»£¨3£©ÎĵµÖÐÖÁÉÙÒª°üÀ¨£ºERÄ£ÐÍͼ¡¢ÏµÍ³¹¦ÄÜͼ¡¢Êý¾Ý×ֵ䡢±í¹ØÏµµÄÏêϸ˵Ã÷¡££¨4£©Óû§ÊֲᣬÃèÊöÈí¼þϵͳËù¾ßÓеŦÄܼ°»ù±¾µÄʹÓ÷½·¨¡£ Îĵµ¸ñʽ²Î¿¼±ÏÒµÂÛÎÄÒªÇó£¬Õ½ڰüÀ¨£º£¨1£©¸ÅÊö£º°üÀ¨ÏîÄ¿±³¾°¡¢±àдĿµÄ¡¢Èí¼þ¶¨Òå¡¢¿ª·¢»·¾³µÈÄÚÈÝ¡££¨2£©ÐèÇó·ÖÎö£ºÎÊÌâ³ÂÊö¡¢ÐèÍê³ÉµÄ¹¦ÄÜ£¬»­³öERÄ£ÐÍͼ£»£¨3£©Êý¾Ý¿âÂß¼­Éè¼Æ£º°ÑERÄ£ÐÍͼת»»Îª¹ØÏµ±í¡£ÃèÊöÿһ¸ö»ù±¾±í¹ØÏµ¡£ÒªÇóËùÓйØÏµ´ïµ½BCNF·¶Ê½¡£¶¨ÒåÊÓͼ¡¢¶¨ÒåË÷Òý¡¢Ö÷¹Ø¼ü×Ö¡¢¶¨ÒåȨÏÞ¡££¨4£©Êý¾Ý¿âÎïÀíÉè¼Æ£º¶¨ÒåÊý¾ÝÎïÀíÎļþ¼°¹ÜÀí¡££¨5£©¿ª·¢Óë±àÂ룺±àд³ÌÐò¡¢µ÷ÊÔ²¢½øÐвâÊÔ¡££¨6£©½áÊøÓд³öÍê³É±¾¿Î³ÌÉè¼ÆµÄÐĵã¬Áì»áÊý¾Ý¿âÀíÂÛÓëÈí¼þ¿ª·¢Êµ¼ùµÄ¹ØÏµ¡£ÓÐÄÄЩÊÕ»ñ¡£Èí¼þ»¹ÐèÒªÄÄЩ¸Ä½ø¡££¨7£©²Î¿¼ÎÄÏס£ ÑϽûØâÇÔ¡¢³­Ï®µÈ×÷±×ÐÐΪ£¡È«Îij­Ï®£¬»òδ°´Ê±½»¾í£¬»òÓë¿Î³ÌÄÚÈݺÁ²»Ïà¹Ø°´²»¼°¸ñ´¦Àí¡£ ÐÅÏ¢¹ÜÀíѧ¿Î³ÌÂÛÎÄÆÀ·Ö±ê×¼ ·ÖÖµ µÃ·Ö Íê³ÉÊý¾Ý¿âϵͳÉè¼Æ¹¤×÷ÈÎÎñ 20·Ö ÂÛÎÄÎÄÕ½ṹ°²ÅźÏÀí£¬Ð´×÷¹æ·¶£¬Òý×¢ÕýÈ·¡£ 10·Ö ÂÛÎÄÂß¼­ÌõÀíÇåÎú£¬ÂÛÖ¤ÓÐÁ¦¡£ÀíÂÛ²ûÊöÈ«Ãæ£¬Äܹ»ÁªÏµÊµ¼Ê·ÖÎöÎÊÌ⣬10·Ö ½â¾öÎÊÌâ¡£ ÐèÇó·ÖÎö£ºÎÊÌâ³ÂÊöÇå³þ¡¢ÐèÍê³ÉµÄ¹¦ÄÜÃèд׼ȷ£¬ERÄ£ÐÍͼÕýÈ·¡£ 20·Ö Êý¾Ý¿âÂß¼­Éè¼Æ£º°ÑERÄ£ÐÍͼת»»Îª¹ØÏµ±í¡£ÃèÊöÿһ¸ö»ù±¾±í¹ØÏµ¡£20·Ö ÒªÇóËùÓйØÏµ´ïµ½BCNF·¶Ê½¡£¶¨ÒåÊÓͼ¡¢Ë÷Òý¡¢Ö÷¹Ø¼ü×Ö¡¢È¨ÏÞ¡£ Êý¾Ý¿âÎïÀíÉè¼Æ£º¶¨ÒåÊý¾ÝÎïÀíÎļþ¼°¹ÜÀí¡£ 10·Ö ¿ª·¢Óë±àÂ룺±àд³ÌÐò¡¢µ÷ÊÔ²¢½øÐвâÊÔ¡£ 10·Ö ³É¼¨ £½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ ²ÍÒû¹ÜÀíϵͳµÄÊý¾Ý¿âÉè¼Æ 1

ÄÚÈÝÕªÒª Êý¾Ý¿âÉè¼ÆÔÚÈç½ñÐÅÏ¢»¯Ê±´úÊÇÒ»¸öÖØÒªµÄ¹ÜÀíÏîÄ¿¡£±¾²ÍÒû¹ÜÀíϵͳµÄÊý¾Ý¿âÉè¼ÆÖ÷ÒªÊÇÕë¶ÔÖÐСÐ͵IJÍÒûµê£¬Í¨¹ý¶Ô²ÍÒûµêµÄÒµÎñ¹ý³Ì·ÖÎö£¬½øÐÐÒµÎñÁ÷³Ìͼ¡¢Êý¾ÝÁ÷³Ìͼ¡¢E-Rͼ¼°Æä¹æ·¶»¯£¬½ø¶øÊý¾Ý¿âÂß¼­Éè¼Æ¡¢ÎïÀíÉè¼ÆµÈ·½ÃæµÄÉè¼Æ£¬´´½¨Ò»¸ö·½±ãÒ×Óᢼò½àÓѺõÄÊý¾Ý¿âϵͳ¡£Í¨¹ýÊý¾Ý¿â¶Ô¸÷·½ÃæÐÅÏ¢½øÐйÜÀíÄÜÌá¸ß²ÎÓë¹ÜÀíµÄЧÂÊ£¬ÔöÇ¿ÆóÒµµÄ¾ºÕùÁ¦£¬Í¬Ê±Ò²ÊÇÆóÒµµÄ¿ÆÑ§»¯¡¢Õý¹æ»¯¹ÜÀíµÄÒªÇó¡£ ¹Ø¼ü´Ê£º Êý¾Ý¿âÉè¼Æ E-Rͼ ¹æ·¶»¯ ²ÍÒû¹ÜÀí Abstract Database design in information era now is an important management project. This restaurant management system database design is mainly aimed at small and medium of restaurants. Through the analysis of the business process of restaurants, conduct business flow chart, data flow chart, E-R chart and standardization, and database logical design, physical design, and other aspects of the design, to create a convenient and easy to use, simple friendly database system. Through the database to manage the information can enhance the efficiency of restaurant management, enhance the competitiveness of the enterprises, which is also the requirements of scientific enterprise, standardization management . Key words£º Database design E-R chart standardization catering management 2

1 ¸ÅÊö 1.1 ÏîÄ¿±³¾° ²ÍÒûÒµÊÇÖ¸ÒÔÉÌÒµÓ®ÀûΪĿµÄµÄ²ÍÒû·þÎñ»ú¹¹¡£Ëæ×ž­¼ÃµÄ·¢Õ¹£¬²ÍÒûÒµÒѳÊÏÖ³ö¸ßËÙ·¢Õ¹µÄ״̬¡£µ«ÊÇ£¬ÔÚ¿ìËÙ·¢Õ¹µÄͬʱ£¬²ÍÒûÒµÔÚÈÕ³£¾­Óª¹ÜÀíÖдó¶¼ÊÇÒÔÈËΪÖ÷ÌåµÄ£¬ÐèÒªºÜ¶àµÄÈËÁ¦¡¢ÎïÁ¦¡¢²ÆÁ¦£¬ÇÒЧÂʲ»ÊǺܸߣ¬ÔÚϵͳÔËӪʱҲ¿ÉÄܲúÉúÈËΪµÄʧÎó¡£´«Í³µÄ²ÍÒû¹ÜÀí¹¤×÷¼È·±ËöÒ²²»ÀûÓÚ·ÖÎöÆóÒµµÄ¾­Óª×´¿ö£¬ÔÚÌṩ¾ö²ßÐÅÏ¢·½ÃæÒ²ÄÑÒÔÊÊÓ¦ÏÖ´ú»¯¾­Óª¹ÜÀíµÄÒªÇó£¬Òò´ËÖÆÔ¼ÁËÕû¸ö²ÍÒûÒµµÄ¹æÄ£»¯·¢Õ¹ºÍÕûÌå·þÎñˮƽµÄÌáÉý¡£ 1.2 ±àдĿµÄ ÔÚ²ÍÒû¹ÜÀíÖÐÒýÈëÊý¾Ý¿âÕâÒ»ÐÅÏ¢¹ÜÀí¼¼Êõ£¬¾ßÓÐÈ˹¤¹ÜÀíËùÎÞ·¨±ÈÄâµÄÓŵ㡣ÀýÈçͳ¼Æ½áÕË¿ìËÙ¡¢°²È«±£ÃÜÐԺᢿɿ¿ÐԸߡ¢´æ´¢Á¿´ó¡¢ÊÙÃü³¤¡¢³É±¾µÍµÈ¡£Í¨¹ý¶Ô²ÍÒûµê¹ÜÀíÐÅÏ¢·½Ãæ½øÐÐÊý¾Ý¿â½¨Á¢£¬Äܹ»¼«´óµØÌá¸ß²ÍÒû¹ÜÀíµÄЧÂÊ£¬ÔöÇ¿ÆóÒµµÄ¾ºÕùÁ¦£¬Í¬Ê±Ò²ÊÇÆóÒµµÄ¿ÆÑ§»¯¡¢Õý¹æ»¯¹ÜÀí£¬ÓëÊÀ½ç½Ó¹ìµÄÖØÒªÌõ¼þ[1]¡£ 1.3 Èí¼þ¶¨Òå ÔÚ±¾Êý¾Ý¿âµÄ¿ª·¢ÖУ¬Ö÷񻃾¼°µÄÈí¼þÈçÏ£º Microsoft office visio 2003 Sybase powerdesigner15.1 Microsoft office word 2003 Microsoft SQL Sever 2000 1.4 ¿ª·¢»·¾³ ²Ù×÷ϵͳ£ºMicrosoft Windows XP Ó²¼þ×é³É£ºGenuine Intel(R) CPU T2300 @ 1.66 GHz 1.66 GHz 0.99 GBµÄÄÚ´æ 3