A university database contains information about professors (identified by SIN) and courses (identified by courseid). Professors teach courses. Professors can teach the same course in several semesters and each offering must be recorded. Every professor must teach some course.
1. Specify a conceptual design of this database using an ER diagram
2. Translate this design into a relational schema and implement it with SQL (show the necessary SQL statements to implement the tables)
3. Write an XML data definition to share the information in your database with others.
4. Show how you would convert the XML definition into HTML to display the record.