{"id":108055,"date":"2022-12-03T12:05:51","date_gmt":"2022-12-03T12:05:51","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/for-the-project-computer-science-homework-help\/"},"modified":"2022-12-03T12:05:51","modified_gmt":"2022-12-03T12:05:51","slug":"for-the-project-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/for-the-project-computer-science-homework-help\/","title":{"rendered":"For the project | Computer Science homework help"},"content":{"rendered":"<div>\n<p>\u00a0\u00a0<\/p>\n<p>For the project, you will be creating a database system to solve a business problem of<\/p>\n<p>your choice. The database system must meet the criteria shown below. In addition to the<\/p>\n<p>database solution, you will prepare a system summary.<\/p>\n<p>Database System Requirements:<\/p>\n<p>Create a database and name it ITCO630_GP3. Populate your database with<\/p>\n<p>appropriate test data.<\/p>\n<p>Include all of the scripts in a single file called ITCO630_GP3.SQL.<\/p>\n<p>Create at least three related tables in the database.<\/p>\n<p>Create at least two stored procedures and a script to use each of them.<\/p>\n<p>Create at least one view (using a script).<\/p>\n<p>Create at least one trigger.<\/p>\n<p>Create at least five useful queries. At least one of these queries should use a<\/p>\n<p>subquery and at least one of the queries should use an aggregate function.<\/p>\n<p>All scripts should be well documented.<\/p>\n<p>Individual Summary:<\/p>\n<p>In addition, you will prepare a summary document with the following information. This<\/p>\n<p>document will be submitted as a separate item along with the ZIP of the database and<\/p>\n<p>the associated files.<\/p>\n<p>1. a Word document describing the system<\/p>\n<p>2. an ERD or other graphical representation of the system<\/p>\n<p>3. a description of the views, stored procedures, triggers, and queries<\/p>\n<p>4. step-by-step instructions on how to run the queries that will demonstrate the<\/p>\n<p>functionality of the system<\/p>\n<p>5. a summary of strengths and weaknesses of the system, as designed<\/p>\n<p>You will submit the database, log file, query files in a zip file called ITCO630_GP.ZIP,<\/p>\n<p>and his or her own individual summary document as a separate submission. Please<\/p>\n<p>detach the database before creating the zip file.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0\u00a0 For the 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, you will prepare a system summary. Database System Requirements: Create a database and name it ITCO630_GP3. Populate your database with appropriate [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-108055","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=108055"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108055\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=108055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=108055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=108055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}