Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

Engineering


Home >> Computer Engineering

1-Consider the relations:

Suppliers(SID, Sname, Rating)

Parts(PID, Pname, Color)

Catalog( SID, PID, Cost)

Use relational algebra language to answer the following queries:

Query 1: Retrieve SIDs of Suppliers whose rating > 10.

Query 2: Retrieve SIDs of Suppliers who supplied red parts.

Query 3: Retrieve Sname of Suppliers who supplied red parts.

2- Consider the following relations:

Student(ssn, name, address, major)

Course(code, title)

Registered(ssn,code)

Use relational algebra language to answer the following queries:

Query 1: List the codes of courses in which at least one student is registered (registered courses).

Query 2: List the titles of registered courses (of those in query 1).

Query 3: List the codes of courses for which no student is registered.

Query 4: The titles of courses for which no student is registered.

Query 5: The number of courses, which are registered for each ssn

3. Give an example of 3 relations illustrating primary keys and foreign keys.

Use your example for a simple Relational algebra query.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M92715087
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Computer Engineering

Junit test labyou will be creating a junit test class for

JUnit Test Lab You will be creating a JUnit Test Class for Gradebook.java, that has been provided for you.   Add a getScoreSize() method to the Gradebook class which returns scoresSize; Add a toString() method to the Gra ...

The relations given below are part of a database schema for

The relations given below are part of a database schema for a hotel management system. Assume that these relations have been populated with suitable data as appropriate, and the underlined attribute is a primary key. Hot ...

Number of cars average trvel time between a and b using

Number of cars Average trvel time between A and B using route 1 1 10 2 10 3 10 4 11 5 12 6 14 7 18 8 24 Alternative route 2: average travel time is 18 minutes(no matter how many cars are using it) How many cars will take ...

You work in a veterinarians office and need to organize the

You work in a Veterinarian's office and need to organize the data on pets that you treat. In your database, you want to keep track of the following information: Customer information: Name Address City State ZIP Phone # Y ...

Question when a syscall is called which register must have

Question : When a syscall is called which register must have the syscall number? Which syscall is a must for every program? Why?

Assignment 1 network access controlin a business

Assignment 1: Network Access Control In a business environment, controlling who has access to business information and at what level is critical for facilitating day-to-day business operations. The emphasis of Network Ac ...

In linux what synchronization methods they use within the

In Linux what synchronization methods they use within the kernel, please dig into your findings for Linux.

Question what are the advantages and disadvantages of using

Question: What are the advantages and disadvantages of using the same system-call interface for manipulating both files and devices? It is sometimes difficult to achieve a layered approach if two components of the operat ...

A student is applying to harvard and dartmouth if the

A student is applying to Harvard and Dartmouth. If the student is accepted at Dartmouth, the probability of being accepted at Harvard is 40%. If the student is not accepted at Dartmouth there is an 80% of non-acceptance ...

Question what is static and dynamic binding explain with

Question : What is static and dynamic binding? Explain with example how you can implement dynamic binding. The response must be typed, single spaced, must be in times new roman font (size 12) and must follow the APA form ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved