Flow-control mechanisms are used at both layers 2 and 3 of X.25. Are both necessary or is this redundant? Explain the problems which can be avoided for having flow control at both layers..

Reflect on the usefulness of both of the tools, Non-Violent Communication (NVC) and SCARF framework. How would you apply the two tools in your daily life? Use two concrete examples for each tool (4 total examples). Be specific, concrete, and original (absolutely no copying and pasting). Emphasize your role, but do not forget that the tools have little meaning for only one of the individuals involved.

Your Discussion should be at least 250 words in length, but not more than 750 words. Use APA citations and references for the textbook and any other sources used.

Based on what we learned in the lecture on spatial structure and on competition, how important is it to vary spatial structure when characterizing competitive interactions? Use specific empirical examples to support your opinion. To what extent could you predict the competitive outcomes in the natural world if you only studied well-mixed environments? What is the paradox of the plankton? describe a solution to it.

Given what you know about microorganisms, their traits, and where and how they live, do you think non-transitive interactions occur frequently?

A health plan uses a four-tier formulary:

$10 generic; $35 brand; $65 brand non-preferred; $120 speciality

Cost of pharmaceutical products:

Drug A (generic)= $50/month

Drug B (brand)=$135/month

Drug C (brand non-preferred)= $230/month

Drug D (speciality)= $2000/month

If a person is a health plan member on all four medications, how much out-of-pocket must he pay? And how much does the health plan for the medications? Explain why.

I can't imagine how much more info you require to answer this. It is MySQL if that helps but even that info is here. If you don't know how to answer, then don't. There is more information here than anyone should need to answer the questions.

The structure and contents of the Ch08_SimpleCo database are shown in Figure P8.16. Use this database to answer the following problems. Database Schema The schema for the Ch08_SimpleCo database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab.

Instructions

Given the structure of the Ch08_SimpleCo database shown above, use SQL commands to answer the problems in the following steps.

Write your SQL statement in the editor on the right, then click the Run Query button to execute your statement in the interactive MySQL shell.

Problem 18

Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in Problem 16, as illustrated in Figure P8.16.

My code: INSERT INTO CUSTOMER VALUES(1,"bhavana","wali",12345678.45);

My error: ERROR 1062 (23000) at line 1: Duplicate entry '1' for key 'PRIMARY'

18.a

Write the set of SQL commands necessary to insert the data into the INVOICE table you created in Problem 17, as illustrated in Figure P8.16.

Use YYYY-MM-DD format when inserting dates.

my code: INSERT INTO INVOICE VALUES(11,'2015/12/1',12312388.12,1);

my error: ERROR 1062 (23000) at line 1: Duplicate entry '11' for key 'PRIMARY'

18.b

Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following customers:

my code:

INSERT INTO CUST_MYSQL(CUST_LNAME,CUST_FNAME,CUST_BALANCE) VALUES ("Smith","Jeanne",1050.11);
INSERT INTO CUST_MYSQL(CUST_LNAME,CUST_FNAME,CUST_BALANCE) VALUES ("Ortega","Juan",840.920);

SELECT * FROM CUSTOMER;
SELECT * FROM INVOICE;
SELECT * FROM CUST_MYSQL;

My results:

the results I need:

SELECT * FROM CUST_MYSQL

Expected Results

18.c

Populate the CUST_NUM, INV_DATE, and INV_AMOUNT fields with the following customers:

my code:

insert into INVOICE(CUST_NUM , INV_DATE, INV_AMOUNT)
values(1000,'2016-03-23', 235.89), (1001, '2016-03-23', 312.82),
(1001, '2016-03-30', 528.10), (1000, '2016-04-12', 194.78), (1000, '2016-04-23', 619.44);

select * from INVOICE;

My error:

ERROR 1364 (HY000) at line 1: Field 'INV_NUM' doesn't have a default value

18.d

Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically:

my code:

insert into CUSTOMER(CUST_LNAME, CUST_FNAME, CUST_BALANCE)
values('Powers', 'Ruth', 500);

select * from CUSTOMER;

my error:

ERROR 1364 (HY000) at line 1: Field 'CUST_NUM' doesn't have a default value

18.e

Modify the CUSTOMER table to include the customer’s date of birth (CUST_DOB), which should store date data

my code:

insert into CUSTOMER(CUST_LNAME, CUST_FNAME, CUST_BALANCE)
values('Powers', 'Ruth', 500);

select * from CUSTOMER;

my error:

ERROR 1364 (HY000) at line 1: Field 'CUST_NUM' doesn't have a default value

18.f

Modify customer 1000 to indicate the date of birth on March 15, 1989.

Use YYYY-MM-DD format for inserting dates.

my code:

UPDATE CUST_MYSQL SET CUST_DOB='1989-03-15' WHERE CUST_NUM=1000;

my results state "NO DATA"

ERROR 1054 (42S22) at line 1: Unknown column 'CUST_DOB' in 'field list'

The wrong headers were returned.

Some expected rows were missing (shown in red below).

Test Query

SELECT CUST_NUM, CUST_DOB FROM CUSTOMER WHERE CUST_NUM = 1000

Expected Results

18.g

Problem 25

Modify customer 1001 to indicate the date of birth on December 22, 1988.

Use YYYY-MM-DD format for inserting dates.

my code:

ALTER TABLE CUSTOMER ADD(DOB DATE);
UPDATE CUSTOMER SET DOB='1988-12-22' WHERE CUST_NUM=1001;
Select * from Customer;

My error:

ERROR 1146 (42S02) at line 3: Table 'Ch08_SimpleCo.Customer' doesn't exist

Help! Talk to me like I'm really stupid. Thank you.

Education industry is classified as non-essential service under the Movement Control Order (MCO) Phase 1 and Phase 2 by the Government of Malaysia, how does education industry develop an e-business strategy applying the 7 dimensions model by Robert Plant (2000). (Please help to elaborate in clearly and details)

XYZ corporation had a $20,000 net loss in 2018. Kitty has $2000 income in 2016 and $8000 income in 2017. Kitty is c corporation tax client. How do you handle this case and what you can tell her to write off on her tax?

You have been asked to build a database for a pet foster and adoption shelter. The agency is a non-profit that takes in stray or abandoned pets and places them with foster care givers until the pet is adopted. Foster care givers are volunteers, though they must first be screened. The database needs to track all animals in its care, their species, breed, name and condition. It also needs to track all approved foster care givers and which animals are currently in their care. Foster care givers are also supposed to turn in monthly reports on the animals in their care. The database also needs to track the adoptions of the animals. Currently, volunteers come into the shelter and fill out a paper form. After a background check they are added to a file. Some volunteers complain that they are never contacted again. The shelter staff admits, they tend to go with foster care givers they know and some people get forgotten in the file. The shelter has also occasionally lost track of an animal in foster care when the care giver failed to turn in the monthly reports. Another recurring problem is that when someone comes into the shelter looking to adopt, it is not always easy or even possible to let them know about all the animals available for adoption. Ideally the shelter would like people to be able to register as a volunteer on-line. They would like to be able to call up a list of all available foster volunteers. They also would be like to be able to pull up all the animals of the kind a potential adopter is interested in and know exactly where those animals are and who is caring for them.

Would animals be stakeholders in this database? Explain why or why not.
What might be some of the shelter database security issues?