Student Registration System - Essay Example

Phase 2 Group Project (IT610-0802B-01: Relational Database Management Systems) Group Project Part All four tables (entities) _Type, Class_Registered, and Class_Type will be used in the Student Registration System. The Student table will be used to store personal records related to students such as student ID, name, and type. The Student_Type table will be used to store descriptions for the degree program in which the student is registered such as non-degree, undergraduate, master-degree, and doctor-degree.

The Class_Type table will store details for each class type such as the name of the class. The Class_Registered table will be used to register students for one or multiple classes. The appropriate fields (Data Types) and size for each field and primary key (PK) and foreign key (FK) for each table are given below: Field Name Data Type Field SizeTable Name: StudentStudent_id (PK) AutoNumber Long IntegerStudent_name Text 50Student_type (FK) Number Long IntegerTable Name: Student_TypeStudent_type (PK) AutoNumber Long IntegerType_Desc Text 50Table Name: Class_RegisteredStudent_id (FK) Number Long Integer class_code (FK) Number Long IntegerTable Name: Class_TypeClass_code (PK) AutoNumber Long Integerclass_name Text 50The id fields, which will be used as unique field (i.e. primary key for the table), will be taken as AutoNumber data type so that it can automatically be inserted for any new records in the table.

For the AutoNumber data type, the Long Integer field size is always taken (in Microsoft Office Access). For foreign key fields, the Number data type with a Long Integer field size will taken so that it can be easily linked with primary key fields. For name and description fields, we will take Text data type with a field size of 50 characters. The 50-character size will be enough for storing the student name, student type description, and class name. The Student table will be linked with tables Student_Type. The Class_Registered table will be linked with two tables Student and Class_Type.