DBMS Mini Projects Topics for Students 2020

    0
    5384

    DBMS Mini Projects Topics for Students 2020

    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.

    Looking for more source code? Type your keyword here here!

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here

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