subject

Consider the following database schema that is part of a larger database and stores information about electronic products (that in our case can be either PC, Laptop or Printer.) Product (maker, model, type) PC (model, speed, ram, hdd, price) Laptop (model, speed, ram, hdd, screen, price) Printer (model, color, type, price) The Product relation gives the manufacturer, model number and type (PC/laptop/printer) of various products. The PC relation gives for each model number that is a PC, the speed (of the processor, in gigahertz), the amount of RAM (in GB), the size of hard disk (in GB), and the price. The Laptop relation is similar, with screen size included. The Printer relation records whether it is a color printer or not (Yes/No), the type (laser/ink-jet), and the price. Write the following queries in Relational Algebra: 1. Find the Laptop models for the Laptops that have at least 8 GBs of RAM. 2. Find the manufacturers that make laser printers. 3. Find the manufacturers that make PCs but not Laptops. 4. Find the manufacturer(s) of the cheapest Laptop(s) (smaller price)

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 19:30
Write a function processpeople() that takes the name of a file as a parameter. each line of the file corresponds to information about a person. in particular a line contains either a name (in the form lastname,firstname with no spaces in it) or a name (lastname,firstname) and a year. the function will process the file, creating a person object for each line in the file. the function will print information about each line as it processes it, as well as appending the new person object into a list. make sure to use person methods to display information rather than recreating the work you did for the first problem. once the entire file has been processed, the function returns the list of person objects created from the file. if the file is empty, the function should return an empty list. if the input file cannot be opened, the function should print a message to that effect and then return an empty list. the following shows what would be displayed for two example files which have been provided in the link. the file none.txt does not exist. note that your function must work on an arbitrary file that consists of valid lines. you cannot assume anything about the file except that it contains lines that have the format described above.
Answers: 2
question
Computers and Technology, 22.06.2019 23:30
Which text format is this, "the text is transcribed exactly as it sounds and includes all the utterances of the speakers. "?
Answers: 2
question
Computers and Technology, 23.06.2019 00:00
Which is the correct sequence of steps to set up a document in landscape orientation? a. select page setup from the file menu. then click the margins tab and select landscape. b. select page setup from the edit menu. then click the margins tab and select landscape. c. select page setup from the insert menu. then click the margins tab and select landscape. d. select page setup from the format menu. then click the margins tab and select landscape
Answers: 1
question
Computers and Technology, 24.06.2019 11:40
100 pts. first person gets brainliest
Answers: 2
You know the right answer?
Consider the following database schema that is part of a larger database and stores information abou...
Questions
question
Mathematics, 30.04.2021 04:00
question
Mathematics, 30.04.2021 04:00
question
Mathematics, 30.04.2021 04:00