XSD File

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
	<xs:complexType name="EnrollmentType">
		<xs:sequence>
			<xs:element name="OfferingInfo">
				<xs:complexType>
					<xs:attribute name="OfferingID" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="StudentInfo">
				<xs:complexType>
					<xs:attribute name="StudentID" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="Grade" type="xs:string"/>
		</xs:sequence>
		<xs:attribute name="EnrollmentID" type="xs:ID" use="required"/>
	</xs:complexType>
	<xs:complexType name="OfferingType">
		<xs:sequence>
			<xs:element name="CourseInfo">
				<xs:complexType>
					<xs:attribute name="CourseCode" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="Section" type="xs:int"/>
			<xs:element name="Instructor">
				<xs:complexType>
					<xs:attribute name="FacultyID" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
		<xs:attribute name="OfferingID" type="xs:ID" use="required"/>
	</xs:complexType>
	<xs:complexType name="CourseType">
		<xs:sequence>
			<xs:element name="CourseName" type="xs:string"/>
			<xs:element name="PreReq" minOccurs="0" maxOccurs="unbounded">
				<xs:annotation>
					<xs:documentation>Reference to Course</xs:documentation>
				</xs:annotation>
				<xs:complexType>
					<xs:attribute name="CourseCode" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
		<xs:attribute name="CourseCode" type="xs:ID" use="required"/>
	</xs:complexType>
	<xs:complexType name="StudentType">
		<xs:sequence>
			<xs:element name="As_Person">
				<xs:complexType>
					<xs:attribute name="PersonID" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="Classification" type="xs:string"/>
			<xs:element name="CreditHours" type="xs:int"/>
			<xs:element name="GPA" type="xs:decimal"/>
			<xs:element name="Mentor">
				<xs:complexType>
					<xs:attribute name="FacultyID" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
		<xs:attribute name="StudentID" type="xs:ID" use="required"/>
	</xs:complexType>
	<xs:complexType name="FacultyType">
		<xs:sequence>
			<xs:element name="As_Person">
				<xs:complexType>
					<xs:attribute name="PersonID" type="xs:IDREF" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="Salary" type="xs:long"/>
			<xs:element name="Rank" type="xs:string"/>
		</xs:sequence>
		<xs:attribute name="FacultyID" type="xs:ID" use="required"/>
	</xs:complexType>
	<xs:complexType name="PersonType">
		<xs:sequence>
			<xs:element name="Name" type="xs:string"/>
			<xs:element name="Address" type="xs:string"/>
			<xs:element name="DOB" type="xs:string"/>
		</xs:sequence>
		<xs:attribute name="ID" type="xs:ID" use="required"/>
	</xs:complexType>
	<xs:element name="University">
		<xs:annotation>
			<xs:documentation>univ</xs:documentation>
		</xs:annotation>
		<xs:complexType>
			<xs:sequence>
				<xs:element name="Person" type="PersonType" minOccurs="0" maxOccurs="unbounded"/>
				<xs:element name="Faculty" type="FacultyType" minOccurs="0" maxOccurs="unbounded"/>
				<xs:element name="Student" type="StudentType" minOccurs="0" maxOccurs="unbounded"/>
				<xs:element name="Course" type="CourseType" minOccurs="0" maxOccurs="unbounded"/>
				<xs:element name="Offering" type="OfferingType" minOccurs="0" maxOccurs="unbounded"/>
				<xs:element name="Enrollment" type="EnrollmentType" minOccurs="0" maxOccurs="unbounded"/>
			</xs:sequence>
		</xs:complexType>
	</xs:element>
</xs:schema>