DBMS Mini Projects Topics for Students 2019

0
436

DBMS Mini Projects Topics for Students 2019

DBMS Mini Project Topics is a collection of projects in Database that contain different management system from various agencies and company.  

This DBMS mini project topic is best for those students in the field of computer science or Information Technology.

The DBMS mini project uploaded will give a lot of database project ideas.

These database ideas will assist students in developing their simple project management software.

All SQL database projects with source code are free to download. The simple database project ideas can help to build the latest project topics for computer science.

Sample Database Design Project Outline

Time needed: 2 minutes.

Database Design Project Example Outline

  1. Title Page

    In the title page, you have to write your desired title for your project. Example: Sales and Inventory System

  2. Table of contents

    In this section, You have to write the outline for your table of contents.

  3. System Description

    For system description, you have to write at least a minimum of 200 words.

  4. Data Dictionaries

    For Data Dictionaries, you have to write the descriptive details of each field in every table. (see example tables below)

  5. Entity Relationship Diagram

    You have to draw an ER diagram that supports your system. (See examples below)

  6. Select Statements using Different Functions

    In select Statement using different functions, you to create questions and you have to provide solution in a query form. Minimum of 20 Select Statements(See Example Image below).
    Select Statements using Different functions

  7. Select Statements using Sub Query (Minimum of 3)

    Same with outline number 6. You have to provide questions with solutions. (see example below)
    Select Statements using Sub query

  8. Select Statements using Count and Group Functions (Minimum of 2)

    Do the same what we did in number 6 and 7.

  9. Select Statements using Different Joins (Minimum of 5)

    Do the same what we did in number 6 and 7.

  10. Insert Statement (Minimum of 5)

    Do the same what we did in number 6 and 7.

  11. Update Statement (Minimum of 5)

    Do the same what we did in number 6 and 7.

  12. Delete Statement (Minimum of 5)

    Do the same what we did in number 6 and 7.

  13. Appendices

Most of the Database ERD uploaded here are designed using PHPMyAdmin Database design tool.

Database design tables

This section will show you some examples of the database design tables.

Table4: tblorder

Field name Description type length
Ordered Order ID int 11
Prodid Product ID int 11
Cusid Customer ID int 11
OrderDate Date ordered Date  
Quantity Product quantity int 11
Price Product price int 11

Table 5: tblproduct

Field name description type Length
Prodid Product ID int 11
Prodname Product name Varchar 30
Proddesc Product Description varchar 30
Quantity Product Quantity int 11
Price Product price int 11

Table 6: tblsupplier

Field name Description type Length
Suppid Supplier ID int 11
Cname Company name varchar 50
Contact Company contact no. int 12
Address Company Address varchar 50
Email Company Email varchar 50

Table 7: tbluser

Field name Description type Length
Userid User ID int 20
Fname User’s Firstname varchar 30
Lname User’s Lastname varchar 30
Address User’s Address varchar 30
Contact User’s contact no. varchar 20
Role Company position varchar 15
Uname Employee username varchar 50
Pword Employee password varchar 50

Table 8: tblitem

Field name Description type Length
Itemid Item ID int 11
Suppid Supplier ID int 11
Prodname Product name varchar 30
Proddesc Product description varchar 30
Quantity Product quantity int 11
Price Product price int 11
Totalprice Product total prize int 11

Table 9: tblcustomer

Field name Description type Length
Cusid Customer ID int 11
Fname Firstname varchar 30
Lname Lastname varchar 30
Address Customer Address varchar 50
Contact Customer contact no. int 12

Table 10: tblpayment

Field name description type Length
Payid Payment ID int 11
Prodid Product ID int 11
Prodname Product name varchar 30
Cusid Customer ID int 11
Cusname Customer name varchar 30
Quantity Product quantity int 11
Price Product price int 11
Credit Customer’s money int 11
Debit Customers payment int 11
Bal Customer’s balance int 11
Paydate Date of payment date  

 


Table 11: tblshipment 

Field name Description type Length
Shipid shipment ID int 11
Suppid Supplier ID int 30
Itemid Item ID int 30
Deliverydate Delivery date date  

Table 12: tblinventory

Field name Description type Length
Itemid Item ID int 11
Prodname Product name varchar 30
Proddesc Product Description varchar 30
Suppid Supplier ID int 11
Quantity Product Quantity int 11
Price Product price int 11
Totalprize Product total prize int 11
Datestock stock Date date  
Stockin Stock in quantity int 11
Stockout Stockout quantity int 11

 

Note: This is just one(1) example of the Database Design in MySQL listed below. You can find and download lots of database design examples uploaded here.

Sample ER Diagram in DBMS mini Projects

In this section, I only show you some of the ERD examples available of the database design listed below.

DBMS mini Project Topics ER Diagram For Library Management System
ER Diagram For Library Management System

ER Diagram for Hospital Management System
Database Design for Clinic Management System
water refilling station database design with tables
water refilling station database design with tables

DBMS mini Project Topics Database Design project
Frozen Foods Ordering System Database Design

Entity Relationship Diagram of Sales and Inventory System
Entity Relationship Diagram of Sales and Inventory System

ER Diagram for Hospital Management System
Database Design for Clinic Management System

List of DBMS Mini Project Topics

No. TITLE Publisher
1 Audio Visual Production Management System Gerick Domaine Mabag
2 Book Storage System Jude Dela Cruz
3 Bus Scheduling System Nielmar Mangana
4 Car Rental System Patrick Tangente
5 Clinic Management System Jude Angel Suarez
6 Decorating System Mary Grace Patulada
7 Detainee Management System Leny Balidio
8 Funeral Service System Saxon Ong
9 Furniture Online Shopping System Niko Curaza
10 Game Archive System Ludwig Von Ferolin
11 Hotel Reservation System Mon Mendoza
12 Hotel Reservation System Maribel Mayuga
13 Library Management System Elijah Galero
14 Media Playlist Management System Joshua John Vallejera
15 Online Cake Ordering System Adrian Mercurio
16 Online Hotel Management System Dieqohr Rufino
17 Rehabilitation System Bernhard Abadia
18 Sales and Inventory System Prince Ly Cesar
19 Sari-Sari Store System Melinda Nardo
20 Shoe Store Management System Cris Patulada
21 Student Information System July King Cadayona
22 FROZEN FOODS ORDERING SYSTEM Evangelista, Adones
23  WATER REFILLING STATION Eriman, Jeremy Kirk
24  JJCK 4KEEPS HOTEL MANAGEMENT SYSTEM Mission, Kassandra
25 MOTORCYCLE DELIVERY SYSTEM Niar, Paul
26 FRUITS STAND MANAGEMENT SYSTEM Pelobello, Carlan
27 MOVIE TICKETING SYSTEM Positar, Dynah Mae
28 Z HOSTEL MANAGEMENT SYSTEM Salde, Benny
29 PHARMACY MANAGEMENT SYSTEM Tanciano, Jinky
30 CELLPHONE SYSTEM Tingson, Armel
31 HOTEL MANAGEMENT SYSTEM Arnaiz, Ruth Ann
32 FASTFOOD MANAGEMENT SYSTEM Wong, Kevin
33 MOTOR PARTS MANAGEMENT SYSTEM Aguirre, Cristy
34 RESORT MANAGEMENT SYSTEM Alarcon, Jahzel
35 BALASAN DELIVERY SYSTEM Bandiola, Daniel
36 HOTEL RESERVATION MANAGEMENT SYSTEM Tuma-ob, Jestoni
37 PIZZA SYSTEM Bariacto, Given
38 LAUNDRY MANAGEMENT SYSTEM Bautista, Caren
39 AJ APPLIANCE MANAGEMENT SYSTEM Bosque, April
40 RENCE RESTAURANT MANAGEMENT SYSTEM Dalmacio, Clarence
41 MINI STORE MANAGEMENT SYSTEM Dela cuz, Rowena
42 HOSPITAL MANAGEMENT SYSTEM Dongcoy, Shella May
43 JOB ORDER SYSTEM Dulla, Jomhel
44 WATER REFILLING STATION SYSTEM Mana-ay, Ryan Christian
45 GYM MANAGEMENT SYSTEM Gomez, Karl Angelo
46 PETSHOP MANAGEMENT SYSTEM Flores, Maria
47 BOUTIQUE STORE MANAGEMENT SYSTEM Jimenez, Gladys
48 SALON MANAGEMENT SYSTEM Mabasa, Lenny Jane
49 ABENDANIO HARDWARE SYSTEM Abendanio, Deseree
50 PERSONAL COLLECTION POINT OF SALE SYSTEM Matillano, Kimmy

*Note: Uploading of Database design are still ongoing. Just keep in touch. 

Another List of Database Design Examples

51 Zathur’s Pizza Delivery Management System  Hermila Claire T. Colimbo
52 Binalbagan Pension House Management System  
53 Reservation Management  System Nierrize Joy F. Dollosa
54 Shek Water Refilling Management System Joan Marie O. Delweste
55 Bakery Shop And Delivery System Nelgen P. Docto
56 Lechon Manok Delivery System Ryan A. Patenio
57 Tsong Joey Tambayan Sales And Product inventory Romie Girl Arsaga
58 Waling-waling Resort Monitoring And Reservation System Desirre P. Bacong
59 Soledad Funeral Homes Management System Traci O. Villanueva
60 CHMSC Binalbagan Janitorial Task Management System  Ruela J. Berio
61 Jessa and Rhoem Mini-Salon System Jaymar Celestial
62 Ven Madalogdog Reservation System Kathleen Mae Barral
63 Libas National High School Automated Enrolment System Mikhaela  Magbanua
64 Rice Delivery Sales And Inventory management System April May Gargarita
65 Barangay Mansablay Elementary School  
66 Automated Enrolment System Sheena P. Alojado
67 Berto’s Meat Shop Sales And Inventory System Mark Jade Fortaleza
68 Quarry Monitoring And Inventory System Jethro Villaverde
69 Cellphone Shop Sales And Inventory System Ted Lawrence Pahilanga
70 Rice Delivery Management System Dennis Octavio Jr
71 Gancio’s Rice Mill Sales And Inventory System Sheena Mae Aycayno

*Note: More database Design examples to Follow
From this
simple database project ideas uploaded here, you will be able to understand the underlying database design principles.
Conclusion

With this database design principles, you can now innovate database project ideas using the database design concepts.

If you have any questions or suggestion, please feel free to contact us or leave a comment below.

Quick answers FAQ

Here’s a quick FAQ to highlight some key concepts.

What is DBMS Mini Project Topics?

DBMS Mini Project Topics is a collection of projects in Database that contain different management system from various agencies and company.  

Who can benefits from this DBMS Mini Project Topics?

This DBMS mini project topic is best for those students in the field of computer science or Information Technology. Through this database ideas,  they are able to do their simple project management software.

Facebook Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.