Forum Stats

  • 3,854,179 Users
  • 2,264,333 Discussions
  • 7,905,589 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