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

Relational Data set - Assignment ExampleThe attribute is attracter should be removed from the knock back Candi witness because this information already exists in the table troupe. It is possible to get to greet if a outlook is leader of any companionship with looking through references to leaders in the table Party.... First_nameMiddle_nameLast_nameaddressgenderdate of fork upPartyPk_idFk_leadernameaddressdate established CandidatePk_idFk_electorateFk_partyFirst_nameMiddle_nameLast_nameaddressgenderdate of birthis leader Second convening form (2NF) further addresses the concept of removing duplicative data Meet either the requirements of the first normal form. Remove subsets of data that apply to multiple rows of a table and place them in separate tables. pull in 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 apart into separate table Person. It also should have a primary key named Pk_id.Then 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