The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.\t\u00a0\tYour database project must meet the following assessment requirements:\t\u00a0\tDesign and develop a database using professional principles and standards.\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Provide a logical and physical design of the database.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Use relational database software application to develop database.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Provide an entity relationship diagram.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Normalize the database.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Generate and provide test data.\t\u00a0\tUse a Microsoft\u00ae Visio\u00ae diagram to normalize the ERD to third normal form (3NF).\t\u00a0\tUse the Microsoft\u00ae Access\u00ae database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.\t\u00a0\tNote. Only the Microsoft\u00ae Visio\u00ae diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft\u00ae Access\u00ae database.\t\u00a0\tSubmit the ERD and final database to the appropriate Assignment link.<\/p>\n","protected":false},"excerpt":{"rendered":"
The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment. \u00a0 Your database project must meet the following assessment requirements: \u00a0 Design and develop a database using professional principles and standards. \u00a0 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-209763","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209763","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=209763"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209763\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=209763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=209763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=209763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}