Show the relational algebra (both in English and in formal notation) 2. List the order number...
Show the relational algebra (both in English and in formal notation)
2. List the order number and client name for each order placed by any client represented by consultant
19.
Homework Answers
Add Answer to:
Show the relational algebra (both in English and in formal
notation)
2. List the order number...
Consider the following relational schema of the company’s database. Use Tuple Relational Calculus (TRC) & Domain...
Consider the following relational schema of the company’s database. Use Tuple Relational Calculus (TRC) & Domain Relational Calculus (DRC) expression to answer each of the following three questions (Step by step brief description is appreciated if possible) PRODUCT (pid, stock, supplier) CLIENT (cid, name, address, city) ORDER (orderno, date, quantity, pid, cid) Question 1: Find the number of orders for products that are being ordered in quantities smaller than 100 items by customers living in Madrid. Provide solutions expressed both...
Using this relations scheme: write these queried in relational algebra 2.List productCode, productName, and productVendor for...
Using this relations scheme:
write these queried in relational algebra
2.List productCode, productName, and productVendor for each
product that has never been ordered in June. Remember that we have
the month function that returns the number of the month component
of a data, and January is month number 1.
3.List the Customers that did not Order any products in
2015.
4.List all CustomerNames who have never had an order go to the
‘Shipped’ status.
1.. products FK product Code product...
Using the relational schema for the College Applications database, write relational algebra expressions that perform the...
Using the relational schema for the College Applications database, write relational algebra expressions that perform the following problems. Complete 5 out of 6 for full credit. Apply(sID, cName, major, decision) Student(sID, sName, GPA, sizeHS) College(cName, state, enrollment) 1. List the ids and names of the students that applied to the CS Dept at MIT. 2. For students that have applied to a college, list the student’s id, name and number of different colleges the students has applied to. 3. List...
chart: Write a relational algebra query AND list the result as a table (use A for...
chart:
Write a relational algebra query AND list the result as a table (use A for Actor, Sfor Show, P for Performance) List the year of the shows that were performed by any actor in Wicked Example: Find the name of actors who performed in "Hamilton'or 'Wicked' shows own (A P (Chowme - Hamilton or showWwWichead S)) actorName Sylvia Andrea Bob Mary Actor actorID 501 502 503 504 505 506 actorName Sylvia Steve Bob Luca Andrea Mary Country Brazil USA...
1. Given the following BANKING database, formulate a Relational Algebra expression for each of the following...
1. Given the following BANKING database, formulate a Relational Algebra expression for each of the following questions. SELECT should be performed before any JOIN operation. Notation: use the symbol S for SELECT, P for PROJECT, J for INNER JOIN, * for NATURAL JOIN, LJ for LEFT JOIN, RJ for RIGHT JOIN, R for RENAME, and F for FUNCTION. Please type your answer; hand-writing is not accepted. branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (customer_name, loan_number)...
Given the following relational schema, write queries in SQL to answer the English questions. The Access...
Given the following relational schema, write queries in SQL to answer the English questions. The Access Database for the schema is available, as is a DDL file. It is also available on the MySQL server. You must only submit the SQL for your answers. You can get your answers without using a DBMS or by using Access or MySQL. Customer(cid: integer, cname: string, address: string, city: string, state: string) Product(pid: integer, pname: string, price: currency, inventory: integer) Shipment(sid: integer, cid:...
[Relational Algebra] Using the above information, please write relational algebra expressions and display tables to answer...
[Relational Algebra]
Using the above information, please write relational algebra
expressions and display tables to answer the following. Do
NOT write in SQL code.
1. Select all staff that happen to be female with a salary more
than $20,000
2. List all staff that happen to have a salary between $20,000
and $30,000
Branch branch No street city postcode BOOS BOO7 воод 3004 BOOZ 22 Deer Rd London SWI4EH 16 Argyll St Aberdeen A235U 163 Main St Glasgow GII YOX...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
Assignment 7 Activities: Using the order form below identify entities to be used in a relational...
Assignment 7
Activities:
Using the order form below identify entities to be used
in a relational database. Normalize to first, second, and third
normal form. Clearly identify within each form with the tables in
each form and specify any assumptions made.
Utilize the following format for each table:
TableName(attribute,etc)
Indicate Primary Key by underlining the attribute name. List
Foreign Keys as such FK=attribute, below the table
listing.
Example:
Sales Rep (EmployeeID, MTD Sales, YTD Sales, MTD
Commission, YTD Commission,...
Create a view that will list the order number, order date, part number, part description, and...
Create a view that will list the order number, order date, part number, part description, and item class for each part that makes up the order from the TAL database. TAL Database: Table_Name Column Name Column Type Column Length Nullable Key Orders Order_Num Character 5 No Primary orders order_date Date Yes Orders Customer_num Character 3 Yes Foreign Order_Line Order_Num Character 5 No Primary Order_Line Part_Num Character 4 No Primary Order_Line Num_Ordered Number 3,0 Yes Order_Line Quoted_Price Number 6,2 Yes Part...
Using this relations scheme:
write these queried in relational algebra
2.List productCode, productName, and productVendor for each
product that has never been ordered in June. Remember that we have
the month function that returns the number of the month component
of a data, and January is month number 1.
3.List the Customers that did not Order any products in
2015.
4.List all CustomerNames who have never had an order go to the
‘Shipped’ status.
1.. products FK product Code product...
chart:
Write a relational algebra query AND list the result as a table (use A for Actor, Sfor Show, P for Performance) List the year of the shows that were performed by any actor in Wicked Example: Find the name of actors who performed in "Hamilton'or 'Wicked' shows own (A P (Chowme - Hamilton or showWwWichead S)) actorName Sylvia Andrea Bob Mary Actor actorID 501 502 503 504 505 506 actorName Sylvia Steve Bob Luca Andrea Mary Country Brazil USA...
[Relational Algebra]
Using the above information, please write relational algebra
expressions and display tables to answer the following. Do
NOT write in SQL code.
1. Select all staff that happen to be female with a salary more
than $20,000
2. List all staff that happen to have a salary between $20,000
and $30,000
Branch branch No street city postcode BOOS BOO7 воод 3004 BOOZ 22 Deer Rd London SWI4EH 16 Argyll St Aberdeen A235U 163 Main St Glasgow GII YOX...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
Assignment 7
Activities:
Using the order form below identify entities to be used
in a relational database. Normalize to first, second, and third
normal form. Clearly identify within each form with the tables in
each form and specify any assumptions made.
Utilize the following format for each table:
TableName(attribute,etc)
Indicate Primary Key by underlining the attribute name. List
Foreign Keys as such FK=attribute, below the table
listing.
Example:
Sales Rep (EmployeeID, MTD Sales, YTD Sales, MTD
Commission, YTD Commission,...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago