Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+1. Which of the following is true of boys compared with girls?

Answered: 1 week ago