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 embroil entities such as students, lecturers, courses, lecture halls, faculties and perhaps dormitories. For this project the key entities under consideration ar the students, instructors, and courses. Therefore, it is sensible 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 stick out 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 pay offs use of relationships that are implemented using hostile keys that originate from raise 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 stir 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