We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

A Graded Discussion Board for Database Management System (CS403) will be opened on Thursday 16 February, 2017 and it will be closed on Friday 17 February, 2017.



Discussion Topic



Suppose an organization wants to develop a database and according to the nature of their operations, most of the tasks require extensive reporting and data read operations on the database for real time decision making. On the other hand, while performing write operations, organization also wants to make sure that no inconsistencies should occur in their database. Now as an expert of databases, you are required to suggest the organization that either they should go for normalized database design or de-normalized database design? Provide at least two proper reasons to support your answer.


Read the following instructions carefully before sending your comments:



GDB will have weight-age of 5% of your total subject marks.
Your discussion must be based on logical facts.
You should post your comments on the Graded Discussion Board & not on the Regular MDB. Both will run parallel to each other during the time specified above.
Your comments should be relevant to the topic i.e. clear and concise (Maximum 4-5 lines answer).
Books, websites and other reading material may be consulted before posting your comments. (Do not copy the material as it is.)
No extra time will be given for discussion.
You cannot participate in the discussion after the due date or through e-mail.

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 2256

.

+ 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?)

Replies to This Discussion

my answer is De-normalization. 

De-normalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data. It is often motivated by performance or scalability in relational database software needing to carry out very large numbers of read operations.

you can get answer from the following links.

thanks and Remember me in your prayers.

http://www.vertabelo.com/blog/technical-articles/denormalization-wh...

https://en.wikipedia.org/wiki/Denormalization

they also want that there should no inconsistency occur so i hop normalize database is consistent.. what you say??

No, Actually "De-normalization" will be wrong they both are opposite to each other in redundancies, We don't need redundancy in our database, So we must go for the Normalization Process.

"Normalization minimizes the redundancies that are present in data tables. Denormalization (reverse of normalization) adds redundant data or group data."

i think normalization is useful for an organization ..

what is your opinion ..?

but how SARA KHAN, u need to explain ur idea?

 yea i know ..

thanks a lot ..! 

i think normalization because it reduce redundancy and it is done to improve performance of query.

in may oppeninon normalization is best becuase

Normalized databases fair very well under conditions where the applications are write-intensive and the write-load is more than the read-load. This is because of the following reasons:

  • Normalized tables are usually smaller and have a smaller foot-print because the data is divided vertically among many tables. This allows them to perform better as they are small enough to get fit into the buffer.
  • The updates are very fast because the data to be updated is located at a single place and there are no duplicates.
  • Similarly the inserts are very fast because the data has to be inserted at a single place and does not have to be duplicated.
  • The selects are fast in cases where data has to be fetched from a single table, because normally normalized tables are small enough to get fit into the buffer.
  • Because the data is not duplicated so there is less need for heavy duty group by or distinct queries.

any one true solution today last date?

 noor thanks for sharing 

Note for All Members: You don’t need to go any other site for this assignment/GDB/Online Quiz solution, Because All discussed data of our members in this discussion are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links.

Please Discuss here about this GDB.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

 

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

.... How to Find Your Subject Study Group & Join .... 

RSS

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

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