Studying the relational database

Assignment Help Computer Engineering
Reference no: EM1318175

Consider the following relational database:

STUDENT (SID, SName, GPA )
ENROLL (SID, CNo, Date )
COURSE (CNo, CTitle, Credits)
REQUIRE (CNo, Prerequisite)

On the basis of this relational database; provide an expression in the relational algebra in order to express each of following queries:

a) Determine the names of all students who have GPA greater than 3.

b) Determine ID of all the students who did not enroll in course IT222.

c) Determine name of all the students who enroll in both IT222 and IT221 courses.

d) Determine names and GPAs of all the students who enrolled in Course IT222.

e) State the students ID, name, GPA, and course Number such that all students have GPA greater than 3.5 and enrolled in the course in Jan 1, 2011.

f) State all the students’ names along with the title of courses they registered in.

g) Specify the details of all students and their course enrolment; along with the courses prerequisites if they have one.

h) Determine details of all the students who enrolled in all courses.

Reference no: EM1318175

Questions Cloud

Computing functional dependencies : Compute the functional dependencies which exist in following table. After determining the functional dependencies, transform this table to an equivalent collection of the tables which are in third normal form.
Explaining a type one and type two error for situation : Explain a Type I error for this situation. Explain a Type II error for this situation.
Determining initial population and maximum population : Determining initial population, maximum population of fruit flies placed in a half pint milk bottle - word problem and Evaluate the initial population
Use single proportion testing, the p value method : The study does not give sufficient evidence to support the claim that less than 75% of college students spend less than $250 per semester on textbooks.
Studying the relational database : On the basis of this relational database; provide an expression in the relational algebra in order to express each of following queries: Determine the names of all students who have GPA greater than 3.
Probability on addition and multiplication rule : Determine the probably of selecting a female or an accounting major? Which rule of addition did you apply?
What depth will provide a maximum cross sectional area : Applications of quadratic equations: Maxima and minima and What depth will provide a maximum cross sectional area and thereby provide for the greatest flow of water
Dependent and independent events : Dependent and independent events.
Identifying the null and alternative hypotheses : Then test to see whether it considerably varies from 0 [use alpha = 5%]. Don't forget to identify the null and alternative hypotheses.

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  Evaluating the post fixed expression

Approximate the post fixed expression a) Initialize an empty stack. While there exist more symbols within postfix string { b) If token is an operand, push it onto the stack. If token is an operator

  What is the idea to observe multiple print queues

What is the idea to observe multiple print queues

  Write a program use a matrix represent

Write a Program Use a matrix represent.

  Illustrate the control flow graph

Illustrate the control flow graph

  How to plan a payroll class

How to plan a PayRoll class.

  Problem on stack

Problem on Stack

  Explain fast process of distributing the cards to accountant

Explain fast process of distributing the cards to accountant.

  Creating a program with a building as subclass

Assume the existence of the Building class. Describe a subclass, ApartmentBuilding that consists of following instance variables: an integer, a boolean, numFloors, an integer, hasElevator, unitsPerFloor, a boolean, hasCentralAir, and a string, man..

  Problem on bubble sort algorithm

Problem on Bubble sort algorithm

  Write down program that models an employee

Write down program that models an employee

  About snmp

What do you understand by the term SNMP? Explain the role which SNMP plays in managing the networks.

  Write a program based on encryption scheme

Write a program based on encryption scheme.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd