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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!