2. Use the following list of attributes and Information from the UML Class Diagram to identify...
Problem 6-4 Part 2 2. Use the following list of attributes and information from the UML Class Diagram to identify the number of the appropriate attribute for each blank in the table listing below. Attributes: 1. Cash account # 2. Cash account balance 3. Check# 4. Check amount 5, Check date 6. Employee# 7. Employee name 8. Inventory category# 9. Inventory category description 10. Number of rental inventory items available in this category 11. Purchase order # 12. Purchase order...
Why does Figure 4 show only one cash resource entity if
Fred’s Train Shop uses a general operating checking account for
purchases of inventory, supplies, and operating expenses such as
rent but also uses a separate imprest checking account for
payroll?
Figure 4 is the image below:
Integrated REA Diagram for Fred's train shop
Take a look at Figure 4 and Table 1. Why do the
Inventory, Cash, Customers, and Suppliers agent & resource
tables all have an attribute that...
1,List the first and last name of the donators that donated in
December 2009.
2. List the ID's of the volunteers that have not worked.
3. List the ID, first name, and last name of any employees who
works in the Finance department.
4. List all the different prices suppliers have for 'Tasty Meat'
product.
5. Select the store ID and store phone number for all stores in
'St.Paul'.
6. List the member first and last name, address, city, zip...
Hello, I need help answering all 8 of these questions for my BIS
422 class. I need the appropriate MySQL script to use for these
questions
Provide the SQL for the following data requests. Your SQL should
be written as a single script that can be pasted into MySQL and run
without edits. Make sure you use the proper notation for your
comments (see the practice solution for an example of the format).
There will be a 5% deduction for...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query because Northwind Traders has decided to
increase their retail prices. Write a query that shows the product
name, the current price, and the new price. Make sure the new price
is listed to 2 decimal points. Follow below guidelines on new
retail price:
a. If the
category is beverages or dairy products, increase the price by...
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...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query to display products purchased by
customers in Germany that were not purchased by customers in the
US.
Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode Country Phone char(5) varchar(40) varchar(30) varchar(30) varchar(60) varchar(15) varchar(15) varchar(10) varchar(15) varchar(24) varchar(24) Order Details Orders PK OrderID int FK CustomerlD char(5) FK Employeeld int...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query because Northwind Traders wants to make
sure that all orders are shipped within 10 days. Display any orders
that were not shipped within 10 days. Include the OrderID, the
OrderDate, and the number of days it took before the order was
shipped.
Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode...
For our Expenditure (Purchases-Payments) cycle, we want to store the following data about our purchases of inventory: item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase a. Semantically create a conceptual design (entity-relationship diagram) with max cardinalities. b. Design a set of properly normalized relational tables to store the data, using the following format: Table Name Primary...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...