UPDATE TABLE & ALTER TABLE statement (Problems 8.20-8.25) | California State University, Northridge - Edubirdie

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

2024
Views:

384

Pages:

3
Author:

Riley K.

UPDATE TABLE & ALTER TABLE statement (Problems 8.20-8.25) New Attempt Due Nov 15 by 11:59pm Points 20 Submitting a file upload File Types odf 20. Enable auto increment to generate values for customer numbers. The values should start with 2000 21. Enable auto increment to generate values for invoice members. The values should start with the value 9000, 22. Insert the following customer into the CUSTOMER table, using the auto increment from Problem 20 to generate the customer number automatically: "Powers'. "Ruth', 500 23. Modify the CUSTOMER table to include the customer's date of birth (CUST_DOB), which should store date data. 24. Modify customer 1000 to indicate the date of birth as March 15, 1989. 25. Modify customer 1001 to indicate the date of birth as December 22, 1988.

Related Documents

UPDATE TABLE & ALTER TABLE statement (Problems 8.20-8.25)

UPDATE TABLE & ALTER TABLE statement (Problems 8.20-8.25) - Page 1

UPDATE TABLE & ALTER TABLE statement (Problems 8.20-8.25) - Page 2

UPDATE TABLE & ALTER TABLE statement (Problems 8.20-8.25) - Page 3

of 3

Recommended Documents

Quiz 1 - Introduction to Database Systems

Quiz 1 - Introduction to Database Systems

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 3 - The Relational Database Model

Quiz 3 - The Relational Database Model

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 5 - Advanced Data Modeling

Quiz 5 - Advanced Data Modeling

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 10 - Database Performance Tuning and Query Optimization

Quiz 10 - Database Performance Tuning and Query Optimization

California State University, Northridge COMP 440 | Database Design

Answer Key

CREATE TABLE & INSERT statement (Problems 8.16-8.19)

CREATE TABLE & INSERT statement (Problems 8.16-8.19)

California State University, Northridge COMP 440 | Database Design

Assignment

CREATE TRIGGER & PROCEDURE statement (8.26-8.30)

CREATE TRIGGER & PROCEDURE statement (8.26-8.30)

California State University, Northridge COMP 440 | Database Design

Assignment

Query optimization (Problems 11.11-11.14)

Query optimization (Problems 11.11-11.14)

California State University, Northridge COMP 440 | Database Design

Assignment

Quiz 8 - Advanced SQL

Quiz 8 - Advanced SQL

California State University, Northridge COMP 440 | Database Design

Answer Key

Normalize Table (Problem 6.5)

Normalize Table (Problem 6.5)

California State University, Northridge COMP 440 | Database Design

Assignment

Transaction management (Problem 10.1)

Transaction management (Problem 10.1)

California State University, Northridge COMP 440 | Database Design

Assignment

Create ERD (Problem 5.3)

Create ERD (Problem 5.3)

California State University, Northridge COMP 440 | Database Design

Assignment

Quiz 7 - Introduction to SQL

Quiz 7 - Introduction to SQL

California State University, Northridge COMP 440 | Database Design

Answer Key