Write a command to add a constraint to the groups table so that the group name i

Question

Write a command to add a constraint to the groups table so that the group name in each record is uniques:

Table: members Column Name member id last_namee first name address city state phone annual dues payment_date Data Type NUMBER VARCHAR2(50) No VARCHAR2(50) No VARCHAR2(100) Yes VARCHAR2(30 Yes CHAR(2) CHAR(12) NUMBER(5,2) Yes DATE Nullable Default Data Constraint No PK Yes No 52.5 Yes Table: member_groups Column Name member id group_id Data Type NUMBER NUMBER Nullable Default Data No No Constraint PK,FK PK,FK Table: groups Column Name group_id group_name Nullable Default Data Constraint Data Type NUMBER PK VARCHAR2(30 Yes

Explanation / Answer

the general Syantax to add a UNIQUE constraint is:-

ALTER TABLE table_name ADD CONSTRAINT constraint_name UNIQUE (column_name);

sql command to add a constraint explicitly-

ALTER TABLE groups ADD CONSTRAINT gp_group_name_unique UNIQUE (group_id);

If there is anything that you do not understand, then please mention it in the comments section.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.