Answered step by step
Verified Expert Solution
Question
1 Approved Answer
As you do the exercises, it is a good idea to copy/paste your query as well as your query result into a word processor. a.
As you do the exercises, it is a good idea to copy/paste your query as well as your query result into a word processor. a. Create a table called Cust with a customer number field as a fixed-length character string of 3, an address field with a variable character string of up to 20, and a numeric balance of five digits. b. Insert values in to the table with INSERT INTO . VALUES. Use the form of INSERT INTO . VALUES that requires that you to have a value for each attribute: therefore, if you have a customer number, address, and balance, you must insert three values with INSERT INTO . VALUES. c. Create at least five rows (rows in the table) with customer numbers 101 . 105 and balances of 200 to 2000. d. Display the table with a simple SELECT. From the Student-Course database, use the Student table to display the student names, classes, and majors for freshmen or sophomores (class
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