Database 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.
- Create a database and name it ITCO630_GPx where “x” is your group letter. Populate your database with appropriate test data.
- Include all of the scripts in a single file called ITCO630_GPx.SQL where x is your group letter.
- Create at least 3 related tables in the database.
- Create at least 2 stored procedures and a script to use each of them.
- Create at least 1 view (using a script).
- Create at least 1 trigger.
- 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.
- All scripts should be well-documented.
-
- A Word document describing the system
- An ERD or other graphical representation of the system
- A description of the views, stored procedures, triggers, and queries
- Step-by-step instructions on how to run the queries that will demonstrate the functionality of the system
- A summary of strengths and weaknesses of the system, as designed
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
