Company Schema // basic entities department, employee, project (same three as in EN ER diagram) // note how dependents are handled here // wrong in EN? // keys and foreign keys // xsd:unique any candidate key // xsd:key the primary key // xsd:keyref a foreign key // xsd:selector table name // xsd:field attribute name // end of xsd:element name="company" // table definitions // Department: note departmentLocations // employee table; notice composite attributes employeeName, employeeAddress // note multivalued attributes employeeWorksOn, employeeDependent // note type WorksOn // project table: again note projectWorker, of type Worker (below) // composite attribute type