Page 1 of 1
(3 points) A table that has three attributes A, B, and C is physically stored in an ordered file using attribute A as a
Posted: Tue Jul 05, 2022 10:27 am
by answerhappygod
- 3 Points A Table That Has Three Attributes A B And C Is Physically Stored In An Ordered File Using Attribute A As A 1 (27.46 KiB) Viewed 13 times
(3 points) A table that has three attributes A, B, and C is physically stored in an ordered file using attribute A as a sort key. Assume the following: Assume that the blocking factor for this table is 5. The table has 100 blocks that are maxed out, i.e., each has the max number of records. A is unique, B is unique, and C contains duplicates but has 20 distinct values. Answer the following: A) If a primary index is to be created, which attribute will be used as an index-key? And how many entries will the primary index have? B) If a secondary index is to be created using attribute B, how many entries will the secondary index have?