The following assignment is based on the database environment proposed in the Week One Individual Assignment.<\/p>\n
Perform<\/strong> a logical design on the proposed database environment without going through the full normalization process.\u00a0 Include the identification of all entities and attributes associated with the environment.<\/p>\n Create<\/strong> a 1-page memo to document your logical design including the process you went through.<\/p>\n Discuss<\/strong> the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.<\/p>\n Create<\/strong> a detailed Entity Relationship Diagram (ERD) using the data specifications from the logical design. Use Microsoft\u00ae<\/span><\/sup> Visio\u00ae<\/span><\/sup>, Lucidchart, or another software tool of your choice to create this diagram.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" The following assignment is based on the database environment proposed in the Week One Individual Assignment. Perform a logical design on the proposed database environment without going through the full normalization process.\u00a0 Include the identification of all entities and attributes Read More …<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-389","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=389"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/389\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}