Back to School Offer

Get 20% of Your First Order amount back in Reward Credits!

Get 20% of Your First Orderback in Rewards

All papers examples
Get a Free E-Book! ($50 Value)
HIRE A WRITER!
Paper Types
Disciplines
Get a Free E-Book! ($50 Value)

The Data Mining, Essay Example

Pages: 1

Words: 330

Essay

Why are there so many more foreign keys in the third normal form than in the first?

In second normal form, tables were created for all data related to the data contained in the first table (Date, 1999).

Is this always going to be true?

No, but it usually is (Freetutes.com, 2011).

Why is it important to define the primary keys of a file correctly?

They are necessary for relational binding on from master to slave tables (Kent, 1983).

What happens to the third normal form when they are incorrectly defined?

The relationships will be wrong (Date, 1999).

Some designers will say that to make an address file into third normal form, you should take out the city and state, place it into a different table, and link it by zip code. What advantages and disadvantages are there to this?

The advantage is that it eliminates maintaining repetitive city, state, and zip data for each record (Freetutes.com, 2011).

The disadvantage is that a location may not follow the city, state, zip pattern strictly (Kent, 1983).

When normalizing a table that can have a many-to-many relationship with another table, what steps should you take?

Identify primary keys in tables (Date, 1999).

Create a composite table of foreign keys (Freetutes.com, 2011).

Link the primary keys to the forgeign keys of the composite table (Kent, 1983).

What are the advantages of third normal form for applications with a lot of changes to the database, such as a data entry program?

The advantage is that data integrity is maintained (Date, 1999).

What are the disadvantages of third normal form for an application that does a lot of reporting on a stable database like general ledger month-end reporting?

The disadvantage is that complex queries must be configured to report the appropriate data (Freetutes.com, 2011).

References

Date, C. J. (1999). An Introduction to Database Systems (8th ed.). Addison-Wesley Longman.

Freetutes.com (2011). Systems analysis and design: Complete introductory tutorial for software engineering. Freetutes.com. Retrieved from http://www.freetutes.com/systemanalysis/

Kent, W. (1983). A Simple Guide to Five Normal Forms in Relational Database Theory, Communications of the ACM, 26: 120–125.

Time is precious

Time is precious

don’t waste it!

Get instant essay
writing help!
Get instant essay writing help!
Plagiarism-free guarantee

Plagiarism-free
guarantee

Privacy guarantee

Privacy
guarantee

Secure checkout

Secure
checkout

Money back guarantee

Money back
guarantee

Related Essay Samples & Examples

Emerging Concepts in Therapies for Autism Spectrum Disorder, Essay Example

Autism spectrum disorder, abbreviated as ASD, is a neuro-developmental disorder caused by brain differences. ASD is characterized by chronic difficulties in social communication that causes [...]

Pages: 3

Words: 949

Essay

Alice’s Adventures in Wonderland, Essay Example

As an episodic novel, Carroll’s book offers more insight into the characters and situations they encounter than it does into the story. The events of [...]

Pages: 5

Words: 1412

Essay

Building Leaders Up, Essay Example

Leadership Definition Leadership refers to the ability of an individual to influence, motivate, and guide other individuals or groups to achieve common goals. Leaders typically [...]

Pages: 9

Words: 2441

Essay

Relationship Conflict, Essay Example

Conflict is a natural and inevitable part of any relationship. It arises when two or more people have different goals, needs, or perceptions. The most [...]

Pages: 6

Words: 1621

Essay

Aristotle’s Concepts of Catharsis and Tragic Pleasure, Essay Example

Aristotle indicates in the first passage that producing a cathartic effect is a crucial element when it comes to constructing a tragedy. In the second [...]

Pages: 1

Words: 280

Essay

African – American History: Black American Cinema, Essay Example

Black American Cinema is about criticism of films produced by black Americans. This is the first inclusive collection of African American cinema critiques. From the [...]

Pages: 4

Words: 1012

Essay

Emerging Concepts in Therapies for Autism Spectrum Disorder, Essay Example

Autism spectrum disorder, abbreviated as ASD, is a neuro-developmental disorder caused by brain differences. ASD is characterized by chronic difficulties in social communication that causes [...]

Pages: 3

Words: 949

Essay

Alice’s Adventures in Wonderland, Essay Example

As an episodic novel, Carroll’s book offers more insight into the characters and situations they encounter than it does into the story. The events of [...]

Pages: 5

Words: 1412

Essay

Building Leaders Up, Essay Example

Leadership Definition Leadership refers to the ability of an individual to influence, motivate, and guide other individuals or groups to achieve common goals. Leaders typically [...]

Pages: 9

Words: 2441

Essay

Relationship Conflict, Essay Example

Conflict is a natural and inevitable part of any relationship. It arises when two or more people have different goals, needs, or perceptions. The most [...]

Pages: 6

Words: 1621

Essay

Aristotle’s Concepts of Catharsis and Tragic Pleasure, Essay Example

Aristotle indicates in the first passage that producing a cathartic effect is a crucial element when it comes to constructing a tragedy. In the second [...]

Pages: 1

Words: 280

Essay

African – American History: Black American Cinema, Essay Example

Black American Cinema is about criticism of films produced by black Americans. This is the first inclusive collection of African American cinema critiques. From the [...]

Pages: 4

Words: 1012

Essay

Get a Free E-Book ($50 in value)

Get a Free E-Book

How To Write The Best Essay Ever!

How To Write The Best Essay Ever!