Forum Stats

  • 3,837,076 Users
  • 2,262,223 Discussions
  • 7,900,198 Comments

Discussions

TABLE CREATION

Shahab Mohyeuddin
Shahab Mohyeuddin Member Posts: 1 Green Ribbon

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

Answers