You are in networking at a large international company. Your company recently decided to implement a cross-training initiative and you have been selected to give a presentation to an audience of non-networking professionals working at various departments in your company.

Your presentation must be clear and concise enough to convey technical information to professionals who have a limited understanding of how networking actually works. However, it must also be accurate enough that your audience can understand how their company roles (such as scheduling resource-hogging reports, allowing contractors access to the system, and setting the hours international customers can place orders on your company’s system) can impact the company’s network, particularly in terms of security.

You decide to use the OSI model to explain the fundamental characteristics and components of networks because it is visual and presents the complexity of network communication in 7 layers.

Draft your speaker notes to hand off to an assistant who will turn your notes into a graphic-rich presentation. Each of your answers should be about 150-250 words long.

Note: Your assignment is to draft speaker notes. Do not create a presentation and do not write a paper.

1. Overview of Networking and Security

You decide to begin your presentation by providing your audience an overview of networking, with an emphasis on security and why it is important for all company roles to assist in securing the company’s network.

Discuss the potential security risks for each layer of the OSI model and the risks in each of the following:

• Distributed vs. centralized computer systems and why your department chose to be distributed/centralized
• Different network topologies and why your department chose the topology it did
• Why standards bodies are essential in networking and how your department complies with standards
• The importance of communication protocols and which one(s) your department chose
• The differences between LAN, WAN, and wireless technologies, and how your department incorporated each
• The responsibilities associated with providing telecommunications services such as security, privacy, reliability, and performance

2. Routing and Switching

Describe basic routing and switching in the context of the OSI model (i.e., in which layer routing, switching, and cabling occur). To underscore your department’s commitment to achieving 24/7 availability, describe 3 strategies your department uses to ensure the availability of network access in switched and routed networks.

3. Effective Security Policy

Describe at least 3 characteristics of an effective security policy, emphasizing the ways in which all departments in the company are responsible for helping secure the company network.

4. Security Strategies

Explain strategies your department used to build security directly into the design of your company network.

5. Malware

Define malware in layperson-friendly language and identify at least 2 strategies your department has put into place to protect your company’s network against malware.

6. Closing

Summarize your presentation.

The Saber City Disaster Preparedness (DP) team wanted to coordinate a mock terrorist attack to study the effectiveness of their disaster-management plan. The goal of the mock attack was to promote confidence, develop skills, coordinate activities, and coordinate participants of the disaster-management team. The DP team planned an attack commonly seen as a terrorist attack: A bus carrying important politicians would explode outside the federal courthouse in downtown Saber. All participating organizations (including the health department, hospital, police department, and fire department) were notified of the date the mock attack would be held. Volunteers were found who would play the victims found at the scene.

After months of planning, the day of the mock attack came. Members of the DP team watched how well the organizations worked together during the events of the mock attack. At noon, reports of an exploded bus in front of the courthouse came across police scanners: “Several people are dead and many more injured.” Emergency medical response teams and hazardous material response crews were called to the scene to care for the injured and attend to the potential hazardous exposure. Policemen quickly cleared the area of people and established a barrier around the scene. Firefighters put out the burning bus.

From the mock attack, the DP team learned that the city of Saber was prepared for a terrorist attack. Communication between organizations flowed smoothly, and the disaster-management team was skillful in controlling the situation. Participants in the mock attack stated that they were happy they had the practice experience and felt more confident in their skills to provide care in the event of a major disaster.

Questions

1. Identify the stage of disaster management that the city of Saber has reached. Be thorough. Provide a rationale to support the choices, not your opinion.

2. You are a nurse who is called to the scene of the mock disaster. Triage the following clients at the disaster site: provide a thorough rationale for the decisions; support with evidence from the textbook for each triage designation.

A. A 60-year-old man with a broken wrist and a history of heart disease.

B. A 30-year-old woman with “road burn” lacerations on her forearms and thighs.

C. A 12-year-old boy with third-degree burn marks over 40% of his body.

3. What are some organizations where nurses can volunteer to work in disasters? Name at least three.

Tony’s favorite memories of his childhood were the times he spent with his dad at camp. Tony was daydreaming of those days a bit as he and Suzie jogged along a nature trail and came across a wonderful piece of property for sale. He turned to Suzie and said, “I’ve always wanted to start a camp where families could get away and spend some quality time together. If we just had the money, I know this would be the perfect place.” On November 1, 2022, Great Adventures purchased the land by issuing a $500,000, 6%, 10-year installment note to the seller. Payments of $5,551 are required at the end of each month over the life of the 10-year loan. Each monthly payment of $5,551 includes both interest expense and principal payments (i.e., reduction of the loan amount).

Late that night Tony exclaimed, “We now have land for our new camp; this has to be the best news ever!” Suzie said, “There’s something else I need to tell you. I’m expecting!” They decided right then, if it was a boy, they would name him Venture.

1) Prepare the journal entries for transactions. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.)

• Record the issuance of the long-term note payable for the purchase of land on November 1, 2022.

• Record the first monthly payment on the long-term note payable, made on November 30, 2022.

• Record the second monthly payment on the long-term note payable, made on December 31, 2022.

• The 12 monthly payments in 2023 (following year) will reduce the note's balance by an additional $38,014. Record the reclassification of this amount from long-term notes payable to current notes payable.

• Prepare the closing entry for revenue accounts.

• Prepare the closing entry for expense and loss accounts.

2) Prepare an income statement for the period ended December 31, 2022. Choose the appropriate accounts to complete the company's income statement. The unadjusted or post-closing balances will appear for each account, based on your selection.

3) Prepare a classified balance sheet as of December 31, 2022. Choose the appropriate accounts to complete the company's balance sheet. The unadjusted or post-closing balances will appear for each account, based on your selection.

CASE STUDY 3

Febrile Seizure

Abby is a 1-year-old girl who presents after a reported seizure at daycare.

Subjective Data

Fever for 1 hour

Eating and drinking normally per mother

Objective Data

Vital signs: T 40, HR 160, R 44, BP 104/68

Awake and alert

Skin hot to touch, otherwise normal physical examination

A. How should the nurse respond to Abby’s mother when she asks if Abby has epilepsy?

B. How should the nurse respond to Abby’s mothers question about brain damage?

C. In this clinical situation what should the nurse do?

CASE 4.

Distal Radius and Ulnar Fracture (Buckle)

Billy is a 10-year-old boy who presents with an obvious deformity to his right forearm. Billy fell on his arm while playing soccer 15 minutes before admission.

Subjective Data

Complains of pain to right forearm

States he is able to feel sensation to right hand

Denies any numbness or tingling to upper right extremity

Objective Data

Vital signs: T 36.8, P 110, RR 28, BP 122/60

Right radial pulses is strong to palpation

Capillary refill to right hand brisk <2 sec

Last PO intake 8 hours ago

A. What complications is Billy at risk for from a fracture?

B. What measures might have helped prevent this injury?

C. What should the nurse do in this clinical situation? Prioritize actions.

CASE 5.

Type 1 Diabetes Mellitus

Susan is an 8-year-old girl who has been brought to her pediatrician by her mother for a weight loss of 5 pounds over the past 2 months despite an increased food intake.

Subjective Data

Complains of thirst

Complains of hunger

Complains of frequent voiding

Objective Data

Today’s Weight: 25 kg

Weight from physical examination 6 months ago: 27.3 kg

Finger stick glucose: 325

HbA1c: 9.1

UA: glycosuria

pH 7.34

Father diagnosed with type 1 diabetes at age 8

A. Will Susan require hospitalization?

B. Susan plays after-school sports; will she have to stop these activities?

C. What should the nurse do in this situation? Prioritize actions.

NO PHOTOS PLEASE

Using the following definition to determine if the child in each case study has a mental disorder. If there’s not enough information in the case study, identify any other information you would need to determine if he or she meets the DSM-5 definition: A mental disorder is a syndrome characterized by clinically significant disturbance in an individual’s cognition, emotion regulation, or behavior that reflects a dysfunction in the psychological, biological, or developmental processes underlying mental functioning. Mental disorders are usually associated with significant distress or disability in social, occupational, or other important activities. An expectable or culturally approved response to a common stressor or loss, such as the death of a loved one, is not a mental disorder. Socially deviant behavior (e.g., political, religious, sexual) and conflicts that are primarily between the individual and society are not mental disorders unless the deviance or conflict results from a dysfunction in the individual, as described above.

Margaret wets the bed at night. Her parents discover her wet the next morning and spend a great deal of time and energy washing her pajamas and bedding. _______________

Shawn is afraid to ride elevators. Every time he is in an elevator, he experiences intense feelings of panic. He tries to avoid elevators whenever he can. ____________________

Charlotte is a teenage girl whose father died of a heart attack. Charlotte isn’t eating or sleeping well. She can’t concentrate on her homework or activities at school. Sometimes, at night, she talks with her father about her day before she falls asleep. She also thinks a lot about death. _____________________

Jordan was slow to reach many developmental milestones, including sitting up and walking. Most striking are Jordan’s marked delays in language. He has limited vocabulary, struggles to recite the alphabet or recognize letters, and has difficulty counting. He also has problems performing self-care tasks typical of children his age, such as dressing, bathing, and grooming. ___________________

Corey is an 8-year-old boy who shows significant problems with hyperactivity and impulsiveness at home. “Corey is always on the go. Watching him tires me out,” his mother reported. Corey has difficulty remaining seated during meals, constantly fidgets with objects around the house, talks incessantly, and engages in high-rate behavior. “He’s very impulsive,” she added. _____________________

Provide positive feedback:

Pay-for-Performance Link. Based on your understanding of linking organization strategy to compensation and performance management, as discussed in Chapter 9, discuss how to strengthen the pay-for-performance link.

Powerful incentives can cause undesired behaviors. Suggest ways to solve this problem, using something you know a great deal about – academic performance.

Oooh, fascinating question! At the end of last year I read Smartest Kids in the World by Amanda Ripley. One of the stories a South Korean boy killed his mom and hid her corpse in their apartment for months. He was under so much stress about his high school graduation exams and had so much pressure to preform well for his family that he snapped. That would be pretty extreme in the US.  

Here I would expect cheating if incentives became too high. Maybe it would be in the form of buying paper. Maybe it would be in the form of parents bribing administrators or admissions counselors.

To promote ethical behavior teachers could try to promote class unity by recognizing accomplishments in a way that does not pit students against each other in competition. Maybe schools could offer teaching classes on ethics. Maybe they could lower the incentives or increase punishments for fraud and cheating.

How would you design a pay-performance system that uses powerful incentives to motivate behavior, yet keep the behavior from veering into the unethical? (Hint: You want to keep the powerful incentive effect of pay. So don’t recommend eliminating incentive pay or reducing the size of the incentive component.) What’s left?

We could try increasing the punishments for unethical behavior. We could do things to promote group unity or at least keep students in pairs - oh but I had group projects. We could try peer reviews to verify that those who are receiving top incentives deserve them honestly.  

   How do you ensure ethical behavior?

My first thought is to hire ethical employees. Another thought is to encourage ethical behavior from the top down and to be quick to remove anyone caught committing fraud. At the end of the day, I don't think we can totally ensure other people's ethical behavior.

Instructions
Please respond to the following questions in essay format; (number each response so I know which person you are referring to). Your response must be at least 250 words in length (standard margins, 12pt Times font). The format of your response must include headings for each topic listed below. You may include information about your own personal experience, information from the book, and empirical research that you have found from a legitimate research journal (NOT Wikipedia or other similar sites). Please review the information on the syllabus about how to find an empirical research article if you choose to incorporate this.

Topic
Vignettes Human Development
Around what age is each of the following individuals? How do you know? What concepts are they displaying? According to Eric Erikson’s stages of development, which stage of development is each person in and what are the characteristics of that stage?

Kelly needs a lot of sleep these days- about 9-10 hours per night, especially on the weekends! Most of the time however, she doesn’t get enough sleep during the week because she’s up late studying. She is spending more time with her friends and not as much time with her parents and her mom is feeling frustrated with this change. Kelly is also very concerned about what others think of her and always worries that they are watching her and that she is the center of attention everywhere she goes.

Joshua just learned how to walk! His parents watched in amazement as he learned to lift his head, then chest, then the rest of his body. He was a determined crawler and is a curious boy, playing with toys and putting them in his mouth. Now he is more interested in whatever his dad is doing, turning nobs on his dad’s stereo as his father does.

Maria has noticed some difficulties with her memory lately. She takes longer to recall events and form words to explain stories. Maria tends to remember the positive interactions she has with her friends these days and enjoys going on walks with them when she has energy. When Maria thinks about her life, she feels a sense of accomplishment and values her small circle of family and friends.

Please use the books database pasted under question 4 to design the following SQL queries. Use any method such as subqueries, equi-join/inner-join, outer join, EXISTS

1. Find the name(s) of the publisher(s) who have published the computer book.

2. Find the name(s) of the author(s) that have authored more than one books.

3. Find the name(s) of the publisher(s) who published the least expensive book.

4. Find the name(s) of the author(s) who wrote the book with the greatest number of pages.

DROP TABLES IF EXISTS Artists,Genre, Members, Titles, Tracks,SalesPeople,Studios,XrefArtistsMembers;
DROP TABLES IF EXISTS Authors,Publishers,Titles,Title_Authors,Royalties;
DROP TABLES IF EXISTS Products,Customers,Orders,Order_details;
DROP TABLES IF EXISTS Sailors,Boats,Reserves;

CREATE TABLE Authors
  (
  au_id    CHAR(3)     NOT NULL,
  au_fname VARCHAR(15) NOT NULL,
  au_lname VARCHAR(15) NOT NULL,
  phone    VARCHAR(12)         ,
  address  VARCHAR(20)         ,
  city     VARCHAR(15)         ,
  state    CHAR(2)             ,
  zip      CHAR(5)             ,
  CONSTRAINT pk_Authors PRIMARY KEY (au_id)
  );

CREATE TABLE Publishers
  (
  pub_id   CHAR(3)     NOT NULL,
  pub_name VARCHAR(20) NOT NULL,
  city     VARCHAR(15) NOT NULL,
  state    CHAR(2)             ,
  country  VARCHAR(15) NOT NULL,
  CONSTRAINT pk_Publishers PRIMARY KEY (pub_id)
  );

CREATE TABLE Titles
  (
  title_id   CHAR(3)      NOT NULL,
  title_name VARCHAR(40)  NOT NULL,
  type       VARCHAR(10)          ,
  pub_id     CHAR(3)      NOT NULL,
  pages      INTEGER              ,
  price      DECIMAL(5,2)         ,
  sales      INTEGER              ,
  pubdate    DATE                 ,
  contract   SMALLINT     NOT NULL,
  CONSTRAINT pk_Titles PRIMARY KEY (title_id)
  );

CREATE TABLE Title_Authors
  (
  title_id      CHAR(3)      NOT NULL,
  au_id         CHAR(3)      NOT NULL,
  au_order      SMALLINT     NOT NULL,
  royalty_share DECIMAL(5,2) NOT NULL,
  CONSTRAINT pk_Title_Authors PRIMARY KEY (title_id, au_id)
  );

CREATE TABLE Royalties
  (
  title_id     CHAR(3)      NOT NULL,
  advance      DECIMAL(9,2)         ,
  royalty_rate DECIMAL(5,2)         ,
  CONSTRAINT pk_Royalties PRIMARY KEY (title_id)
  );

INSERT INTO Authors VALUES('A01','Sarah','Buchman','718-496-7223',
  '75 West 205 St','Bronx','NY','10468');
INSERT INTO Authors VALUES('A02','Wendy','Heydemark','303-986-7020',
  '2922 Baseline Rd','Boulder','CO','80303');
INSERT INTO Authors VALUES('A03','Hallie','Hull','415-549-4278',
  '3800 Waldo Ave, #14F','San Francisco','CA','94123');
INSERT INTO Authors VALUES('A04','Klee','Hull','415-549-4278',
  '3800 Waldo Ave, #14F','San Francisco','CA','94123');
INSERT INTO Authors VALUES('A05','Christian','Kells','212-771-4680',
  '114 Horatio St','New York','NY','10014');
INSERT INTO Authors VALUES('A06','','Kellsey','650-836-7128',
  '390 Serra Mall','Palo Alto','CA','94305');
INSERT INTO Authors VALUES('A07','Paddy','O''Furniture','941-925-0752',
  '1442 Main St','Sarasota','FL','34236');

INSERT INTO Publishers VALUES('P01','Abatis Publishers','New York','NY','USA');
INSERT INTO Publishers VALUES('P02','Core Dump Books','San Francisco','CA','USA');
INSERT INTO Publishers VALUES('P03','Schadenfreude Press','Hamburg',NULL,'Germany');
INSERT INTO Publishers VALUES('P04','Tenterhooks Press','Berkeley','CA','USA');
INSERT INTO Publishers VALUES('P05','PTR Press','Los Angeles','CA','USA');



INSERT INTO Titles VALUES('T01','1977!','history','P01',
  107,21.99,566,'2000-08-01',1);
INSERT INTO Titles VALUES('T02','200 Years of German Humor','history','P03',
  14,19.95,9566,'1998-04-01',1);
INSERT INTO Titles VALUES('T03','Ask Your System Administrator','computer','P02',
  1226,39.95,25667,'2000-09-01',1);
INSERT INTO Titles VALUES('T04','But I Did It Unconsciously','psychology','P04',
  510,12.99,13001,'1999-05-31',1);
INSERT INTO Titles VALUES('T05','Exchange of Platitudes','psychology','P04',
  201,6.95,201440,'2001-01-01',1);
INSERT INTO Titles VALUES('T06','How About Never?','biography','P01',
  473,19.95,11320,'2000-07-31',1);
INSERT INTO Titles VALUES('T07','I Blame My Mother','biography','P03',
  333,23.95,1500200,'1999-10-01',1);
INSERT INTO Titles VALUES('T08','Just Wait Until After School','children','P04',
  86,10.00,4095,'2001-06-01',1);
INSERT INTO Titles VALUES('T09','Kiss My Boo-Boo','children','P04',
  22,13.95,5000,'2002-05-31',1);
INSERT INTO Titles VALUES('T10','Not Without My Faberge Egg','biography','P01',
  NULL,NULL,NULL,NULL,0);
INSERT INTO Titles VALUES('T11','Perhaps It''s a Glandular Problem','psychology','P04',
  826,7.99,94123,'2000-11-30',1);
INSERT INTO Titles VALUES('T12','Spontaneous, Not Annoying','biography','P01',
  507,12.99,100001,'2000-08-31',1);
INSERT INTO Titles VALUES('T13','What Are The Civilian Applications?','history','P03',
  802,29.99,10467,'1999-05-31',1);

INSERT INTO Title_Authors VALUES('T01','A01',1,1.0);
INSERT INTO Title_Authors VALUES('T02','A01',1,1.0);
INSERT INTO Title_Authors VALUES('T03','A05',1,1.0);
INSERT INTO Title_Authors VALUES('T04','A03',1,0.6);
INSERT INTO Title_Authors VALUES('T04','A04',2,0.4);
INSERT INTO Title_Authors VALUES('T05','A04',1,1.0);
INSERT INTO Title_Authors VALUES('T06','A02',1,1.0);
INSERT INTO Title_Authors VALUES('T07','A02',1,0.5);
INSERT INTO Title_Authors VALUES('T07','A04',2,0.5);
INSERT INTO Title_Authors VALUES('T08','A06',1,1.0);
INSERT INTO Title_Authors VALUES('T09','A06',1,1.0);
INSERT INTO Title_Authors VALUES('T10','A02',1,1.0);
INSERT INTO Title_Authors VALUES('T11','A03',2,0.3);
INSERT INTO Title_Authors VALUES('T11','A04',3,0.3);
INSERT INTO Title_Authors VALUES('T11','A06',1,0.4);
INSERT INTO Title_Authors VALUES('T12','A02',1,1.0);
INSERT INTO Title_Authors VALUES('T13','A01',1,1.0);

INSERT INTO Royalties VALUES('T01',10000,0.05);
INSERT INTO Royalties VALUES('T02',1000,0.06);
INSERT INTO Royalties VALUES('T03',15000,0.07);
INSERT INTO Royalties VALUES('T04',20000,0.08);
INSERT INTO Royalties VALUES('T05',100000,0.09);
INSERT INTO Royalties VALUES('T06',20000,0.08);
INSERT INTO Royalties VALUES('T07',1000000,0.11);
INSERT INTO Royalties VALUES('T08',0,0.04);
INSERT INTO Royalties VALUES('T09',0,0.05);
INSERT INTO Royalties VALUES('T10',NULL,NULL);
INSERT INTO Royalties VALUES('T11',100000,0.07);
INSERT INTO Royalties VALUES('T12',50000,0.09);
INSERT INTO Royalties VALUES('T13',20000,0.06);

show tables;

Please use the books database pasted under question 4 to design the following SQL queries. Use any method such as subqueries, equi-join/inner-join, outer join, EXISTS

1. List the title_name and book type of the books that are published earlier than the earliest biography book

2. List the title_name and book type of the books published by 'Abatis Publishers'

3. Find the name(s) of the publisher(s) that have not published any book

4. Find the name(s) of the publisher(s) who have published the computer book.

DROP TABLES IF EXISTS Artists,Genre, Members, Titles, Tracks,SalesPeople,Studios,XrefArtistsMembers;
DROP TABLES IF EXISTS Authors,Publishers,Titles,Title_Authors,Royalties;
DROP TABLES IF EXISTS Products,Customers,Orders,Order_details;
DROP TABLES IF EXISTS Sailors,Boats,Reserves;

CREATE TABLE Authors
  (
  au_id    CHAR(3)     NOT NULL,
  au_fname VARCHAR(15) NOT NULL,
  au_lname VARCHAR(15) NOT NULL,
  phone    VARCHAR(12)         ,
  address  VARCHAR(20)         ,
  city     VARCHAR(15)         ,
  state    CHAR(2)             ,
  zip      CHAR(5)             ,
  CONSTRAINT pk_Authors PRIMARY KEY (au_id)
  );

CREATE TABLE Publishers
  (
  pub_id   CHAR(3)     NOT NULL,
  pub_name VARCHAR(20) NOT NULL,
  city     VARCHAR(15) NOT NULL,
  state    CHAR(2)             ,
  country  VARCHAR(15) NOT NULL,
  CONSTRAINT pk_Publishers PRIMARY KEY (pub_id)
  );

CREATE TABLE Titles
  (
  title_id   CHAR(3)      NOT NULL,
  title_name VARCHAR(40)  NOT NULL,
  type       VARCHAR(10)          ,
  pub_id     CHAR(3)      NOT NULL,
  pages      INTEGER              ,
  price      DECIMAL(5,2)         ,
  sales      INTEGER              ,
  pubdate    DATE                 ,
  contract   SMALLINT     NOT NULL,
  CONSTRAINT pk_Titles PRIMARY KEY (title_id)
  );

CREATE TABLE Title_Authors
  (
  title_id      CHAR(3)      NOT NULL,
  au_id         CHAR(3)      NOT NULL,
  au_order      SMALLINT     NOT NULL,
  royalty_share DECIMAL(5,2) NOT NULL,
  CONSTRAINT pk_Title_Authors PRIMARY KEY (title_id, au_id)
  );

CREATE TABLE Royalties
  (
  title_id     CHAR(3)      NOT NULL,
  advance      DECIMAL(9,2)         ,
  royalty_rate DECIMAL(5,2)         ,
  CONSTRAINT pk_Royalties PRIMARY KEY (title_id)
  );

INSERT INTO Authors VALUES('A01','Sarah','Buchman','718-496-7223',
  '75 West 205 St','Bronx','NY','10468');
INSERT INTO Authors VALUES('A02','Wendy','Heydemark','303-986-7020',
  '2922 Baseline Rd','Boulder','CO','80303');
INSERT INTO Authors VALUES('A03','Hallie','Hull','415-549-4278',
  '3800 Waldo Ave, #14F','San Francisco','CA','94123');
INSERT INTO Authors VALUES('A04','Klee','Hull','415-549-4278',
  '3800 Waldo Ave, #14F','San Francisco','CA','94123');
INSERT INTO Authors VALUES('A05','Christian','Kells','212-771-4680',
  '114 Horatio St','New York','NY','10014');
INSERT INTO Authors VALUES('A06','','Kellsey','650-836-7128',
  '390 Serra Mall','Palo Alto','CA','94305');
INSERT INTO Authors VALUES('A07','Paddy','O''Furniture','941-925-0752',
  '1442 Main St','Sarasota','FL','34236');

INSERT INTO Publishers VALUES('P01','Abatis Publishers','New York','NY','USA');
INSERT INTO Publishers VALUES('P02','Core Dump Books','San Francisco','CA','USA');
INSERT INTO Publishers VALUES('P03','Schadenfreude Press','Hamburg',NULL,'Germany');
INSERT INTO Publishers VALUES('P04','Tenterhooks Press','Berkeley','CA','USA');
INSERT INTO Publishers VALUES('P05','PTR Press','Los Angeles','CA','USA');



INSERT INTO Titles VALUES('T01','1977!','history','P01',
  107,21.99,566,'2000-08-01',1);
INSERT INTO Titles VALUES('T02','200 Years of German Humor','history','P03',
  14,19.95,9566,'1998-04-01',1);
INSERT INTO Titles VALUES('T03','Ask Your System Administrator','computer','P02',
  1226,39.95,25667,'2000-09-01',1);
INSERT INTO Titles VALUES('T04','But I Did It Unconsciously','psychology','P04',
  510,12.99,13001,'1999-05-31',1);
INSERT INTO Titles VALUES('T05','Exchange of Platitudes','psychology','P04',
  201,6.95,201440,'2001-01-01',1);
INSERT INTO Titles VALUES('T06','How About Never?','biography','P01',
  473,19.95,11320,'2000-07-31',1);
INSERT INTO Titles VALUES('T07','I Blame My Mother','biography','P03',
  333,23.95,1500200,'1999-10-01',1);
INSERT INTO Titles VALUES('T08','Just Wait Until After School','children','P04',
  86,10.00,4095,'2001-06-01',1);
INSERT INTO Titles VALUES('T09','Kiss My Boo-Boo','children','P04',
  22,13.95,5000,'2002-05-31',1);
INSERT INTO Titles VALUES('T10','Not Without My Faberge Egg','biography','P01',
  NULL,NULL,NULL,NULL,0);
INSERT INTO Titles VALUES('T11','Perhaps It''s a Glandular Problem','psychology','P04',
  826,7.99,94123,'2000-11-30',1);
INSERT INTO Titles VALUES('T12','Spontaneous, Not Annoying','biography','P01',
  507,12.99,100001,'2000-08-31',1);
INSERT INTO Titles VALUES('T13','What Are The Civilian Applications?','history','P03',
  802,29.99,10467,'1999-05-31',1);

INSERT INTO Title_Authors VALUES('T01','A01',1,1.0);
INSERT INTO Title_Authors VALUES('T02','A01',1,1.0);
INSERT INTO Title_Authors VALUES('T03','A05',1,1.0);
INSERT INTO Title_Authors VALUES('T04','A03',1,0.6);
INSERT INTO Title_Authors VALUES('T04','A04',2,0.4);
INSERT INTO Title_Authors VALUES('T05','A04',1,1.0);
INSERT INTO Title_Authors VALUES('T06','A02',1,1.0);
INSERT INTO Title_Authors VALUES('T07','A02',1,0.5);
INSERT INTO Title_Authors VALUES('T07','A04',2,0.5);
INSERT INTO Title_Authors VALUES('T08','A06',1,1.0);
INSERT INTO Title_Authors VALUES('T09','A06',1,1.0);
INSERT INTO Title_Authors VALUES('T10','A02',1,1.0);
INSERT INTO Title_Authors VALUES('T11','A03',2,0.3);
INSERT INTO Title_Authors VALUES('T11','A04',3,0.3);
INSERT INTO Title_Authors VALUES('T11','A06',1,0.4);
INSERT INTO Title_Authors VALUES('T12','A02',1,1.0);
INSERT INTO Title_Authors VALUES('T13','A01',1,1.0);

INSERT INTO Royalties VALUES('T01',10000,0.05);
INSERT INTO Royalties VALUES('T02',1000,0.06);
INSERT INTO Royalties VALUES('T03',15000,0.07);
INSERT INTO Royalties VALUES('T04',20000,0.08);
INSERT INTO Royalties VALUES('T05',100000,0.09);
INSERT INTO Royalties VALUES('T06',20000,0.08);
INSERT INTO Royalties VALUES('T07',1000000,0.11);
INSERT INTO Royalties VALUES('T08',0,0.04);
INSERT INTO Royalties VALUES('T09',0,0.05);
INSERT INTO Royalties VALUES('T10',NULL,NULL);
INSERT INTO Royalties VALUES('T11',100000,0.07);
INSERT INTO Royalties VALUES('T12',50000,0.09);
INSERT INTO Royalties VALUES('T13',20000,0.06);

show tables;