In This File You Will Find A List Of Database Projects
In This File You Will Find A List Of Database Project
In this file, you will find a list of database project ideas. You must choose one of them to design and implement. This project worth 10 marks, will be distributed as follows: design the database following an ER model (4 marks), normalize the tables (each table should be in 3NF at least) (2 marks), use MySQL or any other database to create the normalized tables and populate with at least 5 rows (2 marks), and execute the sample requested queries (2 marks). Each student must submit a report containing the ER diagram, schemas before and after normalization, SQL statements for creating tables, inserting data, and queries, along with screenshots from the database software showing table contents and query results.
Paper For Above instruction
The task involves selecting one of the provided database project ideas and developing a comprehensive database system, including design, normalization, implementation, and querying. The three project ideas include an Online Library Management System, an Online Hospital Management System, and a Blood Bank Organization Database. Each project requires meticulous planning and execution, adhering to database design principles and normalization rules to ensure data integrity and efficiency.
Online Library Management System
This system aims to manage book issuance for students and faculty within an academic environment. The database should store detailed information about books, students, teachers, departments, and courses. Each book will have an ID, title, author, number of copies, submission details, issue date, and duration. Students and teachers will have personal details such as ID, name, email, and department (for teachers). The system must record who issued a book, when, and the duration, along with fine details for overdue returns.
Designing this database involves creating entities such as Books, Students, Teachers, Departments, and Issues. The ER diagram will illustrate relationships, such as the association between students and books through issuing transactions. Breaking down this model into relational schemas, normalization to 3NF will eliminate redundancy and ensure data consistency. For example, separating author details into a dedicated table prevents duplication if multiple books share the same author.
Sample SQL statements include creating tables, inserting at least five rows for each entity, and running queries such as identifying who issued a specific book recently, students who returned books late, and unpaid fines. Screenshots from MySQL will validate the completeness and correctness of the implementation.
Online Hospital Management System (OHMS)
The OHMS seeks to automate hospital operations, handling patient admissions/discharges, appointment scheduling with doctors, and report management. The database will include entities like Patients, Doctors, Departments, Appointments, Tests, and Medical Store Inventory.
The design should capture details such as patient information, doctor specializations, departmental affiliations, and appointments. The database facilitates efficient scheduling based on availability and specialization. Additionally, stock management for medicines and test reports should be linked with transactional updates to reflect real-time inventory levels. Histories of patient records are maintained for reference.
Normalization of this schema ensures that each entity is stored efficiently without redundancy. Typical SQL operations include fetching admitted patients on a specific date, pending bill payments, doctors with specific specializations, and departmental earnings. These functionalities demonstrate practical management of hospital data through robust database design.
Blood Bank Organization Database
This project involves creating a database system to track blood donors, blood units, clinics, and employees within a blood bank organization. Donors are identified by unique IDs, and their personal data—name, contact, DOB, sex—is stored. Blood units are tracked via unique blood IDs, categorized by blood type and status, and linked to donors and storing clinics. Clinics are identified by unique name and location combinations, and employees are associated with specific clinics.
The design mandates relationships such as donors donating multiple times at various clinics, with blood units linked to donors and clinics. Employees work at particular clinics, and each entity should be normalized into 3NF for efficiency. Sample SQL queries include listing donors with certain blood types, locating clinics storing specific blood types, and filtering donors based on age and donation history.
Implementation involves creating normalized tables, inserting at least five data rows per table, and executing queries to test data retrieval logic. Including screenshots of table contents and query outputs assures correctness and completeness of the database system.
Conclusion
In any of these projects, the complete process includes designing the ER model, normalizing tables, implementing the schema in a suitable database system like MySQL, populating tables, and executing sample queries. Proper documentation and screenshots provide evidence of a well-structured and functional database system, demonstrating mastery of database design principles and practical implementation skills.