Nobody downloaded yet

Relational Data Model - Assignment Example

Comments (0) Cite this document
Summary
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER92.3% of users find it useful
Relational Data Model
Read TextPreview

Extract of sample "Relational Data Model"

Download file to see previous pages 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 ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Relational Data Model Assignment Example | Topics and Well Written Essays - 1000 words”, n.d.)
Relational Data Model Assignment Example | Topics and Well Written Essays - 1000 words. Retrieved from https://studentshare.org/politics/1501687-relational-data-model
(Relational Data Model Assignment Example | Topics and Well Written Essays - 1000 Words)
Relational Data Model Assignment Example | Topics and Well Written Essays - 1000 Words. https://studentshare.org/politics/1501687-relational-data-model.
“Relational Data Model Assignment Example | Topics and Well Written Essays - 1000 Words”, n.d. https://studentshare.org/politics/1501687-relational-data-model.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Relational Data Model

Relational Dialectics

...?Individuality vs. Unity – an Unending Challenge A relationship, whether romantic or arranged, is neither an accident that just persists by chance nor a dice roll that the desired outcome purely depends on probability as what most people presume. Everything involved in a particular relationship follows one certain edict of nature which is theoretically known as the Relational Dialectics. This term implies to the pairs of opposing forces that depend on each other and in majority of ways, influence the outcomes of most relationship. Relational dialectics commonly disguise itself as individuality ­- that each person was made different from another thus occurrences of misunderstandings and conflicts are...
4 Pages(1000 words)Essay

Relational Technology

...Client's 16 November 2009 Relational technology solution is one of the largest and an independent technology leasing company located in North America. It has very recently focused its attention on the healthcare sector and it has already turned around the healthcare sector to an unprecedented extent. This paper will expansively present the importance of relational technology solution and it will also focus upon how beneficial this solution really is. After the recent shift of focus towards the healthcare sector, relational technology solution had made a real difference in the healthcare sector. It has brought much advancement in the medical as well as the surgical sectors and as a result of which many lives have been saved... . This...
3 Pages(750 words)Essay

Data Model and Data Flow Diagram Assignment

...Data Model and Data Flow Diagram for PresRX Case: PresRX is a new online pharmacy that wants to provide prescription and non-prescription drugs to Canadian consumers. When a customer goes online, he is shown the drugs PresRX sells. To make the shopping easy, we allow the customer to search our products based on the following categories: pharmaceutical company, product type (prescription or non-prescription), drug type (antibiotics, antidepressant drugs or vitamins or cold/ flu drugs etc.), problems (like allergies or pain relief etc.) and the main ingredient (like penicillin). Each product also has the strength of the main ingredient (e.g. Allegra 30 mg, Allegra 50 mg etc.). The same...
6 Pages(1500 words)Essay

Data Model

...normal form (3NF) means following: Eliminate duplicative columns from the same table. Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key). 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. Remove columns that are not dependent upon the primary key. (Chapple 2005) So each entity, or table, has one and only one primary key named ID that is unique for every record in the table. So entities (tables) have following...
2 Pages(500 words)Essay

Data Model for Fitness Centre

...DATA MODEL FOR FITNESS CENTRE ENTITIES THE BUSINESS OF A FITNESS CENTRE: a) THE AUDIENCE The of the fitness centre can be ified into two types: i) The members: Those clients who have subscribed some package, have paid in advance and are regular clients. ii) The visitors: Those clients who have not subscribed some package, and pay per visit, when they visit. They are although not the regular clients but the potential ones. Thus, the fitness centre wants to keep a record of them and use them for target marketing. b) BUSINESS OPERATIONS: A fitness center performs following business activities. i) Equipments: Clients may use the resources of the gym, like exercise machines etc. ii) Ambiance: Not only...
3 Pages(750 words)Case Study

Relational Database

...in size as storage costs are not of much concern today. Data warehouses act as archives and analytical tool for the historical data. Relational Database Relational Databases Relational database was a revolution in the field of databases. The idea of having a tabular structure composed of rows and columns was a ground breaking proposition to make storage and retrieval easier than ever before. Peter Rob in his book describes the relational database in terms of storage and representation. The relational database model allows the designer to focus on the logical representation of the data...
8 Pages(2000 words)Essay

Data Model and Data Warehouse Design Architecture & XML

...by these operational database systems which are actually relational databases, and are required to be integrated in the data warehouse. Every clinic has also a manager and a number of staff, such as, cleaners, nurses, and etc. b) Entity Relationship Diagram c) Data Warehouse Model (Star Schema) d) Benefits and Threats As discussed in article at Exforsys (The benefits of data warehouses, n.d.), the proposed implementation would provide the following benefits: Assist the company in making important business decisions. Allow the decision makers to view the company as a whole, rather than looking at the company in terms of the clinics that it owns. Allow the...
12 Pages(3000 words)Essay

Data Model and Data Warehouse Design Architecture & XML

...a centralized database in which it maintains all the information related to its staff, customers, councils, and applications. This centralized database is a relational database which will represent the information source for the data warehouse in this scenario. b. ER Diagram c. Data Warehouse Model d. Benefits and Threats As described by Khan (2003), the implementation of data warehouse can provide the following benefits to any organization, including the company mentioned in the scenario: Facilitate integration in an environment of un-integrated applications Integrate enterprise data across a variety of...
12 Pages(3000 words)Essay

Complaint-Push Model and Data-Pull Model

... to utilize the system. The fragmented system of care delivery in U.S is a significant aspect of a complex health care system that represents barriers to a more rapid diffusion of HIT. To minimize this aspect, we must adopt a federal-state framework for HIT implementation that will foster HIT diffusion by creating an oversight mechanism for the implementation of HIT in U.S. This will enhance quality improvement, access, and integration of health care organisation, HIT systems, health information, and healthcare administration. Notably, Brenda Hunt’s address of complaint-push model and data pull model was relevant in that it related to previous literature as discussed by Joseph Tan, Fay Cobb Payton. Hunt’s strategy of improving... Health...
3 Pages(750 words)Coursework

RELATIONAL DATA MODEL

...Relational Data Model Number Lecturer Relational Data Model. Oracle database is one of the relational database management systems that is used for creation and maintenance of the database components such as tables. A relational database is made of a table that forms the basic unit for storage of data in the database. The database offers commands and functions that are used in the manipulation of the data and records that are stored in the database. The most basic step towards using the oracle database management system is to install the system in the computer and be able...
2 Pages(500 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Relational Data Model for FREE!

Contact Us