Group Project: You Will Be Creating A Da
Group Projectfor The Group Project You Will Be Creating A Database Sy
Group project to create a database system that addresses a specific business problem, including creating and populating the database, writing scripts, and preparing system documentation and analysis. Each student must also prepare an individual summary report.
Paper For Above instruction
The assignment involves developing a comprehensive database system tailored to solve a particular business problem selected by the group. The project encompasses multiple technical components such as creating the database with an appropriate naming convention, populating it with test data, and scripting all database operations into a single SQL file. Specifically, the database should include at least three related tables, with the creation of two stored procedures and associated scripts demonstrating their use. Additionally, the system must incorporate a view, a trigger, and at least five queries fulfilling specific criteria—one using a subquery and another employing an aggregate function.
Designing and documenting the database is essential, including producing a well-annotated script that consolidates all SQL commands into `ITCO630_GPx.SQL`, where "x" denotes the group letter. A graphical representation, such as an Entity Relationship Diagram (ERD), should accompany the documentation to visualize the system’s structure. Clear instructions should be provided on executing the queries to showcase system functionality, demonstrating the use of stored procedures, views, and triggers within the context of the database.
Beyond the technical development, individual students are required to produce a comprehensive Word document that describes the system's design, functionality, and analysis. This report should include a graphical ERD, detailed explanations of the views, stored procedures, triggers, and queries, along with step-by-step instructions for executing key system operations. Furthermore, each report must contain a critical assessment of the system’s strengths and weaknesses.
All project components—database, SQL scripts, log files, queries, and individual reports—must be compiled into a ZIP archive named `ITCO630_GP.ZIP`, with the database PostgreSQL detached before archiving. Each student’s individual report should be submitted separately, ensuring originality and avoiding plagiarism from peers.
This project encourages thorough documentation, clear presentation, and critical analysis, fostering both technical skills and strategic understanding of database design principles in a business context. Comprehensive use of course resources, web tools, and academic references is encouraged to enhance design accuracy and scholarly rigor.
References
- Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Addison-Wesley.