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

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  Chomsky normal form

Requesting assistance with the Theory of Computing.Construct a PDA that accepts L.

  Different visual basic command

Write down the visual basic command in order to Load a LVM file ( file name: Data.lvm), Delete the first 22 row , Insert a new column from 0 to last row of file with increment of 0.1 ( For example, if there are 25 rows in Data.lvm; then 25-22=3, it w..

  Identify connectivity of each relationship

Identify connectivity of each relationship

  Authenticating the evidence

You will offer the POC additionally as a matter of procedure the known facts of incident and what are the procedures were utilized during the initial case reviews. Identification of any collection requirements for attaining and authenticating the ..

  In-house development of software

Discuss the innovative and creative ways in order to use patient ID bracelet consisting of a bar-code representation of patient's ID.

  Wan technologies for mobile user-to-office

WAN technologies for each of the Wilke’s three connectivity situations: mobile user-to-office, office to office, and home-to-office.

  Explain fast process of distributing the cards to accountant

Explain fast process of distributing the cards to accountant.

  Calculating the average of 50 numbers

Write down a program which calculates the average of up to 50 numbers input by the user and stored in an array. The program must use a class named Statistics and have an AddNumber method which stores numbers into an array.

  Speed routing protocol

Following question is related to SPEED routing protocol-Multiple speeds are computed in MAC layer. The forwarder with highest speed is selected on MAC layer feedback. This selection could not produce a shortest path.

  What is total capacity of a track

What is total capacity of a track

  Algorithm to prepare a job applicant report

Develop an algorithm in order to prepare a job applicant report. Input consists of a series of records that contain the Social Security number or equivalent, last name, first name, middle initial, verbal test score, science test score, math test s..

  Illustrate general network design

Illustrate general network design

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