{"id":428719,"date":"2018-10-06T19:51:35","date_gmt":"2018-10-06T19:51:35","guid":{"rendered":"https:\/\/acemystudy.com\/?p=7869"},"modified":"2018-10-24T08:30:45","modified_gmt":"2018-10-24T08:30:45","slug":"database-system-design-and-implementation-stored-procedures-and-triggers","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/database-system-design-and-implementation-stored-procedures-and-triggers\/","title":{"rendered":"Database system design and implementation Stored Procedures and Triggers"},"content":{"rendered":"<p>Database system design and implementation Stored Procedures and Triggers<\/p>\n<p>Group Project<\/p>\n<p>For the group project, you will be creating a database system to solve a business problem of your choice. The database system must meet the criteria shown below. In addition to the database solution, each student will prepare a system summary.<\/p>\n<p>Database System Requirements (Group Work):<\/p>\n<ul>\n<li>Create a database and name it ITCO630_GPx where &#8220;x&#8221; is your group letter. Populate your database with appropriate test data.<\/li>\n<li>Include all of the scripts in a single file called ITCO630_GPx.SQL where x is your group letter.<\/li>\n<li>Create at least 3 related tables in the database.<\/li>\n<li>Create at least 2 stored procedures and a script to use each of them.<\/li>\n<li>Create at least 1 view (using a script).<\/li>\n<li>Create at least 1 trigger.<\/li>\n<li>Create at least 5 useful queries. At least one of these queries should use a subquery and at least 1 of the queries should use an aggregate function.<\/li>\n<li>All scripts should be well-documented.<\/li>\n<\/ul>\n<p>Individual Summary:<\/p>\n<p>In addition to the group work described above, each group member will prepare a summary document with the following information. This document will be submitted as a separate item along with the ZIP of the database and the associated files. Do not submit a single group document. This document must be created individually, and copying from other group members is not allowed. Your assignment must include the following:<\/p>\n<ul>\n<li>A Word document describing the system<\/li>\n<li>An ERD or other graphical representation of the system<\/li>\n<li>A description of the views, stored procedures, triggers, and queries<\/li>\n<li>Step-by-step instructions on how to run the queries that will demonstrate the functionality of the system<\/li>\n<li>A summary of strengths and weaknesses of the system, as designed<\/li>\n<\/ul>\n<p>Each student will submit the database, log file, and query files in a zip file called ITCO630_GP.ZIP, and his or her own individual summary document as a separate submission. Please detach the database before creating the zip file.<\/p>\n<p>I&#8217;m just doing the individual portion<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database system design and implementation Stored Procedures and Triggers Group Project For the group project, you will be creating a database system to solve a business problem of your choice. The database system must meet the criteria shown below. In <a href=\"https:\/\/www.benedictsol.com\/blogs\/database-system-design-and-implementation-stored-procedures-and-triggers\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-428719","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/428719","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=428719"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/428719\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=428719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=428719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=428719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}