Use the alter table statement to add a primary key constraint for the rider_student table. 6. Use
Question:
Use the alter table statement to add a primary key constraint for the rider_student table.
6. Use the alter table statement to add a primary key constraint for the rider_major table.
7. Use the create table statement to create a table using the create table-like syntax. Create a customer table in your database using the dbclass.customer table.
8. Use the insert into / select from syntax to insert rows into the table you created in the previous step. You will insert rows from the dbclass. customer table into the table you created.
9. Use the alter table statement to create a check constraint on the customer table you created in the previous step. Create a constraint that guarantees that the values inserted into the age column are greater than 0.
Expert Answer:
6 Adding a primary key constraint for the riderstudent table ALTER TABLE riderstudent ADD ... View the full answer
