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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!