StudentShare solutions
Triangle menu

Relational Data Model - Assignment Example

Nobody downloaded yet

Extract of sample
Relational Data Model

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.
...
First_name
Middle_name
Last_name
address
gender
date of birth
Party
Pk_id
Fk_leader
name
address
date established
Candidate
Pk_id
Fk_electorate
Fk_party
First_name
Middle_name
Last_name
address
gender
date of birth
is leader

Second normal form (2NF) further addresses the concept of removing duplicative data:
Meet all 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.
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 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 2NF:
Person
Pk_id
First_name
Middle_name
Last_name
address
gender
date of birth

Electorate
Pk_id
unique name
number of registered voters

Elector
Pk_id
Fk_electorate
Fk_party_vote
Fk_candidate_vote
Fk_person

Party
Pk_id
Fk_leader
name
address
date established
Candidate
Pk_id
Fk_electorate
Fk_party
Fk_person
is leader

Third 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.
There's no attributes that are not dependent upon the primary key.
Here are ...Show more

Summary

Author : britneyhansen
Relational Data Model essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Relational Data Model"
with a personal 20% discount.
Grab the best paper

Check these samples - they also fit your topic

Relational Database Assignment
The four prime factors that control the integrity of a database include relationship-level integrity, attribute-level integrity, business rules, and entity-level integrity (Lathem, 2008). Using these relationships, one can divide the data in separate tables.
3 pages (750 words) Assignment
OOP Features Added to Oracle Database
Oracle Database were no exception to this fact. The overwhelming popularity of OOP modeling techniques had some solid grounds which bond other languages and techniques to extend their support for it and many contemporary writers have admitted this fact, “The object-oriented method promised to improve software quality and efficiency.
4 pages (1000 words) Assignment
Brochure, Data Repository
Other than delivering patient keeper applications, the data repository also allows a configuration that offers business continuity solutions for the downtime support. Patient Keeper Business Continuity This system helps in a situation that the core information systems go down either planned or unplanned.
4 pages (1000 words) Assignment
Relational Database Design
The Relational Database specification required nine table in the following relationships. A table Textbook with a many-to-many relationship through a junction table (outside join) to the table Module through the Module_Detail table. A many-to-many relationship is required between Module and Field through a join table (outer join or junction table) Field_Detail.
6 pages (1500 words) Assignment
Assignment Topic: Change Model – Initial Application
On the other hand, individuals are ruling the organizations and the organizations` business strategy heavily depends on them so it is vital to have qualified management who is ready to respond promptly and reliable on any possible challenge.
5 pages (1250 words) Assignment
Web Application development
Sports Pal is a social networking web application intended to connect the people with their taste of sports. Apart from other general purpose social networking website, Sports Pal
12 pages (3000 words) Assignment
INtro to rela dbase Business Intelligence and Data Warehouses week 9
Performing vast expository inquiries on a particular database is not advisable since it affects the systems performance (Ahlemeyer-Stubbe & Coleman, 2014). An explanatory inquiry could take a few minutes to handle. On the other side, a data warehouse is customized for
2 pages (500 words) Assignment
Implement a data warehousing solution alongside the formation of a business analytics
In this context, every functional department of an organization can upload their recent annual or quarterly basis data or can even analyse the existing data in case an organization is subjected to any form of operational issues or undertakes a
16 pages (4000 words) Assignment
Data base coursework assignment
For efficient services, Pronto Pizzas needs to implement a reliable database that will serve both the administration and the customers. The database should put into consideration several features such as load time and usability. Entities specify distinct
4 pages (1000 words) Assignment
Databases
To begin with, we must identify the attributes within the baseball statics. Identified attributes are as follows. Players are labeled as pitchers and hitters. The hitter statics include homeruns, batting average,
2 pages (500 words) Assignment
Hire a pro to write
a paper under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Click to create a comment