Student Information System Entity Relationship Computer Science Essay Free Essay Example

A database is a aggregation of information that is organized so that it can make really easy be accessed, managed, and updated. The metadata provide a description of the information features and the set of relationships that link the information found within the database. All sorts of persons use databases, from instructors entering classs to patrol officers look intoing condemnable histories, montage and universities use databases to maintain records on their pupil, teachers and class. Organization of all type maintains employee personal computers are Microsoft entree, Corel, paradox and Nelumbo nucifera attack.

A database direction system ( DBMS ) is the package for making, modifying, and deriving entree to the database. Database direction system ( DBMS ) provides the needful organisational attack to flexible storage and retrieval of big sums of informations. Relationship describes an association among entities. When a individual set of informations points serves a assortment of applications, different plans perceive different relationships between the informations points. In the relational theoretical account such as identifiers are mapped to primary keys in table.

Key properties are besides underlined in a often used table construction stenography notation utilizing a format. It identifies a portion record unambiguously because no to parts have a same portion figure. The ERD represents the conceptual database as viewed by the terminal user. A relational utilizations two distinguishable notations to depict table, relationship, and restraints. Entity-relationship diagram are the most popular notation for this intent.

Define Question 1

In inquiry 1 we want creates a tabular array for pupil. We want create 4 tabular arraies in different ways.

This inquiry we want to utilize database system. In this inquiry we create different types of tabular arraies for pupils. The pupils create 4 different types of tabular array but we want use same name in the tabular array. And besides we want to happen primary key for every tabular arraies. And than the pupil happen the relationship for every tabular array. The security and recovery from failure is for major importance in database design.

Relationship

A relationship describes an association among entities. . In this construction, there are no entree paths down a hierarchy. Rather, the informations component are stored in different tabular arraies, each of which consists of rows and columns. The ERD represents the conceptual database as viewed by the terminal user. Each column is a field. The Fieldss are license figure last name, foremost name, streets, metropolis, province and nothing. The following subdivision on database this 2nd notation. In this instance, the three tabular arraies are related by the license figure field. An employee may larn occupation accomplishments, and each occupation accomplishment may be learned by many employees.

ANSWEAR FOR QUESTION 1

Student Information

Student ID

First Name

LAST Name

Sexual activity

Semester

ST012

NAVIN

Raj

Meter

4

ST013

Raj

KUMAR

Meter

3

ST014

WEING

Soon

Meter

1

ST015

NURUL

ATIKA

F

1

ST016

VANI

SRI

F

2

ST017

Durga

Devi

F

2

ST018

Pei

JEE

F

4

ST019

THINESH

KUMAR

Meter

2

ST020

CHANDRA

KUMAR

Meter

2

ST021

Lee

CHONG

Meter

4

This tabular array for pupils. In this pupil tabular array got pupil ID, the name, sex, semester.They have different tips of name and ID.In this tabular array got 10 peoples in different names.

LECTURER TABLE

LECTURER ID

PHONE NUMBER

Centre

COURES TEACHING

LT031

016-5432778

IPOH

Dot

LT031

05-5545777

PETALING JAYA

CHO

LT033

019-6327888

KUALA LUMPUR

CICT

LT034

015-5526718

PENANG

DHM

LT035

014-5666667

JOHOR BAHRU

Dot

LT036

010-3303030

KEDAH

Dot

LT037

012-5678890

IPOH

CICT

LT038

014-5678965

KUALA LUMPUR

DBM

LT039

016-3456678

IPOH

CHO

LT040

013-90909090

PENANG

DBM

This tabular array is for lectors.They have pupils phone figure for contact for any silver intelligence.And besides the lectors centre besides got. The pupils class besides have in the tabular array.

Parents TABLE

PARENTS ID

Name

Wage

Student ID

PR001

RAMESH

4700

ST012

PR002

SAFIQ

2,500

ST013

PR003

Look

2,500

ST014

PR004

ABDILLAH

2700

ST015

PR005

RAMASAMMY

1000

ST016

PR006

RAMU

10000

ST017

PR007

Lee

7300

ST018

PR008

ANPALAKAN

5,550

ST019

PR009

BALAN

4500

ST020

PR010

KUANG

1800

ST121

This tabular array for parents. The parents besides got parents ID and the wage. If any job for the pupils we can reach the parents tabular array.

CASHER Table

CASHIER ID

Name

Student ID

Fees PAY

CS001

ANITHA

ST012

RM1,250

CS002

BAWANI

ST013

RM2,000

CS003

PUNITHA

ST014

RM1,750

CS004

XIAU SOON

ST015

RM3,520

CS005

VIJAY

ST016

RM2,800

CS006

ASHA

ST017

RM4,230

CS007

ATIKA

ST018

RM3,200

CS008

KONG

ST019

RM3,530

CS009

TANAM

ST020

RM2,750

CS010

FOO SENG

ST021

RM1,570

This tabular array for the casher. If the pupil wage ready the fees we can seek the casher table.In this tabular array have cashier Edythe name, pupil ID and besides fees pay.

RELATIONSHIP BETWEEN TABLE

This is the relationship for the pupils in pupil tabular array, lector tabular array, parents tabular array and besides cashier tabular arraies.

DEFINE QUESTION 2

Define for inquiry 2 is we wan make a represent our informations for pupil information in ER and database Microsoft Access. this inquiry is how to make a database Microsoft Access. we wan to demo how to make a tabular array in Microsoft Access.

Question 2

How to make a tabular array in Microsoft Access. First we go to get down and press the button to travel the Microsoft Access.

An than they show like this and we press the button database. After that we press the create button.

This tabular array is make a tabular array for the pupil information. We want to make 4 types of tabular arraies. If u wide area network make a new table imperativeness position.

After that we can make the tabular array for pupils like pupil ID, foremost name, last name and semester create for this tabular array.

This tabular array for create a lector table.This besides like pupil tabular array.

This tabular array is student information tabular array for discovery primer key.

In this tabular array at that place ask aa‚¬A“do you wan salvage this tableaa‚¬A? we press YES.

After that parents table we wan to make. In this tabular array have phone num, Centre, class.

This tabular array demo a relationship for the 4 tables.Anthan we press the add button.

The last tabular array is show a relationship like this.

CONCLUTION & A ; RECOMMEDATION

You can anticipate that the information you are utilizing or inputting is coming from or being stored in some type of database. To understand database you may desire to see endeavor tools, how they are designed and the attempt for do so, and the database architecture. . Updating informations in database included adding new records, canceling, bing records and altering information within a records. For database recommendation is easy to fixing tabular arraies and the relationships. If to make the tabular array we can take the Microsoft Access.