Create table as per below data & briefly discuss the why you use these the script for creating of table . only one attribute will be primary key.
The other two attributes will Restrict the duplication and must store data values.
Table name: DEPARTMENT
DPT_CODE DPT_NAME DPT_ALLOTMENT
-------- --------------- -------------
57 IT 65000
63 Finance 15000
47 HR 240000
27 RD 55000
89 QC 75000