Question: Q 3 . Create a table named customer _ groups with two columns: group _ id and group _ name Requirements: group _ id is

Q3.
Create a table named customer_groups with two columns: group_id and group_name
Requirements:
group_id is INT, primary key, the value of group_id starts from 1, increase by one automatically.
group_name is varchar (100). It is not allowed to be null.
Please write your query here:
Create a table named customers with three columns: customer_id, customer_name, and group_id.
Requirements:
customer_id is INT, primary key, the value of customer_id starts from 1, increase by one automatically.
customer_name is varchar (100). It is not allowed to be NULL.
 Q3. Create a table named customer_groups with two columns: group_id and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!