Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following two tables, express in Relational Algebra the queries below: PC (model, speed, ram, hard_disk, price) Laptop (model, speed, ram, hard_disk, price) Express

Given the following two tables, express in Relational Algebra the queries below: PC (model, speed, ram, hard_disk, price) Laptop (model, speed, ram, hard_disk, price) Express in Relational Algebra the following queries: a) List Laptop models with maximum ram 3 GB. [1 mark] b) List the details of pcs having price greater than 250 OMR and ram size greater or equal to 5 GO. [1 mark] c) List the capacities of hard disks that are available in PCs but are not available in laptops. [1 mark]

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

Consider the following table: Instructor (Instructor_Id, Instructor_Name, specialization, Address, #Department_Id) Write in PL/SQL a function named NumberInstructor_department that takes the id of a department as an input parameter and returns the number of instructors who are working in that department.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Antipatterns Avoiding The Pitfalls Of Database Programming

Authors: Bill Karwin

1st Edition

1680508989, 978-1680508987

More Books

Students also viewed these Databases questions