Question: DATABASE SCHEMA - Given the following relational database schema Supplier ( SupplierCode, Name, Address, City) Product (ProductCode, Name, Brand, Model) Catalog (Supplier FK, Product FK,

 DATABASE SCHEMA - Given the following relational database schema Supplier (

DATABASE SCHEMA - Given the following relational database schema Supplier ( SupplierCode, Name, Address, City) Product (ProductCode, Name, Brand, Model) Catalog (Supplier FK, Product FK, Price ) SupplierCode Address 001 Name Ripoff Cheapoff 002 Bringtoyou 010 Richmond Ave New York Victory Blvd New York Hollywood Ave Hoboken Supplier Supplier_FK 001 001 002 002 002 010 010 Price Product FK 0002 0003 0001 0002 0003 0001 0003 S 3.200 2.200 Catalog $1.900 $ 2.500 $1.800 $ 2.200 $ 2.000 Brand Model ProductCode 0001 0002 0003 Name Notebook IBM Desktop Desktop ACER 730 390 x Product IBM RELATIONAL ALGEBRA + SQL Find all desktops from IBM Find codes for products that are Notebook or branded Acer Find the name of suppliers distributing IBM products products - Find the name of suppliers in New York that distribute IBM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!