Database Management

Database Management 2

The paper discusses a studentdatabasemanagement system, which mentionsthe vital

details about students. The article utilizes three table to enter, store, and manage the data. Each

set of data gets placed on a table where it has related data items, in a relational data format. The

organization separates each data andclassifiesthem where they belong. The table in the paper

includes student registration database containing basic information, the student performance

showing the marks and the position of the student compared to other students. Lastly, the fees

payment table that indicates that shows the payment details versus the arrears that a student is

leftto complete the fees payment.

Studentregistration table

The article suggests a table that would hold data concerning the registration details of the

learners. According to Hoffman, (2013), the primary key of the table becomes the student ID,

which uniquely separates each record entry from the rest in the same table. The studentIDis of

numeric data type and accepts number type of data entry. Other elements that form part of the

database include student name, which is the character type. Student address belongs to memo

data type because it may contain both numeric and character data type.

Fees payment table

The table includes data relating to the fee already paid and respective arrears if there

exists. The primary key would occur from the student ID as well. Hoffman, (2013) explains that

the student ID used against each student name makes each record entry special from another. The

other data in the table include some fees paid, which gets auto deductedfromthe total expected

fees. Then another field which is of numeric and auto-generated because it is a result of the

internal calculation within the database.