Person(UPI, givenname, surname) with key UPI Courses(course, title, program) with key course Classes(classnr, course, year) with...
Person(UPI, givenname, surname) with key UPI
Courses(course, title, program) with key course
Classes(classnr, course, year) with key classnr
Enrollments(UPI, classnr)
Grades(UPI, classnr, grade)
Prereqs(course, prereq)
Teachers(UPI, classnr)
With natural foreign key constraints given by common attribute names.
1. List all UPIs of all teachers who teach a course with a prerequisite.
2. List all enrollments (i.e., list UPI and classnr) where the enrolled person has a grade for all prerequisites.
3. List all enrollments where the enrolled person has a grade for any prerequisite.
4. List all enrollments where the enrolled person does not have a grade for all prerequisites.
Q.a) Give a Relational Algebra and SQL representation?
Homework Answers
Add Answer to:
Person(UPI, givenname, surname) with key UPI
Courses(course, title, program) with key course
Classes(classnr, course, year) with...
1. Consider the following database. Note that it distinguishes between a course and the class of...
1. Consider the following database. Note that it distinguishes between a course and the class of that course in a particular year. Courses can have prerequisites (aka a prereq), which is again a course. Person(UPI, givenname, surname) with key UPI Courses(course, title, program) with key course Classes(classnr, course, year) with key classnr Enrollments(UPI, classnr) Grades(UPI, classnr, grade) Prereqs(course, prereq) Teachers(UPI, classnr) With natural foreign key constraints given by common attribute names. 1. List all UPIs of all teachers who teach...
Please do these carefully. Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourseNumber, Course Title,...
Please do these carefully. Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourseNumber, Course Title, NumberUnits) Section = ( CourseNumber, Quarter, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00PM. Enrollment = (SSN,CourseNumber, Quarter, Grade)// Grade is either Null or a letter grade. Express the following queries using appropriate SQL statements with a minimum number of operations: 1. List the name of every student and SSN who has not taken any course more than once. 2. List every...
Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourseNumber, Course Title, NumberUnits) Section = (...
Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourseNumber, Course Title, NumberUnits) Section = ( CourseNumber, Quarter, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00PM. Enrollment = (SSN,CourseNumber, Quarter, Grade)// Grade is either Null or a letter grade. Express the following queries using appropriate SQL statements with a minimum number of operations: 1. List every two CourseNumber and their titles which have the same prerequisites. 2. List the name of every student and SSN who has completed...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
Most questions answered within 3 hours.
-
Explain the following basis of electron configuration i) the
electron affinity of S is +200kJ mol-1
asked 43 seconds from now -
Determine the pH of a 0.10 M
CH3NH3Cl solution.
(Kb
(CH3NH2) = 4.4 x 10-4)
2.18...
asked 7 minutes ago -
Asolid metal sphere with radius 0.470 m carries a net charge of
0.200 nC .
Part...
asked 3 minutes ago -
Determine the pH of a 0.0500 M KBr solution (using activity
coefficients when needed)
( please...
asked 5 minutes ago -
Bender's skateboards have the following manufacturing
expenses:
Direct Materials: $10/unit
Direct Labor: $8/unit
Rent: $10,000/month
Depreciation:...
asked 14 minutes ago -
9) A resistor is connected to a capacitor of 4 micro-farads
without a battery. The initial...
asked 22 minutes ago -
Via Gelato is a popular neighborhood gelato shop. The company
has provided the following cost formulas...
asked 43 minutes ago -
The Williams have a stock they have held for over a year that
they believe is...
asked 1 hour ago -
11.53g sample of NaBr contains 22.34% Na by mass Considering
the law of constant composition how...
asked 2 hours ago -
Exercise 5-22A Complete the accounting cycle using receivable
transactions (LO5–1, 5–2, 5–4, 5–5, 5–7) [The following...
asked 3 hours ago -
Do you agree with the view that small businesses are more
vulnerable to employee theft because...
asked 3 hours ago -
Four forces act on an object, given by A = 41.3 N east, B = 46.3...
asked 4 hours ago