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

Database Modeling - Essay Example It might be important to have alternative contact addresses for students in case of unexpected situations. Therefore, in order to cater for such a situation, we need to create additional tables to handle the addresses. One table named email-address will contain the following fields: 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 primary 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 values. 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 many to many relationships between student-information table and course-information table. In order to accomplish this relationship, another table is required.