Multiple Type Inheritance SQL:1999 and SQL:2003 do not support multiple inheritance If our type system supports multiple inheritance,we can define a type for teaching assistant as follows: create type Teaching Assistant under Student,Teacher To avoid a conflict between the two occurrences of department we can rename them create type Teaching Assistant under Student with departmentas student dept) Teacher with (department as teacherdept) ■ Each value must have a most-specific type Database System Concepts-7th Edition 29.13 ©Silberscha乜，Korth and SudarshanDatabase System Concepts - 7 29.13 ©Silberschatz, Korth and Sudarshan th Edition Multiple Type Inheritance ▪ SQL:1999 and SQL:2003 do not support multiple inheritance ▪ If our type system supports multiple inheritance, we can define a type for teaching assistant as follows: create type Teaching Assistant under Student, Teacher ▪ To avoid a conflict between the two occurrences of department we can rename them create type Teaching Assistant under Student with (department as student_dept), Teacher with (department as teacher_dept) ▪ Each value must have a most-specific type