Reference no: EM131100355
Question 1: Relational algebra
A database records information about tutorials in a particular unit offering (such as ICT285 this semester). A student is supposed to attend only one of several available tutorials, each of which is taken by a tutor at a particular day and time. A tutor might take several different tutorials.
The schema for this database is as follows: (note that primary keys are shown underlined, foreign keys in bold).
STUDENT (StudentNo, FamilyName, FirstName, StudentAddress, StudentEmail)
TUTORIAL (TutorialNo, DayAndTime, Lab)
TUTOR (StaffNo, TutorName, TutorEmail)
CLASS (StaffNo, TutorialNo)
ATTENDS (StudentNo, TutorialNo)
Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks.
a. List the student number, full name and email of all students.
b. List the day and time for all tutorials held in lab Lon 3.32
c. List the day and time, lab and tutor name for all tutorials.
d. List the student number and full name of all students in the Wednesday 10.30 lab.
e. List the student number and full name of all students in Val's classes.
f. List the student number, full name, tutorial details and tutor name of all students.
g. List the student number of any students who have signed up to attend both the Monday 4.30 and Monday 5.30 tutorial.
h. List the student number of any students who have signed up to attend any or all of the Wednesday tutorials (they are at 9.30, 10.30 and 11.30)
i. List all the students who aren't in any tutorial yet.
j. List the full name of any student who has signed up to attend all tutorials.
|
Writing the vectorized version of the program
: E27: Computer Vision - Spring 2016 - PROJECT 3. How did you approach writing the vectorized version of the program? Did you implement the iterative version first and then modify it, or did you do something else
|
|
About solving dynamic programming problems
: Consider the following statements about solving dynamic programming problems. Label each statement as true or false, and then justify your answer by referring to specific statements (with page citations) in the chapter.
|
|
Identify a best practice in community policing
: Identify a best practice in community policing that you believe could be replicated in most midsized police agencies. Why do you believe it has potential in most jurisdictions?
|
|
The following project network when applying pert/cpm
: Consider the following project network when applying PERT/CPM as described in Chap. 10, where the number over each node is the time required for the corresponding activity. Consider
|
|
Problem regarding the relational algebra
: A database records information about tutorials in a particular unit offering (such as ICT285 this semester). A student is supposed to attend only one of several available tutorials, each of which is taken by a tutor at a particular day and time. A..
|
|
How does your research design take into consideration
: Birth Order Effects on personality and achievement within the family's hypothetical research design, What ethical concerns related to your research design have you identified?
|
|
The sales manager for a publisher of college
: The sales manager for a publisher of college textbooks has six traveling salespeople to assign to three different regions of the country. She has decided that each region should be assigned at least one salesperson and that each individual salespe..
|
|
Provide a basic summary of the given document or event
: Provide a basic summary of the document, or event, or activity represented in the image. What does this source tell us about the people who created this source or participated in the events described?
|
|
How can a theory be reliable
: How can a theory be reliable or consistent over time if personality is believed to change? Please support responses with credible references.
|