Observe the following table and answer the parts (i) and (ii): 1. In the above table, can we have Qty as primary key.
Observe the following table and answer the parts (i) and (ii):
Table: Store
| Item Code | Item | Qty | Rate |
| 10 | Gel Pen Classic | 1150 | 25 |
| 11 | Sharpener | 1500 | 10 |
| 12 | Ball Pen 0.5 | 1600 | 12 |
| 13 | Eraser | 1600 | 5 |
| 15 | Ball Pen 0.25 | 800 | 20 |
1. In the above table, can we have Qty as primary key.
2. What is the cardinality and degree of the above table?
4 views
1 Answers
1. We cannot use Qty as the primary key because there is a duplication of values and primary key value cannot be duplicated.
2. Degree =4
Cardinality = 5
4 views
Answered