Rdms.group project Essay Example | Topics and Well Written Essays - 500 words

Rdms.group project - Essay Example The 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 inserted for any new records in table. For AutoNumber data type, Long Integer field size is always taken (in Microsoft Office Access). For foreign key fields, Number data type with Long Integer field size will taken so that it can be easily linked with primary key fields. For name, description fields, we will take Text data type with field size 50 character. The 50-character size will be enough for storing 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. The relationship between Student and Student_Type table will be One-To-Many (1:N). The relationship between Student and Class table will be Many-To-Many (M:N) and will be represented by two relationships: One-To-Many (1:N) relationship between Student and Class_Registered table and One-To-Many (1:N) relationship between Class_Type and Class_Registered