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

Intro to Relat Dbase Mgt Syst week1 - Essay ExampleThese include entities such as students, lecturers, courses, lecture halls, faculties and maybe dormitories. For this project the nominate 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 aim 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 supernumerary 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