A Database For A Student Information System Computer Science Essay

Database normally refers to the usage of modern computing machine engineering to screen out all sorts of information orderly, easy to happen and pull off. In web selling refers to the usage of the cyberspace to roll up personal information, and archive direction, such as: fname, lname, age, sex, reference, phone figure, consumer behaviour and so on.

Database is an application that can be pull offing informations and allows fast storage and retrieval of informations. Database besides is a aggregation of informations, hive awaying information ; it is really easy to question the contents of the agreement, managing and updates.

Databases usually use to set up in conformity with a format of informations and information aggregation in order to ease easy and effectual usage of the informations. For illustration: the database may be formed by the group of contracts, together with relevant information. It may incorporate bibliographic, numerical or other informations, by and large structured so that it can be sought and retrieved automatically.

Get quality help now
Marrie pro writer
Verified writer
5 (204)

“ She followed all my directions. It was really easy to contact her and respond very fast as well. ”

+84 relevant experts are online
Hire writer

Relational database, the relationship between the informations explicitly provided entree to the same belongings.

Database can be considered to automatically question and modify informations sets. There are many types of databases ; from the simplest signifier of assorted informations shops to be able to transport out large-scale mass informations storage in all facets of database system has been widely used. The most popular is relational database that shops informations in tabular arraies where each row in the tabular array holds the same kind of information. Largely, the database aggregation of a big figure of informations records or informations files, such as gross revenues minutess, merchandise catalogs, stock list, and client files.

Get to Know The Price Estimate For Your Paper
Topic
Number of pages
Email Invalid email

By clicking “Check Writers’ Offers”, you agree to our terms of service and privacy policy. We’ll occasionally send you promo and account related email

"You must agree to out terms of services and privacy policy"
Check writers' offers

You won’t be charged yet!

A typical database direction system provides users with entree to informations, study coevals and informations analysis capablenesss, SQL is a standard question linguistic communication, and for database updates, and IBM, the same functionality.

The logic of the database is to portion relevant informations aggregation and the information description. Its intent is to run into the information demands of an organisation. Database system catalog ( metadata ) to supply informations to do the plan description informations independency. Database logically related informations comprises entities, attributer, and relationships of an organisation ‘s information.

In Question 2, we are utilizing Microsoft Access to make relational database. Microsoft Access is a pseudo-relational system from Microsoft Office. Microsoft Access is widely used by little concerns, within sections of big corporations, and avocation coders to make ad hoc customized systems for passing the creative activity and use of informations. Its easiness of usage and powerful design tools given the non-professional coder a batch of convenience for small attempt.

A relational database is a aggregation of dealingss or tabular arraies. The rows of a tabular array in a relational database are known as tuples and each column of a tabular array is called an property. By definition becomes a set of tuples holding the same properties. Operationss, which can be performed on the dealingss, are choice, undertaking and articulation. The connection operation combines dealingss, the choice questions are used for informations retrieval and the undertaking operation identifies attributes. Similar to other database theoretical accounts, even relational databases support the insert, delete and update operations.

Define Question 1

Application database is implemented as a aggregation of end-user services.Also, each plan could be defines and manages its ain information. It is a system that can see information to user. Database allows each user has his or her ain positions on the program. It Is basically a sing a subset of a figure of database. In the database, all users should be able to entree the same information. A user ‘s point of position is non capable to the positions of other alterations. In add-on, the user does non necessitate to cognize the physical database storage inside informations. Merely the DBA should be able to alter, and will non impact the positions of users, database storage construction. The internal construction of the database should be free from physical storage alterations. In fact, DBA should be able to alter all users, without impacting the construct of the database construction.

Answer of Question 1

In Question 1, we must make a Student Information System. In that database, we must include table and each tabular array should hold Primary Key stated and relationship between of them.

There are some relational keys that are including Primary Key. First is Super key. It is an property, or set of properties, that uniquely identifies a tuple within a relation. Second one is candidate key ; it is a minimum ace key. Primary Key is a campaigner key that selected to place tuples unambiguously within relation. Alternate keys are candidate keys that are non selected to be primary key. Last one is foreign key. It is besides a set of properties ; it is within one relation that matches candidate key of some ( perchance same ) relation.

Primary Key

Primary key is to record and hive away the informations in others tabular arraies associated with it. At this point, the primary key is pointer. Normally, the primary cardinal value for users is nonmeaningful, and its value has to be given no particular links. Primary cardinal normally used for general enquiries faster ; it is because there is an index in the above.

Information science

Fname

Lname

Sexual activity

Age

Address

Capable

1001

Trap

Lucky

F

20

7 Taman Untung

Dot

1002

Phang

Tommy

Meter

22

10 Sungai Siput

CICT

1003

Phang

Harry

Meter

19

10 Sungai Siput

CICT

1004

Chemical bond

James

Meter

20

11 Taman Chemor

Dot

1005

Oh

Loser

Meter

19

69 Taman Bunga

Dot

1006

Elizabeth

Mary

F

19

44 Taman Ipoh

DBM

1007

Lee

Anna

F

18

KLCC

DHM

1008

Valentine

Vincent

Meter

21

7 Taman Fantasi

DHM

1009

Discord

Cloud

Meter

19

8 Taman Fantasi

DBM

1010

Lockhart

Tifa

F

18

9 Taman Fantasi

IEP

Table 1: Student ‘s Table

This tabular array is the 1st tabular array that demoing 10 pupils who are surveies in Olympia College Ipoh. In this tabular array, there are 6 male and 4 female. 3 of them are analyzing DIT, 2 of them are analyzing CICT, 2 of them are analyzing DBM, 2 of them are analyzing DHM and the last one are analyzing IEP. The primary key of this tabular array is TP.

By how to make table, we have to utilize Microsoft Excel. In the Microsoft Excel, we have to tape all of the rubric 1st, so that we can set all pupil information one by one into the tabular array.

StuffNo

FName

LName

Sexual activity

Age

Address

Capable

SN010

Reasonably

Wong

F

28

Lucky Hotel

Dot

SN011

Handsome

Lee

Meter

25

Lucky Hotel

CICT

SN012

Olivia

Holmium

F

30

12 Taman Ipoh

DHM

SN013

Emily

Chan

F

38

23 Taman Kinta

DBM

SN014

Andy

Lao

Meter

32

52 Jalan Pinang

IEP

Table 2: Lector ‘s Table

This is the second tabular array. This tabular array is demoing who the lector is and what topic that are those lectors learning approximately. In this tabular array, there is demoing 5 lectors ‘ information. Each lector is learning one topic. The Primary key of this tabular array is SUBJECT. This is because SUBJECT is same information with Student tabular array. In lector tabular array, SUBJECT is relational with Student tabular array.

Information science

Fname

Lname

Capable

Consequence

1001

Trap

Lucky

Dot

C-

1002

Phang

Tommy

CICT

A

1003

Phang

Harry

CICT

A+

1004

Chemical bond

James

Dot

A-

1005

Oh

Loser

Dot

I/W

1006

Elizabeth

Mary

DBM

B+

1007

Lee

Anna

DHM

B-

1008

Valentine

Vincent

DHM

A-

1009

Discord

Cloud

DBM

Bacillus

1010

Lockhart

Tifa

IEP

A

Table 3: Oscilloscope Table

This is the 3rd tabular array. This tabular array is demoing that consequence for all pupils. In this tabular array, it is demoing that some might go through, some might neglect and tonss of them acquire high mark. The primary key of this tabular array is IP besides, and the IP is relational with the 1st tabular array. Besides, this tabular array is demoing about pupil topic.

Information science

Fname

Lname

Sexual activity

Capable

Pqyment

1001

Trap

Lucky

F

Dot

Yttrium

1002

Phang

Tommy

Meter

CICT

Nitrogen

1003

Phang

Harry

Meter

CICT

Nitrogen

1004

Chemical bond

James

Meter

Dot

Nitrogen

1005

Oh

Loser

Meter

Dot

Yttrium

1006

Elizabeth

Mary

F

DBM

Yttrium

1007

Lee

Anna

F

DHM

Nitrogen

1008

Valentine

Vincent

Meter

DHM

Yttrium

1009

Discord

Cloud

Meter

DBM

Nitrogen

1010

Lockhart

Tifa

F

IEP

Nitrogen

Table 4: Casher Table

This is the last tabular array. This tabular array is demoing most of the pupil information. Besides that, this tabular array besides demoing the payment information of all pupils. It is demoing that pupil has been or havens wage the fee. The primary key of this tabular array besides are IP. In this tabular array, the IP primary key besides relational with the 1st tabular array.

Define Question 2

In inquiry 2, we need to stand for the database for the Student Information System Entity Relationship ( ER ) theoretical account. Besides, Question 2 demands Microsoft Access to stand for database.

Microsoft Access

Microsoft Access is the database application from the Microsoft Office Suite of applications. It is a powerful personal database and informations use tool that is besides widely used in many little concerns.

Microsoft entree is released by Microsoft relational database direction system. It combines the Microsoft Jet Database Engine, and two graphical user interface characteristics. It is one of the Microsoft Office system plans. It could be entree though the Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant database informations. Skilled package interior decorators and informations analysts use it to develop application package, and some unskilled coders and non-programmers while advanced user can utilize it to develop simple applications.

Answer of Question 2

Before making database with Microsoft Access, we need to some measure.

This tabular array is demoing that taking Icon application. First, we should snap on ( start ) , and so we can see the ( All Program ) . Snap it, so it will come out the list, so we choose Microsoft Office. After that, take and snap Microsoft Access.

This is the 2nd portion ; this tabular array is demoing what will come out after snaping the application. In this tabular array, we need to snap the ( Blank Database ) . So on, it will come out the right side thing. Now, we can entry the file name, and it is Student Information System.

After create the database file, it will demo this tabular array. From now on, we can come in all pupil information. We must make at least 4 tabular arraies ; there are Student tabular array, Lecturer tabular array, Casher tabular array, and CRO tabular array.

In this tabular array, we have been taping all information into the tabular array. In the pupil information, we have IP, FNAME, LNAME, SEX, AGE, ADDRESS and SUBJECT. In lector tabular array, there are STUFFNO, FNAME, LNAME, SEX, AGE, ADDRESS and SUBJECT. In casher tabular array, there are IP, FNAME, LNAME, SEX, SUBJECT and PAYMENT. In the last tabular array, it is CRO tabular array. In that tabular array, there are IP, FNAME, LNAME, SEX, SUBJECT and RESULT.

After come ining all information, we need to take the Primary key. The primary key of pupil tabular array, IP is the Primary Key. In the lector tabular array, SUBJECT is the Primary Key. IP is set as Primary Key in Casher tabular array. The CRO tabular array ‘s primary key besides is set as IP.

This tabular array demoing that three tabular array are relational with the last tabular array. The chief tabular array is the pupil tabular array. The lector is relational with pupil tabular array with the capable primary key. The casher and CRO tabular array are same relational with pupil tabular array with the IP primary key.

From this tabular array, we can see that all tabular arraies are relational with the pupil tabular array. So the pupil tabular array will be the chief tabular array.

This tabular array demoing that the lector is relational with the pupil tabular array. After snaping the boxes, it will demo the pupil information that the pupil who take the topic that is learning by those lector.

This is the table demoing the payment of all pupils, and this is the Casher tabular array.

The boxes demoing pupil have been or haven pay their payment.

This tabular array shows the consequence of all pupils, and this is the CRO tabular array.

The boxes demoing the full pupil consequence.

Conclusion & A ; Recommendation

Database is a really powerful system. Database besides can be say as package. It can be created to pull off generalised database is normally called a database direction system ( DBMS ) . Several package architectures are possible: For smaller individual user databases frequently all maps are managed by one plan. Questions 2 are utilizing relational theoretical account nomenclature. It is a relation and is a tabular array with columns and rows. In relational theoretical account, user can bespeak informations from a relational database by directing it a question that is written in a particular linguistic communication, it normally a idiom of SQL. Although SQL was originally intended for end-users, it is much more common for SQL questions to be embedded into package that provides an easier user interface.

In this assignment, a relational database lucifers informations by utilizing common features found within the information set. The ensuing groups of informations are organized and will be much easier for other user to understand it. Relational databases are presently the predominant pick in hive awaying fiscal records, fabrication and logistical in formation, forces informations and etc.

We are utilizing Microsoft Access in inquiry 2. Microsoft Access is a development environment used to make computer-based databases. To complement it, it ships with a scheduling linguistic communication called Visual Basic for Application ( VBA ) and assorted libraries. This linguistic communication and the libraries are used in a scheduling environment called Microsoft Visual Basic, which besides ships with Microsoft Access.

In my sentiment, there are some advantages of the relational databases. Relational database is based on set theory dealingss. A relational algebra relational database are back uping the relationship between set theory operations. In add-on to mathematical set operations, viz. brotherhood, intersection, difference and Cartesian merchandise, relational databases besides support the choice, undertaking and relationship to fall in and division. These operations are alone relational database.

?-e?»

??c¤?a??a?”cs„?‹‰a??a­-c¬¦cs„?‹?eY?

Besides that, there are a few advantages of DBMS. It is holding good control of informations redundancy and information consistence. Users can seek more information from the same sum of informations. DBMS can utilize to sharing informations, it besides enforcement off criterions and economic system of graduated table. DBMS could be improved informations unity and security.

As my recommendation, database will better in the hereafter. It is because, the database usually is better to used for little company or concern. If database for large company, it is more complexness and confusing.

Cite this page

A Database For A Student Information System Computer Science Essay. (2020, Jun 01). Retrieved from https://studymoose.com/a-database-for-a-student-information-system-computer-science-new-essay

👋 Hi! I’m your smart assistant Amy!

Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.

get help with your assignment