{"id":1690,"date":"2026-04-12T06:22:17","date_gmt":"2026-04-12T06:22:17","guid":{"rendered":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/"},"modified":"2026-04-12T06:22:17","modified_gmt":"2026-04-12T06:22:17","slug":"senior-dbas-approach-ambiguous-erd-requirements","status":"publish","type":"post","link":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/","title":{"rendered":"C\u00e2u h\u1ecfi &#038; C\u00e2u tr\u1ea3 l\u1eddi: C\u00e1c DBA c\u1ea5p cao ti\u1ebfp c\u1eadn c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o?"},"content":{"rendered":"<p>M\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u th\u01b0\u1eddng \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 nh\u01b0 c\u00e2y c\u1ea7u n\u1ed1i gi\u1eefa logic kinh doanh v\u00e0 tri\u1ec3n khai k\u1ef9 thu\u1eadt. Tuy nhi\u00ean, c\u00e2y c\u1ea7u n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng tr\u00ean n\u1ec1n \u0111\u1ea5t kh\u00f4ng \u1ed5n \u0111\u1ecbnh. Khi c\u00e1c b\u00ean li\u00ean quan kinh doanh \u0111\u01b0a ra nh\u1eefng kh\u00e1i ni\u1ec7m m\u01a1 h\u1ed3 nh\u01b0 &#8220;theo d\u00f5i ho\u1ea1t \u0111\u1ed9ng kh\u00e1ch h\u00e0ng&#8221; hay &#8220;qu\u1ea3n l\u00fd m\u1ee9c t\u1ed3n kho&#8221; m\u00e0 kh\u00f4ng x\u00e1c \u0111\u1ecbnh r\u00f5 r\u00e0ng c\u00e1c r\u00e0ng bu\u1ed9c c\u1ee5 th\u1ec3, s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 (ERD) tr\u1edf th\u00e0nh m\u1ed9t cu\u1ed9c \u0111\u00e1nh c\u01b0\u1ee3c mang t\u00ednh r\u1ee7i ro cao. C\u00e1c qu\u1ea3n tr\u1ecb vi\u00ean c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ea5p cao kh\u00f4ng \u0111\u01a1n gi\u1ea3n \u0111o\u00e1n m\u00f2; h\u1ecd \u00e1p d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p c\u00f3 c\u1ea5u tr\u00fac \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i s\u1ef1 kh\u00f4ng ch\u1eafc ch\u1eafn th\u00e0nh c\u00e1c \u0111\u1ecbnh ngh\u0129a d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac.<\/p>\n<p>H\u01b0\u1edbng d\u1eabn n\u00e0y kh\u00e1m ph\u00e1 c\u00e1c chi\u1ebfn l\u01b0\u1ee3c c\u1ee5 th\u1ec3, k\u1ef9 thu\u1eadt \u0111\u1eb7t c\u00e2u h\u1ecfi v\u00e0 c\u00e1c m\u1eabu ki\u1ebfn tr\u00fac \u0111\u01b0\u1ee3c c\u00e1c chuy\u00ean gia c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 kinh nghi\u1ec7m s\u1eed d\u1ee5ng khi \u0111\u1ed1i m\u1eb7t v\u1edbi c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3. Ch\u00fang ta s\u1ebd xem x\u00e9t c\u00e1ch \u1ed5n \u0111\u1ecbnh qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf, \u0111\u1ea3m b\u1ea3o t\u00ednh to\u00e0n v\u1eb9n d\u1eef li\u1ec7u v\u00e0 t\u1ea1o ra m\u1ed9t l\u01b0\u1ee3c \u0111\u1ed3 v\u1eabn v\u1eefng ch\u1eafc ngay c\u1ea3 khi nhu c\u1ea7u kinh doanh thay \u0111\u1ed5i.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img alt=\"Cartoon infographic illustrating how senior database administrators handle ambiguous requirements in Entity Relationship Diagram design, featuring key strategies: iterative mindset, requirement extraction techniques, structural modeling patterns, three-phase design process, documentation practices, data integrity safeguards, and best practice checklist for scalable database architecture\" decoding=\"async\" src=\"https:\/\/www.viz-note.com\/wp-content\/uploads\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg\"\/><\/figure>\n<\/div>\n<h2>\ud83e\udde0 T\u01b0 duy c\u1ee7a m\u1ed9t DBA c\u1ea5p cao<\/h2>\n<p>C\u00e1c nh\u00e0 m\u00f4 h\u00ecnh h\u00f3a c\u1ea5p th\u1ea5p th\u01b0\u1eddng coi s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 (ERD) nh\u01b0 m\u1ed9t b\u1ea3n v\u1ebd t\u0129nh ph\u1ea3i ho\u00e0n h\u1ea3o ngay t\u1eeb l\u1ea7n \u0111\u1ea7u ti\u00ean. C\u00e1c chuy\u00ean gia c\u1ea5p cao hi\u1ec3u r\u1eb1ng m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u l\u00e0 m\u1ed9t qu\u00e1 tr\u00ecnh kh\u00e1m ph\u00e1 l\u1eb7p l\u1ea1i. S\u1ef1 m\u01a1 h\u1ed3 kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i; \u0111\u00f3 l\u00e0 d\u1ea5u hi\u1ec7u cho th\u1ea5y logic kinh doanh v\u1eabn ch\u01b0a \u0111\u01b0\u1ee3c di\u1ec5n \u0111\u1ea1t \u0111\u1ea7y \u0111\u1ee7. M\u1ee5c ti\u00eau kh\u00f4ng ph\u1ea3i l\u00e0 lo\u1ea1i b\u1ecf s\u1ef1 m\u01a1 h\u1ed3 ngay l\u1eadp t\u1ee9c, m\u00e0 l\u00e0 c\u00f4 l\u1eadp n\u00f3, ghi ch\u00e9p l\u1ea1i v\u00e0 thi\u1ebft k\u1ebf xung quanh m\u1ed9t c\u00e1ch an to\u00e0n.<\/p>\n<p>Nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m ch\u00ednh c\u1ee7a c\u00e1ch ti\u1ebfp c\u1eadn n\u00e0y bao g\u1ed3m:<\/p>\n<ul>\n<li>\n<p><strong>X\u00e1c minh gi\u1ea3 \u0111\u1ecbnh:<\/strong>Xem m\u1ecdi gi\u1ea3 \u0111\u1ecbnh nh\u01b0 m\u1ed9t gi\u1ea3 thuy\u1ebft c\u1ea7n \u0111\u01b0\u1ee3c ki\u1ec3m ch\u1ee9ng th\u00f4ng qua c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/p>\n<\/li>\n<li>\n<p><strong>Kh\u1ea3 n\u0103ng b\u1ea3o v\u1ec7:<\/strong>\u0110\u1ea3m b\u1ea3o r\u1eb1ng m\u1ed7i kh\u00f3a ngo\u1ea1i v\u00e0 ch\u1ec9 m\u1ee5c \u0111\u1ec1u c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c bi\u1ec7n minh b\u1eb1ng m\u1ed9t quy t\u1eafc kinh doanh, ch\u1ee9 kh\u00f4ng ch\u1ec9 d\u1ef1a tr\u00ean s\u1edf th\u00edch k\u1ef9 thu\u1eadt.<\/p>\n<\/li>\n<li>\n<p><strong>B\u1ea3o v\u1ec7 t\u01b0\u01a1ng lai:<\/strong>Thi\u1ebft k\u1ebf cho ba n\u0103m ph\u00e1t tri\u1ec3n kinh doanh ti\u1ebfp theo, ch\u1ee9 kh\u00f4ng ch\u1ec9 cho \u0111\u1ee3t ph\u00e1t tri\u1ec3n hi\u1ec7n t\u1ea1i.<\/p>\n<\/li>\n<li>\n<p><strong>Giao ti\u1ebfp:<\/strong>Chuy\u1ec3n \u0111\u1ed5i c\u00e1c r\u00e0ng bu\u1ed9c k\u1ef9 thu\u1eadt th\u00e0nh ng\u00f4n ng\u1eef kinh doanh m\u00e0 c\u00e1c b\u00ean li\u00ean quan c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c.<\/p>\n<\/li>\n<\/ul>\n<h2>\ud83d\udde3\ufe0f K\u1ef9 thu\u1eadt tr\u00edch xu\u1ea5t c\u00e1c quy t\u1eafc \u1ea9n<\/h2>\n<p>Khi m\u1ed9t y\u00eau c\u1ea7u n\u00eau r\u1eb1ng &#8220;ch\u00fang t\u00f4i c\u1ea7n theo d\u00f5i \u0111\u01a1n h\u00e0ng&#8221;, s\u1ef1 m\u01a1 h\u1ed3 n\u1eb1m \u1edf \u0111\u1ecbnh ngh\u0129a v\u1ec1 m\u1ed9t \u0111\u01a1n h\u00e0ng. \u0110\u00f3 l\u00e0 m\u1ed9t giao d\u1ecbch mua? M\u1ed9t b\u00e1o gi\u00e1? M\u1ed9t tr\u01b0\u1eddng h\u1ee3p b\u1ecf gi\u1ecf h\u00e0ng? C\u00e1c DBA c\u1ea5p cao s\u1eed d\u1ee5ng c\u00e1c m\u1eabu \u0111\u1eb7t c\u00e2u h\u1ecfi c\u1ee5 th\u1ec3 \u0111\u1ec3 thu h\u1eb9p ph\u1ea1m vi.<\/p>\n<h3>1. T\u00ecnh hu\u1ed1ng &#8220;\u0110i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu&#8221;<\/h3>\n<p>Thay v\u00ec ch\u1ea5p nh\u1eadn m\u1ed9t ph\u00e1t bi\u1ec3u \u1edf c\u1ea5p \u0111\u1ed9 cao, DBA th\u00fac \u0111\u1ea9y t\u00ecm ki\u1ebfm c\u00e1c tr\u01b0\u1eddng h\u1ee3p bi\u00ean. Nh\u1eefng c\u00e2u h\u1ecfi nh\u01b0 &#8220;\u0110i\u1ec1u g\u00ec x\u1ea3y ra n\u1ebfu m\u1ed9t \u0111\u01a1n h\u00e0ng \u0111\u01b0\u1ee3c giao m\u1ed9t ph\u1ea7n?&#8221; hay &#8220;M\u1ed9t \u0111\u01a1n h\u00e0ng c\u00f3 th\u1ec3 b\u1ecb h\u1ee7y sau khi thanh to\u00e1n kh\u00f4ng?&#8221; bu\u1ed9c b\u00ean li\u00ean quan ph\u1ea3i ti\u1ebft l\u1ed9 c\u00e1c r\u00e0ng bu\u1ed9c m\u00e0 ban \u0111\u1ea7u ch\u01b0a th\u1ec3 hi\u1ec7n r\u00f5. Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p bi\u00ean n\u00e0y th\u01b0\u1eddng x\u00e1c \u0111\u1ecbnh nhu c\u1ea7u v\u1ec1 b\u1ea3ng tr\u1ea1ng th\u00e1i, nh\u1eadt k\u00fd giao d\u1ecbch ho\u1eb7c c\u00e1c quy t\u1eafc r\u00e0ng bu\u1ed9c c\u1ee5 th\u1ec3.<\/p>\n<h3>2. Kh\u1ea3o s\u00e1t v\u00f2ng \u0111\u1eddi d\u1eef li\u1ec7u<\/h3>\n<p>M\u1ed7i m\u1ea3nh d\u1eef li\u1ec7u \u0111\u1ec1u c\u00f3 m\u1ed9t v\u00f2ng \u0111\u1eddi. C\u00e1c DBA c\u1ea5p cao \u0111\u1eb7t c\u00e2u h\u1ecfi v\u1ec1 c\u00e1c chuy\u1ec3n \u0111\u1ed5i tr\u1ea1ng th\u00e1i:<\/p>\n<ul>\n<li>\n<p><strong>T\u1ea1o l\u1eadp:<\/strong>Ai t\u1ea1o b\u1ea3n ghi? C\u00f3 t\u1ef1 \u0111\u1ed9ng hay th\u1ee7 c\u00f4ng?<\/p>\n<\/li>\n<li>\n<p><strong>S\u1eeda \u0111\u1ed5i:<\/strong>L\u1ecbch s\u1eed c\u00f3 \u0111\u01b0\u1ee3c theo d\u00f5i hay b\u1ea3n ghi b\u1ecb ghi \u0111\u00e8? N\u1ebfu theo d\u00f5i l\u1ecbch s\u1eed, \u0111\u00f3 l\u00e0 b\u1ea3n ch\u1ee5p to\u00e0n b\u1ed9 hay s\u1ef1 thay \u0111\u1ed5i t\u1eebng ph\u1ea7n?<\/p>\n<\/li>\n<li>\n<p><strong>L\u01b0u tr\u1eef:<\/strong>Khi n\u00e0o d\u1eef li\u1ec7u tr\u1edf th\u00e0nh &#8220;c\u0169&#8221;? C\u00f3 ph\u1ea3i x\u00f3a m\u1ec1m (\u0111\u00e1nh d\u1ea5u) hay x\u00f3a c\u1ee9ng (x\u00f3a b\u1ecf)?<\/p>\n<\/li>\n<li>\n<p><strong>X\u1eed l\u00fd:<\/strong>C\u00f3 c\u00e1c kho\u1ea3ng th\u1eddi gian l\u01b0u tr\u1eef theo ph\u00e1p lu\u1eadt quy \u0111\u1ecbnh vi\u1ec7c l\u01b0u gi\u1eef d\u1eef li\u1ec7u kh\u00f4ng?<\/p>\n<\/li>\n<\/ul>\n<h3>3. Kh\u1ea3o s\u00e1t t\u00ednh cardinality<\/h3>\n<p>Cardinality x\u00e1c \u0111\u1ecbnh m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c th\u1ef1c th\u1ec3. S\u1ef1 m\u01a1 h\u1ed3 \u1edf \u0111\u00e2y d\u1eabn \u0111\u1ebfn c\u00e1c v\u1ea5n \u0111\u1ec1 hi\u1ec7u su\u1ea5t v\u00e0 tr\u00f9ng l\u1eb7p d\u1eef li\u1ec7u. DBA \u0111\u1eb7t c\u00e2u h\u1ecfi:<\/p>\n<ul>\n<li>\n<p>M\u1ed9t m\u1ee5c c\u00f3 th\u1ec3 thu\u1ed9c v\u1ec1 nhi\u1ec1u danh m\u1ee5c c\u00f9ng l\u00fac kh\u00f4ng?<\/p>\n<\/li>\n<li>\n<p>M\u1ed1i quan h\u1ec7 l\u00e0 b\u1eaft bu\u1ed9c (ph\u1ea3i t\u1ed3n t\u1ea1i) hay t\u00f9y ch\u1ecdn (c\u00f3 th\u1ec3 l\u00e0 null)?<\/p>\n<\/li>\n<li>\n<p>N\u1ebfu m\u1ed9t m\u1ed1i quan h\u1ec7 b\u1ecb ph\u00e1 v\u1ee1, \u0111i\u1ec1u \u0111\u00f3 \u1ea3nh h\u01b0\u1edfng nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ebfn b\u1ea3n ghi cha?<\/p>\n<\/li>\n<\/ul>\n<h2>\ud83d\udcd0 C\u00e1c chi\u1ebfn l\u01b0\u1ee3c c\u1ea5u tr\u00fac cho s\u1ef1 kh\u00f4ng ch\u1eafc ch\u1eafn<\/h2>\n<p>Khi c\u00e1c y\u00eau c\u1ea7u v\u1eabn c\u00f2n m\u01a1 h\u1ed3 sau khi tham v\u1ea5n, thi\u1ebft k\u1ebf c\u01a1 s\u1edf d\u1eef li\u1ec7u ph\u1ea3i ch\u1ea5p nh\u1eadn s\u1ef1 kh\u00f4ng ch\u1eafc ch\u1eafn m\u00e0 kh\u00f4ng l\u00e0m t\u1ed5n h\u1ea1i \u0111\u1ebfn t\u00ednh to\u00e0n v\u1eb9n. \u0110i\u1ec1u n\u00e0y bao g\u1ed3m c\u00e1c m\u1eabu m\u00f4 h\u00ecnh h\u00f3a c\u1ee5 th\u1ec3 cho ph\u00e9p linh ho\u1ea1t.<\/p>\n<h3>1. Quy\u1ebft \u0111\u1ecbnh gi\u1eefa Thu\u1ed9c t\u00ednh v\u00e0 Th\u1ef1c th\u1ec3<\/h3>\n<p>M\u1ed9t trong nh\u1eefng s\u1ef1 m\u01a1 h\u1ed3 ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 li\u1ec7u m\u1ed9t ph\u1ea7n d\u1eef li\u1ec7u c\u00f3 n\u00ean l\u00e0 m\u1ed9t c\u1ed9t (thu\u1ed9c t\u00ednh) hay m\u1ed9t b\u1ea3ng ri\u00eang bi\u1ec7t (th\u1ef1c th\u1ec3). V\u00ed d\u1ee5, \u201cs\u1ed1 \u0111i\u1ec7n tho\u1ea1i\u201d c\u00f3 n\u00ean l\u00e0 m\u1ed9t c\u1ed9t duy nh\u1ea5t hay m\u1ed9t b\u1ea3ng ri\u00eang bi\u1ec7t li\u00ean k\u1ebft v\u1edbi th\u1ef1c th\u1ec3 \u201cLi\u00ean h\u1ec7\u201d?<\/p>\n<p>Khi y\u00eau c\u1ea7u kh\u00f4ng r\u00f5 r\u00e0ng, c\u00e1ch ti\u1ebfp c\u1eadn c\u1ee7a chuy\u00ean gia \u01b0u ti\u00ean chu\u1ea9n h\u00f3a. T\u1ea1o m\u1ed9t b\u1ea3ng ri\u00eang cho s\u1ed1 \u0111i\u1ec7n tho\u1ea1i cho ph\u00e9p m\u1ed7i li\u00ean h\u1ec7 c\u00f3 nhi\u1ec1u s\u1ed1 m\u00e0 kh\u00f4ng c\u1ea7n th\u00eam c\u00e1c c\u1ed9t c\u00f3 th\u1ec3 null. N\u00f3 c\u0169ng cho ph\u00e9p ph\u00e2n lo\u1ea1i (v\u00ed d\u1ee5: Nh\u00e0, Di \u0111\u1ed9ng, C\u00f4ng s\u1edf) m\u00e0 kh\u00f4ng l\u00e0m bloat b\u1ea3ng ch\u00ednh. C\u00e1ch ti\u1ebfp c\u1eadn n\u00e0y x\u1eed l\u00fd s\u1ef1 ph\u00e1t tri\u1ec3n t\u1ed1t h\u01a1n so v\u1edbi c\u00e1c b\u1ea3ng r\u1ed9ng c\u00f3 nhi\u1ec1u c\u1ed9t t\u00f9y ch\u1ecdn.<\/p>\n<h3>2. X\u1eed l\u00fd c\u00e1c m\u1ed1i quan h\u1ec7 t\u00f9y ch\u1ecdn<\/h3>\n<p>N\u1ebfu kh\u00f4ng r\u00f5 r\u00e0ng m\u1ed1i quan h\u1ec7 c\u1ee5 th\u1ec3 \u0111\u00f3 c\u00f3 b\u1eaft bu\u1ed9c ph\u1ea3i t\u1ed3n t\u1ea1i hay kh\u00f4ng, DBA s\u1ebd m\u00f4 h\u00ecnh h\u00f3a n\u00f3 nh\u01b0 m\u1ed9t m\u1ed1i quan h\u1ec7 t\u00f9y ch\u1ecdn b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng kh\u00f3a ngo\u1ea1i c\u00f3 th\u1ec3 null. Tuy nhi\u00ean, \u0111i\u1ec1u n\u00e0y \u0111i k\u00e8m c\u1ea3nh b\u00e1o. Kh\u00f3a ngo\u1ea1i c\u00f3 th\u1ec3 null c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn d\u1eef li\u1ec7u b\u1ecb b\u1ecf r\u01a1i n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd \u0111\u00fang c\u00e1ch. Gi\u1ea3i ph\u00e1p th\u01b0\u1eddng l\u00e0 tri\u1ec3n khai c\u00e1c trigger ho\u1eb7c x\u00e1c th\u1ef1c \u1edf c\u1ea5p \u0111\u1ed9 \u1ee9ng d\u1ee5ng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh to\u00e0n v\u1eb9n tham chi\u1ebfu \u0111\u01b0\u1ee3c duy tr\u00ec v\u1ec1 m\u1eb7t logic, ngay c\u1ea3 khi c\u01a1 s\u1edf d\u1eef li\u1ec7u cho ph\u00e9p gi\u00e1 tr\u1ecb null.<\/p>\n<h3>3. Chi\u1ebfn l\u01b0\u1ee3c b\u1ea3ng li\u00ean k\u1ebft<\/h3>\n<p>C\u00e1c m\u1ed1i quan h\u1ec7 nhi\u1ec1u-nhi\u1ec1u l\u00e0 ngu\u1ed3n ph\u1ed5 bi\u1ebfn g\u00e2y nh\u1ea7m l\u1eabn. N\u1ebfu y\u00eau c\u1ea7u n\u00f3i r\u1eb1ng \u201cNg\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u vai tr\u00f2\u201d v\u00e0 \u201cVai tr\u00f2 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c g\u00e1n cho nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng\u201d, m\u1ed9t c\u1ed9t \u0111\u01a1n gi\u1ea3n kh\u00f4ng th\u1ec3 l\u01b0u tr\u1eef d\u1eef li\u1ec7u n\u00e0y. B\u1ea3ng li\u00ean k\u1ebft (th\u1ef1c th\u1ec3 li\u00ean k\u1ebft) l\u00e0 gi\u1ea3i ph\u00e1p ti\u00eau chu\u1ea9n. N\u00f3 cho ph\u00e9p DBA g\u1eafn c\u00e1c thu\u1ed9c t\u00ednh v\u00e0o ch\u00ednh m\u1ed1i quan h\u1ec7, ch\u1eb3ng h\u1ea1n nh\u01b0 \u201cVai tr\u00f2 \u0111\u01b0\u1ee3c g\u00e1n v\u00e0o l\u00fac n\u00e0o?\u201d hay \u201cAi \u0111\u00e3 ph\u00ea duy\u1ec7t vi\u1ec7c g\u00e1n?\u201d \u0110i\u1ec1u n\u00e0y th\u00eam m\u1ed9t l\u1edbp kh\u1ea3 n\u0103ng ki\u1ec3m to\u00e1n, th\u01b0\u1eddng \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u sau n\u00e0y khi y\u00eau c\u1ea7u ph\u00e1t tri\u1ec3n.<\/p>\n<h2>\ud83d\udd04 Quy tr\u00ecnh l\u1eb7p l\u1ea1i<\/h2>\n<p>C\u00e1c DBA c\u1ea5p cao hi\u1ebfm khi \u0111\u01b0a ra s\u01a1 \u0111\u1ed3 cu\u1ed1i c\u00f9ng trong b\u1ea3n nh\u00e1p \u0111\u1ea7u ti\u00ean. H\u1ecd s\u1eed d\u1ee5ng c\u00e1ch ti\u1ebfp c\u1eadn theo giai \u0111o\u1ea1n \u0111\u1ec3 gi\u1ea3m thi\u1ec3u r\u1ee7i ro.<\/p>\n<h3>Giai \u0111o\u1ea1n 1: M\u00f4 h\u00ecnh kh\u00e1i ni\u1ec7m<\/h3>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t s\u01a1 \u0111\u1ed3 c\u1ea5p cao t\u1eadp trung v\u00e0o c\u00e1c th\u1ef1c th\u1ec3 kinh doanh v\u00e0 m\u1ed1i quan h\u1ec7 gi\u1eefa ch\u00fang. N\u00f3 b\u1ecf qua ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 c\u00e1c r\u00e0ng bu\u1ed9c k\u1ef9 thu\u1eadt. M\u1ee5c ti\u00eau l\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ef1 \u0111\u1ed3ng thu\u1eadn t\u1eeb c\u00e1c b\u00ean li\u00ean quan v\u1ec1 *c\u00e1i g\u00ec*, ch\u1ee9 kh\u00f4ng ph\u1ea3i *c\u00e1ch th\u1ee9c* nh\u01b0 th\u1ebf n\u00e0o. \u0110i\u1ec1u n\u00e0y ng\u0103n ch\u1eb7n c\u00e1c chi ti\u1ebft k\u1ef9 thu\u1eadt l\u00e0m m\u1edd \u0111i s\u1ef1 \u0111\u1ed3ng thu\u1eadn v\u1ec1 logic kinh doanh.<\/p>\n<h3>Giai \u0111o\u1ea1n 2: M\u00f4 h\u00ecnh logic<\/h3>\n<p>\u1ede \u0111\u00e2y, ki\u1ec3u d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh v\u00e0 c\u00e1c quy t\u1eafc chu\u1ea9n h\u00f3a (th\u01b0\u1eddng \u0111\u1ebfn d\u1ea1ng chu\u1ea9n h\u00f3a b\u1eadc ba) \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng. Nh\u1eefng s\u1ef1 m\u01a1 h\u1ed3 \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft b\u1eb1ng c\u00e1ch \u0111\u01b0a ra c\u00e1c gi\u1ea3 \u0111\u1ecbnh th\u1eadn tr\u1ecdng, \u0111\u01b0\u1ee3c ghi l\u1ea1i trong t\u1eeb \u0111i\u1ec3n d\u1eef li\u1ec7u. \u0110\u00e2y l\u00e0 n\u01a1i DBA x\u00e1c \u0111\u1ecbnh kh\u00f3a ch\u00ednh, kh\u00f3a ngo\u1ea1i v\u00e0 c\u00e1c r\u00e0ng bu\u1ed9c duy nh\u1ea5t.<\/p>\n<h3>Giai \u0111o\u1ea1n 3: M\u00f4 h\u00ecnh v\u1eadt l\u00fd<\/h3>\n<p>M\u00f4 h\u00ecnh logic \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh c\u00e1c chi ti\u1ebft tri\u1ec3n khai c\u1ee5 th\u1ec3. \u0110i\u1ec1u n\u00e0y bao g\u1ed3m c\u00e1c chi\u1ebfn l\u01b0\u1ee3c ch\u1ec9 m\u1ee5c, ph\u00e2n v\u00f9ng v\u00e0 c\u00e1c b\u1ed9 \u0111\u1ed9ng l\u01b0u tr\u1eef. \u1ede giai \u0111o\u1ea1n n\u00e0y, DBA xem x\u00e9t c\u00e1c h\u1ec7 qu\u1ea3 v\u1ec1 hi\u1ec7u su\u1ea5t c\u1ee7a c\u00e1c quy\u1ebft \u0111\u1ecbnh m\u01a1 h\u1ed3 \u0111\u01b0\u1ee3c \u0111\u01b0a ra tr\u01b0\u1edbc \u0111\u00f3. N\u1ebfu y\u00eau c\u1ea7u v\u1ec1 \u201cb\u00e1o c\u00e1o nhanh\u201d l\u00e0 m\u01a1 h\u1ed3, m\u00f4 h\u00ecnh v\u1eadt l\u00fd c\u00f3 th\u1ec3 bao g\u1ed3m vi\u1ec7c phi chu\u1ea9n h\u00f3a ho\u1eb7c c\u00e1c view \u0111\u00e3 \u0111\u01b0\u1ee3c v\u1eadt ch\u1ea5t h\u00f3a \u0111\u1ec3 \u0111\u00e1p \u1ee9ng nhu c\u1ea7u \u0111\u00f3, k\u00e8m theo ghi ch\u00fa \u0111\u1ec3 xem x\u00e9t l\u1ea1i sau n\u00e0y.<\/p>\n<h2>\ud83d\udcdd T\u00e0i li\u1ec7u v\u00e0 Giao ti\u1ebfp<\/h2>\n<p>T\u00e0i li\u1ec7u l\u00e0 t\u1ea5m l\u01b0\u1edbi an to\u00e0n cho c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3. N\u1ebfu m\u1ed9t quy\u1ebft \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111\u01b0a ra d\u1ef1a tr\u00ean m\u1ed9t gi\u1ea3 \u0111\u1ecbnh, \u0111i\u1ec1u \u0111\u00f3 ph\u1ea3i \u0111\u01b0\u1ee3c ghi l\u1ea1i. \u0110i\u1ec1u n\u00e0y b\u1ea3o v\u1ec7 DBA v\u00e0 t\u1ed5 ch\u1ee9c kh\u1ecfi vi\u1ec7c m\u1edf r\u1ed9ng ph\u1ea1m vi ho\u1eb7c m\u1ea5t d\u1eef li\u1ec7u.<\/p>\n<ul>\n<li>\n<p><strong>T\u1eeb \u0111i\u1ec3n d\u1eef li\u1ec7u:<\/strong> M\u1ed9t t\u00e0i li\u1ec7u s\u1ed1ng \u0111\u1ed9ng \u0111\u1ecbnh ngh\u0129a m\u1ecdi c\u1ed9t, m\u1ee5c \u0111\u00edch v\u00e0 c\u00e1c r\u00e0ng bu\u1ed9c c\u1ee7a n\u00f3. N\u1ebfu m\u1ed9t tr\u01b0\u1eddng c\u00f3 th\u1ec3 null, l\u00fd do ph\u1ea3i \u0111\u01b0\u1ee3c ghi ch\u00fa.<\/p>\n<\/li>\n<li>\n<p><strong>Nh\u1eadt k\u00fd quy\u1ebft \u0111\u1ecbnh:<\/strong> M\u1ed9t ph\u1ea7n trong t\u00e0i li\u1ec7u d\u1ef1 \u00e1n ghi l\u1ea1i l\u00fd do t\u1ea1i sao c\u00e1c l\u1ef1a ch\u1ecdn m\u00f4 h\u00ecnh h\u00f3a c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n. V\u00ed d\u1ee5: \u201cGi\u1ea3 \u0111\u1ecbnh m\u1ed1i quan h\u1ec7 m\u1ed9t-nhi\u1ec1u cho \u0110\u01a1n h\u00e0ng d\u1ef1a tr\u00ean cu\u1ed9c ph\u1ecfng v\u1ea5n b\u00ean li\u00ean quan v\u00e0o [Ng\u00e0y].\u201d<\/p>\n<\/li>\n<li>\n<p><strong>C\u00e1c bu\u1ed5i \u0111i th\u1ef1c t\u1ebf tr\u1ef1c quan:<\/strong> Tr\u01b0\u1edbc khi sinh m\u00e3, s\u01a1 \u0111\u1ed3 \u0111\u01b0\u1ee3c xem x\u00e9t c\u00f9ng v\u1edbi \u0111\u1ed9i ng\u0169 kinh doanh. \u0110i\u1ec1u n\u00e0y \u0111\u1ea3m b\u1ea3o m\u00f4 h\u00ecnh ph\u1ea3n \u00e1nh b\u1ea3n \u0111\u1ed3 t\u01b0 duy c\u1ee7a h\u1ecd v\u1ec1 doanh nghi\u1ec7p.<\/p>\n<\/li>\n<\/ul>\n<h2>\u26a0\ufe0f Nh\u1eefng sai l\u1ea7m ph\u1ed5 bi\u1ebfn c\u1ea7n tr\u00e1nh<\/h2>\n<p>Ngay c\u1ea3 nh\u1eefng chuy\u00ean gia c\u00f3 kinh nghi\u1ec7m c\u0169ng c\u00f3 th\u1ec3 r\u01a1i v\u00e0o b\u1eaby khi y\u00eau c\u1ea7u kh\u00f4ng r\u00f5 r\u00e0ng. Nh\u1eadn th\u1ee9c v\u1ec1 nh\u1eefng sai l\u1ea7m n\u00e0y gi\u00fap duy tr\u00ec t\u00ednh to\u00e0n v\u1eb9n c\u1ee7a thi\u1ebft k\u1ebf.<\/p>\n<ul>\n<li>\n<p><strong>Thi\u1ebft k\u1ebf qu\u00e1 m\u1ee9c:<\/strong>C\u1ed1 g\u1eafng gi\u1ea3i quy\u1ebft cho m\u1ecdi t\u00ecnh hu\u1ed1ng t\u01b0\u01a1ng lai c\u00f3 th\u1ec3 x\u1ea3y ra s\u1ebd d\u1eabn \u0111\u1ebfn m\u1ed9t l\u01b0\u1ee3c \u0111\u1ed3 qu\u00e1 ph\u1ee9c t\u1ea1p \u0111\u1ec3 duy tr\u00ec. T\u1ed1t h\u01a1n h\u1ebft l\u00e0 x\u00e2y d\u1ef1ng theo c\u00e1c y\u00eau c\u1ea7u hi\u1ec7n t\u1ea1i \u0111\u00e3 bi\u1ebft v\u00e0 th\u00eam t\u00ednh linh ho\u1ea1t cho t\u01b0\u01a1ng lai.<\/p>\n<\/li>\n<li>\n<p><strong>B\u1ecf qua ki\u1ec3u d\u1eef li\u1ec7u:<\/strong>Xem t\u1ea5t c\u1ea3 v\u0103n b\u1ea3n nh\u01b0 ki\u1ec3u \u201cVARCHAR\u201d l\u00e0 m\u1ed9t sai l\u1ea7m ph\u1ed5 bi\u1ebfn. Ng\u00e0y th\u00e1ng, ti\u1ec1n t\u1ec7 v\u00e0 ID c\u00f3 c\u00e1c r\u00e0ng bu\u1ed9c c\u1ee5 th\u1ec3 c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1ea3m b\u1ea3o \u1edf c\u1ea5p \u0111\u1ed9 c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n<\/li>\n<li>\n<p><strong>Ghi c\u1ee9ng logic:<\/strong>Vi\u1ec7c \u0111\u1eb7t c\u00e1c quy t\u1eafc kinh doanh tr\u1ef1c ti\u1ebfp v\u00e0o s\u01a1 \u0111\u1ed3 ERD (v\u00ed d\u1ee5: \u201cStatus = 1 c\u00f3 ngh\u0129a l\u00e0 Active\u201d) l\u00e0 r\u1ee7i ro. T\u1ed1t h\u01a1n n\u00ean d\u00f9ng c\u00e1c enum d\u1ec5 \u0111\u1ecdc ho\u1eb7c b\u1ea3ng tra c\u1ee9u \u0111\u1ec3 \u00fd ngh\u0129a d\u1eef li\u1ec7u tr\u1edf n\u00ean r\u00f5 r\u00e0ng.<\/p>\n<\/li>\n<li>\n<p><strong>B\u1ecf qua d\u1ea5u v\u1ebft ki\u1ec3m to\u00e1n:<\/strong>N\u1ebfu y\u00eau c\u1ea7u m\u01a1 h\u1ed3, ngu\u1ed3n g\u1ed1c d\u1eef li\u1ec7u tr\u1edf n\u00ean quan tr\u1ecdng. Vi\u1ec7c th\u00eam c\u00e1c c\u1ed9t nh\u01b0 \u201ccreated_by\u201d, \u201ccreated_at\u201d v\u00e0 \u201cupdated_at\u201d s\u1ebd t\u1ea1o n\u1ec1n t\u1ea3ng \u0111\u1ec3 theo d\u00f5i c\u00e1c thay \u0111\u1ed5i.<\/p>\n<\/li>\n<\/ul>\n<h2>\ud83d\udcca C\u00e1c lo\u1ea1i m\u01a1 h\u1ed3 v\u00e0 chi\u1ebfn l\u01b0\u1ee3c gi\u1ea3i quy\u1ebft<\/h2>\n<p>\u0110\u1ec3 h\u1ed7 tr\u1ee3 tra c\u1ee9u nhanh, b\u1ea3ng sau \u0111\u00e2y tr\u00ecnh b\u00e0y c\u00e1c lo\u1ea1i m\u01a1 h\u1ed3 ph\u1ed5 bi\u1ebfn trong thi\u1ebft k\u1ebf ERD v\u00e0 c\u00e1c gi\u1ea3i ph\u00e1p k\u1ef9 thu\u1eadt \u0111\u01b0\u1ee3c khuy\u1ebfn ngh\u1ecb.<\/p>\n<table style=\"min-width: 75px;\">\n<colgroup>\n<col style=\"min-width: 25px;\"\/>\n<col style=\"min-width: 25px;\"\/>\n<col style=\"min-width: 25px;\"\/><\/colgroup>\n<tbody>\n<tr>\n<th colspan=\"1\" rowspan=\"1\">\n<p><strong>Lo\u1ea1i m\u01a1 h\u1ed3<\/strong><\/p>\n<\/th>\n<th colspan=\"1\" rowspan=\"1\">\n<p><strong>T\u00ecnh hu\u1ed1ng v\u00ed d\u1ee5<\/strong><\/p>\n<\/th>\n<th colspan=\"1\" rowspan=\"1\">\n<p><strong>Chi\u1ebfn l\u01b0\u1ee3c gi\u1ea3i quy\u1ebft<\/strong><\/p>\n<\/th>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">\n<p>S\u1ef1 kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 cardinality<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u201cM\u1ed9t s\u1ea3n ph\u1ea9m c\u00f3 th\u1ec3 n\u1eb1m trong nhi\u1ec1u \u0111\u01a1n h\u00e0ng.\u201d (Li\u1ec7u \u0111i\u1ec1u n\u00e0y c\u00f3 ng\u1ee5 \u00fd nhi\u1ec1u \u0111\u01a1n h\u00e0ng cho m\u1ed7i s\u1ea3n ph\u1ea9m? Hay ch\u1ec9 m\u1ed9t?)<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>M\u00f4 h\u00ecnh h\u00f3a nh\u01b0 quan h\u1ec7 Nhi\u1ec1u-\u0110a v\u1edbi b\u1ea3ng li\u00ean k\u1ebft \u0111\u1ec3 cho ph\u00e9p m\u1edf r\u1ed9ng trong t\u01b0\u01a1ng lai.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">\n<p>T\u00ednh b\u1ea5t \u1ed5n c\u1ee7a d\u1eef li\u1ec7u<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u201cCh\u00fang ta c\u1ea7n l\u01b0u tr\u1eef \u0111\u1ecba ch\u1ec9 kh\u00e1ch h\u00e0ng.\u201d (Li\u1ec7u ch\u00fang c\u00f3 thay \u0111\u1ed5i? Ch\u00fang ta c\u00f3 l\u01b0u l\u1ecbch s\u1eed kh\u00f4ng?)<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>S\u1eed d\u1ee5ng m\u1ed9t b\u1ea3ng \u201cL\u1ecbch s\u1eed \u0111\u1ecba ch\u1ec9\u201d ri\u00eang bi\u1ec7t v\u1edbi c\u00e1c ng\u00e0y hi\u1ec7u l\u1ef1c thay v\u00ec ghi \u0111\u00e8 l\u00ean \u0111\u1ecba ch\u1ec9 ch\u00ednh.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u0110\u1ed9 chi ti\u1ebft thu\u1ed9c t\u00ednh<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u201cL\u01b0u tr\u1eef v\u1ecb tr\u00ed ng\u01b0\u1eddi d\u00f9ng.\u201d (Th\u00e0nh ph\u1ed1? T\u1ecda \u0111\u1ed9 GPS? IP?)<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>T\u1ea1o m\u1ed9t th\u1ef1c th\u1ec3 \u201cV\u1ecb tr\u00ed\u201d chuy\u00ean bi\u1ec7t v\u1edbi c\u00e1c tr\u01b0\u1eddng c\u1ee5 th\u1ec3 (V\u0129 \u0111\u1ed9, Kinh \u0111\u1ed9, Th\u00e0nh ph\u1ed1) \u0111\u1ec3 cho ph\u00e9p \u0111\u1ed9 ch\u00ednh x\u00e1c trong t\u01b0\u01a1ng lai.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">\n<p>Qu\u1ea3n l\u00fd tr\u1ea1ng th\u00e1i<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u201cTheo d\u00f5i tr\u1ea1ng th\u00e1i \u0111\u01a1n h\u00e0ng.\u201d (Nh\u1eefng tr\u1ea1ng th\u00e1i h\u1ee3p l\u1ec7 l\u00e0 g\u00ec?)<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>Th\u1ef1c hi\u1ec7n b\u1ea3ng tra c\u1ee9u tr\u1ea1ng th\u00e1i v\u1edbi c\u00e1c r\u00e0ng bu\u1ed9c \u0111\u1ec3 ng\u0103n ch\u1eb7n c\u00e1c chuy\u1ec3n \u0111\u1ed5i tr\u1ea1ng th\u00e1i kh\u00f4ng h\u1ee3p l\u1ec7.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">\n<p>R\u00e0ng bu\u1ed9c t\u00ednh duy nh\u1ea5t<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u201c\u0110\u1ea3m b\u1ea3o email l\u00e0 duy nh\u1ea5t.\u201d (Ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng? C\u00f2n l\u1ed7i ch\u00ednh t\u1ea3 th\u00ec sao?)<\/p>\n<\/td>\n<td colspan=\"1\" rowspan=\"1\">\n<p>\u00c1p d\u1ee5ng r\u00e0ng bu\u1ed9c duy nh\u1ea5t tr\u00ean phi\u00ean b\u1ea3n ch\u1eef th\u01b0\u1eddng c\u1ee7a tr\u01b0\u1eddng ho\u1eb7c s\u1eed d\u1ee5ng m\u1ed9t l\u1edbp ki\u1ec3m tra ri\u00eang bi\u1ec7t.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\ud83d\udee1\ufe0f \u0110\u1ea3m b\u1ea3o t\u00ednh to\u00e0n v\u1eb9n d\u1eef li\u1ec7u trong m\u00f4i tr\u01b0\u1eddng m\u01a1 h\u1ed3<\/h2>\n<p>Khi y\u00eau c\u1ea7u kh\u00f4ng r\u00f5 r\u00e0ng, nguy c\u01a1 d\u1eef li\u1ec7u b\u1ecb h\u1ecfng s\u1ebd t\u0103ng l\u00ean. C\u00e1c DBA c\u1ea5p cao tri\u1ec3n khai c\u00e1c bi\u1ec7n ph\u00e1p b\u1ea3o v\u1ec7 \u0111\u1ec3 b\u1ea3o v\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u1ecfi d\u1eef li\u1ec7u x\u1ea5u x\u00e2m nh\u1eadp v\u00e0o h\u1ec7 th\u1ed1ng.<\/p>\n<h3>1. Ki\u1ec3m tra r\u00e0ng bu\u1ed9c<\/h3>\n<p>Ngay c\u1ea3 khi c\u00e1c quy t\u1eafc kinh doanh m\u01a1 h\u1ed3, c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u1eabn ph\u1ea3i th\u1ef1c thi c\u00e1c ranh gi\u1edbi nghi\u00eam ng\u1eb7t. V\u00ed d\u1ee5, n\u1ebfu tr\u01b0\u1eddng \u201cGi\u00e1\u201d l\u00e0 b\u1eaft bu\u1ed9c, c\u01a1 s\u1edf d\u1eef li\u1ec7u ph\u1ea3i ng\u0103n c\u1ea3n c\u00e1c s\u1ed1 \u00e2m ho\u1eb7c gi\u00e1 tr\u1ecb r\u1ed7ng, tr\u1eeb khi logic kinh doanh c\u1ee5 th\u1ec3 cho ph\u00e9p.<\/p>\n<h3>2. Gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh<\/h3>\n<p>Khi m\u1ed9t y\u00eau c\u1ea7u b\u1ecb thi\u1ebfu, s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh an to\u00e0n t\u1ed1t h\u01a1n l\u00e0 cho ph\u00e9p gi\u00e1 tr\u1ecb r\u1ed7ng. V\u00ed d\u1ee5, n\u1ebfu tr\u01b0\u1eddng \u201cTr\u1ea1ng th\u00e1i\u201d kh\u00f4ng r\u00f5 r\u00e0ng, \u0111\u1eb7t gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh l\u00e0 \u201c\u0110ang ch\u1edd\u201d ho\u1eb7c \u201cB\u1ea3n nh\u00e1p\u201d s\u1ebd \u0111\u1ea3m b\u1ea3o b\u1ea3n ghi kh\u00f4ng b\u1ecb b\u1ecf qu\u00ean hay b\u1ecb b\u1ecf qua.<\/p>\n<h3>3. Quy \u01b0\u1edbc \u0111\u1eb7t t\u00ean<\/h3>\n<p>\u0110\u1eb7t t\u00ean nh\u1ea5t qu\u00e1n gi\u00fap gi\u1ea3m thi\u1ec3u s\u1ef1 m\u01a1 h\u1ed3. S\u1eed d\u1ee5ng ti\u1ec1n t\u1ed1 cho c\u00e1c kh\u00f3a ngo\u1ea1i (v\u00ed d\u1ee5, <code>user_id<\/code> thay v\u00ec ch\u1ec9 <code>id<\/code>) gi\u00fap m\u1ed1i quan h\u1ec7 tr\u1edf n\u00ean r\u00f5 r\u00e0ng ngay c\u1ea3 khi c\u1ea5u tr\u00fac b\u1ea3ng thay \u0111\u1ed5i sau n\u00e0y. \u0110i\u1ec1u n\u00e0y gi\u1ea3m t\u1ea3i nh\u1eadn th\u1ee9c cho c\u00e1c nh\u00e0 ph\u00e1t tri\u1ec3n khi \u0111\u1ecdc s\u01a1 \u0111\u1ed3 c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n<h2>\ud83d\ude80 M\u1edf r\u1ed9ng cho nh\u1eefng \u0111i\u1ec1u ch\u01b0a bi\u1ebft<\/h2>\n<p>Cu\u1ed1i c\u00f9ng, c\u00e1c DBA c\u1ea5p cao xem x\u00e9t c\u00e1ch s\u01a1 \u0111\u1ed3 s\u1ebd ch\u1ecbu \u0111\u01b0\u1ee3c t\u1ea3i tr\u1ecdng. Nh\u1eefng y\u00eau c\u1ea7u m\u01a1 h\u1ed3 th\u01b0\u1eddng d\u1eabn \u0111\u1ebfn c\u00e1c truy v\u1ea5n \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u k\u00e9m sau n\u00e0y. B\u1eb1ng c\u00e1ch d\u1ef1 \u0111o\u00e1n s\u1ef1 ph\u00e1t tri\u1ec3n, m\u00f4 h\u00ecnh v\u1eabn duy tr\u00ec kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng.<\/p>\n<ul>\n<li>\n<p><strong>Chi\u1ebfn l\u01b0\u1ee3c ch\u1ec9 m\u1ee5c:<\/strong> X\u00e1c \u0111\u1ecbnh c\u00e1c tr\u01b0\u1eddng c\u00f3 kh\u1ea3 n\u0103ng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm ho\u1eb7c l\u1ecdc. Ngay c\u1ea3 khi y\u00eau c\u1ea7u m\u01a1 h\u1ed3, vi\u1ec7c th\u00eam ch\u1ec9 m\u1ee5c v\u00e0o c\u00e1c c\u1ed9t t\u00ecm ki\u1ebfm ti\u1ec1m n\u0103ng s\u1ebd ng\u0103n ng\u1eeba suy gi\u1ea3m hi\u1ec7u su\u1ea5t v\u1ec1 sau.<\/p>\n<\/li>\n<li>\n<p><strong>Xem x\u00e9t chia t\u00e1ch d\u1eef li\u1ec7u:<\/strong> V\u1edbi c\u00e1c b\u1ea3ng l\u1edbn, h\u00e3y xem x\u00e9t c\u00e1ch d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c chia t\u00e1ch. N\u1ebfu y\u00eau c\u1ea7u m\u01a1 h\u1ed3 v\u1ec1 ph\u1ea1m vi th\u1eddi gian, vi\u1ec7c chia t\u00e1ch theo kho\u1ea3ng ng\u00e0y s\u1ebd gi\u00fap b\u1ea3o tr\u00ec v\u00e0 l\u01b0u tr\u1eef d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n v\u1ec1 sau.<\/p>\n<\/li>\n<li>\n<p><strong>C\u00e2n b\u1eb1ng gi\u1eefa \u0111\u1ecdc v\u00e0 ghi:<\/strong> Hi\u1ec3u xem h\u1ec7 th\u1ed1ng l\u00e0 tr\u1ecdng t\u00e2m \u0111\u1ecdc hay tr\u1ecdng t\u00e2m ghi. \u0110i\u1ec1u n\u00e0y \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn vi\u1ec7c c\u00f3 n\u00ean chu\u1ea9n h\u00f3a m\u1ea1nh hay \u0111\u01b0a v\u00e0o vi\u1ec7c phi chu\u1ea9n h\u00f3a c\u00f3 ki\u1ec3m so\u00e1t nh\u1eb1m c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t hay kh\u00f4ng.<\/p>\n<\/li>\n<\/ul>\n<h2>\ud83e\udd1d Thi\u1ebft k\u1ebf h\u1ee3p t\u00e1c<\/h2>\n<p>Nh\u1eefng thi\u1ebft k\u1ebf ERD hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u01b0\u1ee3c t\u1ea1o ra th\u00f4ng qua h\u1ee3p t\u00e1c. M\u1ed9t DBA c\u1ea5p cao kh\u00f4ng l\u00e0m vi\u1ec7c trong c\u00f4 l\u1eadp. H\u1ecd \u0111\u00f3ng vai tr\u00f2 nh\u01b0 ng\u01b0\u1eddi phi\u00ean d\u1ecbch gi\u1eefa \u0111\u1ed9i k\u1ef9 thu\u1eadt v\u00e0 c\u00e1c b\u00ean li\u00ean quan kinh doanh.<\/p>\n<p>S\u1ef1 h\u1ee3p t\u00e1c n\u00e0y \u0111\u1ea3m b\u1ea3o r\u1eb1ng:<\/p>\n<ul>\n<li>\n<p>C\u00e1c b\u00ean li\u00ean quan kinh doanh hi\u1ec3u \u0111\u01b0\u1ee3c chi ph\u00ed c\u1ee7a s\u1ef1 ph\u1ee9c t\u1ea1p.<\/p>\n<\/li>\n<li>\n<p>C\u00e1c nh\u00e0 ph\u00e1t tri\u1ec3n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1c gi\u1edbi h\u1ea1n c\u1ee7a d\u1eef li\u1ec7u.<\/p>\n<\/li>\n<li>\n<p>C\u00e1c DBA hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1c y\u00eau c\u1ea7u v\u1eadn h\u00e0nh.<\/p>\n<\/li>\n<\/ul>\n<p>C\u00e1c cu\u1ed9c h\u1ecdp xem x\u00e9t \u0111\u1ecbnh k\u1ef3 l\u00e0 thi\u1ebft y\u1ebfu. Trong c\u00e1c bu\u1ed5i h\u1ecdp n\u00e0y, s\u01a1 \u0111\u1ed3 \u0111\u01b0\u1ee3c \u0111i qua t\u1eebng d\u00f2ng m\u1ed9t. C\u00e1c c\u00e2u h\u1ecfi \u0111\u01b0\u1ee3c \u0111\u1eb7t ra v\u00e0 c\u00e1c gi\u1ea3 \u0111\u1ecbnh \u0111\u01b0\u1ee3c th\u00e1ch th\u1ee9c. V\u00f2ng ph\u1ea3n h\u1ed3i l\u1eb7p l\u1ea1i n\u00e0y l\u00e0 bi\u1ec7n ph\u00e1p ph\u00f2ng th\u1ee7 ch\u00ednh ch\u1ed1ng l\u1ea1i c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3.<\/p>\n<h2>\ud83c\udfaf T\u00f3m t\u1eaft c\u00e1c th\u1ef1c h\u00e0nh t\u1ed1t nh\u1ea5t<\/h2>\n<p>T\u00f3m l\u1ea1i, c\u00e1ch ti\u1ebfp c\u1eadn v\u1edbi c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong thi\u1ebft k\u1ebf ERD:<\/p>\n<ul>\n<li>\n<p><strong>H\u1ecfi m\u1ecdi th\u1ee9:<\/strong>Kh\u00f4ng ch\u1ea5p nh\u1eadn c\u00e1c ph\u00e1t bi\u1ec3u c\u1ea5p cao m\u00e0 kh\u00f4ng t\u00ecm hi\u1ec3u chi ti\u1ebft.<\/p>\n<\/li>\n<li>\n<p><strong>T\u00e0i li\u1ec7u h\u00f3a c\u00e1c gi\u1ea3 \u0111\u1ecbnh:<\/strong> N\u1ebfu m\u1ed9t l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c \u0111\u01b0a ra d\u1ef1a tr\u00ean ph\u1ecfng \u0111o\u00e1n, h\u00e3y ghi l\u1ea1i n\u00f3.<\/p>\n<\/li>\n<li>\n<p><strong>Chu\u1ea9n h\u00f3a tr\u01b0\u1edbc:<\/strong>B\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t c\u1ea5u tr\u00fac chu\u1ea9n h\u00f3a s\u1ea1ch s\u1ebd v\u00e0 ch\u1ec9 thay \u0111\u1ed5i khi th\u1ef1c s\u1ef1 c\u1ea7n thi\u1ebft.<\/p>\n<\/li>\n<li>\n<p><strong>S\u1eed d\u1ee5ng b\u1ea3ng tra c\u1ee9u:<\/strong>Tr\u00e1nh ghi c\u1ee9ng c\u00e1c gi\u00e1 tr\u1ecb b\u00ean trong l\u01b0\u1ee3c \u0111\u1ed3.<\/p>\n<\/li>\n<li>\n<p><strong>L\u1eb7p l\u1ea1i:<\/strong>Xem thi\u1ebft k\u1ebf \u0111\u1ea7u ti\u00ean nh\u01b0 m\u1ed9t b\u1ea3n nh\u00e1p, ch\u1ee9 kh\u00f4ng ph\u1ea3i s\u1ea3n ph\u1ea9m cu\u1ed1i c\u00f9ng.<\/p>\n<\/li>\n<li>\n<p><strong>T\u1eadp trung v\u00e0o t\u00ednh to\u00e0n v\u1eb9n:<\/strong>Ch\u1ea5t l\u01b0\u1ee3ng d\u1eef li\u1ec7u quan tr\u1ecdng h\u01a1n t\u1ed1c \u0111\u1ed9 tri\u1ec3n khai.<\/p>\n<\/li>\n<\/ul>\n<p>B\u1eb1ng c\u00e1ch tu\u00e2n theo nh\u1eefng nguy\u00ean t\u1eafc n\u00e0y, c\u00e1c chuy\u00ean gia c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 th\u1ec3 v\u01b0\u1ee3t qua m\u00e0n s\u01b0\u01a1ng c\u1ee7a c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 v\u00e0 cung c\u1ea5p c\u00e1c ki\u1ebfn tr\u00fac d\u1eef li\u1ec7u v\u1eefng ch\u1eafc, m\u1edf r\u1ed9ng \u0111\u01b0\u1ee3c v\u00e0 d\u1ec5 b\u1ea3o tr\u00ec. M\u1ee5c ti\u00eau kh\u00f4ng ph\u1ea3i l\u00e0 d\u1ef1 \u0111o\u00e1n t\u01b0\u01a1ng lai, m\u00e0 l\u00e0 x\u00e2y d\u1ef1ng m\u1ed9t h\u1ec7 th\u1ed1ng linh ho\u1ea1t \u0111\u1ee7 \u0111\u1ec3 th\u00edch nghi khi t\u01b0\u01a1ng lai \u0111\u1ebfn.<\/p>\n<p>H\u00e3y nh\u1edb r\u1eb1ng m\u1ed9t l\u01b0\u1ee3c \u0111\u1ed3 \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf t\u1ed1t l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 giao ti\u1ebfp. N\u00f3 n\u00f3i chuy\u1ec7n v\u1edbi c\u00e1c nh\u00e0 ph\u00e1t tri\u1ec3n, c\u00e1c nh\u00e0 ph\u00e2n t\u00edch v\u00e0 c\u00e1c ch\u1ee7 doanh nghi\u1ec7p. Khi y\u00eau c\u1ea7u kh\u00f4ng r\u00f5 r\u00e0ng, l\u01b0\u1ee3c \u0111\u1ed3 ph\u1ea3i \u0111\u1ee7 r\u00f5 r\u00e0ng \u0111\u1ec3 \u0111\u1ecbnh h\u01b0\u1edbng \u0111\u1ed9i ng\u0169 ti\u1ebfn b\u01b0\u1edbc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u th\u01b0\u1eddng \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 nh\u01b0 c\u00e2y c\u1ea7u n\u1ed1i gi\u1eefa logic kinh doanh v\u00e0 tri\u1ec3n khai k\u1ef9 thu\u1eadt. Tuy nhi\u00ean, c\u00e2y c\u1ea7u n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c x\u00e2y&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1691,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_title":"H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3","_yoast_wpseo_metadesc":"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.","fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[68],"tags":[89,92],"class_list":["post-1690","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-design","tag-academic","tag-erd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3<\/title>\n<meta name=\"description\" content=\"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3\" \/>\n<meta property=\"og:description\" content=\"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\" \/>\n<meta property=\"og:site_name\" content=\"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-12T06:22:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1664\" \/>\n\t<meta property=\"og:image:height\" content=\"928\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"vpadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"vpadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\"},\"author\":{\"name\":\"vpadmin\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/#\/schema\/person\/d69595112293b803501f7b381be28255\"},\"headline\":\"C\u00e2u h\u1ecfi &#038; C\u00e2u tr\u1ea3 l\u1eddi: C\u00e1c DBA c\u1ea5p cao ti\u1ebfp c\u1eadn c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o?\",\"datePublished\":\"2026-04-12T06:22:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\"},\"wordCount\":4682,\"publisher\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg\",\"keywords\":[\"academic\",\"erd\"],\"articleSection\":[\"Database Design\"],\"inLanguage\":\"vi\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\",\"url\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3\",\"isPartOf\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg\",\"datePublished\":\"2026-04-12T06:22:17+00:00\",\"description\":\"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage\",\"url\":\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg\",\"contentUrl\":\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg\",\"width\":1664,\"height\":928},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.viz-note.com\/vi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e2u h\u1ecfi &#038; C\u00e2u tr\u1ea3 l\u1eddi: C\u00e1c DBA c\u1ea5p cao ti\u1ebfp c\u1eadn c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/#website\",\"url\":\"https:\/\/www.viz-note.com\/vi\/\",\"name\":\"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.viz-note.com\/vi\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/#organization\",\"name\":\"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates\",\"url\":\"https:\/\/www.viz-note.com\/vi\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2025\/03\/cropped-viz-note-logo.png\",\"contentUrl\":\"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2025\/03\/cropped-viz-note-logo.png\",\"width\":512,\"height\":512,\"caption\":\"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates\"},\"image\":{\"@id\":\"https:\/\/www.viz-note.com\/vi\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/#\/schema\/person\/d69595112293b803501f7b381be28255\",\"name\":\"vpadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/www.viz-note.com\/vi\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56e0eb902506d9cea7c7e209205383146b8e81c0ef2eff693d9d5e0276b3d7e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56e0eb902506d9cea7c7e209205383146b8e81c0ef2eff693d9d5e0276b3d7e3?s=96&d=mm&r=g\",\"caption\":\"vpadmin\"},\"sameAs\":[\"https:\/\/www.viz-note.com\"],\"url\":\"https:\/\/www.viz-note.com\/vi\/author\/vpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3","description":"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3","og_description":"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.","og_url":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/","og_site_name":"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates","article_published_time":"2026-04-12T06:22:17+00:00","og_image":[{"width":1664,"height":928,"url":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg","type":"image\/jpeg"}],"author":"vpadmin","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"vpadmin","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"23 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#article","isPartOf":{"@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/"},"author":{"name":"vpadmin","@id":"https:\/\/www.viz-note.com\/vi\/#\/schema\/person\/d69595112293b803501f7b381be28255"},"headline":"C\u00e2u h\u1ecfi &#038; C\u00e2u tr\u1ea3 l\u1eddi: C\u00e1c DBA c\u1ea5p cao ti\u1ebfp c\u1eadn c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o?","datePublished":"2026-04-12T06:22:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/"},"wordCount":4682,"publisher":{"@id":"https:\/\/www.viz-note.com\/vi\/#organization"},"image":{"@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg","keywords":["academic","erd"],"articleSection":["Database Design"],"inLanguage":"vi"},{"@type":"WebPage","@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/","url":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/","name":"H\u01b0\u1edbng d\u1eabn cho c\u00e1c DBA c\u1ea5p cao: X\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u ERD m\u01a1 h\u1ed3","isPartOf":{"@id":"https:\/\/www.viz-note.com\/vi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage"},"image":{"@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg","datePublished":"2026-04-12T06:22:17+00:00","description":"H\u1ecdc c\u00e1ch c\u00e1c DBA c\u1ea5p cao x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong qu\u00e1 tr\u00ecnh thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3. C\u00e1c chi\u1ebfn l\u01b0\u1ee3c \u0111\u1ec3 l\u00e0m r\u00f5 c\u00e1c quy t\u1eafc kinh doanh v\u00e0 m\u00f4 h\u00ecnh h\u00f3a d\u1eef li\u1ec7u.","breadcrumb":{"@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#primaryimage","url":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg","contentUrl":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2026\/04\/senior-dba-erd-ambiguity-infographic.jpg","width":1664,"height":928},{"@type":"BreadcrumbList","@id":"https:\/\/www.viz-note.com\/vi\/senior-dbas-approach-ambiguous-erd-requirements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.viz-note.com\/vi\/"},{"@type":"ListItem","position":2,"name":"C\u00e2u h\u1ecfi &#038; C\u00e2u tr\u1ea3 l\u1eddi: C\u00e1c DBA c\u1ea5p cao ti\u1ebfp c\u1eadn c\u00e1c y\u00eau c\u1ea7u m\u01a1 h\u1ed3 trong thi\u1ebft k\u1ebf s\u01a1 \u0111\u1ed3 quan h\u1ec7 th\u1ef1c th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o?"}]},{"@type":"WebSite","@id":"https:\/\/www.viz-note.com\/vi\/#website","url":"https:\/\/www.viz-note.com\/vi\/","name":"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates","description":"","publisher":{"@id":"https:\/\/www.viz-note.com\/vi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.viz-note.com\/vi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/www.viz-note.com\/vi\/#organization","name":"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates","url":"https:\/\/www.viz-note.com\/vi\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/www.viz-note.com\/vi\/#\/schema\/logo\/image\/","url":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2025\/03\/cropped-viz-note-logo.png","contentUrl":"https:\/\/www.viz-note.com\/vi\/wp-content\/uploads\/sites\/10\/2025\/03\/cropped-viz-note-logo.png","width":512,"height":512,"caption":"Viz Note Vietnamese - AI Insights &amp; Software Industry Updates"},"image":{"@id":"https:\/\/www.viz-note.com\/vi\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.viz-note.com\/vi\/#\/schema\/person\/d69595112293b803501f7b381be28255","name":"vpadmin","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/www.viz-note.com\/vi\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56e0eb902506d9cea7c7e209205383146b8e81c0ef2eff693d9d5e0276b3d7e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56e0eb902506d9cea7c7e209205383146b8e81c0ef2eff693d9d5e0276b3d7e3?s=96&d=mm&r=g","caption":"vpadmin"},"sameAs":["https:\/\/www.viz-note.com"],"url":"https:\/\/www.viz-note.com\/vi\/author\/vpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/posts\/1690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/comments?post=1690"}],"version-history":[{"count":0,"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/posts\/1690\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/media\/1691"}],"wp:attachment":[{"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/media?parent=1690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/categories?post=1690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.viz-note.com\/vi\/wp-json\/wp\/v2\/tags?post=1690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}