Write a stored procedure or a function

Assignment Help Computer Engineering

Reference no: EM133482027

Question: The Product relation gives manufacturer, model number and type (PC, laptop, or printer) of various products. We assume for convenience that model numbers are unique over all manufacturers and product types (i.e., model is the primary key). The PC relation gives for each model number that is a PC the speed (of the processor in gigahertz), the amount of RAM (in megabytes), the size of the hard disk (in gigabytes), and the price. The Laptop relation is similar, except that the screen size (in inches) is also included. The Printer relation records for each printer model whether the printer produces color output (true if so), the process type (laser or inkjet, typically), and the price.

Please write a stored procedure or a function for each of the following:

a) Take a price as an argument and returns the model number of the PC whose price is closet.

b) Take a maker and model as arguments, and return the price of whatever type of product that the model is.

Reference no: EM133482027

Questions Cloud

How could improve the quality of care as a life care planner : How could one improve the quality of care as a life care planner? Please provide reference.

What is the purpose of completing a critical appraisal : When working on a rapid critical appraisal what are you specifically looking for and why/why not is this an important step?

Developing a clinical judgment for professional nursing : Developing Clinical Judgment for Professional Nursing, in Course Materials. In the textbook are the Thinking Exercises required for this deliverable.

Which software platform is behind the starbucks crm system : What has the Starbucks CRM achieved? How does it help the bottom line? Which software platform is behind the Starbucks CRM system?

Write a stored procedure or a function : Write a stored procedure or a function for each of the following: a) Take a price as an argument and returns the model number of the PC whose price is closet.

Evaluate the effectiveness of different strategies : Evaluate the effectiveness of different strategies and interventions that can be employed to manage employee relations and influence stakeholder behaviour.

Differences between ethics and bioethics : Describe the similarities and differences between ethics and bioethics.

Create visualizations to show the correlations : Identify the correlations between facility attributes and customer satisfaction. All visualizations in this task must be in the same page

What is the purpose of the business : What is the purpose of the business? What type of external assessment does this company/organization currently perform?

User Account

All Pages