Relational Data Model Assignment Example | Topics and Well Written Essays - 1000 words

Relational Data Model - Assignment ExampleThe refer is attraction should be removed from the table candi experience because this information already exists in the table Party. It is possible to get to know if a Candidate is leader of any party with looking through references to leaders in the table Party.... First_nameMiddle_nameLast_nameaddressgrammatical genderdate of birthPartyPk_idFk_leadernameaddressdate established CandidatePk_idFk_electorateFk_partyFirst_nameMiddle_nameLast_nameaddressgenderdate of birthis leader Second practice form (2NF) further addresses the concept of removing duplicative data Meet all the requirements of the first normal form. Remove subsets of data that keep back to multiple rows of a table and place them in separate tables. Create relationships between these new tables and their predecessors through the use of foreign keys. (Chapple 2005)So, personal information, such as name (first, middle, last), address, gender, and date of birth can be taken ap art into separate table Person. It also should have a primary key named Pk_id. thus tables Elector and Candidate should reference to it via secondary (foreign) key Fk_person.Therefore there are 5 tables in the relational database schema for the 2NFPersonPk_idFirst_nameMiddle_nameLast_nameaddressgenderdate of birthElectoratePk_idunique namenumber of registered votersElectorPk_idFk_electorateFk_party_voteFk_candidate_voteFk_personPartyPk_idFk_leadernameaddressdate established CandidatePk_idFk_electorateFk_partyFk_personis leaderThird normal form (3NF) goes one large step further Meet all the requirements of the second normal form. Remove columns that are not dependent upon the primary key. (Chapple 2005)The attribute is leader should be removed from the table Candidate because this information already exists in the table Party. It is possible to get to know if a Candidate is leader of any party with looking through references to leaders in the table Party.Theres no attributes that are not dependent upon the primary key. Here are