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

The Art of Analysis - Research Paper Example

Cite this document
Summary
The author of this paper "The Art of Analysis" touches upon the normalization of the database. As the text has it, in this step redundancy or repetition of data is reduced while at the same time ensures that there is a unique column of the table that identifies each item in the table uniquely…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.4% of users find it useful
The Art of Analysis
Read Text Preview

Extract of sample "The Art of Analysis"

To normalize the table into the third form it means that the tables must attain the following status or characteristics:1. There should be elements or groups of elements that repeat themselves within a table2. There should be no partial dependencies on a concatenated key3. Non-key attributes should not depend on each other. The first step is to design a table for all of the attributes below then start to normalize it up to the third normal form. Orders: Order_id Order_dateCustomer_id Customer_name Customer_address Customer_city Customer_state Item_id Item_description Item_qty Item_price Item_total_price Order_total_priceFigure 1 table with all the fieldsThe First Normal Form In this step redundancy or repetition of data is reduced while at the same time ensures that there is a unique column of the table that identify each item in the table uniquely.

Looking at the above table there is no single column that can uniquely identify each of the items in a table. Therefore, two columns will be combined to form a primary key. This means that the uniqueness of the items are identified by Order_ID and Item_ID, this is called concatenation.OrdersOrder_id(PK) Order_date Customer_id Customer_name Customer_address Customer_city Customer_state Item_id (PK)Item_description Item_qty Item_price Item_total_price Order_total_priceDiagram 1The Second Normal Form Dependencies should not be partial on the combined key; this is the main task in this stage.

The items in the table must depend on all the combined keys, attributes should not depend on only one of the keys. Sending of normal form fails if this is not attained. Item total price and order total price are derivatives, hence, they should not be a part of the database all these fields, apart from the item quantity, do not fully depend on both order id and item id, hence, the table fails the 2nd normal form standards or requirements. OrdersOrder_id(PK) Order_date Customer_id Customer_name Customer_address Customer_city Customer_state Item_id (PK)Item_description Item_qty Item_price Item_total_price Order_total_priceDiagram 2.

The 1st normal form The solution to this is to split the table into two tables so that the items that depend on order id fall in the table with order-id as the primary key, while those items that depend on item-id fall in that table too. Given that item_qty fully depends on order id, item id field and order id field, which is also in the order-item table as primary forming a many to one relation indicated in the diagrams. After this the table now passed to the 2nd normal form by having field which depends fully on the primary key in the orders table (Diagram 3) but in order-items table the item_price and item_descripition do not depend on order_id as in case with the primary key, hence, further splitting of this table is needed.

With diagram 4 all the requirements for the 2nd normalization have been achieved. Diagram 3 Diagram 4 . The 2nd normalized form The 3d normal form The following should be attained1. There should be elements or groups of elements that repeat themselves within a table2. There should be no partial dependencies on a concatenated key3. Non-key attributes should not depend on each other.To avoid repetition, for instance, if a customer makes several orders, their address and name will be repeated in the order tables, hence, another table called Customers table is created.

Diagram 5. The 3rd normal formFigure 2. The 3rd normalized formFigure 3 ReferencesLanger, Art. (1997). The Art of Analysis, devotes considerable space to normalization. Springer-Verlag Telos.Dr. Codd's Seminal. (1969). Paper on database normalization. Retrieved from www.acm.org/classics/nov95Coulson, Fred. (2010). 3 Normal Forms Database. Retrieved from http://www.phlonx.com/resources/nf3/

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“The Art of Analysis Research Paper Example | Topics and Well Written Essays - 250 words”, n.d.)
The Art of Analysis Research Paper Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/information-technology/1591684-normalization-relationships-and-constraints
(The Art of Analysis Research Paper Example | Topics and Well Written Essays - 250 Words)
The Art of Analysis Research Paper Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/information-technology/1591684-normalization-relationships-and-constraints.
“The Art of Analysis Research Paper Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/information-technology/1591684-normalization-relationships-and-constraints.
  • Cited: 0 times

CHECK THESE SAMPLES OF The Art of Analysis

Art Scavenger Hunt Analysis

Name of the of the Concerned Professor Subject 10 July 2011 Art Scavenger Hunt analysis 1.... (OzOutback: Online) Title of the Work “Gangi Nganan” or “First Mirriwung Man”- Aboriginal Rock Painting Artist/Artists Australian Aboriginal people Current Physical Location of the Piece Nganalam art Site located in Keep River National Park in Australia Medium Drawn using organic colors and materials on rocks Approximate Date Approximately 13,000 years old Internet Site where the Piece was found “Aboriginal Rock Paintings”....
5 Pages (1250 words) Essay

The Sten Gun Artwork

Though its dimensions may be small, the art work is immensely powerful.... Name: Professor: Institution: Date: Art analysis The work of art was an acrylic STEN MK.... V submachine gun drawn on a canvas courtesy of The Estate of Jeff Davies.... The STEN MK.... V submachine gun has its sight and muzzle resting on the globe and its stock the inscriptions God Bless America....
4 Pages (1000 words) Essay

Visual Analysis Art

Name: Professor: Course: Date: Introduction Art analysis attempts to evaluate the artistic sanding of the art or design and its effectiveness in communication of the anticipated message.... While the art points to heaven and at top of it during the night light shines resembling the biblical star that directed the Wiseman to the birth place of the king (Jesus)....
4 Pages (1000 words) Essay

Comparative Analysis of Art Pieces

They have impressive similarities in terms of theme, setting, atmosphere, and general impression conveyed. In this essay, each of the art pieces will be analyzed individually.... Everything on earth shows certain degrees of uniqueness, for no two things are exactly the same.... On the other hand, how ever different two things may be from each other, there will always be something in common between the two because there are certain conditions that are common to these two things....
7 Pages (1750 words) Book Report/Review

Art Scavenger Hunt-Analysis

These paintings were not merely works of art but also carried ample spiritual and religious significance.... The ancient aboriginal rock art to which the above given painting is affiliated to had some vital and important ritualistic purpose in the aboriginal societies (Buehler 58).... Perhaps, just as it is in the later day art galleries, the aborigines drew these paintings on the cave rocks to protect them from the ravages of time, so as to pass them safely to the future generations....
5 Pages (1250 words) Essay

Of Dots and Brushstrokes

Edgar Degas' Ballet Rehearsal on the Set was painted near the time A Sunday Afternoon on the Island of La Grande Jatte by Georges Seurat was made, a period where artworks flourished birthing different forms of the trade.... Although they have lived on the same era and from the… His usual subjects were ballet dancers which is linked to his owning a studio where he spent most of his time observing the movements of the Full Of Dots and Brushstrokes Edgar Degas' Ballet Rehearsal on the Set was painted near the time A Sunday Afternoon on the Island of La Grande Jatte by Georges Seurat was made, a period where artworks flourished birthing different forms of the trade....
2 Pages (500 words) Essay

The Ancient Art Analysis

The essay "The Ancient Art analysis" contains the comparison and contrast of the seated Buddha on the Lion Throne and Indra and Surya.... Ancient art AnalysisComparison and contrast of the seated Buddha on the Lion Throne and Indra and SuryaThe seated Buddha on the Lion Throne and the sculpture of Indra and Surya play a significant role in the Indian history....
2 Pages (500 words) Essay

Impression, Sunrise by Claude Monet

I like this paining because it is not static; thick brushstrokes add texture to the picture and keep it alive.... It is less photographic than paintings by classicists or… Overall, Monet did not have the aim to keep everything real; he wanted to capture the moment and did it successfully. This painting is very expressive in terms of feelings and emotions....
1 Pages (250 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.
Contact Us