subject

Consider the relations: Customer(CID, Name, City, State), Order(OID, CID, Date), and Product(PID, ProductName, Price) LineItem(LID, OID, PID, Number, TotalPrice), where CID is a customer id and is a key for Customer, OID is an order id and is a key for Order, and LID is a line item id and is a key for Line Item. In addition the attribute CID of Order is a foreign key referring to the CID of Customer, that is, for each CID c of Order there is exactly one tuple of Customer whose CID attribute is c. The OID of Line Item is a foreign key referring to the OID of Order. There are several line items for the same order, a line item refers to a product and contains the quantity ordered for the product. Express the following queries Algebra: 1. List the customers who ordered computers
2. List the other products bought by customers who bought computers.
3. List the customers who did not place any order since January 1 2014.
4. List the products bought by at least one customer of Newark.
5. List the products bought by all the customers of Newark.
6. List the products ordered only by the customers of Newark.
7. List the products never ordered by customers of New Jersey.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 09:30, caldonjoshhsms2061
What are the steps involved in accepting all the changes in a document? arrange these in order click edit. click accept or reject. click changes. click accept all.
Answers: 1
image
Computers and Technology, 22.06.2019 14:40, coryowens44
For this assignment you have to write a c program that will take an infix expression as input and display the postfix expression of the input. after converting to the postfix expression, the program should evaluate the expression from the postfix and display the result. what should you submit? write all the code in a single file and upload the .c file. compliance with rules: ucf golden rules apply towards this assignment and submission. assignment rules mentioned in syllabus, are also applied in this submission. the ta and instructor can call any students for explaining any part of the code in order to better assess your authorship and for further clarification if needed. problem: we as humans write math expression in infix notation, e. g. 5 + 2 (the operators are written in-between the operands). in computer's language, however, it is preferred to have the operators on the right side of the operands, ie. 5 2 +. for more complex expressions that include parenthesis and multiple operators, a compiler has to convert the expression into postfix first and then evaluate the resulting postfix write a program that takes an "infix" expression as input, uses stacks to convert it into postfix expression, and finally evaluates it. it must support the following operations: + - / * ^ % ( example infix expression: (7-3)/(2+2) postfix expression: 7 3 2 2 result: rubric: 1) if code does not compile in eustis server: 0. 2) checking the balance of the parenthesis: 2 points 3) incorrect postfix expression per test case: -2 points 4) correct postfix but incorrect evaluation per test case: -i points 5) handling single digit inputs: maximum 11 points 6) handling two-digit inputs: 100 percent (if pass all test cases)
Answers: 3
image
Computers and Technology, 22.06.2019 21:30, mjweed2456
Nathan wants to create multiple worksheet containing common formatting styles for his team members. which file extension him to save these worksheets? nathan to create multiple worksheets with common styles. he needs to save them with the extension.
Answers: 1
image
Computers and Technology, 23.06.2019 15:20, headshotplayzcod
In a game with three frames, where will the objects on layer 1 appear? a. next to the play area b. in the middle of the game c. behind everything else d. in front of everything else
Answers: 1
You know the right answer?
Consider the relations: Customer(CID, Name, City, State), Order(OID, CID, Date), and Product(PID, Pr...

Questions in other subjects:

Konu
Social Studies, 17.03.2020 15:12
Konu
History, 17.03.2020 15:12
Konu
Chemistry, 17.03.2020 15:13
Konu
Mathematics, 17.03.2020 15:14
Konu
Mathematics, 17.03.2020 15:14
Konu
Mathematics, 17.03.2020 15:14