MCIS 5113 DBMS Project Assignment 1 Objectives
MCIS 5113 Dbms Project Assignment 1 Objectives The Purpose Of
The purpose of this project is to improve the understanding of DBMS and improve the project execution ability by developing the actual use case of DBMS.
Students are required to complete a comprehensive project that demonstrates their knowledge and practical skills in designing, implementing, and presenting a database management system (DBMS). The project involves creating a detailed report, a demonstration, and a partial or complete implementation of a database application.
The project topics include, but are not limited to, a university database, payroll management system, health-related DBMS, salary management, medicine management, or any other DBMS project approved by the group members.
Project Report Requirements
The report should be between 10 to 15 pages and include the following components:
- Project Title & Author Information
- Abstract
- Introduction
- E-R Modeling
- Logical Database Design and the Relational Model
- Physical Database Design
- Implementation Methodology
- Create tables using MySQL
- Retrieve data via web applications (PHP, XML, JSP, or other tools)
- Experimental Results
- Conclusion
- References
Project Demonstration
Prepare slides for a 15-20 minutes presentation that describes your project work. The presentation should effectively communicate the project scope, design, implementation, and results.
Project Implementation
Choose some part or the entire scope of your project model to implement using tools such as MySQL, PHP, JSP, or other suitable frameworks. All source code along with introductory documentation must be uploaded to the designated platform (Blackboard). This documentation should verify the implementation and facilitate evaluation.
Academic Integrity Policy
All students are responsible for maintaining honesty in their academic work. Acts of dishonesty such as plagiarism, cheating, or fabrication of research results constitute academic misconduct and can lead to disciplinary actions.
Paper For Above instruction
This paper presents a comprehensive database management system (DBMS) project, emphasizing design, implementation, demonstration, and evaluation. The objective is to deepen students’ understanding of database concepts through practical application aligned with real-world scenarios such as university management, payroll, health records, or medicine management systems. The project incorporates stages from initial modeling to physical implementation, fostering both theoretical knowledge and practical skills.
Initially, students are expected to define a project scope and develop a detailed report outlining the design process, from conceptual ER modeling to logical and physical design. ER modeling involves identifying entities, relationships, and attributes relevant to the chosen system, which lays the foundation for logical schema development. The logical database design translates these models into relational schemas consistent with normalization principles, ensuring data integrity and efficiency.
The physical database design focuses on storage considerations, indexing, and optimization strategies suitable for the deployment environment. Implementation follows, where foundational tables are created using MySQL, demonstrated through web-based applications utilizing PHP, JSP, or XML for data retrieval and interaction. This process emphasizes practical skills in database querying, web development, and UI design, enabling students to connect theoretical models with functional applications.
The experimental phase involves testing the database system for correctness, performance, and usability. Results are documented, highlighting key observations and areas of improvement. The final report consolidates all work, including an introduction, methodology, results, and conclusions, providing a cohesive narrative of the project lifecycle.
Furthermore, students must prepare presentation slides summarizing their project, clearly illustrating the system architecture, design decisions, implementation steps, and outcomes. The oral demonstration validates the comprehensive understanding achieved through the project.
Overall, this assignment not only reinforces core database concepts but also cultivates project management, team collaboration, and communication skills essential for professional success. By engaging in hands-on development with real tools and environments, students bridge the gap between theoretical learning and industry practice.