Develop a 150 to 200 word posting that responds to the following question: How might the value process frameworks help companies avoid faulty e-commerce strategies? Another way to pose this question would be: What strategic insights might be gained from such models that may not be self-evident to business strategists within a given company? Provide an example in your posting.

One of the real word examples in chapter 1 discussed a recent trend in the fast food restaurant industry where remote order-taking is completed at a drive-through window. In the case of McDonald’s, an experimental order-taking center takes drive-through orders for several different McDonald’s locations.

Describe how this real world example relates to each of the components of an accounting information system.

(Keep the answer as simple as possible.)

For Assignment 2, submit a word or pdf file with the SQL queries along with screenshots of the outputs.

(It is ok if the whole problem cannot be answered, if possible, I just would like an idea of how to begin, thanks in advance!)

9. Write a query to count the number of invoices.
10. Write a query to count the number of customers with a balance of more than $500.
11. Generate a listing of all purchases made by the customers, using the output shown
in Figure P7.11 as your guide. Sort the results by customer code, invoice number,
and product description.
12. Using the output shown in Figure P7.12 as your guide, generate a list of customer
purchases, including the subtotals for each of the invoice line numbers. The subtotal
is a derived attribute calculated by multiplying LINE_UNITS by LINE_PRICE. Sort
the output by customer code, invoice number, and product description. Be certain
to use the column aliases as shown in the figure.
13. Write a query to display the customer code, balance, and total purchases for each
customer. Total purchase is calculated by summing the line subtotals (as calculated
in Problem 12) for each customer. Sort the results by customer code, and use aliases
as shown in Figure P7.13.
14. Modify the query in Problem 13 to include the number of individual product purchases
made by each customer. (In other words, if the customer’s invoice is based on
three products, one per LINE_NUMBER, you count three product purchases. Note
that in the original invoice data, customer 10011 generated three invoices, which
contained a total of six lines, each representing a product purchase.) Your output
values must match those shown in Figure P7.14, sorted by customer code.

/* This script file creates the following tables:   */
/* VENDOR, PRODUCT, CUSTOMER, INVOICE, LINE       */              
/* and loads the default data rows           */

BEGIN;

DROP TABLE IF EXISTS LINE ;
DROP TABLE IF EXISTS INVOICE;
DROP TABLE IF EXISTS CUSTOMER;
DROP TABLE IF EXISTS PRODUCT;
DROP TABLE IF EXISTS VENDOR;
DROP TABLE IF EXISTS EMPLOYEE;
DROP TABLE IF EXISTS EMP;

CREATE TABLE VENDOR (
V_CODE        INTEGER,
V_NAME        VARCHAR(35) NOT NULL,
V_CONTACT    VARCHAR(15) NOT NULL,
V_AREACODE    CHAR(3) NOT NULL,
V_PHONE    CHAR(8) NOT NULL,
V_STATE    CHAR(2) NOT NULL,
V_ORDER    CHAR(1) NOT NULL,
PRIMARY KEY (V_CODE));

CREATE TABLE PRODUCT (
P_CODE    VARCHAR(10) PRIMARY KEY,
P_DESCRIPT    VARCHAR(35) NOT NULL,
P_INDATE    DATETIME NOT NULL,
P_QOH    INTEGER NOT NULL,
P_MIN        INTEGER NOT NULL,
P_PRICE    NUMERIC(8,2) NOT NULL,
P_DISCOUNT    NUMERIC(4,2) NOT NULL,
V_CODE        INTEGER,
CONSTRAINT PRODUCT_V_CODE_FK FOREIGN KEY (V_CODE) REFERENCES VENDOR (V_CODE));

CREATE TABLE CUSTOMER (
CUS_CODE   INTEGER PRIMARY KEY,
CUS_LNAME   VARCHAR(15) NOT NULL,
CUS_FNAME   VARCHAR(15) NOT NULL,
CUS_INITIAL   CHAR(1),
CUS_AREACODE    CHAR(3),
CUS_PHONE   CHAR(8) NOT NULL,
CUS_BALANCE   NUMERIC(9,2) DEFAULT 0.00,
CONSTRAINT CUS_UI1 UNIQUE(CUS_LNAME,CUS_FNAME, CUS_PHONE));

CREATE TABLE INVOICE (
INV_NUMBER    INTEGER PRIMARY KEY,
CUS_CODE   INTEGER NOT NULL,
INV_DATE     DATETIME NOT NULL,
CONSTRAINT INVOICE_CUS_CODE_FK FOREIGN KEY (CUS_CODE) REFERENCES CUSTOMER(CUS_CODE));

CREATE TABLE LINE (
INV_NUMBER    INTEGER NOT NULL,
LINE_NUMBER   NUMERIC(2,0) NOT NULL,
P_CODE       VARCHAR(10) NOT NULL,
LINE_UNITS   NUMERIC(9,2) DEFAULT 0.00 NOT NULL,
LINE_PRICE   NUMERIC(9,2) DEFAULT 0.00 NOT NULL,
PRIMARY KEY (INV_NUMBER,LINE_NUMBER),
FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE (INV_NUMBER) ON DELETE CASCADE,
FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE),
CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE));

CREATE TABLE EMPLOYEE (

EMP_NUM VARCHAR(3) PRIMARY KEY,
EMP_LNAME VARCHAR(15) NOT NULL,
EMP_FNAME VARCHAR(15) NOT NULL,
EMP_INITIAL VARCHAR(1),
EMP_HIREDATE DATE,
JOB_CODE VARCHAR (3)
);

/* Loading data rows                   */

/* VENDOR rows                       */
INSERT INTO EMPLOYEE VALUES(101,'News' ,'John','G','2000-11-08','502');
INSERT INTO EMPLOYEE VALUES(102,'Senior' ,'David','H','1989-07-12','501');
INSERT INTO EMPLOYEE VALUES(103,'Arbough' ,'June' ,'E','1996-12-01','500');
INSERT INTO EMPLOYEE VALUES(104,'Ramoras' ,'Anne' ,'K','1987-11-15','501');
INSERT INTO EMPLOYEE VALUES(105,'Johnson' ,'Alice' ,'K','1993-02-01','502');
INSERT INTO EMPLOYEE VALUES(107,'Alonzo' ,'Maria','D','1993-10-10','500');
INSERT INTO EMPLOYEE VALUES(108,'Washington' ,'Ralph' ,'B','1991-08-22','501');
INSERT INTO EMPLOYEE VALUES(109,'Smith' ,'Larry' ,'W','1997-07-18','501');

/* VENDOR rows                       */
INSERT INTO VENDOR VALUES(21225,'Bryson, Inc.' ,'Smithson','615','223-3234','TN','Y');
INSERT INTO VENDOR VALUES(21226,'SuperLoo, Inc.' ,'Flushing','904','215-8995','FL','N');
INSERT INTO VENDOR VALUES(21231,'D&E Supply' ,'Singh' ,'615','228-3245','TN','Y');
INSERT INTO VENDOR VALUES(21344,'Gomez Bros.' ,'Ortega' ,'615','889-2546','KY','N');
INSERT INTO VENDOR VALUES(22567,'Dome Supply' ,'Smith' ,'901','678-1419','GA','N');
INSERT INTO VENDOR VALUES(23119,'Randsets Ltd.' ,'Anderson','901','678-3998','GA','Y');
INSERT INTO VENDOR VALUES(24004,'Brackman Bros.' ,'Browning','615','228-1410','TN','N');
INSERT INTO VENDOR VALUES(24288,'ORDVA, Inc.' ,'Hakford' ,'615','898-1234','TN','Y');
INSERT INTO VENDOR VALUES(25443,'B&K, Inc.' ,'Smith' ,'904','227-0093','FL','N');
INSERT INTO VENDOR VALUES(25501,'Damal Supplies' ,'Smythe' ,'615','890-3529','TN','N');
INSERT INTO VENDOR VALUES(25595,'Rubicon Systems' ,'Orton' ,'904','456-0092','FL','Y');

/* PRODUCT rows                       */
INSERT INTO PRODUCT VALUES('11QER/31','Power painter, 15 psi., 3-nozzle' ,'2017-11-03', 8, 5,109.99,0.00,25595);
INSERT INTO PRODUCT VALUES('13-Q2/P2','7.25-in. pwr. saw blade' ,'2017-12-13', 32, 15, 14.99,0.05,21344);
INSERT INTO PRODUCT VALUES('14-Q1/L3','9.00-in. pwr. saw blade' ,'2017-11-13', 18, 12, 17.49,0.00,21344);
INSERT INTO PRODUCT VALUES('1546-QQ2','Hrd. cloth, 1/4-in., 2x50' ,'2018-01-15', 15, 8, 39.95,0.00,23119);
INSERT INTO PRODUCT VALUES('1558-QW1','Hrd. cloth, 1/2-in., 3x50' ,'2018-01-15', 23, 5, 43.99,0.00,23119);
INSERT INTO PRODUCT VALUES('2232/QTY','B&D jigsaw, 12-in. blade' ,'2017-12-30', 8, 5,109.92,0.05,24288);
INSERT INTO PRODUCT VALUES('2232/QWE','B&D jigsaw, 8-in. blade' ,'2017-12-24', 6, 5, 99.87,0.05,24288);
INSERT INTO PRODUCT VALUES('2238/QPD','B&D cordless drill, 1/2-in.' ,'2018-01-20', 12, 5, 38.95,0.05,25595);
INSERT INTO PRODUCT VALUES('23109-HB','Claw hammer' ,'2018-01-20', 23, 10, 9.95,0.10,21225);
INSERT INTO PRODUCT VALUES('23114-AA','Sledge hammer, 12 lb.' ,'2018-01-02', 8, 5, 14.40,0.05,NULL);
INSERT INTO PRODUCT VALUES('54778-2T','Rat-tail file, 1/8-in. fine' ,'2017-12-15', 43, 20, 4.99,0.00,21344);
INSERT INTO PRODUCT VALUES('89-WRE-Q','Hicut chain saw, 16 in.' ,'2018-02-07', 11, 5,256.99,0.05,24288);
INSERT INTO PRODUCT VALUES('PVC23DRT','PVC pipe, 3.5-in., 8-ft' ,'2018-02-20',188, 75, 5.87,0.00,NULL);
INSERT INTO PRODUCT VALUES('SM-18277','1.25-in. metal screw, 25' ,'2018-03-01',172, 75, 6.99,0.00,21225);
INSERT INTO PRODUCT VALUES('SW-23116','2.5-in. wd. screw, 50' ,'2018-02-24',237,100, 8.45,0.00,21231);
INSERT INTO PRODUCT VALUES('WR3/TT3' ,'Steel matting, 4''x8''x1/6", .5" mesh','2018-01-17', 18, 5,119.95,0.10,25595);

/* CUSTOMER rows                   */
INSERT INTO CUSTOMER VALUES(10010,'Ramas' ,'Alfred','A' ,'615','844-2573',0);
INSERT INTO CUSTOMER VALUES(10011,'Dunne' ,'Leona' ,'K' ,'713','894-1238',0);
INSERT INTO CUSTOMER VALUES(10012,'Smith' ,'Kathy' ,'W' ,'615','894-2285',345.86);
INSERT INTO CUSTOMER VALUES(10013,'Olowski' ,'Paul' ,'F' ,'615','894-2180',536.75);
INSERT INTO CUSTOMER VALUES(10014,'Orlando' ,'Myron' ,NULL,'615','222-1672',0);
INSERT INTO CUSTOMER VALUES(10015,'O''Brian','Amy' ,'B' ,'713','442-3381',0);
INSERT INTO CUSTOMER VALUES(10016,'Brown' ,'James' ,'G' ,'615','297-1228',221.19);
INSERT INTO CUSTOMER VALUES(10017,'Williams','George',NULL,'615','290-2556',768.93);
INSERT INTO CUSTOMER VALUES(10018,'Farriss' ,'Anne' ,'G' ,'713','382-7185',216.55);
INSERT INTO CUSTOMER VALUES(10019,'Smith' ,'Olette','K' ,'615','297-3809',0);

/* INVOICE rows                       */
INSERT INTO INVOICE VALUES(1001,10014,'2018-01-16');
INSERT INTO INVOICE VALUES(1002,10011,'2018-01-16');
INSERT INTO INVOICE VALUES(1003,10012,'2018-01-16');
INSERT INTO INVOICE VALUES(1004,10011,'2018-01-17');
INSERT INTO INVOICE VALUES(1005,10018,'2018-01-17');
INSERT INTO INVOICE VALUES(1006,10014,'2018-01-17');
INSERT INTO INVOICE VALUES(1007,10015,'2018-01-17');
INSERT INTO INVOICE VALUES(1008,10011,'2018-01-17');

/* LINE rows                       */
INSERT INTO LINE VALUES(1001,1,'13-Q2/P2',1,14.99);
INSERT INTO LINE VALUES(1001,2,'23109-HB',1,9.95);
INSERT INTO LINE VALUES(1002,1,'54778-2T',2,4.99);
INSERT INTO LINE VALUES(1003,1,'2238/QPD',1,38.95);
INSERT INTO LINE VALUES(1003,2,'1546-QQ2',1,39.95);
INSERT INTO LINE VALUES(1003,3,'13-Q2/P2',5,14.99);
INSERT INTO LINE VALUES(1004,1,'54778-2T',3,4.99);
INSERT INTO LINE VALUES(1004,2,'23109-HB',2,9.95);
INSERT INTO LINE VALUES(1005,1,'PVC23DRT',12,5.87);
INSERT INTO LINE VALUES(1006,1,'SM-18277',3,6.99);
INSERT INTO LINE VALUES(1006,2,'2232/QTY',1,109.92);
INSERT INTO LINE VALUES(1006,3,'23109-HB',1,9.95);
INSERT INTO LINE VALUES(1006,4,'89-WRE-Q',1,256.99);
INSERT INTO LINE VALUES(1007,1,'13-Q2/P2',2,14.99);
INSERT INTO LINE VALUES(1007,2,'54778-2T',1,4.99);
INSERT INTO LINE VALUES(1008,1,'PVC23DRT',5,5.87);
INSERT INTO LINE VALUES(1008,2,'WR3/TT3',3,119.95);
INSERT INTO LINE VALUES(1008,3,'23109-HB',1,9.95);

/* EMP rows */

INSERT INTO EMP VALUES(100,'Mr.' ,'Kolmycz' ,'George' ,'D' ,'1942-06-15','1985-03-15','615','324-5456',NULL);INSERT INTO EMP VALUES(101,'Ms.' ,'Lewis' ,'Rhonda' ,'G' ,'1965-03-19','1986-04-25','615','324-4472',100);INSERT INTO EMP VALUES(102,'Mr.' ,'Vandam' ,'Rhett' ,NULL,'1958-11-14','1990-12-20','901','675-8993',100);INSERT INTO EMP VALUES(103,'Ms.' ,'Jones' ,'Anne' ,'M' ,'1974-10-16','1994-08-28','615','898-3456',100);INSERT INTO EMP VALUES(104,'Mr.' ,'Lange' ,'John' ,'P' ,'1971-11-08','1994-10-20','901','504-4430',105);INSERT INTO EMP VALUES(105,'Mr.' ,'Williams' ,'Robert' ,'D' ,'1975-03-14','1998-11-08','615','890-3220',NULL);INSERT INTO EMP VALUES(106,'Mrs.','Smith' ,'Jeanine','K' ,'1968-02-12','1989-01-05','615','324-7883',105);INSERT INTO EMP VALUES(107,'Mr.' ,'Diante' ,'Jorge' ,'D' ,'1974-08-21','1994-07-02','615','890-4567',105);INSERT INTO EMP VALUES(108,'Mr.' ,'Wiesenbach','Paul' ,'R' ,'1966-02-14','1992-11-18','615','897-4358',NULL);INSERT INTO EMP VALUES(109,'Mr.' ,'Smith' ,'George' ,'K' ,'1961-06-18','1989-04-14','901','504-3339',108);INSERT INTO EMP VALUES(110,'Mrs.','Genkazi' ,'Leighla','W' ,'1970-05-19','1990-12-01','901','569-0093',108);INSERT INTO EMP VALUES(111,'Mr.' ,'Washington','Rupert' ,'E' ,'1966-01-03','1993-06-21','615','890-4925',105);INSERT INTO EMP VALUES(112,'Mr.' ,'Johnson' ,'Edward' ,'E' ,'1961-05-14','1983-12-01','615','898-4387',100);INSERT INTO EMP VALUES(113,'Ms.' ,'Smythe' ,'Melanie','P' ,'1970-09-15','1999-05-11','615','324-9006',105);INSERT INTO EMP VALUES(114,'Ms.' ,'Brandon' ,'Marie' ,'G' ,'1956-11-02','1979-11-15','901','882-0845',108);INSERT INTO EMP VALUES(115,'Mrs.','Saranda' ,'Hermine','R' ,'1972-07-25','1993-04-23','615','324-5505',105);INSERT INTO EMP VALUES(116,'Mr.' ,'Smith' ,'George' ,'A' ,'1965-11-08','1988-12-10','615','890-2984',108);/* EMPLOYEE rows */INSERT INTO EMPLOYEE VALUES(100,'Mr.' ,'Kolmycz' ,'George' ,'D' ,'1942-06-15','1985-03-15',18,'615','324-5456');INSERT INTO EMPLOYEE VALUES(101,'Ms.' ,'Lewis' ,'Rhonda' ,'G' ,'1965-03-19','1986-04-25',16,'615','324-4472');INSERT INTO EMPLOYEE VALUES(102,'Mr.' ,'Vandam' ,'Rhett' ,NULL,'1958-11-14','1990-12-20',12,'901','675-8993');INSERT INTO EMPLOYEE VALUES(103,'Ms.' ,'Jones' ,'Anne' ,'M' ,'1974-10-16','1994-08-28', 8,'615','898-3456');INSERT INTO EMPLOYEE VALUES(104,'Mr.' ,'Lange' ,'John' ,'P' ,'1971-11-08','1994-10-20', 8,'901','504-4430');INSERT INTO EMPLOYEE VALUES(105,'Mr.' ,'Williams' ,'Robert' ,'D' ,'1975-03-14','1998-11-08', 4,'615','890-3220');INSERT INTO EMPLOYEE VALUES(106,'Mrs.','Smith' ,'Jeanine','K' ,'1968-02-12','1989-01-05',14,'615','324-7883');INSERT INTO EMPLOYEE VALUES(107,'Mr.' ,'Diante' ,'Jorge' ,'D' ,'1974-08-21','1994-07-02', 8,'615','890-4567');INSERT INTO EMPLOYEE VALUES(108,'Mr.' ,'Wiesenbach','Paul' ,'R' ,'1966-02-14','1992-11-18',10,'615','897-4358');

INSERT INTO EMPLOYEE VALUES(109,'Mr.' ,'Smith' ,'George' ,'K' ,'1961-06-18','1989-04-14',13,'901','504-3339');INSERT INTO EMPLOYEE VALUES(110,'Mrs.','Genkazi' ,'Leighla','W' ,'1970-05-19','1990-12-01',12,'901','569-0093');INSERT INTO EMPLOYEE VALUES(111,'Mr.' ,'Washington','Rupert' ,'E' ,'1966-01-03','1993-06-21', 9,'615','890-4925');INSERT INTO EMPLOYEE VALUES(112,'Mr.' ,'Johnson' ,'Edward' ,'E' ,'1961-05-14','1983-12-01',19,'615','898-4387');INSERT INTO EMPLOYEE VALUES(113,'Ms.' ,'Smythe' ,'Melanie','P' ,'1970-09-15','1999-05-11', 3,'615','324-9006');INSERT INTO EMPLOYEE VALUES(114,'Ms.' ,'Brandon' ,'Marie' ,'G' ,'1956-11-02','1979-11-15',23,'901','882-0845');INSERT INTO EMPLOYEE VALUES(115,'Mrs.','Saranda' ,'Hermine','R' ,'1972-07-25','1993-04-23', 9,'615','324-5505');INSERT INTO EMPLOYEE VALUES(116,'Mr.' ,'Smith' ,'George' ,'A' ,'1965-11-08','1988-12-10',14,'615','890-2984');COMMIT;

The population of the developing word today is much larger than the population of developed world
a) explain in a simple term the historic reasons that led to this situation
b) describe and explain one of the most effective ways to promote lower fertility rate in developing countries without having to resort to coercion

List the correct word under the correct title.  There are some words that can be in both categories.

HYPERTHYROIDISM                                                             HYPOTHYROIDISM

Words

Hair loss

Weight loss

Weight gain

Fine hair

Insomnia

Fatigue

Intolerance to cold

Intolerance to heat

Constipation

Memory loss/mental fog

Diarrhea

Muscle tremors

Weakness

Enlarges thyroid

Irritability/nervousness

Brittle nails

Exophthalmus

Amenorrhea

Please provide a 250 word explanation AND DESCRIPTION OF A REAL WORLD APPLICATION of one of the following topics:

-ideal gases or the ideal gas law

-the gas constant or the Boltzmann constant

-the root mean square speed of molecules in a gas

-molar specific heat

-the mean free path of a gas molecule

Please be descriptive and include example equations if possible. If post meets requirements of 250 words, explanation of theory, AND A REAL WORLD APPLICATION, I will promptly thumbs up. Thank you!

: Your report should be completed on Microsoft Word and should be between 1,000 and 1,250 words excluding references.

1. silver in 2017-2019

In your answer you should explain what has happened to prices of the good you have chosen over the time period stated. You should consider the role of supply and demand and provide a diagramatic explanation, using supply and demand curves for the changes in the prices of the good, you should refer to the elasticity of supply and demand of the good, the market structure of the good and specifically if there are any cartels/price fixing activities in the industry effecting the price changes discussed. You should use these relevant theories in your answer but you should also refer to data where relevant too.

Entrepreneurs Please respond to the following with a 250-300 word response: Analyze the characteristics of a successful entrepreneur (see pages 5-7 in textbook) and determine if you have what it takes to start your own business. Provide specific examples to support your response. A recent tax change will significantly lower tax rates for businesses. Consider the contributions of small businesses, as discussed on pages 27-28 in textbook, and provide your opinion on this tax modification.

Chapter 7

Develop a response in either Word or Excel and follow the instructions outlined in the Assignments Menu for submission.

On December 31, 2010, Palli Company finished consultation services and accepted in exchange a promissory note with a face value of $240,000, a due date of December 31, 2013, and a stated rate of 5%, with interest receivable at the end of each year. The fair value of the services is not readily determinable and the note is not readily marketable. Under the circumstances, the note is considered to have an appropriate imputed rate of interest of 10%.

         The following interest factors are provided:

                                                                                                    Interest Rate       

Table Factors for Three Periods                      5%                  10%

Future value of 1                                          1.15763             1.33100

Present value of 1                                          .86384               .75132

Future value of an ordinary annuity of 1 3.15250             3.31000

Present value of an ordinary annuity of 1 2.72325            2.48685

         REQUIRED

(a) Determine the present value of the note.

Prepare a Schedule of Note Discount Amortization using the effective interest method. (Round to whole dollars.)

Prepare the journal entry to record the acceptance of the note on December 31, 2010.

Prepare the journal entry to record the interest payment received on December 31, 2011

55)

A) In how many dierent ways can the letters of the word 'JUDGE' be arranged such that the vowels

always come together?

B) How many 3 digit numbers can be formed from the digits 2, 3, 5, 6, 7 and 9 which are divisible by 5

and none of the digits is repeated?

C) In how many ways can 10 engineers and 4 doctors be seated at a round table without any restriction?

D) In how many ways can 10 engineers and 4 doctors be seated at a round table if all the 4 doctors sit

together?