ServiceNow
Workflows

IT Workflows
Employee Workflows
Customer Workflows
Creator Workflows

IT Workflows
We offer workflows that can transform IT into a fully-fledged growth engine. Take advantage of the benefits of operational flexibility by increasing workforce adaptability...
Read More

Employee Workflows
Make employee experiences more integrated and engaging with ServiceNow Employee Workflows. Motivate your staff by making it simple for them to obtain what they require when they require it...
Read More

Customer Workflows
We connect clients, front-line agents, middle and back-office staff on a single ServiceNow platform with ServiceNow Customer Workflows using digital processes to scale customer operations...
Read More

Creator Workflows
With a low-code platform, you can quickly create digital workflow apps. Scale quickly across the organization to build natural, linked experiences that users enjoy...
Read More

Solutions
ServiceNow Solutions

IT Service Management
IT Operations Management
IT Asset Management
Governance, Risk, and Compliance
Security Operations

HR Service Delivery
Customer Service Management
Field Service Management
Integration Hub

IT Service Management
IT service management includes all the ServiceNow services and processes that ensure end to end...
Read More

IT Operations Management
ServiceNow ITOM consists of a set of modules in ServiceNow to manage the operations...
Read More

IT Asset Management
It is the set of business practices to manage the lifecycle of various assets in IT like software assets...
Read More

Governance, Risk, and Compliance
Almost every aspect of the business is driven by governance, risk, and compliance...
Read More

Security Operation
To minimize risk, ServiceNow SecOps allows you to immediately identify, prioritize, and respond to threats...
Read More

HR Service Delivery
With ServiceNow HRSD, you can increase company productivity and provide your employees...
Read More

Customer Service Management
Proactively solve problems and take actions to rectify common requests more efficiently with ServiceNow...
Read More

Field Service Management
ServiceNow Field Service Management enables you to efficiently and safely manage field service activity...
Read More

Integration Hub
For the fastest time to value, lowest TCO, and ease of use with zero learning curve for all ServiceNow developers...
Read More

Digital Transformation
Digital Transformation

DevOps
Robotic process automation
User Experience Design

DevOps
Devops includes the set of practices that automates the IT operations and accelerate the delivery...
Read More

Robotic process automationt
We help organizations to integrate different techniques like machine learning and artificial...
Read More

User Experience Design
User experience design is the creation of the effective flow between users and software...
Read More

Product Engineering
Product Engineering

IT Consulting
New Application development
Product testing & QA
Re-engineering & Migration
Support & maintenance

IT Consulting
We help Companies to Better their IT infrastructure and to Implement various IT strategies. Alignment of all the services to boost the overall performance...
Read More

New Application development
We are an IT service provider company using high-value business processes and technical stacks to build digital products...
Read More

Product testing & QA
We help clients to deliver quality products and services. Skilled Quality Assurance Team to perform a series...
Read More

Re-engineering & Migration
Re-Engineering and Migration is the concept of Comparing the Existing business model to the desired model...
Read More

Support & maintenance
We provide a range of support and maintenance services to our clients in the form of version upgrades, post-project support...
Read More

Tutorial: How to create ER diagrams for a database in PHPmyadmin

  • By Aelum consulting
  • July 6, 2021
  • 3146 Views

An Entity Relationship Diagram (ERD) is a visual representation of different entities within a system and how they relate to each other.

Agenda: To create ER diagrams for the tables in the database.

create ER diagrams

Consider a hypothetical scenario in which Restaurant data is stored in a database. The database contains the following tables:

Following are the tables: Food_Item, List_Recipies, Food_Menu, Order_Details, My_Customers, My_Promo, My_Orders, My_Employees, My_Promo

In the diagrams above the Column names in orange are called ‘Entities’ and the keys in green are called ‘Attributes’. The following diagram describes this further.

Follow the steps to create ER diagram for the above tables:

STEP 1:

Go to phpMyAdmin and create a database named ‘Restaurant’.

STEP 2:

To populate the tables in the database run the following SQL commands.

CREATE TABLE IF NOT EXISTS Food_Item ( id INTEGER NOT NULL PRIMARY KEY , menu_id INTEGER , item_name VARCHAR(40) , Item_price VARCHAR(20) , Stock VARCHAR(20))

CREATE TABLE IF NOT EXISTS Customer( id INTEGER NOT NULL PRIMARY KEY , food_item_id INTEGER , name VARCHAR(40) , contact INTEGER(30) , member_id VARCHAR(20))

CREATE TABLE IF NOT EXISTS Employees( emp_id INTEGER NOT NULL PRIMARY KEY , customer_id VARCHAR(30) , name VARCHAR(40) , address Varchar(20) , salary VARCHAR(20))

CREATE TABLE IF NOT EXISTS Promo( id INTEGER NOT NULL PRIMARY KEY , order_id VARCHAR(30), promo_desc VARCHAR(40) , discount VARCHAR (20) , expiry_date VARCHAR(20))

CREATE TABLE IF NOT EXISTS Food_Menu( id INTEGER NOT NULL PRIMARY KEY, employee_id VARCHAR(20), menu_name VARCHAR(40), price Varchar(20), cooking_time VARCHAR(20))

CREATE TABLE IF NOT EXISTS Orders( id INTEGER NOT NULL PRIMARY KEY , employee_id INTEGER , order_date VARCHAR(40) , order_type Varchar(20) , total_amount VARCHAR(20))

Now your database is populated with all the tables.

Note: You do not need to insert data in the tables to create an Entity Relationship  Diagram. You just need the field names and their data types.

STEP 3:

In the top menu select More → Designer option as shown in the image below.

This will open the designing mode. You can see all the tables scattered on the designing sheet something like this:

Now you have to create relationships between the different tables. The following chart will help you to understand the relationships between the two tables better.

STEP 4:

Now create relationships by clicking on the relationship icon on the left menu bar. Then select the primary key and foreign key in a relation and click on create relationship option. Perform the same for all the rest of the tables.

The result will look something like this:

Now you had create ER Diagrams for your database.

STEP 5:

The last page of the report will be as shown below:

Hence these are the basic steps of creating an Entity-Relationship (ER) Diagrams [create ER diagrams] for a database.

Thanks For Reading
Read More on Aelum Blogs

Author: Abhikhya Ashi
Designation: Senior Php Developer