The document provides instructions for a database mini project for an MCA course. Students must form groups of five and design a database application to solve a defined problem, such as e-commerce, railway systems, or faculty management. They are instructed to understand the problem, conduct a feasibility study, gather requirements, design the database using an application like Oracle or MySQL, and build a front-end application using a language like Java, PHP, or Python. Finally, students must create a project report that documents the system analysis, feasibility study, tools used, entity relationship diagram, data dictionary, software interface, and testing.
The document provides instructions for a database mini project for an MCA course. Students must form groups of five and design a database application to solve a defined problem, such as e-commerce, railway systems, or faculty management. They are instructed to understand the problem, conduct a feasibility study, gather requirements, design the database using an application like Oracle or MySQL, and build a front-end application using a language like Java, PHP, or Python. Finally, students must create a project report that documents the system analysis, feasibility study, tools used, entity relationship diagram, data dictionary, software interface, and testing.
The document provides instructions for a database mini project for an MCA course. Students must form groups of five and design a database application to solve a defined problem, such as e-commerce, railway systems, or faculty management. They are instructed to understand the problem, conduct a feasibility study, gather requirements, design the database using an application like Oracle or MySQL, and build a front-end application using a language like Java, PHP, or Python. Finally, students must create a project report that documents the system analysis, feasibility study, tools used, entity relationship diagram, data dictionary, software interface, and testing.
The document provides instructions for a database mini project for an MCA course. Students must form groups of five and design a database application to solve a defined problem, such as e-commerce, railway systems, or faculty management. They are instructed to understand the problem, conduct a feasibility study, gather requirements, design the database using an application like Oracle or MySQL, and build a front-end application using a language like Java, PHP, or Python. Finally, students must create a project report that documents the system analysis, feasibility study, tools used, entity relationship diagram, data dictionary, software interface, and testing.
DEPARTMENT OF MATHEMATICAL AND COMPUTATIONAL SCIENCES
NATIONAL INSTITUTE OF TECHNOLOGY KARNATAKA, SURATHKAL
MA611 – MCA 2 nd Semester, 2022
DATABASE MANAGEMENT SYSTEMS LAB (MINI PROJECT) Total Marks: 50 Design and construct a database together with a front-end application, to handle the defined problem. Create a project report for documentation. Follow the instructions for the project: ➢ Form a team of five students ➢ Identify the problem that involves data processing (For example: E-commerce platform, railway system, blood donation management, payroll management system, faculty and student management in educational institution, restaurant management system etc.) ➢ Understand the problem, study the existing system and prepare a problem description and present drawbacks of existing system and scope of the proposed system ➢ Carry out feasibility study of proposed system ➢ Identify the users of the system ➢ Gather data requirements and functional requirements ➢ Identify entities and their attributes and draw Entity Relationship Diagrams ➢ Create data dictionary and design the database using any DBMS application (Oracle, MySql or any other similar dbms package) ➢ Create an application using any programming or scripting language with database such as Java, C#, PHP, Python, or any other similar front-end tool ➢ All applications must be demonstrated on desktop/laptop as a stand -alone or web-based application ➢ Create a project report for documentation having the following sections: ▪ Title Page ▪ Contents ▪ Introduction ▪ System Analysis o Existing system o Proposed system ▪ Feasibility Study o Technical Feasibility o Economic Feasibility ▪ Tools and Platforms Used o Hardware Configuration o Software Configuration ▪ Entity Relationship Diagram ▪ Data Dictionary ▪ Software Interface ▪ Software Testing ▪ Bibliography