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.

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

.

+ 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

Sedhi tarah bolo naa... "Ye dgb hai ya shaitaan ki aanth?"

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.

just for idea not ditto copy:

https://binbox.io/0hCB7

WHAT IS INDEX

Index is a database object, which can be created on one or more columns
(16 Max column combinations). When creating the index will read the column(s) and forms a relevant data structure to minimize the number of data comparisons. The index will improve the performance of data retrieval and adds some overhead on data modification such as create, delete and modify. So it depends on how much data retrieval can be performed on table

CLUSTERED INDEX            

clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

EXAMPLES OF CLUSTERED INDEX

Assume that you often need to gather employee information by department. In the EMP table, you can create a clustering index on the DEPTNO column.

CREATE INDEX DEPT_IX

ON EMP

(DEPTNO ASC)

CLUSTER;

As a result, all rows for the same department are probably close together. DB2 can generally access all the rows for that department in a single read. (Using a clustering index does not guarantee that all rows for the same department are stored on the same page. The actual storage of rows depends on the size of the rows, the number of rows and the amount of available free space. Likewise, some pages may contain rows for more than one department.)

https://binbox.io/0hCB7

 yh kia 

is ma cluster use ho ga because finding the record is easy and also cluster is fast

define b to kren kesy clustere index better hy

solution cs403 gdb :

https://binbox.io/0hCB7

Attachments:

i think

  Non- Clustered Index

because Clustered index mai database update krny sy prob hain

mujhy bhi yahi lgta kyun k updation k lahaz sy Non-clustering sahi rahay gy.

no-clustered bilkul ghalat hae. non cluster m physically data do jaga m save hota hae. jaisy textbook ka index.  

kis ne kaha problems hain.. kisay problems?

Which indexing technique will be better for above scenario for updation of records?
1) Clustered Indexing
2) Non- Clustered Indexing

RSS

Latest Activity

+ ! ! ! "EM" ! ! ! updated their profile
33 minutes ago
DUA FATIMA liked + M.Tariq Malik's group MTH302 Business Mathematics & Statistics
45 minutes ago
DUA FATIMA liked + M.Tariq Malik's group PAK301 Pakistan Studies
45 minutes ago
DUA FATIMA joined + M.Tariq Malik's group
45 minutes ago
DUA FATIMA joined + M.Tariq Malik's group
57 minutes ago
be serious updated their profile
1 hour ago
ADIL SUFYAN liked + M.Tariq Malik's discussion ENG501 Final Term Papers Spring 2019 (24 August ~ 04 September 2019) & All Solved Past Papers, Solved MCQs & Helping Material
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS507 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material in the group CS507 Information Systems
2 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS507 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material in the group CS507 Information Systems
2 hours ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS507 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material
2 hours ago
+ M.Tariq Malik's 18 discussions were featured
2 hours ago
+ M.Tariq Malik added a discussion to the group CS507 Information Systems
2 hours ago

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

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

.