DBMS Mini Projects Topics for Students 2019

0
2322

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 nameDescriptiontypelength
OrderedOrder IDint11
ProdidProduct IDint11
CusidCustomer IDint11
OrderDateDate orderedDate 
QuantityProduct quantityint11
PriceProduct priceint11

Table 5: tblproduct

Field namedescriptiontypeLength
ProdidProduct IDint11
ProdnameProduct nameVarchar30
ProddescProduct Descriptionvarchar30
QuantityProduct Quantityint11
PriceProduct priceint11

Table 6: tblsupplier

Field nameDescriptiontypeLength
SuppidSupplier IDint11
CnameCompany namevarchar50
ContactCompany contact no.int12
AddressCompany Addressvarchar50
EmailCompany Emailvarchar50

Table 7: tbluser

Field nameDescriptiontypeLength
UseridUser IDint20
FnameUser’s Firstnamevarchar30
LnameUser’s Lastnamevarchar30
AddressUser’s Addressvarchar30
ContactUser’s contact no.varchar20
RoleCompany positionvarchar15
UnameEmployee usernamevarchar50
PwordEmployee passwordvarchar50

Table 8: tblitem

Field nameDescriptiontypeLength
ItemidItem IDint11
SuppidSupplier IDint11
ProdnameProduct namevarchar30
ProddescProduct descriptionvarchar30
QuantityProduct quantityint11
PriceProduct priceint11
TotalpriceProduct total prizeint11

Table 9: tblcustomer

Field nameDescriptiontypeLength
CusidCustomer IDint11
FnameFirstnamevarchar30
LnameLastnamevarchar30
AddressCustomer Addressvarchar50
ContactCustomer contact no.int12

Table 10: tblpayment

Field namedescriptiontypeLength
PayidPayment IDint11
ProdidProduct IDint11
ProdnameProduct namevarchar30
CusidCustomer IDint11
CusnameCustomer namevarchar30
QuantityProduct quantityint11
PriceProduct priceint11
CreditCustomer’s moneyint11
DebitCustomers paymentint11
BalCustomer’s balanceint11
PaydateDate of paymentdate 

 


Table 11: tblshipment 

Field nameDescriptiontypeLength
Shipidshipment IDint11
SuppidSupplier IDint30
ItemidItem IDint30
DeliverydateDelivery datedate 

Table 12: tblinventory

Field nameDescriptiontypeLength
ItemidItem IDint11
ProdnameProduct namevarchar30
ProddescProduct Descriptionvarchar30
SuppidSupplier IDint11
QuantityProduct Quantityint11
PriceProduct priceint11
TotalprizeProduct total prizeint11
Datestockstock Datedate 
StockinStock in quantityint11
StockoutStockout quantityint11

 

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.TITLEPublisher
1Audio Visual Production Management SystemGerick Domaine Mabag
2Book Storage SystemJude Dela Cruz
3Bus Scheduling SystemNielmar Mangana
4Car Rental SystemPatrick Tangente
5Clinic Management SystemJude Angel Suarez
6Decorating SystemMary Grace Patulada
7Detainee Management SystemLeny Balidio
8Funeral Service SystemSaxon Ong
9Furniture Online Shopping SystemNiko Curaza
10Game Archive SystemLudwig Von Ferolin
11Hotel Reservation SystemMon Mendoza
12Hotel Reservation SystemMaribel Mayuga
13Library Management SystemElijah Galero
14Media Playlist Management SystemJoshua John Vallejera
15Online Cake Ordering SystemAdrian Mercurio
16Online Hotel Management SystemDieqohr Rufino
17Rehabilitation SystemBernhard Abadia
18Sales and Inventory SystemPrince Ly Cesar
19Sari-Sari Store SystemMelinda Nardo
20Shoe Store Management SystemCris Patulada
21Student Information SystemJuly King Cadayona
22FROZEN FOODS ORDERING SYSTEMEvangelista, Adones
23 WATER REFILLING STATIONEriman, Jeremy Kirk
24 JJCK 4KEEPS HOTEL MANAGEMENT SYSTEMMission, Kassandra
25MOTORCYCLE DELIVERY SYSTEMNiar, Paul
26FRUITS STAND MANAGEMENT SYSTEMPelobello, Carlan
27MOVIE TICKETING SYSTEMPositar, Dynah Mae
28Z HOSTEL MANAGEMENT SYSTEMSalde, Benny
29PHARMACY MANAGEMENT SYSTEMTanciano, Jinky
30CELLPHONE SYSTEMTingson, Armel
31HOTEL MANAGEMENT SYSTEMArnaiz, Ruth Ann
32FASTFOOD MANAGEMENT SYSTEMWong, Kevin
33MOTOR PARTS MANAGEMENT SYSTEMAguirre, Cristy
34RESORT MANAGEMENT SYSTEMAlarcon, Jahzel
35BALASAN DELIVERY SYSTEMBandiola, Daniel
36HOTEL RESERVATION MANAGEMENT SYSTEMTuma-ob, Jestoni
37PIZZA SYSTEMBariacto, Given
38LAUNDRY MANAGEMENT SYSTEMBautista, Caren
39AJ APPLIANCE MANAGEMENT SYSTEMBosque, April
40RENCE RESTAURANT MANAGEMENT SYSTEMDalmacio, Clarence
41MINI STORE MANAGEMENT SYSTEMDela cuz, Rowena
42HOSPITAL MANAGEMENT SYSTEMDongcoy, Shella May
43JOB ORDER SYSTEMDulla, Jomhel
44WATER REFILLING STATION SYSTEMMana-ay, Ryan Christian
45GYM MANAGEMENT SYSTEMGomez, Karl Angelo
46PETSHOP MANAGEMENT SYSTEMFlores, Maria
47BOUTIQUE STORE MANAGEMENT SYSTEMJimenez, Gladys
48SALON MANAGEMENT SYSTEMMabasa, Lenny Jane
49ABENDANIO HARDWARE SYSTEMAbendanio, Deseree
50PERSONAL COLLECTION POINT OF SALE SYSTEMMatillano, Kimmy

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

Another List of Database Design Examples

51Zathur’s Pizza Delivery Management System Hermila Claire T. Colimbo
52Binalbagan Pension House Management System 
53Reservation Management  SystemNierrize Joy F. Dollosa
54Shek Water Refilling Management SystemJoan Marie O. Delweste
55Bakery Shop And Delivery SystemNelgen P. Docto
56Lechon Manok Delivery SystemRyan A. Patenio
57Tsong Joey Tambayan Sales And Product inventoryRomie Girl Arsaga
58Waling-waling Resort Monitoring And Reservation SystemDesirre P. Bacong
59Soledad Funeral Homes Management SystemTraci O. Villanueva
60CHMSC Binalbagan Janitorial Task Management System Ruela J. Berio
61Jessa and Rhoem Mini-Salon SystemJaymar Celestial
62Ven Madalogdog Reservation SystemKathleen Mae Barral
63Libas National High School Automated Enrolment SystemMikhaela  Magbanua
64Rice Delivery Sales And Inventory management SystemApril May Gargarita
65Barangay Mansablay Elementary School 
66Automated Enrolment SystemSheena P. Alojado
67Berto’s Meat Shop Sales And Inventory SystemMark Jade Fortaleza
68Quarry Monitoring And Inventory SystemJethro Villaverde
69Cellphone Shop Sales And Inventory SystemTed Lawrence Pahilanga
70Rice Delivery Management SystemDennis Octavio Jr
71Gancio’s Rice Mill Sales And Inventory SystemSheena 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.

Leave a Reply

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