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.

User Account

All Pages