Basic College Management System Using SQL Plus

1
1733

Here I am going to illustrate how to create a college management system using basic SQL commands. DDL and DML are the two major parts of SQL. We need to understand simple database operations like SELECT, UPDATE,DELETE and INSERT INTO.

The SELECT command is sued to “select” an item from the database. In a college management system, we need to clearly specify fields for:

  • Student Details
  • Fee Structure
  • College Profile
  • Course Details

Now let us draw the Data Flow Diagram so that you will get a better idea about what I am talking about.

Data Flow Diagram:

1. Level 0:

 

sql-plus

2. Level 1

college-management-system

3. Level 2

DFD-college database-systems

 

1. Creating  a Table

sql-table-creation

Inserting into Table

sql-plus-help

View Table (College Profile)

mini-project-download

 Update Table (Course Details)

university-database-creation

These are just basic operations. It differs according to your requirements and the nature of college details. You can just try out these simple operations in Oracle SQL Plus before trying out complex ones.

[wp_ad_camp_1]

SHARE
Previous articleMicrosoft Surface Tablet Vs iPad Specs
Next articleIntel Core i7-3920XM 3rd Generation Processor Specs
Jesna is an assistant professor, digital marketing strategist and professional blogger who stumbled upon writing online since 2009. She started her blogging career in 2010, and never looked back. Since then, she has developed an incredible passion for writing about all sorts of tech. Away from blogosphere, she loves to paint and is the founder of fineartblogger.com

1 COMMENT

LEAVE A REPLY