Intro to Relat Dbase Mgt Syst week1 Essay Example | Topics and Well Written Essays - 250 words

Intro to Relat Dbase Mgt Syst week1 - Essay Example These include entities such as students, lecturers, courses, lecture halls, faculties and perhaps dormitories. For this project the key entities under consideration are the students, instructors, and courses. Therefore, it is logical that the first tables to be identified be Students, Instructors, and Courses tables. These are the tables in the 1st Normal Form. These key tables contain attributes that describe the entities they represent. However, the design follows two more tables that do not represent any key attributes that are initially identified. Relative Database Design makes use of relationships that are implemented using foreign keys that originate from parent tables. This process; therefore, proves challenging to implement while still exercising referential integrity. The two extra tables make the design practical since separation of the key entities is paramount (Churcher, 2012). Modification of a key entity does not affect the other key entities. These two tables are Students Allocation table and Instructor Allocation tables. Their attributes contain foreign keys for Students and Instructor tables, and they represent the action of ‘allocating’, which becomes