Современные концепции управления предприятием - Юлия Орлова

Скачать книгу

убедитесь в том, что каждая из частей ключа соответствует правилам.

      Рис. 1.3.7. Пример IDEF1X диаграммы

      Для наглядного представления о том, как целесообразно выбирать первичные ключи, приведем следующий пример – выберем первичный ключ для знакомой нам сущности "СОТРУДНИК":

      • Атрибут "ID сотрудника" является потенциальным ключом, так как он уникален для всех экземпляров сущности СОТРУДНИК.

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAIBAQIBAQICAgICAgICAwUDAwMDAwYEBAMFBwYHBwcGBwcICQsJCAgKCAcHCg0KCgsMDAwMBwkODw0MDgsMDAz/2wBDAQICAgMDAwYDAwYMCAcIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAFiAj4DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9/KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAPz7+HPjj9qj9rn9on48Wfgv4y+CvAvhf4a+OJvDGnWF34Jj1KZokt4ZQ7SmVSTmUjkdq77/hmv9tD/AKOa+Hv/AIbOL/5Ipv8AwSu/5Lv+17/2WG7/APSG0r7IoA+Of+Ga/wBtD/o5r4e/+Gzi/wDkij/hmv8AbQ/6Oa+Hv/hs4v8A5Ir6H+NX7VPw3/Zxto5vHvjjwz4QikxsbVb+O2DZ6Y3EVt+B/jH4V+Jnh/8Atbw/4g0nWdNNut39ptLlZYvKYblfcDjaRzmgD5d/4Zr/AG0P+jmvh7/4bOL/AOSKP+Ga/wBtD/o5r4e/+Gzi/wDkivavAX7fHwV+KXxGfwh4c+KXgfW/FEbyRtpVnq0Ut0rRna48sHOVPB9K9coA+Of+Ga/20P8Ao5r4e/8Ahs4v/kij/hmv9tD/AKOa+Hv/AIbOL/5Ir7GooA+Of+Ga/wBtD/o5r4e/+Gzi/wDkitz/AIJb/HX4mfFm1+MXh/4qeItH8Va/8M/Hl14Xh1PTtKXTYrqGKCCQMYlZsHMh7mvqqvjz/gld/wAlg/a0/wCyyah/6SWtAH2HRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB8b/APBK7/ku/wC17/2WG7/9IbSvrzxDqTaP4fvrxV3Na28kwHqVUn+lfIf/AASuP/F+P2vv+ywXf/pDaV9jTwLcwPHIu6ORSrA9weDQB+cX/BJT4Z6L+2f45+Mfxh+Imnw+Kdck8Z6j4bs7XVEF1Z2NlayAwokD5jDDzWBYLuPGTwK7H9v/AMN+Cf8AgnH8NvF3xK0e11aOT4i6jonhmTSLJm+zDdO0KRxoGCxK5lIJQDAx1xT5f2F/jd+xz8fPFHin9nXUvBereGfHV5LqWq+FvF1zNa2VjdyEs88DwI0hZyQCGOAEGB1r0v4s/sS+Iv2pf2eNS0/4iahpy+NNSa21CJLB2k0/Tby2bzIfKLgMVWTHLDOAKAPEvgf8bPG3wX+KWk6J40/Z1+FvhC+8TabJJ4P13QmNws8gVfLhv7loUeGWQsmcbyTv5OOaX/BNj/gugf2yPGvi7wr42b4S+CfGWlardaRpHh+18Syz6hfy28zwsZI3jBVS6jBGchga9K+G37Nn7Qvje/0u4+KTfDn/AIoK1K+HI9HvLmRdVnUDypbwugMeCikiPj5m9q+aP2bv+CQ37Q3w50STwvr+n/BWPR5vGNx4vfXtOuro6zvkuppxb5MQHl/viDzn5FoA9Z8G/wDBSD9qj4h+APG2oaT8Efhu2peFdYNrEJ/El2lnNZqH3SvIISVkyFwoGCCeeK7z/glh+3X8eP239B0vxd48+GHgnwn8P/EWnXFxpmoaLrdxfXJuIrprcxTRyRKqA+W5BDE4A9axf2aP2Uv2kvg/8Afi3oOrL8L7zXfE0jv4daO/uzbgbSqi4Plgr1GdoNehf8Eg/wBm74sfsg/snWHw3+KS+C5JPDU8y6Vc+H7qeb7TDLK87GbzVXaweRgAvGAO9AH1VXx5/wAErv8AksH7Wn/ZZNQ/9JLWtv8Aa0/4LGfA/wDYh+JH/CK/EjxLH4c1aSPzoUucKJ4843L7ZBH4V8//APBDT9u74eftK/Hr9pmx8H6surTa/wDEO78UWpi5U2EsNvEkpPoXRhQB+lFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUVX1bWLTQbCS6vrq3s7WEZeWaQRog9yeK+ZvHn/AAUPbxv40vPBvwZ8P3njzxFZSrBfXqxmPT9KLDIeRn2CVQMH92xNAH0P45+Imh/DTQbjU9e1S00uxtkLySzPjAHoOp/AGvmGb9tLx1+1xftpfwL8PqPDlwCreNtXR009lztPkKpEu8H++mODWz4G/YDuviTrlv4l+NmuN461eGYXNrpfI0vTG7eUhG4ED1Y8k19L6VpFroVhHa2dvDa28KhUjjXaqgUAfCP/AARH+HupfD3xz+1JYa5r154m1yx+KlzbXeqXQUS3rCztW3sFCjPOOAOlfe1fG/8AwSu/5Lv+17/2WG7/APSG0r7IoAKKKKACiiigAooooA+H/wDguH/wSU0H/gpz+zPeQW9rBb+PvD8TXGiXoX53cA/umP8AdILfiRXwN/wbVfsgfGb9nT9n/wCJmteHk0/TfHHh3xZPoGs+G9cQ7GEUcMhUNEN3mHd0L7elfuzXx3/wStGPi/8Ataf9lk1D/wBJLWgDtPhR/wAFFdG1HxLH4Z+I+i6l8M/FckhhhtNVUGO+I/jieMuoU843EHivoqw1G31W1Wa1nhuIZBlXjcMrfiK574pfBrwv8avDM2j+KNFsdY0+4Uq0U6Z6+45r5s1z9iH4l/s53kmqfAz4gTQ6fGIY08I+Ii0+jW8KNlxbpGFdZGUkAs5GQuehoA+uqK+XfhV/wUrsYPFMHhT4teGNW+Fviy4kljto9RAmtb9IzgzLLFujjRhhgJGBwfrX0xo+u2XiGxjurC8tr23kUMksEokRgeQQQcUAWqKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiivJv2jP20PA/7NOm/wDE3vpNS1aRhHDpGlRG+v5HPC5hi3SKpJ+8VwOT2NAHrDyLEjMzBVUZJJwAK8C+PP8AwUA8O/DXU28P+E9Pu/iF40njf7JpWktujd1/ge4wYozkgYcjv6GvPdO8M/HP9uCSO88QTN8Ifh7cOdul2lx5msajD/DJ9ojKmHcOsbISM4Ne/wDwF/Zd8E/s16G1l4T0W3sWmYvcXbKGurtzyXlkwCzEkkk9STQB4TpH7JfxG/a3l/tH4369Jp/hm6VJIvBekyeVBtIy0V6cuk/pldo6+tfTHw1+F3h/4PeE7bQ/DOk2ei6TaLtitrWMJGg+grfooAKKKKAPg+y/YV/am+Cfx8+LviD4S/Fj4Q6R4Z+KHiqXxR9h1/wrd313aSPDFFsMiTopGIx0Het7/hUH7e3/AEWj9nj/AMIW/wD/AJKr7SooA+Lf+FQft7f9Fo/Z4/8ACFv/AP5Ko/4VB+3t/wBFo/Z4/wDCFv8A/wCSq+0qKAPi3/hUH7e3/RaP2eP/AAhb/wD+Sq8j/bC+K37dH7IPhfwfql/8UPgHrSeL/Fun+E4o7fwXexG3kuzIFmYtdHKrsOQOTmv0ur4x/wCC2P8AySb4K/8AZZPDf87igDyv9l3x7+3V+0/4Z1PU7P4pfAHSU028azZJvBV7IXKlhuBF0P7teof8Kg/b2/6LR+zx/wCELf8A/wAlV0H/AASU/wCSU+Kv+w3L/wChyV9ZUAfFv/CoP29v+i0fs8f+ELf/APyVXoH/AATg/ZD8dfsqaH8SLz4jeKvDni3xZ8SfF0/iq9utD0+Sxs4nliijKLHI7sMeXn7x619JUUAFFFFAHN/FX4ReGfjf4MvPDvi3RdP1/RdQjMVxZ3kQkilUjBBB+tfO+s/sLeLvgAUvfgV4ym0C1t/LUeG9VLXOjrEgx5cMKFPLJHAJJAr6sooA+Y/Af/BQ9fCniS18L/F3wvqfgDxBKCEuZB9o0+5CnHmedGDHEDkHDtkA+xr6M8N+KtM8Y6ZHe6TqFjqVnIMrNazrNGfxUkVU+IPw20H4reGLjRfEmk2OtaVdrtmtbyESxSD3U8V84+J/2ANd+Dd+dY+BPi648H3Cnc2iX+670Zx/djtwyLGT65Pf1oA+qaK+W/C//BQq9+F/iS28MfGjwjqXgvVpPkj1S3Vr3S7n/po88a+XADzw7fzr6Q8IeN9H8f6NFqOh6pp+r2Mwyk9ncJPGw/3lJFAGpRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRWV4z8caR8O/Dtxq2uajaaVplmpea5uZBHHGPUk0Aatcb8aPj/AOEf2f8Aw02qeK9asdKhIPkxyyqs1039yNCQXb2HNeB+Kf20/Gv7RGof2P8AAfw7/aNm0phuvFGqAwWEC4/1ls210nIOBg47+lb3wP8A+Cd+k+Gteg8VfEfWrz4meOGQefeakm2xV85zHZ7mhjI6ZUA0Acgvxx+Mv7a9/Na/D3RZPh38P7iFCviTWYCupXBLfPGtnIFZBtxhw3VvavWf2ef2GvBfwAuZtSjhuPEHia6cyz6zq8pvLsseoSSTLIvXCg4GTXskEEdrCscUaxxoMKqjaqj2FOoAKKKKACiiigAooooAKKKKACiiigAr4x/4LY/8km+Cv/ZZPDf87ivs6vjH/gtj/wAkm+Cv/ZZPDf8AO4oA3P8Agkp/ySnxV/2G5f8A0OSvrKvk3/gkp/ySnxV/2G5f/Q5K+sqACiiigAooooAKKKKACiiigDL8X+CtH+IGiTabrmmWOrafOMSW93As0Tj3VgRXzj4w/wCCfF58ONcm8RfBbxTeeB9W24/syUm60dwDnalqWWOPPTIFfUVFAHypo37f+vfBHVl0X43eDtQ8NzFykWtaZG19psqAf62WVVCQjrwSccetfRvw5+KHh34veFrbXPC+tabr2k3ih4buxuFnhkB5yGUkGtDxB4a07xbpkljqlhZ6lZzKVeC6gWaNweoKsCDXzH4//wCCaMPhPxhd+MPgz4s1T4Z+J5kijNtFm70d4o2LeUlk7CCHdllLomQCPQUAfVVFfIehft++Of2e9Sj0n4+eArvRo5J5Ug8ReH1bUNL8lfuy3MpWNYGYc7eQDkZr6a+GPxb8N/GfwxDrPhbWtP1zTJwClxaSiRD+IoA6KiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKGYIpZjgDkk9qACo7u7jsbZ5ppFjijG5mY4CivC/wBoP/goB4P+C+sR+HtLS68aeNro7bbQNHAlunP945IUKMjPzZrzKX9lL4q/tq6rBqXxh8QSeFfBc0MsUvgjRnKxX8b42G6kYCVJFUYIjcDLN6CgDqvij/wUPh13xBeeE/gzoj/EzxhbuIZ3tyTpelueguply0frwp4BrN8CfsEeIvi94mXxV8c/Fd14oujKtxZ+HLVvJ03RyBjYGj2NOp5P70Hk47V9D/C34N+Gfgt4Zt9J8M6PZ6XZ2saxKIly7BRgbnOWb6kmumoAo+HPDGneENJisdLsbXT7OFdqQ28QjRR9AMVeoooAKKKKACiiigAooooAKKKKACiiigAooooAK+Mf+C2P/JJvgr/2WTw3/O4r7Or4x/4LY/8AJJvgr/2WTw3/ADuKANz/AIJKf8kp8Vf9huX/ANDkr6yr5N/4JKf8kp8Vf9huX/0OSvrKgAooooAKKKKACiiigAooooAKKKKACiiigCrrOhWPiOwktdQs7W+tZBh4riJZEYe4YEV86/Ev/gnbYQeJZvFHwx8Q6n8OfE7FWZrP99Z3AX/lmYHJiQHoSq55r6UooA+SLP8AbW+JH7NN1HY/GrwLcHSULA+KPD6tdWMUYOFkuWbYIyV5IAIGG9K+jfhD8bfCvx58Jxa54R1zT9e0uXgT2km9Qe4PuMEfhXSahptvq1s0N1bw3UL8NHLGHVvqDxXzv8Xv+CdWi6z4hk8TfDvWtT+GfjDO432lEPHOf7rRSbowDxyFzxQB9HUV8h237XPxf/Zg1ePTPi54E/tzw8r

Скачать книгу