ONLY DO THIS USING SQL DEVELOPER (ORACLE SQL). And using the following tables (Tables for Part 1 …

ONLY DO THIS USING SQL DEVELOPER (ORACLE SQL).

And using the following tables (Tables for Part 1 and 2):

CREATE TABLE Customers
(
Cust_id int PRIMARY KEY,
Last_Name varchar(255),
First_Name varchar(255),
State varchar(255),
Zipcode Number(10)
);

CREATE TABLE Customers_history
(
History_id int PRIMARY KEY,
Cust_id int,
Last_Name varchar(255),
First_Name varchar(255),
State varchar(255),
Zipcode Number(10)
);

TEST CODE BEFORE POSTING SOLUTION.

Your assignment is to create an auditing policy that keep track of insertion and update activities of Customers table. This Customers trigger fires before update or insert or delete on customers. You have to test your trigger and provide screenshots to prove that it works correctly

D1. Create a new table named Customers. The new table should have at least 5 columns including a primary key. (Cust-id, First_name, Last_name, State, Zip-code. Use cust_id as PK.

D2. Insert 2 rows into the Customers table.

D3. Create a history table for Customers table, (create table customers_history). The table should have same structure as Customers table Cust-id + First_name + Last_name+ State + Zip_code. Don’t forget the history_id as pk . Do NOT insert any data (values) into this table.

D4. Create a trigger for auditing?create trigger audit_customers on the Custoners table

D5. Insert 3 records into the Customers table.

D4. Retrieve all rows from customers and customers-history table to verify that rows were added to the Customers table and that the trigger is populating the customers-history table.

D5. Now update the zip code of one customer and check if rows were added to the customers table and that the trigger did populate the customers-history table with the new zip code.

D6. Update the first record of Customers, and then delete this record.

D7. Display the content of Customers table and the history table.

You have to provide the trigger code, code you used to create the table and insert records. (2 points)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

: The Makonsel company is a fully connected supply chain that produces goods in production…

:The Makonsel company is a fully connected supply chain that produces goods in production centers (Atlanta and Birmingham) and sells them at its markets or retail outlets in Pittsburgh and Detroit. After production, the goods are stored in one of the warehouses in Nashville and Memphis and then they are sent to one of the cities in Cincinnati, Columbus, or Richmond for final delivery. The possible logistic paths and their travel times (hrs) are listed in the table below:

Atlanta

4

6

Birmingham

3

3

Nashville

5

6

9

Memphis

7

9

12

Indianapolis

6

3

Columbus

3

3

Richmond

6

9

Part a) Use dynamic programming to find the shortest path for delivering products from Atlanta to Detroit. (Define stages and states, show all tables and final solution)

Trucks with limited transportation capacity of 1000 products are used to transport the goods. The transportation cost is 0.01 ($/hour per product) and there is also a fixed charge of $500 for transportations from Atlanta to Nashville. The tables below show other costs and capacities.

Plants

Production Cost ($)

Production Capacity

Atlanta

8

3000

Birmingham

6

6000

Markets

Min Demand

Product Price ($)

Detroit

5000

100

Pittsburgh

3000

50

Part b) Formulate the problem as a linear programming model to find the best logistic strategy for this supply chain.

Part c) Use software to solve the problem (Show the screen shot of the setting window and results)

Part d) Investigate the effects of transportation capacity on total profit (Be creative, no specific requirement)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Write an introduction about what type of analysis you plan to execute. Provide a brief data…

1. Write an introduction about what type of analysis you plan to execute. Provide a brief data description: what are your data about; how many variables and observations there; what are highest and lowest temperatures were observed and when? 2. Make a function to calculate and (nicely) present descriptive statistics (mean, standard deviation, skewness, kurtosis, median, IQR) for a given month and year. Run it for a maximal temperature for any month of 1961 and 2019. Compare results and discuss. Present appropriate data visualisation to support your discussion. 3. Combine two data sets together and calculate a daily range between maximal and minimal temperature. Get an average range for each year, discuss its distribution and change over the time. Provide appropriate data visualisation to support your discussion. 4. Count number of days per year with maximal temperature above 35 degrees. Build a graph. Discuss your observations. 5. Select and justify a threshold for a minimal temperature and repeat step 4 for the number of days below the chosen threshold. 6. Combine results from steps 4 and 5; discuss your finding and implications for the question of climate change. 7. Write a conclusion outlining your analysis and results.

Attachments:

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Question 1. Identify the 5 factors that enhance the diffusion of a good or service? Explain each fac

Question

 

1. Identify the 5 factors that enhance the diffusion of a good or service? Explain each factor. For each factor identify a product that had this factor lead to its success. 2. Identify and explain common pricing practices that are considered to be illegal or unethical? Give examples of each. 3. Identify the difference between intensive, exclusive, and selective levels of distribution intensity? Give an example of a product that would be best for each level of distribution.. 4. Identify and explain 3 different ways to schedule advertising. Select an example for each way would be used.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

You are the greatest student of anatomy and physiology, and you are well-prepared for your exam on..

You are the greatest student of anatomy and physiology, and you are well-prepared for your exam on the brain. As you confidently answer the questions, your brain is exhibiting beta waves.
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

THIS REQUIRES ONLY CERTAIN SECTIONS OF CHAPTER 3. IT ONLY REQUIRES 3 PAGES. ALL REFERENCES MUST BE..

THIS REQUIRES ONLY CERTAIN SECTIONS OF CHAPTER 3. IT ONLY REQUIRES 3 PAGES. ALL REFERENCES MUST BE FROM MEDICAL PEER REVIEW ARTICLES NO OLDER THAN 2009

Measuring the effectiveness of Complementary and Alternative Medicine Therapies for Veteran’s with Post-traumatic Stress Disorder (PTSD) and Traumatic Brain Injury

(TBI)

Click here for more on this paper…….
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted

1. Discuss the Validity of the Research (2 PAGES). Validity is an assessment of the truthfulness of a study’s results and findings (e.g. its trustworthiness)

Click here for more on this paper…….
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted

-Argue the Validity of the Research(Include Internal, External and Threats)
-Also discuss:-
-Utility (the hope that the outcome of the research and its recommendations help future researchers)
-Participation (the goal that all stakeholders are offered an open invitation to participate with the study and view its results)
-Dependability (the desire to produce a method able to measure the effectiveness of CAMs)
-Transferability/Generalizability (the concept of asking whether the results, plans, methods can be transferred into other contexts)
-Credibility.
-Talk of Persi

Click here for more on this paper…….
Click here for more on this paper…….
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted

stence in Observation and Data Collection (the concept that longer observation time mitigate the observation of events leading to short-term changes in

orbserved behavior)
Triangulaltion (Drawing upon an assortment of sources leads to a verifiable, believable, and valid understanding of the data.
Negative Case Analysis – Discuss data failing to support or possible contradicting the research, assumptions or a particular element in the study

Click here for more on this paper…….
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted

Referential Adequacy
Linguistic Adequacy

2. Reliability (1 PAGE)
Argue the measurements used in the study as reliable and valid using these categories:
-Test-Retest Reliability
-Internal Consistency
-Alternate Forms
-Interrater and Intrarater Reliability
-Face Validity
-Content
-Criterion
-Construct Validation

Click here for more on this paper…….
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Identify the form of discourse of the passage as a whole–i.e., whether it is an argument, a…

(a) List the statements (not the merely expressed propositions) in the passage.

(b) Identify the form of discourse of the passage as a whole–i.e., whether it is an

argument, a conditional statement, an explanation, a report/narrative, or none of the

above.

It’s possible a passage might not be an argument as a whole, but might contain an argument.

If, but only if, the passage is, or contains an argument:

(c) Reconstruct the argument in standard form.

(d) Is the argument a candidate for, or an argument of the right kind to commit, any of the

fallacies discussed in Chapter 4.2 of Pendlebury? If so, which one or ones (if more

than one)?

If, but only if, the argument is of the right kind, for each fallacy identified in (d):

(e) Does the argument actually commit the fallacy?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

driver pressure is 7 atm, while the pressure in the driven section is 1 atm. The temperature in… 1 answer below »

For a 1D shocktube, with both the driver and driven sections are filled with air. The

driver pressure is 7 atm, while the pressure in the driven section is 1 atm. The temperature in both sections are 300 K. When the diaphragm separating the driver and

driven sections is removed, a shock wave is generated, which propagates with a constant speed us until the shock or expansion fan reaches the two ends of the shock tube.

The shock Mach number is defined as Ms = us/cR, where cR is the initial sound speed

in the driven section. Please find Ms.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

– Mike Cichanowski founded Wenonah Conie, and later purchasedDescriptionSolution downloadThe…

– Mike Cichanowski founded Wenonah Conie, and later purchasedDescriptionSolution downloadThe QuestionMike Cichanowski founded Wenonah Conie, and later purchased Current Designs a company that designs and manufactures kayaks. The Kayak manufacturing facility is located just minutes from the conoe company’s headquarters in Winona, Minnesota. Current Designs makes Kayaks using two different processes. The rotational molding process uses high temperature to melt poyethylene powder in a closed rotating metal mold to produce a complete kayak hull and deck in a single piece. These kayaks are less labor intensive and less expensive for the company to produce and sell, Its other kayaks use the vacuum bagged composit lamination process. Layers of fiberglass or kevlar are carefully placed by hand in a mold and are bonded with resin. Then a high pressure vacuum is used to eliminate any excess resin that would otherwise add weight and reduce strength of the finished kayak. These kayaks require a great deal of skilled labor as each boat is individually finished. The exquisite finish of the vacuum bagged composite kayaks gave rise to Current Designs tag line “A work of art, made for life.” Current Designs has the following managers: Mike Cichanowski- CEO Diane Buswell- controller Deb Welch- purchasing manager Bill Johnson- Sales Manager Dave Thill- Kayak plant manager Rick Thrune- Production manager for Composite Kayaks What are the primary information needs of each manager? Name on special purpose managment accounting report that could be designed for each manager. Include the name of the report, the information that it would contain, and how frequently it should be issued. When diane buswell controller for current designs reviews the accounting records for a recent period, she noted the following items. Classify each item as a product cost, or a period cost. If an item is a product cost not that it is a direct materials, direct labor or manufacturing overhead item. Payroll check to Sales manager Payroll check to plant manager Property taxes on manufacturing plant paid to Winona County Property insurance for manufacturing plant paid to Winona agency Electricity bill for manufacturing plant Sales commissions Payroll check to kayak assembler shop supplies (brooms, paper towels) paid to Fastenal Polyethylene powder whis is the main ingrediat for the rotational molded kayaks paid to Ravango Kevlar favric for composite kayaks paid to North American Composites Waste managment- trash disposal for company office building bagging film used when kayaks are assembled- paid to Composite oneQuestions: Name on special purpose managment accounting report that could be designed for each manager. Include the name of the report, the information that it would contain, and how frequently it should be issued?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"