Question: Add an attribute to the instructor table named title. This attribute should have a default value of PHD. It should have a size of varchar(10)

Add an attribute to the instructor table named title. This attribute should have a default value of PHD. It should have a size of varchar(10) and it should be none nullable. (Please just write the SQL code needed for this).
student Id CHAR(9) NN name VARCHAR(50) address VARCHAR(50) major VARCHAR(10) NN Indexes + registration student_id CHAR(9) NN of course_id VARCHAR(10) grade CHAR(1) NN Indexes instructor name VARCHAR(50) IN location CHAR(5) NA Indexes course id VARCHAR(10) NN -OC title VARCHAR(45) Nov instructor_name VARCHAR(50) Indexes NN
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
