Objective: CREATE TABLE statement, Primary/Foreign key constraints
Problem 1:
Create the following table:
• Table name: customer
• Columns:
o customerID (whole number max 4 digits)
o customerName (variable character max 50 characters) o customerSince (date)
• Primary key on column customerID named customer_pk
Problem 2:
Execute the following two statements (inserting one sample record into table customer and verifying that record was correctly inserted):
• INSERT INTO customer VALUES(1008, 'New Customer', sysdate);
• SELECT * FROM customer;
Problem 3:
Create a second table:
• Table name: orders
• Columns:
o orderID (whole number max 8 digits) o orderDate (date)
o shippingMethod (variable character max 25 characters) o customerID (whole number max 4 digits)
• Primary key on column orderID named orderID_pk
• Foreign key on column customerID relating to column customerID in table customer named customerid_fk
Problem 4:
Execute the following statements:
• INSERT INTO orders VALUES(12345678, sysdate, '2-Day', 1008);
• INSERT INTO orders VALUES(88888888, sysdate, '2-Day', 1009);
• SELECT * FROM orders;
Problem 5:
Explain why the second INSERT statement under 4. failed with an error (No screenshot needed, simply a written answer).
