The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.<\/p>\n
Your database project must meet the following assessment requirements:<\/p>\n
Design and develop a database using professional principles and standards.<\/p>\n
\u2022 Provide a logical and physical design of the database. \u2022 Use relational database software application to develop database. \u2022 Provide an entity relationship diagram. \u2022 Normalize the database. \u2022 Generate and provide test data.<\/p>\n
Use a Microsoft\u00ae Visio\u00ae diagram to normalize the ERD to third normal form (3NF).<\/p>\n
Use 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.<\/p>\n
Note. 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.<\/p>\n
I have attached the week 3 Access 2010 database tables and the Visio non normalized ERD. I need this done by no later than 11:00PM MST 7 May and if possible by 11:30PM tonight.<\/p>\n","protected":false},"excerpt":{"rendered":"
The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment. Your database project must meet the following assessment requirements: Design and develop a database using professional principles and standards. \u2022 Provide a 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-75648","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/75648","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=75648"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/75648\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=75648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=75648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=75648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}