Question: 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
Get step-by-step solutions from verified subject matter experts
