University:
California State University, Northridge
Course:
COMP 440 | Database Design
Academic year:

2024
Views:

359

Pages:

3
Author:

Riley K.

CREATE TABLE & INSERT statement (Problems 8.16-8.19) Assignment Details: Due: Nov 8 by 11:59pm Points: 20 Submitting: a file upload File Types: pdf Table Illustrations (from "Figure P8.16"): Table name: CUSTOMER Column Names and Data: CUST_NUM: 1000, 1001 CUST_LNAME: Smith, Ortega CUST_FNAME: Jeanne, Juan CUST_BALANCE: 1050.11, 840.52 Table name: INVOICE Column Names and Data: INV_NUM: 3000, 3001, 3002, 3003, 3004 CUST_NUM: 1000, 1001, 1001, 1000, 1000 INV_DATE: 23-Mar-22, 23-Mar-22, 30-Mar-22, 12-Apr-22, 23-Apr-22 INV_AMOUNT: 235.89, 312.82, 528.10, 194.78, 619.44 Problems: Problem 16: Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should store integer values. The name attributes should support variable length character data up to 30 characters each. The customer balance should support up to six digits on the left of the decimal place and two digits to the right of the decimal place. Problem 17: Create the INVOICE table structure illustrated in Figure P8.16. The invoice number should store integer values. The invoice date should store date values