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

.

+ 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

Mani Siddiqui BS VIII posted a status
"کبھی کبھی دل چاہتا ہے کہ میں کسی سے دل کی باتیں کہہ دوں اور وہ میرے بکھرے الفاظ کو ترتیب دے کر میری ساری باتیں سمجھ جائے"
24 minutes ago
mansoor liked +! ! ! Mano ! ! !+'s discussion issy kehty hn help
1 hour ago
mansoor replied to +! ! ! Mano ! ! !+'s discussion issy kehty hn help
1 hour ago
+! ! ! Mano ! ! !+ replied to +! ! ! Mano ! ! !+'s discussion issy kehty hn help
1 hour ago
Somia and KWL ex student are now friends
2 hours ago
hafsa updated their profile
2 hours ago
mansoor commented on + IUUOƆƎUT +'s blog post China coronavirus: A new Virus in China
2 hours ago
mansoor commented on + IUUOƆƎUT +'s blog post Coronavirus in the Islamic world
2 hours ago
mansoor replied to zohaib iftikhar's discussion ...* HER BEMARI KA ILAJ ...*
2 hours ago
mansoor liked +!!!StRaNGeR!!! +'s discussion دوسرا عشق نہ کروں، جی بہتر
2 hours ago
mansoor liked +!!!StRaNGeR!!! +'s discussion تم نہ آۓ ! تو ، کیا سحر نہ ہوئی ؟۔
2 hours ago
mansoor liked +!!!StRaNGeR!!! +'s discussion مختصر سی یہ زندگانی ہے
2 hours ago

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

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

.