10+ database project ideas

To build any application you need to work with large data and you need to manage this data. To manage data we use database such as Oracle database, Microsoft database, MySQL database etc. We store our data in database. To retrieve or extract data we use SQL query. The SQL query are same for all database. In this discussion I give you some database project idea. Before describing project idea I give you some useful information.
First of all you need to think. Think what problem you want to solve? In your area or in your country, there are many kinds of unsolved problem. Try to solve it do not think firstly how this problem will be implemented in database. Such that in my school life our school librarian maintain our school library using paper. This process is time consuming. To solve this problem I just think automated online library management system.

When your thinking is completed. Then you need to do some paper work. Try to sketch some diagram and think how to solve that problem using diagram. You need to draw E-R( Entity -Relationship) diagram to understand each data and their attributes. E-R diagram is very important for any database project. Here I give you some database project idea.

Blood Management System :
In blood management system you need to collect donor information, hospital information, doctors information, blood bag information etc. This donor, hospital information are the entity name and you need to sketch up the relationship between this entity set. Try it I think it is one of good project.
Extra curriculum activities management of school :
In modern time schools are not only concern formal education but also concern extra curriculum activities. As a result many cultural clubs are established. Such as debating club, language club, signing and dancing club and so on. I think it is another good database project. 
E-Exam Management System : 
If your school, college or universities follow paper based exam system. It is the chance for you to make good impression. You need to maintain exam paper, student information, marks distribution system and so on.
Hospital Management System :
The database management system for a hospital is one of the tremendous idea. You need to make doctors list, patient list, nurse list and so on.  
Shop Management System :
Shop management system is old idea but not bad. You need to maintain customers information, customers shipping information, product information etc. This project easy but valuable.
Banking System :
Now a days banking database management system become a vast sector in the world. Banking data management system is the perfect example for database system. It's a challenging work. I think to do this project you can learn many things.
E-Library
Think of your school or university library management system. How can librarian handle books?
Take this work as a challenge.

Task Management System
Hotel Management System
E-Ticket System
Electricity Bill Payment System
Database Management System for Stock Exchange
E-Tender Management System etc are the famous project idea on database management system. If you have any idea please share it.

Comments

Post a Comment

Popular posts from this blog

How to construct a B+ tree with example

Image
A B+ tree contains n-1 search key values K1K2…….Kn-1 and have n pointers.   In a B+ tree the data are ordered  sequentially.  The leaf node may hold up to n pointers and must hold at least N/2 pointers. The root node must hold at least two pointers, unless the tree consists of only one node.  Now we construct a B+ tree. Construct a B+ tree for the following set of key values: (2,3,5,7,11,17,19,23,29,31) Assume that the tree is initially empty and values are added in ascending order. Construct a B+ tree where the pointer number is Four. Solution: When a node exceeds n-1 search key value then we split it into two nodes. First node contains (ceiling(n-1)/2) values.  2 nd node contains remaining node. Copy the smallest search key value of the second node to the parent node. Let's start, we know each node has N pointer and has N-1 search key values. In our example pointer number is 4, so the search key value is 4-1=3. So each node has 4 pointers and 3 search key value. The first node i
Read more

How to show only month and year fields in android Date-picker?

Image
Android default DatePicker show day/month/year fields but you have to customize this DatePicker as your requirements. Suppose that you want to show only month and year fields in android datepicker . To do this, you have to customize the Dialog DatePicker source code but it is not an easy task. In this tutorial I will show you a tricky way to solve this problem. Lets see how to show only month and year field in android DatePicker as a dialog.   Step to show only month and year fields in android date-picker: Some days ago I got this same problem and here I am trying to explain this in a sequential manner. I want to show a dialog datepicker when user click on an EditText. So if user click on EditText, A dialog datepicker will be invocked and it will show only month and year fields. To do this, at first we have to create a xml layout to hold the EditText fields. So create an android project and name it DatePickerExample. In the main.xml file just try to write this simple code.  main.xml
Read more

Visitor Counter Script Using PHP

Image
If you have noticed that many websites display their total numbers of visitors.In this tutorial I am going to explain you how to create a simple visitor counter using php. For this, 1) Create one table called “visitor_counter” in your database. 2) Create file named “counter.php”. Step1: Creating “visitor_counter” Table CREATE TABLE `visitor_counter` ( `counts` int(10) NOT NULL default '0' ) Step2: Creating “counter.php” File <?php  // Database Details $host="localhost"; $username="root"; $password=""; $db_name="test"; $tbl_name="visitor_counter"; // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect to server "); mysql_select_db("$db_name")or die("cannot select DB");  $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); $counter=$rows['counts']; // se
Read more