A7 - Course relation, respectively. Suppose a database...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
- 1 - University of Waterloo School of Computer Science CS348 Spring 2009 Assignment 7 Due: July 21, 2009 1. Consider the following relational schema. Student(Id :Integer, Name:String, Address;String, Status:String) Course(DeptId:String, CourseCode :String, CourseName: String, Desc:String) Transcript(StudId :Integer, CourseCode :String, Semester :Stype, Year :Integer, Grade:Integer) The underlined attributes are the primary keys of the corresponding relation schemes. Stype consist of Term which assume values “Fall”, “Spring” or “Winter”. Grade is in the range of 0-100 CourseCode is a string of 6 characters, the first 3 are alphabetical string while the last 3 are number. For instance, CSC348. StudId and CourseCode in Transcript are foreign key referencing Student and
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Course relation, respectively. Suppose a database defined by the above schema is stored as a document. 30% (a) Give a DTD schema definition for the documents defined in the above database. Each document contains data on a database defined on the above schema. State constraints, if any, that cannot be captured with your design. Your design should be as simple as possible. 70% (b) Give an XML schema definition for the documents defined on the above database. Each document contains data on a database defined on the above schema. You may assume the default and target namespaces are the same. State constraints, if any, that cannot be captured by your design. Give an instance of a document based on your design....
View Full Document

Ask a homework question - tutors are online