Write a table creation script for a table called OWNER. Include the following:

Question

• Column for the owner id; primary key
• Column for the owner username (i.e., the logon name); unique and not null
• Column for the owner’s first name; can be null
• Column for the owner’s last name; can be null
Determine the appropriate data types.
```
CREATE TABLE owner (
owner_id NUMBER NOT NULL
CONSTRAINT OWNER_PK PRIMARY KEY,
user_name VARCHAR2(30) NOT NULL
CONSTRAINT OWNER_UK1 UNIQUE,
first_name VARCHAR2(30) NULL,
last_name VARCHAR2(30) NULL)
```
a) Add a row to OWNER using the following values:
• Owner id = 20
• Owner username = Cartman_E
• Owner first name = Eric
• Owner last name = Cartman
b) Create a sequence called SEQ_OWNER. Write a SELECT statement to find out the highest value currently in the OWNER table. Start the sequence at that value plus one when you create it.
c) Add to OWNERS table all the entries in the STUDENT table using an INSERT INTO…SELECT. Use the sequence number to generate the owner id. Construct the owner username using string functions and appending the student id to insure uniqueness (use the format MORRISON_A_122).

Answer 1

a.
```
INSERT INTO owner
VALUES (20,'Cartman_E','Eric','Cartman')
COMMIT
```
b.
```
SELECT MAX(owner_id)
FROM owner

CREATE SEQUENCE seq_owner
START WITH 21
```
c.
```
INSERT INTO owner
SELECT seq_owner.NEXTVAL,
last_name||'_'||SUBSTR(first_name,1,1)||TO_CHAR(student_id),
first_name, last_name
FROM student


SELECT *
FROM owner
```