Consider the E-R diagram in Figure 8.7 showing entity set instructor. Give an SQL schema definition corresponding to the E-R diagram, treating phone number as an array of 10 elements, using Orac/8le or PostgreSQL syntax.

Figure 8.7 

Transcribed Image Text:

instructor first_name middle_inital last_name ID name address street street_number street_name apt_number city state zip [phone_number} date of birth age ()