Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 3 . Create a table named customer _ groups with two columns: group _ id and group _ name Requirements: group _ id is
Q
Create a table named customergroups with two columns: groupid and groupname
Requirements:
groupid is INT, primary key, the value of groupid starts from increase by one automatically.
groupname is varchar It is not allowed to be null.
Please write your query here:
Create a table named customers with three columns: customerid customername, and groupid
Requirements:
customerid is INT, primary key, the value of customerid starts from increase by one automatically.
customername is varchar It is not allowed to be NULL.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started