{"id":636,"date":"2021-05-04T17:55:53","date_gmt":"2021-05-04T21:55:53","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/?p=636"},"modified":"2021-05-04T17:55:53","modified_gmt":"2021-05-04T21:55:53","slug":"week-8-database-design-steps-prince-patel","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/2021\/05\/04\/week-8-database-design-steps-prince-patel\/","title":{"rendered":"Week 8 Database Design Steps &#8211; Prince Patel"},"content":{"rendered":"<h2 class=\"fusion-responsive-typography-calculated\" data-fontsize=\"29.184\" data-lineheight=\"36.48px\">How to Design Database: Steps of Designing Database<\/h2>\n<p>Database designing generally starts with identifying the purpose of your\u00a0database. The relevant data is then collected and organized into tables. Then, specify the primary keys and analyze relationships between different tables for an efficient data design. After refining the tables, the last step is to apply normalization rules for table standardization.<\/p>\n<ul>\n<li><strong>Define the objective of your database<\/strong><\/li>\n<li><strong>Locate and consolidate the necessary data<\/strong><\/li>\n<li><strong>Distribute the data into tables<\/strong><\/li>\n<li><strong>Change data items into columns<\/strong><\/li>\n<li><strong>Identify primary keys<\/strong><\/li>\n<li><strong>Determine how tables are related<\/strong><\/li>\n<li><strong>Enhance your database design<\/strong><\/li>\n<li><strong>Implement the normalization rules<\/strong><\/li>\n<\/ul>\n<p>ref- https:\/\/www.astera.com\/type\/blog\/all-you-need-to-know-about-database-design\/#:~:text=Database%20design%20is%20defined%20as,for%20the%20proposed%20database%20system.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Design Database: Steps of Designing Database Database designing generally starts with identifying the purpose of your\u00a0database. The relevant data is then collected and organized into tables. Then, specify the primary keys and analyze relationships between different tables for an efficient data design. After refining the tables, the last step is to apply normalization [&hellip;]<\/p>\n","protected":false},"author":12990,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[663943],"tags":[],"class_list":{"0":"post-636","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-instructor","7":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts\/636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/users\/12990"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/comments?post=636"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts\/636\/revisions"}],"predecessor-version":[{"id":637,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts\/636\/revisions\/637"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/media?parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/categories?post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/tags?post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}