===================================================================== Question #1: ------------------------------------------------------------------ STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-----|-----|-------|---------| | _x | P. | P. | P. | | P. | | ------------------------------------------------------------------------- LIVES_IN | StuID | DormID | Room_Number | ------------------------|---------------|----------------|--------------| NOT | _x | | | ===================================================================== Question #2: ------------------------------------------------------------------------ STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-----------|-----|-------|---------| | _S | | | P.AVG.ALL | | | | ------------------------------- PARENT_OF | FacID | StuID | ------------|--------|--------| | | _S | ===================================================================== Question #7: -------------------------------------------------------------------------- FACULTY | FacID | Lname | Fname | Rank | Sex | Phone | Room | Building | ---------|-------|--------|-------|------|-----|-------|------|----------| | _Z | | | | F | | | | -------------------------------------------------------------------------- COURSE | CID | CName |Credits| Instructor | Days | Hours | DNO | ---------|-------|--------|-------|------------|-------|-------|---------| | _Y | | | _Z | | | | ------------------------------------------------------------------ STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-----|-----|-------|---------| | _X | P. | P. | P. | F | | | --------------------------------------- ENROLLED_IN | StuID | CID | Grade | ------------|--------|--------|-------| | _X | _Y | | ------------------------------------------------------------------ DEPARMENT | DNO |Division| DName | Room | Building | DPhone | ----------|-------|--------|-------|--------|-----------|--------| | _W | EN | | | | | | _V | EN | | | | | -------------------------------------------- MEMBER_OF | FacID | DNO | Appt_Type | ------------|--------|---------|-----------| | _Z | _V | Primary | ------------------------------- MINOR_IN | StuID | DNO | ------------|--------|--------| | _X | _W | ===================================================================== Question #8: ----------------------------------------------------------------------------- FACULTY | FacID | Lname | Fname | Rank | Sex | Phone | Room | Building | ---------|-------|-----------|-------|------|-----|-------|------|----------| | _Z | Smolensky | Paul | | | | | | | _W | Smolensky | Paul | | | | | | -------------------------------------------------------------------------- COURSE | CID | CName |Credits| Instructor | Days | Hours | DNO | ---------|-------|--------|-------|------------|-------|-------|---------| | _Y | | | _Z | | | | | _V | | | _W | | | | ------------------------------------------------------------------ STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-----|-----|-------|---------| | _X | P. | P. | | | | | --------------------------------------- ENROLLED_IN | StuID | CID | Grade | ------------|--------|--------|-------| | P.G._X | _Y | | ------------------------------- CONDITIONS | ------------------------------| CNT.ALL._Y = CNT.ALL._V | ===================================================================== Question #9: ------------------------------------------------------------------ STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-----|-----|-------|---------| | P._X | P. | P. | | | | | | _Z | Smith | Linda | | | | | --------------------------------------- ENROLLED_IN | StuID | CID | Grade | ------------|--------|--------|-------| | _X | _C1 | | | _Y | _C1 | | | _Y | _C2 | | | _Z | _C2 | | ===================================================================== Question #14: -------------------------------------------------------------------------- STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-------------|-----|-------|---------| | _s1 | P. | P. | | | | | -------------------------------------------------------------------------- STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-------------|-----|-------|---------| | _s2 | P. | P. | | | | | ------------------------------------------------------------------------- LIVES_IN | StuID | DormID | Room_Number | ------------------------|---------------|----------------|--------------| | _s1 | _d | _n | ------------------------------------------------------------------------- LIVES_IN | StuID | DormID | Room_Number | ------------------------|---------------|----------------|--------------| | _s2 | _d | _n | ----------------------------------- Conditions | ----------------------------------- _s1 < _s2 | ===================================================================== Question #20: ---------------------------------------------------------- ACTIVITY | ActID | Activity_Name | ---------|--------------|--------------------------------| | _a | P. | ---------------------------------------------------------- PARTICIPATES_IN | StuID | ActID | ------------------------|---------------|----------------| | | _a | ------------------------------------------------------------------ FACULTY_PARTICIPATES_IN | FacID | ActID | --------------------------------|---------------|----------------| NOT | | _a | ===================================================================== Question #22: ----------------------------------------------------------------------------------------- STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | City_Code | ----------|-------|--------|-------|-------------|-----|-------|---------|--------------| | _s1 | P. | P. | | | | | _ci1 | ----------------------------------------------------------------------------------------- STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | City_Code | ----------|-------|--------|-------|-------------|-----|-------|---------|--------------| | _s2 | P. | P. | | | | | _ci2 | ------------------------------------------------------------------------- LIVES_IN | StuID | DormID | Room_Number | ------------------------|---------------|----------------|--------------| | _s1 | _d | _n | ------------------------------------------------------------------------- LIVES_IN | StuID | DormID | Room_Number | ------------------------|---------------|----------------|--------------| | _s2 | _d | _n | ------------------------------------------------------------------------------ CITY | City_Code | City_Name | State | Country | Latitude | Longitude | --------|------------|------------|--------|----------|----------|-----------| | _ci1 | | | _nat1 | | | ------------------------------------------------------------------------------ CITY | City_Code | City_Name | State | Country | Latitude | Longitude | --------|------------|------------|--------|----------|----------|-----------| | _ci2 | | | _nat2 | | | ----------------------------------- Conditions | ----------------------------------- _s1 < _s2 | ----------------------------------- Conditions | ----------------------------------- _nat1 <> _nat2 | ===================================================================== Question 24: -------------------------------------------------------------------------- FACULTY | FacID | Lname | Fname | Rank | Sex | Phone | Room | Building | ---------|-------|--------|-------|------|-----|-------|------|----------| | _f |P. |P. | | | | | | | | | | | | | | | -------------------------------------------- MEMBER_OF | FacID | DNO | Appt_Type | ------------|--------|---------|-----------| | _f |_d | | ------------------------------------------------------------------ STUDENT | StuID | Lname | FName | Age | Sex | Major | Advisor | ----------|-------|--------|-------|-----|-----|-------|---------| |_x | | | | | |_f | |_z | | | | |_d1 | | | | | | | | | | --------------------------- MINOR_IN | StuID | DNO | ---------|--------|-------| |_z |_d2 | | | | | | | --------------------------------------- ENROLLED_IN | StuID | CID | Grade | ------------|--------|--------|-------| | _x |_c | | | _y |_c | | | | | | ----------------------------------------------- LIVES_IN | StuID | DormID | Room_number | ---------|---------|---------|----------------| | _y |_o |_r | | _z |_o |_r | | | | | ----------------------------------- Conditions | ----------------------------------- _d =_d1 or _d =_d2 | ----------------------------------- Conditions | ----------------------------------- !x=_y |