Database Modeling Essay Example | Topics and Well Written Essays - 500 words

Database Modeling - Essay ExampleIt might be important to have alternating(a) contact addresses for students in case of unexpected situations. Therefore, in order to cater for such a situation, we need to create additional control panels to handle the addresses.One instrument panel named email-address will retain the followers palm id, email address and student-id. Likewise, another table named phone-number will be created containing the following fields id, phone number, and student-id. Finally, another table will be street-details. This table will have the following fields id, street-name, city-name, state, and student-id.The four tables created to satisfy the requirements of 1NF. They are also in 2NF since they do not contain any partial dependencies. All fields in each table are uniquely reliant on the respective chief(a) key as 2NF requires (Buxton, 2009). The four tables also fulfill the requirements of 3Nf since all fields present depend on the primary key for their val ues.The next table that requires normalization is named course-information. This table contains the following fields Course-Id, course-title, and course credit. This table is already in first normal form since it does not contain multi-valued fields. This table also fulfills the requirements of 2NF since all fields in the table rely uniquely on the primary key. This table also fulfills the requirements of 3NF since each field in that table is dependent on the primary key.The last thing now is to create a relationship between a student and the courses that they take. This can be done by employing a umteen to many relationships between student-information table and course-information table. In order to accomplish this relationship, another table is required.