User Account

All Pages

Write expressions of sql query-relational algebra

Assignment Help Basic Computer Science
Reference no: EM132231510

Given following relational schema, I want to write expressions of SQL query/Relational algebra to answer the following.

Relational schema of question

1. Product(model, maker, type)

PC(model, speed, ram, hd, price)

Laptop(model, speed, ram, hd, screen, price)

Printer(model, color, type, price)

1. List the models and prices of all Laptop's with the most expensive first.

2. List the model and price of the Laptops with more than 512 KB RAM and faster than 1.60.

3. List all manufacturers who make PCs.

4. List the model and manufacturer of all Laptop's costing less than $ 1,000.

5. List the names and models of the manufacturers who make PCs and laptops with speeds greater than 2.

6) Which manufacturers make PC's, but not printers?

Reference no: EM132231510

Questions Cloud

Vpns are commonplace in modern data networks : VPNs are commonplace in modern data networks and are required for many employees.
Describe the traditional structure and function of it : Describe the traditional structure and function of IT in hospitals in the context of its state of development and the structure of hospitals.
What might be the advantages : What might be the disadvantages of allowing unlimited access? What might be the advantages?
How can large corporate information systems : How can large corporate information systems such as CRM, ERP, and SCM have value?
Write expressions of sql query-relational algebra : Given following relational schema, I want to write expressions of SQL query/Relational algebra to answer the following.
The factors that should be modified by us based suppliers : To stop the outsourcing by original equipment manufacturer (OEMs) of US ,what are the factors that should be modified by US based suppliers?
Creating and replace a new disk copy from the backups : What is the mean time to a disk failure involving a data loss, if it takes 5 hours to creating and replace a new disk copy from the backups
Existing database for their residential property sales : The real estate company has existing database for their residential property sales and agents. It has tables for agents property details and sales transactions
Write complete javadoc style comments : Write complete JavaDoc style comments for all methods and for the class. Include your name at the top of the assignment as a block comment

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Design the necessary preprocessing and searching algorithms

As soon as we get a mismatch in trying to match the word sought we skip to the start of the next word. To do this it is necessary to build the "skip-to-the-next-word" links into the text

  Define the relation

For a real number x, define f(x) to be the fractional part of x. More precisely, if x ∈ [n, n + 1) for some n ∈ Z, then f(x) = x - n. Define the relation ∼ on R by x ∼ y if f(x) = f(y).

  Er diagram, normalization, relational structure only

The proprietors of BigM have approached you and asked if you could design a database to help them manage their business. The management has commissioned you (in your capacity as a Database Management System consultant) to analyse, design and devel..

  Discuss the changing nature of health and medical care

Discuss the changing nature of health and medical care and the implications for medical practice, medical education and research, and health policy.

  Name of a source file where an error occurs

How can a program be made to print the name of a source file where an error occurs?

  Which have user profiles that are available for transfer

Which have user profiles that are available for transfer?

  Write subroutine in marie assembly that multiplies two value

Write a subtoutine in MARIE assembly that multiplies two values where the arguments for this subroutine are two pointers (each pointer pointing to a value). The routube, multiply (a,b), performs *a x *b where a's value is the address storing the valu..

  Current trends and issues with javascript

In which you analyse at least two of the current trends and issues with JavaScript in terms of Web development and deployment.

  Parking tickets and missing women

The following case study was reported in the article "Parking Tickets and Missing Women," which appeared in an early edition of the book Statistics

  Exploit the experts to get valuable reviews

Feedback on your project (online food delivery) is a crucial factor of success. How you will exploit the experts to get valuable reviews?

  Probability that a number chosen at random

If the first digit of a seven-digit telephone number cannot be a 0 or a 1, what is the probability that a number chosen at random will have all seven

  Write the definition of a class counter containing

Write the definition of a class Counter containing: An instance variable named counter of type int . An instance variable named limit of type int . A static int variable named nCounters which is initialized to 0 .

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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