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

Rdms.group project - hear ExampleThe id fields, which impart be used as unique field (i.e. primary key for the duck), go away be interpreted as AutoNumber data type so that it can automatically inserted for any in the buff records in table. For AutoNumber data type, Long Integer field size is always gather inn (in Microsoft Office Access). For exotic key fields, Number data type with Long Integer field size will taken so that it can be easily colligate 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 seemly 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 amongst Student and Student_Type table will be One-To-Many (1N). The relationship between Student and Class table will be Many-To-Many (MN) and will be repre sented by two relationships One-To-Many (1N) relationship between Student and Class_Registered table and One-To-Many (1N) relationship between Class_Type and Class_Registered