Find the model number-speed and hard-disk size

Assignment Help Basic Computer Science
Reference no: EM132493599

Q1 Going from these SQL relations, Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price)

Printer(model, color, type, price)

Write the following queries in SQL:

a) Find the model number, speed, and hard-disk size for all PC's whose price is under $1000.

b) Do the same as (a), but rename the speed column gigahertz and the hd column terabytes.

c) Find the manufacturers of printers.

d) Find the model number, memory size, and screen size for laptops costing more than $1500.

e) Find all the tuples in the Printer relation for color printers. Remember that color is a boolean-valued attribute.

f) Find the model number and hard-disk size for those PC's that have a speed of 3.2 and a price less than $2000.

Part Two:

  • Create E/R diagram for a database recording information about teams, players, and their fans, including:
  • For each team, its name, its players, its team captain (one of its players), and the colors of its uniform.
  • For each player, their name.
  • For each fan, their name, favorite teams, favorite players, and favorite color.

Reference no: EM132493599

Questions Cloud

Describe user needs analysis steps and tasks : In order to save time and money in a user needs analysis project, if you could choose to omit one of the steps described above, which step
Calculate the issue price of the bill : A bank bill with 90 days to maturity is issued with a yield of 1% pa. Face value is $100,000. Calculate the issue price of the bill.
Explain in what ways physical meetings can be inefficient : Explain in what ways physical meetings can be inefficient. Explain how technology can make meetings more effective?
How much jack has invested in the investment property : Show how much extra Jack can expect to spend each year (assuming start-of-year withdrawals), over and above the $50,000 from the property investment
Find the model number-speed and hard-disk size : a) Find the model number, speed, and hard-disk size for all PC's whose price is under $1000.
Determine the dividends to be distributed to preferred : Determine the dividends to be distributed to preferred and common stockholders in total and per share under the following independent conditions.
What is the arithmetic average : What is the annual rate of return on each of these indices? Explain the difference in information provided by these two indices. What is the arithmetic average?
How two copyrights should be reported in the statement : During 2018, Discuss how these two copyrights should be reported in the statement of financial position of ABC company at 30 June 2019?
Identify six supporting peer-revised research articles : For this assignment, you will create a clinical guiding question know as a PICOT question. The PICOT question must be relevant to a nursing practice problem.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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