HomeworkLib
Question

Pc 1002 pc pc Product model maker type 1001 pc 1003 pc 2004 laptop 2005 laptop 2006 laptop 1004 pc 1005 pc 1006 2007 laptop 1512 512 PC model speed ram hd 1001 2.66 1024 | 250 1002 2.10 250 1003 1.42 512 80 1004 2.80 1024 250 1005 3.20 250 1006 3.20

Find the manufacturer(s) of the computer (PC or laptop) with the highest available speed. Write in Relational Algebra.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

answer)

Πmaker( σ(product.model=PC.model ^ product.type="pc" ^ pc.speed=MAX(PC.speed)(Product x PC)) U

Πmaker( σ(product.model=PC.model ^ product.type="laptop" ^ Laptop.speed=MAX(Laptop.speed)(Product x Laptop))

explanation:

Max is used to find the max element from that column.

Πmaker( σ(product.model=PC.model ^ product.type="pc" ^ pc.speed=MAX(PC.speed)(Product x PC)) is used to find the manufacture fo computer pc with highest available speed

Πmaker( σ(product.model=PC.model ^ product.type="laptop" ^ Laptop.speed=MAX(Laptop.speed)(Product x Laptop)) is used to find the manufacture of computer laptop with highest available speed

0 1
Add a comment
Know the answer?
Add Answer to:
Find the manufacturer(s) of the computer (PC or laptop) with the highest available speed. Write in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please help we are suppose to explain what the C code does. This is the electronics database (6 pts) This problem is...

    Please help we are suppose to explain what the C code does. This is the electronics database (6 pts) This problem is based on Electronics database. Add some annotations to the following table to explain what the C program is doing in detail. Note that "void" is how C declares a function that does not return anything. You are expected to generalize or research svntaxes not mentioned in the lecture C Program Annotation void newPCproduct EXEC SQL BEGIN DECLARE SECTION;...

  • SQL QUERIES 1) Using the Product and PC relations, create both tables in your database and...

    SQL QUERIES 1) Using the Product and PC relations, create both tables in your database and insert all the data. Show the SQL statements to create each table and show a representative SQL insert statement for the data in each table (i.e. you do not need to show insert statements for all the data). – For the remaining questions, assume that your SQL is part of a program function and the function provides the input needed for your SQL query....

  • WRITE A JAVA PROGRAM THAT READS DATA FROM A .CSV FILE !! PLEASE SEE INSTRUCTIONS BELOW...

    WRITE A JAVA PROGRAM THAT READS DATA FROM A .CSV FILE !! PLEASE SEE INSTRUCTIONS BELOW !! BELOW IS THE DATA THAT NEEDS TO BE CONTAINED INTO THE CSV FILE !! employeeId,dbId,privileged,service,inactive,groupmbr,userName,JobFunction,JobFunctionCode,JobFunctionStatus 200,512,TRUE,FALSE,FALSE,PayrollAccess,Bob Fields,Administrator,3000,Active 210,532,TRUE,FALSE,FALSE,AdminAccess,Ann Parson,Administrator,3001,Inactive 220,552,TRUE,FALSE,FALSE,AcctsPayableAccess,Ima Shields,Engineer,1002,Active 230,572,TRUE,FALSE,FALSE,PayrollAccess,Chris Stephens,Administrator,3002,Inactive 211,534,FALSE,FALSE,TRUE,PayrollAccess,Pat Anderson,Developer,2003,Active 212,536,FALSE,FALSE,TRUE,PayrollAccess,Shelley Peterson,Administrator,3003,Inactive 213,538,FALSE,FALSE,FALSE,PayrollAccess,Brian Murray,Engineer,1004,Inactive 214,540,FALSE,FALSE,FALSE,PayrollAccess,Phil Grate,Engineer,1005,Active 221,554,FALSE,FALSE,FALSE,AcctsPayableAccess,Victor Fuzz,Administrator,3004,Inactive 222,556,FALSE,FALSE,FALSE,AcctsPayableAccess,Alan Snow,Developer,2004,Active 223,558,FALSE,FALSE,FALSE,AcctsPayableAccess,Valerie Williams,Administrator,3005,Inactive 224,560,FALSE,FALSE,FALSE,AcctsPayableAccess,Bob Walters,Engineer,1006,Active 231,574,FALSE,FALSE,FALSE,AcctsReceivableAccess,Sue Flynn,Developer,2005,Inactive 233,578,FALSE,FALSE,FALSE,AcctsReceivableAccess,Sean Antonini,Engineer,1007,Active 234,580,FALSE,FALSE,FALSE,AcctsReceivableAccess,Tom Lennon,Administrator,3006,Inactive 300,712,TRUE,TRUE,FALSE,PayrollAccess,John Knight,Administrator,3007,Inactive A PROGRAM THAT READS DATA FROM A CSV FILE AND SHOWS MULTIPLE ENTITLEMENTS. FOR EXAMPLE: Input...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT