CS-06 Data Base Management System June-2001
Q4(a). Is the following relation in Third Normal Form?
Roll No. Name Department Year Hostel Name
2101 Raman Physics I Ganga
2102 Krishna Chemistry I Ganga
2103 Abdul Mathematics U Kaveri
2104 John Botany S Kaveri
Justify your answer, if it is in Third Normal Form. If it is not, then bring it in Third Normal Form.
(b)Again consider the. record-types given in Question No. l(e):
Where S# and P# are keys respectively for SUPPLIER and PARTS.
Express the following in SQL:
(i) Get the part numbers that cost 20,30 or 40 rupees.
(ii) Get the supplier names who do not supply part
(iii) Get the part numbers whose cost is greater than average cost
© Discuss the issue of Data Replication or the issue of Data Fragmentation in respect of distributed database.