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 files as you receive in your LMS, So it can be discussed/solved timely. Files Upload Here.

GDB Dated: Aug 06, 15

Dear Students,

 

Note that the Graded Discussion Board (GDB) of CS403 Database Management Systems will remain open for Two days (48 Hours only) from 12:00 AM August 12th, 2015 (Wednesday) to August 13th, 2015 (Thursday) till 11:59 PM according to Pakistan Standard Time.

 

The topic of Graded Discussion Board:

 

Orchid Textile is a large scale organization consisting of hundreds of employees in different office branches across country. HR department decided some new benefits and bonus policies according to pay scale and Designation of employees. So they need to update employees’ relevant record based on specific criteria.  Which indexing technique will be better for above scenario for updation of records?

 

1)      Clustered Indexing

2)      Non- Clustered Indexing

 

Justify your answer with proper reasoning.

 

Note: Try to provide precise (4 to 5 lines only including solid reasons), to the point answer and avoid irrelevant details

 

For any query: CS403@vu.edu.pk

--

Instructor CS403

+ 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: 5033

.

+ 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

According to the given scenario. Non-Clustered indexing is best. In Clustered Indexing we can efficiently ordered the data on the basis of First name or the Last name but we can not modified the data efficiently.
But in Non-Clustered indexing we can ordered the data also we can modified the data efficiently . Because, in Non-Clustered indexing the order of data logically and physically not same.

So, It is best to use Non-Clustered indexing according to the given scenario.

Thanks

yes got the point

final is non cluster is best for updation

why do you think clustered is not the right choice?

see given scenrio accourding the updation point of view

can you quote the lines or where it's written in detail that non-clustered is better for updating?

wrong

non clustered are much slower search for thousands of hundreds of records in a database. you can user apply composite cluster to combine designation and salary fields in desired order for quick search and update.

in non clustered index data is stored in two separate places. like textbook indexes which refer the address of the real data. which are much slower then the real clustered index where data is phisically stored in database. remember every table create automatically an index for the primary key in SQL server databa.se

ki musibat vay

sir dard laag gayi hai

Dear Fellows!

Kindly guide me if i am wrong that the only problem stated by most students, "Updation is the time taking process in Clustered Index and so is not good for heavy data"

For such type of problem, there is a solution available in clustered index that is creation of primary keys or foreign keys. where assigned such values which are less likely to be changed.

Now if u concentrate on our GDB, what it says? I think only updation is required "one Arear" filed which will decide bonus related to other benefits of the employees. 

Plz comments over it.

Clustered Index

  • Only one per table
  • Faster to read than non clustered as data is physically stored in index order

Non Clustered Index

  • Can be used many times per table
  • Quicker for insert and update operations than a clustered index

Both types of index will improve performance when select data with fields that use the index but will slow down update and insert operations.

Because of the slower insert and update clustered indexes should be set on a field that is normally incremental ie Id or Timestamp.

you wrong bro..

in this GDB, our primary key is not going to be change that certainly would be Employee Name or ID. So no new addition of row in the data. If Bonus and Incentives take place a new table and we allot them a primary and then connect these two tables, i mean Employee Table (already exist) and Bonus Table (updated material) then Clustered Index would be the best option to execute SQL searching and update criteria.

comments please.

RSS

Latest Activity

Atif Malik updated their profile
10 minutes ago
Shani Gujjar updated their profile
10 minutes ago
HaMza Tufail left a comment for Aniqa Fatima
16 minutes ago
HaMza Tufail left a comment for + M.Tariq Malik
43 minutes ago
+ ! ❤INNOCENT❤ commented on + ! ❤INNOCENT❤'s photo
55 minutes ago
Profile IconAmna, noor, tafseel and 15 more joined Virtual University of Pakistan
59 minutes ago
Syeda left a comment for Hafiz Furqan Sabir
1 hour ago
Hadi replied to MIT's discussion Visual Programing (CS411) Assignment#01 Deadline Date = 18-11-2019 in the group CS411 Visual Programming
1 hour ago
Profile IconHadi and Fazal ur Rehman joined + M.Tariq Malik's group
1 hour ago
November 2019 replied to + M.Tariq Malik's discussion CS301 Assignment No 01 Fall 2019 Solution & Discussion in the group CS301 Data Structures
1 hour ago
KIRAN SIAF replied to + M.Tariq Malik's discussion How to Prepare The Mid Term Exams & Study in VU
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked + M.Tariq Malik's discussion Waqar Files For Mid Term Past Papers
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked + M.Tariq Malik's discussion VU All Handouts Power Point Slides ( Handouts PPTs)
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion Army Public School and College Mangla........ Staff required!!
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked shan's discussion project cs619
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked UMER UMER's discussion images111.jpg
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut +'s discussion TERMPAPER ON ‘FINANCIAL SYSTEM OF BANGLADESH’.
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked +¢αяєℓєѕѕ gιяℓ's discussion Mera tu Mohabbat se aitbar.............:-P
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked +¢αяєℓєѕѕ gιяℓ's discussion Hazam Kary....!
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked +¢αяєℓєѕѕ gιяℓ's discussion Kashish Aur Mohabbat
1 hour ago

Today Top Members 

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

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