## Rowaida AlOkka 220182247

### 1. Drop last_name column

ALTER TABLE owner DROP last_name;

### 2. Change first_name to full_name

ALTER TABLE owner CHANGE first_name full_name VARCHAR(20);

### 3. Add City != Gaza Constraint

ALTER TABLE owner ADD CONSTRAINT city_cons CHECK (city != 'Gaza');

### 4. Set Default Number

ALTER TABLE owner ALTER phone_number SET DEFAULT '0591234567';

# Car Table
### 1. Table Before Editing

### 2. Remove Auto Incremeant

ALTER TABLE car CHANGE id id int(11);

### 3. Drop Primary Key

ALTER TABLE car DROP PRIMARY KEY;

### 4. Allow model_name to be NULL

ALTER TABLE car MODIFY model_name VARCHAR(10) NULL;