Student Information System Entity Relationship Computer Science Essay

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

A database is a collection of information that is organized so that it can do very easily be accessed,managed,and updated. The metadata provide a description of the data characteristics and the set of relationships that link the data found within the database. All kinds of individuals use databases, from teachers recording grades to police officers checking criminal histories, collage and universities use databases to keep records on their student, instructors and course. Organization of all type maintains employee microcomputers are Microsoft access, Corel, paradox and lotus approach. A database management system (DBMS) is the software for creating, modifying, and gaining access to the database. Database management system (DBMS) provides the needed organizational approach to flexible storage and retrieval of large amounts of data. Relationship describes an association among entities. When a single set of data items serves a variety of applications, different programs perceive different relationships between the data items. In the relational model such as identifiers are mapped to primary keys in table .Key attributes are also underlined in a frequently used table structure shorthand notation using a format. It identifies a part record uniquely because no to parts have a same part number. The ERD represents the conceptual database as viewed by the end user. A relational uses two distinct notations to describe table, relationship, and constraints. Entity-relationship diagram are the most popular notation for this purpose.

Define Question 1

In question 1 we want creates a table for student. We want create 4 tables in different ways. This question we want to use database system. In this question we create different types of tables for students. The students create 4 different types of table but we want use same name in the table. And also we want to find primary key for every tables. And than the student find the relationship for every table. The security and recovery from failure is for major importance in database design.

RELATIONSHIP

A relationship describes an association among entities. . In this structure, there are no access paths down a hierarchy. Rather, the data element are stored in different tables, each of which consists of rows and columns. The ERD represents the conceptual database as viewed by the end user. Each column is a field. The fields are license number last name, first name, streets, city, state and zip. The next section on database this second notation. In this case, the three tables are related by the license number field. An employee may learn job skills, and each job skill may be learned by many employees.

ANSWEAR FOR QUESTION 1

Student Information

STUDENT ID

FIRST NAME

LAST NAME

SEX

SEMESTER

ST012

NAVIN

RAJ

M

4

ST013

RAJ

KUMAR

M

3

ST014

WEING

SOON

M

1

ST015

NURUL

ATIKA

F

1

ST016

VANI

SRI

F

2

ST017

DURGA

DEVI

F

2

ST018

PEI

JEE

F

4

ST019

THINESH

KUMAR

M

2

ST020

CHANDRA

KUMAR

M

2

ST021

LEE

CHONG

M

4

This table for students. In this student table got student ID, the name,sex,semester.They have different tips of name and ID.In this table got 10 peoples in different names.

LECTURER TABLE

LECTURER ID

PHONE NUMBER

CENTRE

COURES TEACHING

LT031

016-5432778

IPOH

DIT

LT031

05-5545777

PETALING JAYA

CHO

LT033

019-6327888

KUALA LUMPUR

CICT

LT034

015-5526718

PENANG

DHM

LT035

014-5666667

JOHOR BAHRU

DIT

LT036

010-3303030

KEDAH

DIT

LT037

012-5678890

IPOH

CICT

LT038

014-5678965

KUALA LUMPUR

DBM

LT039

016-3456678

IPOH

CHO

LT040

013-90909090

PENANG

DBM

This table is for lecturers .They have students phone number for contact for any argent news .And also the lecturers centre also got. The students course also have in the table.

PARENTS TABLE

PARENTS ID

NAME

SALARY

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 table for parents. The parents also got parents ID and the salary. If any problem for the students we can contact the parents table.

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 table for the casher. If the student pay ready the fees we can search the casher table.In this table have cashier Edythe name, student ID and also fees pay.

RELATIONSHIP BETWEEN TABLE

This is the relationship for the students in student table, lecturer table, parents table and also cashier tables.

DEFINE QUESTION 2

Define for question 2 is we wan create a represent our data for student information in ER and database Microsoft Access. this question is how to create a database Microsoft Access. we wan to show how to create a table in Microsoft Access.

QUESTION 2

How to create a table in Microsoft Access. First we go to start and press the button to go the Microsoft Access.

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

This table is create a table for the student information. We want to create 4 types of tables. If u wan create a new table press view.

After that we can do the table for students like student ID, first name, last name and semester create for this table.

This table for create a lecturer table.This also like student table.

This table is student information table for find primer key.

In this table there ask “do you wan save this table” we press YES.

After that parents table we wan to create. In this table have phone num,centre,course.

This table show a relationship for the 4 tables.Anthan we press the add button.

The last table is show a relationship like this.

CONCLUTION & RECOMMEDATION

You can expect that the data you are using or inputting is coming from or being stored in some type of database. To understand database you may want to consider enterprise tools, how they are designed and the effort for do so, and the database architecture. . Updating data in database included adding new records, deleting, existing records and changing information within a records. For database recommendation is easy to preparing tables and the relationships. If to do the table we can choose the Microsoft Access.

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.