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


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.

CS403 Database Management Systems GDB Fall 2019 Solution & Discussion

+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 502

.

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

Replies to This Discussion

Share the GDB Question & Discuss Here.... 

Dear Students,

The Graded Discussion Board (GDB) of the course Database Management System (CS403) will be opened on Wednesday, January 29, 2020 (29/01/2020) and will remain open for 2 days (48 hours) only.

GDB Instructions:

  1. You need to provide precise and to the point answer, avoid irrelevant details.
  2. Copied from the internet or another student will get zero marks.
  3. You cannot participate in the discussion after the due date via email.
  4. The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.

 

GDB Topic:

 

Suppose, you are going to develop an application that will be mainly used for data analysis. The database for this application contains huge amount of data which is mainly loaded in batches. This application does not require insertion/updation/deletion of individual records. Our main objective is to improve the performance of application to quickly perform desired analysis.

Now, as a student of the Database Management System, you are going to design the database for above application. In the database design, your main concern will be the “efficiency” in term of searching. Now would you normalize the database or keep your database in de-normalized form.

Justify your answer in either case with proper reasons.

CS403 GDB Solution Due date 30 1 2020

Cs403 GDB

Normalization is essentially a route of capably organizing data in a database. There are two goals of the normalization procedure: get rid of disused data and make sure data dependencies make intelligence both of these are laudable goals as they trim down the amount of hole a database consumes and ensure that data is sensibly stored.

Normalization is a step by step procedure to make DB design more well-organized and correct. A normalized database helps the DBA to preserve the evenness of the database. However, the normalization process is not a ought to, somewhat it is a powerfully recommended movement performed after the logical DB design stage. Not a have got to income, that the steadiness of the database can be maintained still with an un-normalized database design, though, it will make it complicated for the designer. Un-normalized relatives are more flat to errors or inconsistencies.

De-normalization is a system to move from senior to subordinate normal forms of database modeling in order to pace up database right of entry. De-normalization procedure is practical for deriving a physical data model form a rational form. There is a suitable motive for de normalization that is to improve the routine.

In the higher than given location to get better the presentation of request to rapidly scent preferred psychiatry we ought to keep our record in de-normalization form but we ought to care first the constancy of the scheme because the de-normalization leads the system to the discrepancy which is not satisfactory. The competence and presentation are the after the steadiness, if our scheme is consistence then for achieving the efficiency in term of penetrating, we may have to pay the cost of additional storage space due to keep the catalog de-normalized.

page.cs403 gdb solution ,,, change kr lna copy na karna ok

#CS403 GDB IDEA SOL 2019-20

Keeping in view the above scenario, in my opinion we should keep database in de-normalized form as there is no need to insert, delete and update individually.

Normalization is used when the faster insertion, deletion and update anomalies, and data consistency are necessarily required.

Here our main concern is to increase the performance of application, by increasing the efficiency of searching data from database.

As a student of database management system i think de-normalization is perfect in this case because de-normalization is database optimization technique used when faster search and optimize the read performance is our main objective, It is also helps us to avoid costly joins in a relational database.

CS403 GDB 2019-2020


Normalization is essentially a route of capably organizing data in a database. There are two goals of the normalization procedure: get rid of disused data and make sure data dependencies make intelligence both of these are laudable goals as they trim down the amount of hole a database consumes and ensure that data is sensibly stored.
Normalization is a step by step procedure to make DB design more well-organized and correct. A normalized database helps the DBA to preserve the evenness of the database. However, the normalization process is not a ought to, somewhat it is a powerfully recommended movement performed after the logical DB design stage. Not a have got to income, that the steadiness of the database can be maintained still with an un-normalized database design, though, it will make it complicated for the designer. Un-normalized relatives are more flat to errors or inconsistencies.
De-normalization is a system to move from senior to subordinate normal forms of database modeling in order to pace up database right of entry. De-normalization procedure is practical for deriving a physical data model form a rational form. There is a suitable motive for de normalization that is to improve the routine.
In the higher than given location to get better the presentation of request to rapidly scent preferred psychiatry we ought to keep our record in de-normalization form but we ought to care first the constancy of the scheme because the de-normalization leads the system to the discrepancy which is not satisfactory. The competence and presentation are the after the steadiness, if our scheme is consistence then for achieving the efficiency in term of penetrating, we may have to pay the cost of additional storage space due to keep the catalog de-normalized.

RSS

Latest Activity

NAGINA SHAHEEN replied to + M.Tariq Malik's discussion MTH603 Current Final Term Papers Fall 2019 (15 to 26 February 2020) & All Solved Past Papers, Solved MCQs & Helping Material in the group MTH603 Numerical Analysis
42 minutes ago
NAGINA SHAHEEN joined + M.Tariq Malik's group
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + posted a discussion
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + replied to BS MATH's discussion My Question?
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + replied to BS MATH's discussion My Question?
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + replied to BS MATH's discussion My Question?
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion Hold On...!
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + replied to +!!!StRaNGeR!!! +'s discussion وقت خوش خوش کاٹنے کا مشورہ دیتے ھوئے
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + liked +!!!StRaNGeR!!! +'s discussion جھے ایک خواب کا تاوان بھرنا ہے.. !
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + liked +!!!StRaNGeR!!! +'s discussion آپ گِر کر میری آنکھوں سے کدھر جائیں گے
1 hour ago
+ ! ! ❥ρsүcнσ༄ ! ! + liked +!!!StRaNGeR!!! +'s discussion وقت خوش خوش کاٹنے کا مشورہ دیتے ھوئے
1 hour ago
+!!!StRaNGeR!!! + posted discussions
1 hour ago

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

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

.