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

Rdms.group project - Essay ExampleThe id fields, which result be used as droll 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 whole number 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 edition 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 disciple table will be linked with tables Student_Type. The Class_Registered table will be linked with two tables Student and Class_Type. The relationship among 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 represented by two re lationships One-To-Many (1N) relationship between Student and Class_Registered table and One-To-Many (1N) relationship between Class_Type and Class_Registered