StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Relational Data Model Issues - Assignment Example

Cite this document
Summary
The assignment "Relational Data Model Issues" focuses on the critical analysis of the relational data model. Drawing a fully labeled E-R diagram to show the appropriate entities, (with primary keys underlined), relationships, cardinality ratios, and optional & mandatory membership classes…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.6% of users find it useful
Relational Data Model Issues
Read Text Preview

Extract of sample "Relational Data Model Issues"

Download file to see previous pages

M stands for “many”, m stands for “mandatory”, and o stands for “optional”.

The relational database schema consists of 4 tables. All relations are defined by a foreign key, which name begins with Fk_. Here are tables of the relational database schema.

Table Elector has a foreign key to the electorate this elector belongs to, to party this elector gives vote and to candidate this elector gives vote.

Table Party has a foreign key to its leader, a candidate who leads this party.

Table Candidate has a foreign key to the electorate this candidate is listed in, and to the party to which this candidate belongs to.

The first normal form (1NF) sets the very basic rules for an organized database:
- 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) (Chapple, 2005).

So, the field name (first, middle, last) should be replaced by a group of three fields: First_name, Middle_name, and Last_name.

The primary keys for each table are already identified.

There are no duplicate columns in the same table.

Here are tables of the relational database schema for the 1NF.

The 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 refer to it via secondary (foreign) key Fk_person.

...Download file to see next pages Read 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

CHECK THESE SAMPLES OF Relational Data Model Issues

Decision Making At Sleep-Inn Motel

This business is going through a number of issues.... These issues include decision on the manner of operation of business, new investments of capital for joining either of the chains, competition from different motels such as the Best Western inn, lack of developments in the turnoffs, insufficient signs for advertising the Sleepy-Inn motel, and the reduction in the level of occupancy.... This business is going through a number of issues.... These issues include decision on the manner of operation of business, new investments of capital for joining either of the chains, competition from different motels such as the Best Western inn, lack of developments in the turnoffs, insufficient signs for advertising the Sleepy-Inn motel, and the reduction in the level of occupancy....
10 Pages (2500 words) Case Study

Fundamental International Relation Theory Issues

The focal points of this paper are to analyze the merits and demerits of two Fundamental International Relation Theory issues and find out the more positive theory.... The basic concept may be incorporated into positive-sum game's emphasis on social closure to more clearly differentiate social classes which could develop into a model of the class structure, usefully differentiates relational and gradational conceptualizations of social class, and re-visits some key differences between Marxian and positive-sum game theory....
5 Pages (1250 words) Essay

Relational database solution

A relational data base can be explained or defined as a collection of data or information.... relational data base was invented in the 1970 by Edgar Codd at IBM Harrington (2004).... Without a good database design even the best programs cannot avoid problems related to data storage with issues such as the presence of inaccurate and inconsistent data ().... One very well known model for database management is the rational database solution....
2 Pages (500 words) Essay

Database Management System

This papper "Database Management System " discusses a database management system or DBMS as the kind of software intended to aid in maintenance and utilization of large storage of data.... data is being widely acclaimed as an organizational asset of value.... However, without the capability to manage this large amount of data or a failure to readily insert the significant information in response to a given question; it has the tendency to not only become a distraction but also a liability....
50 Pages (12500 words) Research Paper

Relational Database Management Systems and their Alternatives

In this scenario, relational database management systems provide an excellent support to companies for the management of their complex data in an effective and efficient manner (Jingmin & Wang, 2001).... relational database allows its users to store all the data and information in tables.... In this scenario, the Join function is used to unite relations, the project operation is performed to identify attributes and the select queries are performed for accessing data....
6 Pages (1500 words) Literature review

Oracle Database Management System and the Object Oriented Data Model Overview

The director's main requirement is that the current data capturing and processing can be streamlined and that these data can be queried to produce online and real-time reports concerning various departmental processes and that it can be distributed on the university's network later on and be able to be accessed from the fourteen constituent campuses of the university.... The current database is running on standalone machines running the Microsoft Office applications, especially Access 2003 to store the university data....
14 Pages (3500 words) Coursework

NoSQL and Big Data Management

It pairs that unique key with other associated keys in a simple data model.... The article "Big Data Management issues" focuses on the critical analysis of the major issues in big data management.... Big data can be described as large volumes of data that are both structured and unstructured.... The concept of being data has evolved in the current century.... In the 2000s, analysts described the concept of big data regarding the Vs: Volume, Velocity, and Variety....
8 Pages (2000 words) Article

Data Base Management Systems

One Popular DBMS product associated with the relational data model is the DB2, which is a Relational Database Management System from IBM.... One Popular DBMS product associated with the relational data model is the DB2, which is a Relational Database Management System from IBM.... One Popular DBMS product associated with the relational data model is the DB2, which is a Relational Database Management System from IBM.... The paper "data Base Management Systems " is an outstanding example of a management literature review....
10 Pages (2500 words) Literature review
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.
Contact Us