2 find the age of the oldest student who is either a

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: sname, Class (cname, meets-at, room, fid) (cname meetsEnrolled (snum, cname) (snum Faculty (fid, fname, deptid) (fid fname, deptid) Express each of the following integrity constraints in SQL. 2. Find the age of the oldest student who is either a History major or enrolled in a course taught by I.Teach. I.Teach. 4. Find the names of all students who are enrolled in two classes that meet at the same time. 5. Find the names of faculty members who teach in every room in which some class is taught. 10. Find the names of students enrolled in the maximum number of classes. (a) Every class has a minimum enrollment of 5 students and a maximum enrollment of 30 students. (c) Every faculty member must teach at least two courses. (i) No department can have more than 10 faculty members. 57 Exercise 5.10 (p. 180) 58 Views Consider the following relations: Emp (eid, ename, age, salary) ename, Works (eid, did, pct_time) pct_time) (eid Dept (did, budget, managerid) managerid) (did Express each of the following inte...
View Full Document

This note was uploaded on 10/15/2012 for the course CSE 4503 taught by Professor Edallen during the Fall '12 term at Mississippi State.

Ask a homework question - tutors are online