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

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: 2252

.

+ 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

in may opinion normalization is best because
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.

RSS

Latest Activity

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

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