Practicum Project 2 Due On 11/23/2019: The Purpose Of The Da
Practicum Project 2 Due On 11232019the Purpose Of The Database Ter
The purpose of the database term project is to understand topics covered in class and apply it to a real life problem. The students are free to pick any topic. The goal is to create a database and demonstrate different aspects of how this database can be utilized to accomplish different requests. The term project is composed with 3 components: 1. Practicum Project Part .
Practicum Project Part . Final Project + Presentation Some project ideas include (but not limited to): Inventory control management database project student record keeping system database project online retail application database project hospital management system database project payroll management system database project
For the second component, these are the requirements: The database (it is okay if not all data is in the tables) SQL scripts for different tasks (make sure JOIN operators, SUBQUERY, and relational SET operators are used for your scripts)
Paper For Above instruction
The objective of this practicum project is to develop a comprehensive database system that effectively models a real-world scenario, demonstrating proficiency in database design, SQL scripting, and relational algebra. The project allows students to choose a domain of interest—such as inventory control, student records, online retail, hospital management, or payroll systems—and build a functional database that can handle various data management tasks and queries.
In undertaking this project, the initial step involves conceptualizing the database schema, including identifying entities, relationships, attributes, and constraints. For example, in an inventory control management system, entities might include Products, Suppliers, Warehouses, and Orders, while relationships could cover which suppliers provide specific products or how products are stored across warehouses. Proper normalization should be applied to minimize redundancy and ensure data integrity.
Following schema design, the focus shifts to implementation. Using a relational database management system such as MySQL, PostgreSQL, or SQL Server, students will create the necessary tables and populate them with representative data. Although not all data needs to be entered, the dataset should be sufficient to support a variety of meaningful SQL queries.
The core of the project requires students to develop and demonstrate different SQL scripts demonstrating their understanding of key relational database concepts. The scripts should include complex queries that utilize JOIN operators to combine data from multiple tables, subqueries to perform nested data retrieval, and relational SET operators like UNION, INTERSECT, and EXCEPT to compare or merge datasets.
The final deliverables include the completed database, an organized set of SQL scripts illustrating diverse tasks—such as searching, updating, and reporting data—and a presentation that explains the database design, demonstrates SQL queries, and discusses how the system can be used in a real-world context. The presentation should highlight the reasoning behind schema design choices, showcase sample outputs from SQL scripts, and address potential improvements or extensions.
This practicum project not only reinforces theoretical knowledge but also emphasizes practical skills in designing and manipulating relational databases. It prepares students to handle real-life data management challenges and improves their ability to communicate complex database concepts effectively.