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

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

.

+ 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

Azhar Sagar liked Azhar Sagar's discussion quiz main kese 10/10 mark la saktay hain cheating ka asan tareeqa
26 minutes ago
Azhar Sagar liked Azhar Sagar's discussion Subscribe my youtube channel for assignment solution and final year project help
26 minutes ago
M IDREES replied to + M.Tariq Malik's discussion CS403 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS403 Database Management Systems
27 minutes ago
Azhar Sagar posted discussions
27 minutes ago
M IDREES replied to + M.Tariq Malik's discussion CS403 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS403 Database Management Systems
28 minutes ago
M IDREES replied to + M.Tariq Malik's discussion CS403 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS403 Database Management Systems
31 minutes ago
M IDREES joined + M.Tariq Malik's group
31 minutes ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
37 minutes ago
Profile IconM IDREES, Abdul Ghaffar and Umair ali joined + M.Tariq Malik's group
37 minutes ago
+ AiM replied to 彡Tweety彡 ❤️'s discussion .... Mera Pakistan... :x:p
40 minutes ago
Siddiq khan kakar joined + M.Tariq Malik's group
46 minutes ago
+ M.Tariq Malik replied to +¢αяєℓєѕѕ gιяℓ's discussion CS202 - Fundamentals of Front End Development Assignments No. 1 Due Date Nov 14, 2019 in the group CS202 Fundamentals of Front End Development
57 minutes ago
+ M.Tariq Malik replied to +¢αяєℓєѕѕ gιяℓ's discussion CS202 - Fundamentals of Front End Development Assignments No. 1 Due Date Nov 14, 2019 in the group CS202 Fundamentals of Front End Development
59 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT211 GDB Fall 2019 Solution & Discussion in the group MGT211 Introduction To Business
59 minutes ago
Mian Ali added a discussion to the group MCM520 Contemporary Mass Media
1 hour ago
Mian Ali joined + M.Tariq Malik's group
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion EDU302 Human Development and Learning Assignment No 01 Fall 2019 Solution & Discussion in the group EDU302 Human Development and Learning
1 hour ago
Mian Ali joined + M.Tariq Malik's group
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS508 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 12-11-2019 in the group CS508 Modern Programming Languages
1 hour ago
+ !! SARAH replied to Rana Ali's discussion Tell some words in the Shan of Hazart Muhammad (S.A.W)
1 hour ago

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

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