Activity (4 items x 5 points) Write SQL statements that will: 1. Create a table named Flavors with columns Item Code (in
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Activity (4 items x 5 points) Write SQL statements that will: 1. Create a table named Flavors with columns Item Code (in
Activity (4 items x 5 points) Write SQL statements that will: 1. Create a table named Flavors with columns Item Code (int), Item Desc (varchar), and Price (float). 2. Set Item Code as the primary key. 3. Add a CHECK constraint on the Price column to ensure that the lowest price is 65. 4. Delete the Item Desc column. Property of STI IT1924 Weeks 11-12
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!