We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

the topic is

“Normalization Process removes the anomalies from the data but ultimately it affects the Query Performance why..?Justify the statement.”

Plz discuss about it here 
It will remain open for 2 days and will open on 18 january 


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


Views: 1341

Replies to This Discussion

Please Discuss here about this GDB.Thanks

kuch smjh aye to justify kren na kisi ko smjh ayi k kia justify krna he

ye kio DML oprations ki Query performance pr affect krta he koi bta skta he plzzzzzzzzzzzzzzz

Positive Affect: Normalization save our space by removing redundancy and anomalies and also save our record for curruption.

Negative Affect: It makes the DML query slow because number of joins are involved.

Networkmodel in a database with examples and characteristics.

Fariha Chaudhry gud keep it up 

This is because the Normalization process removes the anomalies from the data but ultimately it affects the Query performance of operations

Positive Affect: Normalization save our space by removing redundancy and anomalies and also save our record for corruption or damage.

Negative Affect: It makes the DML query slow because number of joins are involved

Fariha  Unrelated meterial. Tariq bhai weldon....Really appreciate to you.....

Using of normalization in sql is good because.....

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

thanks both

CS403 GDB SOLUTION

Positive Affect: Normalization save our space by removing redundancy and anomalies and also
save our record for corruption.
Negative Affect: It makes the DML query slow because number of joins is involved.

You can take idea from following paragraphs!
Application of normal forms beyond third normal
form can tend to produce too many entities, resulting in too many
entities in SQL query joins. Too many entities in SQL query joins can
reduce system performance for any type of database. The more entities in a
join, the more difficult queries are to tune. Also, more query complexity
makes it more difficult for a database query optimizer to make a best guess
at the fastest execution path for a query. The result is poor performance.
From a purely commercial perspective, good performance is much more
important than granular perfection in relational database design. It’s not
about the design but more about satisfied customers and end users. Poor
response time from a computer system will upset people. In fact, poor
response time can be much more than simply upsetting because it can
impact business and the bottom line for a company.
Over normalization using third normal forms and beyond can lead to
poor performance in both OLTP and data warehouse type databases. Over normalization
is more commercially in top-down designed Java object
applications. In this situation, an object structure is imposed onto a relational
database. Object and relational data structures are completely different
methodologies, because the fine details of granularity are inherent in
object modeling. The same is true of extreme application of normal forms,
but that creates too many entities, too much processing built into a database
model, and ultimately highly complex SQL coding and poor performance
as a result.


RSS

Latest Activity

Muhammad Faizan Alam liked ・༓☾ Shayna ☽༓・'s profile
11 minutes ago
Muhammad Faizan Alam liked Ellen Shades's profile
12 minutes ago
Muhammad Faizan Alam replied to Muhammad Faizan Alam's discussion CS604 - Operating Systems Assignment NO 1 Due Date: 30-November-2020 in the group CS604 Operating Systems
15 minutes ago
■ T̲h̲e̲ ̲J̲o̲k̲e̲r̲ ■ replied to ■ T̲h̲e̲ ̲J̲o̲k̲e̲r̲ ■'s discussion Why Chat is not working anymore?
23 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS506 Assignment 01 Fall 2020 Solution / Discussion in the group CS506 Web Design and Development
24 minutes ago
Aysha Maqbool replied to +M.Tariq Malik's discussion CS506 Assignment 01 Fall 2020 Solution / Discussion in the group CS506 Web Design and Development
34 minutes ago
Profile IconAysha Maqbool and madi ali joined +M.Tariq Malik's group
34 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
38 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
44 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
45 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
46 minutes ago
++!!Zuni Khan(Am Cyco) posted discussions
53 minutes ago

Looking For Something? Search Here

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.