Answer:
## http://pastebin.com/nQWtHb3B
#use above link for formatted program #Python3
c=[float(cord) for cord in input('Enter a point with 2 coordinate :').split(' ')]
base=[0,0]
w=10
h=5
if((abs(c[0]-base[0])<= float(w)/2) and (abs(c[1]-base[1])<= float(h)/2)):
print('Point (',c[0],', ',c[1],') is in the rectange')
else:
print('Point (',c[0],', ',c[1],') is not in the rectange')
Answer:
SQL queries
The command used to display the customer ID and total number of orders placed is given below
Query:
SELECT CustomerID, COUNT (orderID) AS TotalOrders
FROM Order_Table
GROUP BY CustomerID
Explanation:
SQL queries
The command used to display the customer ID and total number of orders placed is given below
Query:
SELECT CustomerID, COUNT (orderID) AS TotalOrders
FROM Order_Table
GROUP BY CustomerID
SELECT - To query the database and get back the specified fields SQL uses the select statement
CustomerID is a coloumn name
The function COUNT(OrderID) returns the number of orders
Totalorderds is a label
FROM - To query the database and get back the preferred information by specifying the table name
Order_Table is a table name
GROUP BY - The clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column
The table below displays the CustomerID and total number of orders placed
CustomerID Totalorders
4 28
1 6
12 5
16 5
6 3
9 3
15 3
3 1
13 1
14 1
The table below shows the total number of orders situated for each sales person
SalesPerson_ID TotalOrders
3 16
2 3
4 3
5 3
Answer:
The advantage of the simulated link strategy are:
- It is easily able to provide the practical feedback to the customers and users while designing the whole system. It also determine the efficiency and the correctness of the design in the stimulated link strategy.
- In the stimulated link strategy, the sharing and delivering of the data and information is done efficiently without any occurrence of error and interrupt. It is also high flexible technique.
The disadvantage of the simulated link strategy are:
- The simulated link strategy is flexible but it is not standardization and also it required more good concept.
- This technique is expensive and it is not readily available as it always require validation process.
Answer:
I'm pretty sure it's photogenic drawing.
