Business Information Systems: ERD Diagrams and Database Relationships

Desklib provides solved assignments and past papers to help students succeed.

BUSINESS
INFORMATION SYSTEM

Introduction
 Business Information system gives the
knowledge and give the skills to develop
the business and implement information
system in business. This also include the
design system of database and
implementation of it.

Primary Key
This key is the unique
key which is used in
the relation. This
shows by bolding the
letter followed by
underlining.

Foreign Key
A foreign key is kind
of cross reference
which have tables in
between the
reference of the
primary key. This
establish the link
between them.

ERD

ERD with many to many
realtionship

ERD without many to many
relationship

ERD of Student Records
Database Management System
 Courses are the
entity here which
have the several
attributes namely
Courses A, courses
B and Courses C
along with the
Courses_id and this
Course_id works as
the primary key in
the student entity.

Student is the entity
which have the
attributes such
Student_id, Emial_id,
and Course_Id, Name,
Enroll_Id. This have
the database of the
particular
individuals .Modificati
on will be done by the
admin.
ERD of Student Records
Database Management System

ERD of Student Records
Database Management System
 In this the entity is the
enrolments which have
the student_Id,
course_Id, enrol_id and
admin_id in this all the
Id works as the foreign
key. There are primary
key in the different
entities and here they
work as forging key.
This has the one to
many relationships
with the other entity.

ERD of Student Records
Database Management System
In this, the entity is
the admin which have
the Name_Ad,
Updation_St,
View_Profile and
Admin_Id this all is
attributes of the
entity.

ERD of Student Records
Database Management System
There are various
courses of various
department. The
student of the
respected
department will
have the particular
student.