Consider the Database schema on the relations   Courses (Number, Faculty, Course Title, Tutor) Student (Number, Surname, First Name, Faculty) Tutors (Number, Surname, First Name) Exam (Student, Course, Grade, Date) Study Plan (Student, Course, Year)   Formulate in relational algebra, in domain calculus, in tuple calculus and in Data log, the queries that produce:   The student who have gained an ‘A’ in at least one exam, showing for each of them, the first name, sur name and the date of the first of such occasions; For every course in the engineering faculty, the student who passes the exam during last session; The students who pass all the exams required by their respective study plan For every course in the literature faculty, the student who pass the exam with the highest grade; The student whose study plans require them to attend lectures only in their own faculties; First name and sur name of the students who have taken an exam with a tutor having the same surname as the student.

Question

Consider the Database schema on the relations

 

Courses (Number, Faculty, Course Title, Tutor)

Student (Number, Surname, First Name, Faculty)

Tutors (Number, Surname, First Name)

Exam (Student, Course, Grade, Date)

Study Plan (Student, Course, Year)

 

Formulate in relational algebra, in domain calculus, in tuple calculus and in Data log, the queries that produce:

 

  • The student who have gained an ‘A’ in at least one exam, showing for each of them, the first name, sur name and the date of the first of such occasions;
  • For every course in the engineering faculty, the student who passes the exam during last session;
  • The students who pass all the exams required by their respective study plan
  • For every course in the literature faculty, the student who pass the exam with the highest grade;
  • The student whose study plans require them to attend lectures only in their own faculties;
  • First name and sur name of the students who have taken an exam with a tutor having the same surname as the student.
Expand

Expert Answer

1 Rating

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Engineering
Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by students like you.

Q: #include <stdio.h>#include <stdint.h> char sz_1[] = "Upper/LOWER.";char sz_2[] = "mIXeD ...

A: ASSEMBLY LANGUAGE: Assembly language is basically the low level language which is used for various ...

Q: A queueing system has 1 server and two phases. The interarrival time is uniform between 20 and 50 se...

A: A program is written in c to simulate the queueing system. assume that each customer uses the server...

Q: Describe the role of cyber forensics examiners and unique factors to keep in mind when collecting ev...

A: Role of Cyber\ Computer Forensics Analysts: The role of Cyber\ Computer forensics analysts in today'...

Q: Create a WBS for project to create a job portal for students with an embedded exam set by employers

A: The Work Breakdown Structure (WBS) includes the entire scope of a project and shows it diagrammatica...

Q: WBS for creating a job portal for students

A: The Work Breakdown Structure (WBS) includes the entire scope of a project and shows it diagrammatica...

Q: 1.Develope a 12 month project schedule for the WBS for a job portal for student with an embbed exam ...

A: Gantt Chart A Gantt chart, or harmonogram, is a sort of bar diagram that represents an undertaking p...

Q: Prove that the language L2={} is not regular language with the pumping lemma.

A: The given language is expanded as L1  = {} as it is an empty language. Now, we are going to prove th...

Q: c++

A: #include <iostream>using namespace std; int main() { int n;  cout << "Enter an integer: ...

Q: The order of precedence of the && operator is higher than that of the || operator except whe...

A: Logical AND (&&) operator : The logical AND(&&) operator evaluates to true if both ...

Q: What is the relationship between the MULTICS project and the early development of computer security?

A: PC security essentially is the assurance of PC frameworks and data from mischief, robbery, and unapp...

Q: C programming

A: Program: #include <stdio.h> //fucntion nSystemint nSystem(int n, int k){ //switch n which is n...

Q: develop project schedule for creating job portal using gantt chart

A: The Gantt Chart is a great way to build your project schedule and visually judge its progress. Read ...

Q: Please type and execute this java program and also need an output for this java program. Need as soo...

A: 1. Declare the variables- N, sumFormula, and sumLoop and initialize the variable- sumLoop with 0 1. ...

Q: To be eligible for the leadership training program offered by the office, a student must have at lea...

A: =IF((A1>=2)*OR(B1="Yes"),"YES","NO")

Q: Consider the following encryption scheme for a block cipher (using the notationfrequently used in cl...

A: Fours basic modes of operations of block cipher : 1) Electronic Code Book (ECB) –  Electronic code b...

Q: Write a value-returning method that returns the product of all the elements in an integer array

A: class Person: listnew=[1,2,3,4]  def __init__(self):    continue   def myfunc(self):    print(listne...

Q: Write a program called q3.py that repeatedly asks the user to enter words until they enter a period ...

A: list = [] while True:    word = input()    list.append(word)    if word == ".":        break print(*...

Q: 1. Write a Java application in a project called Alphabet. It should print the uppercasealphabet, thr...

A: /*******************************************************************************////beginningpublic ...

Q: Generate a RAC parity matrix for a (20, 12) coding of the data word 111001010001. Use the grid shown...

A: In coding theory, a parity-check matrix of a linear block code C is a matrix that describes the line...

Q: Using the concept of networking in java create a chatting application that allows two instances of y...

A: Actually, the code has given below:

Q: CHAPTER 9 Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that sho...

A: Table Name Foreign Key Customer Table None Salesman Table None Cash Receipts Table Customer Nu...

Q: what are potential security risks for each layer of the OSI model for Distributed vs. centralized co...

A: The OSI model is a kind of understanding of how computer networks operate and communicate. Understan...

Q: 1) a) create a dictionary, rank = {1:"Freshman", 2:"Sophmore", 3:"Junior", 4:"Senior" }b) request a ...

A: PYTHON CODE: def know_your_rank(n):     rank = {         1:"Freshman",         2:"Sophmore",        ...

Q: Write a program to implement phone book dictionaryusing Binary Search Tree which provides followingo...

A: #include <iostream> using namespace std;   // Class to store contact // details class node {  ...

Q: An architectural firm of eight employees, each with a networked desktop computer, wants you to devel...

A: The answer has given below:

Q: Review: Entity-Relationship (ER) "crow-feet symbol" О Опе-to-many: one sale person can have many Sal...

A: ER-Diagram:

Q: 1. Which of the following statements about the Bitcoin incentive mechanisms is INCORRECT: A. We can ...

A: Transaction fees are currently voluntary, but they may be mandatory in the future when the block rew...

Q: ·On slide #34, describe and draw a diagram to illustrate how you link the three tables: File: Studen...

A: The tables are linked as follows:

Q: Given the following three word sequences (i.e., the corpus)– very good tennis player in US open– ten...

A: Terminology : Sentence : unit of written language.Word Form : The inflected form that appears in the...

Q: (This is for devc++ but I use mindmap from Cengage. I know it a little different. If you can't use C...

A: Body fat of the person: The best way to determine how a person is healthy is by calculating the body...

Q: Write a program that displays your name and age on the screen, age must be stored in some integer. S...

A: EXPLANATION - In this program firstly declare character array variable named with name it will stor...

Q: Show that if and only if DFS(Depth-first Search) finds no back edges, the graph being traversed is a...

A: DFS Algorithm DFS full form Depth First Search, it is an algorithm for visiting the vertices of a gr...

Q: c++

A: C++ Code:   #include <iostream>#include <iomanip>using namespace std; int main() { // yo...

Q: Change this program to loop until it encounters a sentinel value, which is a negative number. The da...

A: .ORIG x3000 LEA R1, xFF AND R3, R3, #0 AND R2, R2, #0 ADD R2, R2, #12 LDR R4, R1, #0 ADD R3, R3, R4 ...

Q: C and D In this program, you are asked to write a program in assembly which works as a simple calcul...

A: c) We need 6 registers :- $v0,$a0,$t0-$t3  

Q: 7.26 LAB: Nutritional information (classes/constructors) C++   Given main(), complete the FoodIte...

A: File name: “FoodItem.h” #ifndef FOODITEMH #define FOODITEMH #include <string> using namespace ...

Q: In loop_functions.py, define a function named list_concat that takes a single parameter li.This func...

A: The main objective of the program, loop_functions.py is that the program concatenates the string val...

Q: what are the responsibilities associated with providing telecommunications services such as security...

A: Today's telecommunication networks are switched and controlled by computers. These computers are a m...

Q: Question 3, Explain briefly the difference in activities among the following levels of information s...

A: Actually, the answer has given below:

Q: Exercise # 2: Write a while loop that prints all positive numbers that are divisible by 10 and less ...

A: Below is the required code in C++ language. Approach of Program: Include necessary header files an...

Q: Problem_#09] Determine the value of the IEEE single precision floating-point number. (a) 1 10000001 ...

A: Hey, since there are multiple questions posted, we will answer first question. If you want any speci...

Q: *Python Programming*-Use Atom. Print "spring" if a is equal to b, print "fall" if a is greater than ...

A: PROGRAM: #Getting input from the user a=input("Enter the value of a: ") b=input("Enter the value of ...

Q: Create a program using JavaScript to solve the following problem. How many students passed and how m...

A: <script>     var myArray = [1,2,1,1,2,1,1,2,2,2];   array = [ 1, 2, 3, 4, 5, 6 ];  for (index ...

Q: Input a Boolean function from the user as a string then calculate and print a formatted truth table ...

A: Objective: This program displays the truth table for a boolean function that will be entered by the ...

Q: Discuss the reasons that one might choose SystemC over Verilog.

A: Below are the reasons that one might use system C over Verilog.

Q: GM being a global virtual company definitely presents with several areas of information ethics. Rich...

A: Areas of information ethics Richard O Mason identified four different areas of information ethics. ...

Q: Define function overloading. Provide a simple example with two function definitions where the functi...

A: Function Overloading: The method of having two or more functions with the same name, but different p...