Computers and Technology, 30.12.2020 20:50, soogy

Consider the following relational database which consists of the 4 following relations: Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd. screen, price) Printer(model. color, type, price) The Product relation gives the manufacturer, model and type (PC, Laptop, or printer). We assume for convenience that model numbers are unique over all manufacturers and product types. The PC relation gives for each model number the speed of the processor(in gigahertz), the amount of RAM(in megabytes) and the size of the hard disk (in gigabytes), and the price. The Laptop relation is similar, except that the scorch size is also included. The Printer relation records for each printer model whether the printer produces color output or not, the process type (laser or ink-jet), and the price. 1) Define a suitable schema for each relation.
2) Draw the Crow foot representation of your database.
3) Write expressions of relational algebra for the following queries and draw the query trees for each:
a. What PC models have a speed of at least 3. 00
b. What the model numbers of all color printers
c. Which manufacturer make laptops with at least 100 GB
d. Find the model and price of all products (of any type) made by manufacturer "B"
e. Find the manufacturers that sell laptops but not PC.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 03:10, victoriadorvilu

This program reads a file called 'test. txt'. you are required to write two functions that build a wordlist out of all of the words found in the file and print all of the unique words found in the file. remove punctuations using 'string. punctuation' and 'strip()' before adding words to the wordlist. write a function build_wordlist() that takes a 'file pointer' as an argument and reads the contents, builds the wordlist after removing punctuations, and then returns the wordlist. another function find_unique() will take this wordlist as a parameter and return another wordlist comprising of all unique words found in the wordlist. example: contents of 'test. txt': test file another line in the test file output: ['another', 'file', 'in', 'line', 'test', 'the']

Answers: 1

continue

Computers and Technology, 22.06.2019 05:00, 105001964

Write a loop that reads positive integers from standard input and that terminates when it reads an integer that is not positive. after the loop terminates, it prints out, on a line by itself and separated by spaces, the sum of all the even integers read, the sum of all the odd integers read, a count of the number of even integers read, and a count of the number of odd integers read, all separated by at least one space. declare any variables that are needed. assume the availability of a variable, stdin, that references a scanner object associated with standard input. that is, stdin = new scanner(system. in); is given.

Answers: 3

continue

Computers and Technology, 23.06.2019 06:00, Disd112984

Which statement is true of web-based social media? a. they allow consumers to interact with and update content. b. they cannot be updated easily, as compared to print media. c. they are expensive to produce and maintain, as compared to print and television. d. they can exist independent of the internet.

Answers: 1

continue

Computers and Technology, 23.06.2019 18:00, yedida

File account. java (see previous exercise) contains a definition for a simple bank account class with methods to withdraw, deposit, get the balance and account number, and return a string representation. note that the constructor for this class creates a random account number. save this class to your directory and study it to see how it works. then write the following additional code: 1. suppose the bank wants to keep track of how many accounts exist. a. declare a private static integer variable numaccounts to hold this value. like all instance and static variables, it will be initialized (to 0, since itâ€™s an int) automatically. b. add code to the constructor to increment this variable every time an account is created. c. add a static method getnumaccounts that returns the total number of accounts. think about why this method should be static - its information is not related to any particular account. d. file testaccounts1.java contains a simple program that creates the specified number of bank accounts then uses the getnumaccounts method to find how many accounts were created. save it to your directory, then use it to test your modified account class.

Answers: 3

continue

Do you know the correct answer?

Consider the following relational database which consists of the 4 following relations: Product(make...