Question
Create a table named products based on the following information. Make sure you create all given constraints in the following table. Column Name Column Type
Create a table named products based on the following information. Make sure you create all given constraints in the following table.
| Column Name | Column Type | nullable | PK | FK | UK | CK |
| product_id | Number(4) | no | yes |
|
|
|
| name | Char(35) |
|
|
|
|
|
| supplier_id | Number(4) | no |
|
|
|
|
| price | Number(10,2) |
|
|
|
| Price cannot be less than $5.0. It cannot be greater than $1000,000. |
| For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). |
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
The Database Relational Model A Retrospective Review And Analysis
Authors: C. J. Date
1st Edition
0201612941, 978-0201612943
