When the blood glucose concentration is low, the pancreas secretes glucagon to signal the liver to produce glucose and glucose-1-phosphate. Which metabolic steps are involved in this biosignaling pathway? I. Inactivation of glycogen synthase via phosphorylation by protein kinase A II. Activation of glycogen synthase via phosphorylation by protein kinase A III. Activation of phosphofructokinase-2 via phosphorylation by protein kinase A IV. Activation of fructose-2,6-bisphosphatase via phosphorylation by protein kinase A V. Activation of phosphofructokinase-1 by fructose-2,6-bisphosphate VI. Inhibition of fructose-1,6-bisphosphatase by fructose-2,6-bisphosphate VII. Inactivation of pyruvate kinase via phosphorylation by protein kinase A A. I, IV, and VII. B. II C. I and IV. D. I, III, V, VI, and VII.

Which biochemical steps are involved in the glucagon-triggered activation of gluconeogenesis? I. Activation of fructose-2,6-bisphosphatase via phosphorylation by protein kinase A II. Inactivation of fructose-2,6-bisphosphatase via phosphorylation by protein kinase A III. Activation of phospholipase C IV. Inactivation of phospholipase C V. Release of calcium VI. Sequestration of calcium VII. Phosphorylation of FoxO1 VIII. Dephosphorylation of FoxO1 IX. Increased expression of PEP carboxykinase X. Phosphorylation of PEP carboxykinase XI. Formation of additional PEP, which is a glycolytic intermediate XII. Degradation of PEP, which is a glycolytic intermediate A. I, III, V, VII, X, and XI. B. II, III, V, VII, IX, and XI. C. I, III, VI, VII, IX, and XII. D. I, III, V, VII, IX, and XI.

When the blood glucose concentration is high, the level of cAMP in the liver decreases and glycolytic flux increases. Which biochemical steps occur under this condition? I. Protein kinase A is activated. II. Protein kinase A is not activated. III. Phosphofructokinase-2 is activated via phosphorylation by protein kinase A. IV. Phosphofructokinase-2 is activated due to the lack of phosphorylation by protein kinase A. V. Fructose-2,6-bisphosphatase is activated via phosphorylation by protein kinase A. VI. Fructose-2,6-bisphosphatase is activated due to the lack of phosphorylation by protein kinase A. VII. Phosphofructokinase-1 is activated by fructose-2,6-bisphosphate. VIII. Phosphofructokinase-1 is inhibited by fructose-2,6-bisphosphate. IX. Fructose-1,6-bisphosphatase is activated by fructose-2,6-bisphosphate. X. Fructose-1,6-bisphosphatase is inhibited by fructose-2,6-bisphosphate. A. II, IV, VIII, and IX. B. II, IV, VII, and X. C. I, III, VII, and X. D. II and V.

After glucagon stimulates glucose production via glycogenolysis and/or gluconeogenesis in a liver cell, which steps are required to transport glucose to other cells in the body? A. Glucose is transported to other cells by the carrier protein GLUT-1. B. Glucose-6-phosphate is converted to glucose by GLUT-1. C. Glucose cannot leave the liver cell. D. Glucose exits the liver cell via GLUT-1 and enters the bloodstream.

In certain smooth muscles, glucagon increases the amount of glucose available for glycolysis; under this condition, which enzyme is required to convert glucose-1-phosphate into a glycolytic intermediate? A. No enzyme is needed for this conversion. B. G6Pase. C. Glucokinase (or hexokinase). D. Phosphoglucomutase.

MOLECULAR MASS BY FREEZING POINT DEPRESSION

SHOW YOUR WORK PLEASE!

Procedures:

Experiment 1: Measure the Freezing Point of Pure Water

Take a clean test tube from the Containers shelf and place it on the workbench.

Take a balance from the Instruments shelf and place it on the workbench.

Place the test tube on the balance. Zero the balance.

Take water from the Materials shelf and add 10 mL to the test tube.
NOTE: In a classroom laboratory, you would remove the container from the balance before you add any chemicals or solutions. Filling the container separately prevents any spills, sprays, or splashes that might affect your measurements when they land on the balance. Luckily virtual labs are spill-, spray-, and splash-free, so you can skip that step to save time.

Record the mass of the water in your Lab Notes.

Take a thermometer from the Instruments shelf and attach it to the test tube.

Take a constant temperature bath and place it on the workbench. Run the bath at -15 °C.

Move the test tube into the constant temperature bath. Make sure the test tube is submerged in water.

Watch the temperature of the water in the test tube decrease. The water should begin to freeze. You will see some solid ice form in the test tube. You may want to use the + or – zoom buttons in the lower right of the screen for a closer view.

Record the first temperature when ice just begins to appear as the freezing point of the solvent in your Lab Notes.

Clear your station by dragging the test tube and thermometer to the recycling bin beneath the workbench.

Experiment 2: Measure the Freezing Point of a Solution of an Unknown Substance

Take a clean test tube from the Containers shelf and place it onto the workbench.

Move the test tube onto the balance. Zero the balance.

Take a thermometer from the Instruments shelf and attach it to the test tube.

Take FP sample 1 from the Materials shelf and add 2 g to the test tube. Record the mass of sample added in your Lab Notes.

Take water and add 10 mL to the test tube. Record the total mass of water and sample in your Lab Notes.

Move the test tube into the constant temperature bath. Make sure it is still set to -15 °C.

Record the freezing point of the solution as the first temperature when ice just begins to appear in your Lab Notes.

Clear your station by dragging the test tube to the recycling bin.

Repeat steps 1 – 7 but using unknown FP Sample 2.

Clear your station by dragging any containers and instruments to the recycling bin. Remember to press Save Notes.

NOTES:

Experiment 1

1. Mass of water was 10 g

2. 16, 11.3, 7.3, 3.9, 1.0, 0.0 degrees celsius is where it froze

Experiment 2

1. 2 g of sample fp 1 added

2. 12 g after water added to sample

3. -2.2 degrees when ice first appeared.

4. 2 g of sample fp 2 added

5. 12 g after water added to sample

6. -3.6 degrees when ice first appeared.

QUESTIONS

1. Experiment 1: Measure the Freezing Point of Pure Water
How many mL of water did you add to the test tube?

A. 10

B. 35 mL

C. 20 mL

d. 50 mL

2. Experiment 1: Measure the Freezing Point of Pure Water

At what temperature did the water in the test tube begin to turn into ice?

a. -2.0 degrees celsius

b. -15.0 degrees C

c. 10.0 degrees C

d. 0.0 degrees C

3. Experiment 1: Measure the Freezing Point of Pure Water

What does the freezing point measured for water tell you about the water's purity?

a. the water is not pure because the freezing point is lower than expected

b. the water is not pure because the freezing point is higher than expected

c. the water is not pure but the thermostat is not very accurate

d. the water is pure because the freezing point is exactly as expected

4. Experiment 2: Measure the Freezing Point of a Solution of an Unknown Substance

How many grams of FP sample #1 did you add to the test tube?

a. 12 g

b. 10 g

c. 8 g

d. 2 g

5. Experiment 2: Measure the Freezing Point of a Solution of an Unknown Substance

At what temperature did the water with FP sample #1 begin to freeze? Choose the closest answer.

a. 10 C

b. -2.1 C

c. 0.0 C

d. -5.0 C

6. Experiment 2: Measure the Freezing Point of a Solution of an Unknown Substance

What is the molality of FP sample #1? Choose the closest answer.

a. 0.56 mol/kg

b. 5.34 mol/kg

c. 1.13 mol/kg

d. 0.972 mol/kg

7. Experiment 2: Measure the Freezing Point of a Solution of an Unknown Substance
What is the molality of FP sample #2? Choose the closest answer.

a. 0.967 mol/kg

b. 9.67 mol/kg

c. 2.78 mol/kg

d. 1.94 mol/kg

8. What was the purpose of measuring the freezing point of water?

to assess the volume of water necessary to form ice which would be used for the solution of unknowns

b. to verify the accuracy of the apparatus and to determine the freezing point of the pure solvent

c. to determine the heat of the fusion of water which would be used in calculating the molar masses of the unknowns

d. to calculate the density of water versus ice

9. Suppose that the test tube you used for the experiment was not fully dry and there were some water droplets in the test tube. What effect would this have on the calculated molar mass of the unknown?

a. the calculated molar mass would be unaffected by the additional water

b. the calculated molar mass does not depend on the amount of solvent

c. the calculated molar mass would be much smaller than the true molar mass

d. the calculated molar mass would be larger than the true molar mass.

10. Suppose you added 4.000 g of FP sample #1 instead of 2.000 g, what would happen to the freezing point temperature of the water?

a. there is not enough info to calculate the freezing point depression

b. the freezing point would be depressed twice as much

c. the freezing point would be depressed half as much

d. the freezing poing would be increased twice as much

11. What is meant by "freezing point depression"?

a. when a solute and solvent are mixed together, the specific heat of the solution is depressed.

b. when a solute is added to a solvent, the freezing point of the solvent is lowered

c. when a solute is added to a solvent, the freezing point of the solvent is increased

d. the solubility of a solute changes as the solvent is frozen.

12. What is the first experimental step in calculating the molar mass by using the freezing point depression method?

a. you must first determine the molar mass of the solute by looking up the elements in the periodic table

b. you must first measure the heat of fusion of the solvent

c. you must first calculate the number of moles in a kilogram of solvent to determine its molality

d. you must first measure the freezing point of the pure solvent and then measure the freezing point of the solution

13. What is the molality of a solution?

a. the numver of moles of solute in a liter of solvent

b. the number of moles of solvent in a kilogram of solute

c. the number of grams of solute in a liter of solvent

d. the number of moles of solute in a kilogram of solvent

14.

Suppose you performed a similar experiment using benzene as your solvent. Given the data in the table below, what would be the temperature at which the benzene solution would begin to freeze? Choose the closest answer.

K_f of benzne 5.12 C/m

freezing point of pure benzene 5.48 C

molality of solution 0.724 mol/kg

i 1

a. 1.77 C

b. 3.71 C

c. 5.48 C

d. 9.19 C

15.

Which of the compounds in the table below is most likely to be your unknown FP sample 1?

Name of compound: Molar mass (g/mol)

Calcium sulfate 136.14

glucose 180.16

potassium hydrogen phthalate 204.22

sodium oxalate 134.00

a. glucose

b. calcium sulfate

c. sodium oxalate

d. potassium hydrogen phthalate

16. Suppose you dissolve 154.286 g of sodium chloride in 2.00 L of water. What is the molality of the solution given that the molar mass of sodium chloride is 58.44 g/mol and the density of water is 1.000 g/mL?

a. 2.64 mol/kg

b. 1.32 mol/kg

c. 771.1 mol/kg

d. 5.84 mol/kg

The purpose of this assignment is to identify and apply OSCM concepts/tools to solve problems in managing operations and supply chains. Students are expected to find an interesting OSCM problem from the real business world, think about how you can apply the OSCM concepts/tools that you learn in this course to solve the problem, and write up a report based on your analysis. More specifically, each student should: • Find a problem in managing operations and supply chains from the real business world (from work or from any business articles/cases) • Identify specific OSCM concepts/tools that can be applied to the problem • Apply an appropriate OSCM concept/tool or a set of appropriate OSCM concepts/tools to propose a solution to the problem • Analyze the expected results that may be obtained when the solution is implemented. The report should be 8-10 pages in length including the cover and appendices, with 1” margins on all sides, double-spacing, and 12 point font. The cover of the report should include title, class code and name, section number, student name, and date of completion.

1. Abstract (150 words maximum) - Summarize the entire report, including problem statement, OSCM concepts/tools that have been applied to the problem, and expected results of the proposed solution.

2. Background information - Clearly state whether the problem is from work or from business articles/cases. If it is from business articles/cases, provide its source (title, author, name of the journal, date published). Briefly introduce the company background (e.g., name, products, business size, location, internal/external interesting facts, and etc.).

3. Problem Description - Describe the problem clearly and specifically. - You should focus on a single problem, although you can introduce several other issues for informational purposes. - This section must include a problem statement starting with, e.g., “This paper considers the problem of determining …”, “The main problem of the firm is how to ...”, and etc., either in the beginning or at the end of the section.

4. OSCM concepts/tools that can be applied - Describe what specific OSCM concepts/tools can be applied to the problem and why they are appropriate to the problem. This section should make it clear that you understand the concepts/tools you are about to use.

5. Application of OSCM concepts/tools - Choose an OSCM concept/tool or a set of OSCM concepts/tools among the ones provided in section 4 and apply it to propose a solution to the problem. - This section should include your work/calculations in detail to show how you have applied the OSCM concept/tool(s) to develop the solution.

6. Analysis of expected results - Analyze the expected results of the proposed solution. - The expected results may include cost/revenue impact and/or improvement of supply chain performance. You must be specific to receive full credit. - Discuss the pros and cons of the suggested solution.

7. Conclusion The meaning of an OSCM problem will become clearer as you study this course (see the textbook contents). An OSCM problem may involve process design and improvement, supply chain management, capacity planning, inventory management, quality management, project management, production planning and control, forecasting, facility location and layout, supplier management, etc. You are encouraged to find a problem from work if you have relevant work experience, so that you may apply the concepts/tools learned from this course at work. However, if you want to find a problem from business articles/cases, you can find one from any journals/newspapers such as The Wall Street Journal, Business Week, Forbes, Harvard Business Review, and so on. Or you can surf the Internet to find an interesting article/case.

The purpose of this assignment is to identify and apply OSCM concepts/tools to solve problems in managing operations and supply chains. Students are expected to find an interesting OSCM problem from the real business world, think about how you can apply the OSCM concepts/tools that you learn in this course to solve the problem, and write up a report based on your analysis. More specifically, each student should: • Find a problem in managing operations and supply chains from the real business world (from work or from any business articles/cases) • Identify specific OSCM concepts/tools that can be applied to the problem • Apply an appropriate OSCM concept/tool or a set of appropriate OSCM concepts/tools to propose a solution to the problem • Analyze the expected results that may be obtained when the solution is implemented. The report should be 8-10 pages in length including the cover and appendices, with 1” margins on all sides, double-spacing, and 12 point font. The cover of the report should include title, class code and name, section number, student name, and date of completion.

1. Abstract (150 words maximum) - Summarize the entire report, including problem statement, OSCM concepts/tools that have been applied to the problem, and expected results of the proposed solution.

2. Background information - Clearly state whether the problem is from work or from business articles/cases. If it is from business articles/cases, provide its source (title, author, name of the journal, date published). Briefly introduce the company background (e.g., name, products, business size, location, internal/external interesting facts, and etc.).

3. Problem Description - Describe the problem clearly and specifically. - You should focus on a single problem, although you can introduce several other issues for informational purposes. - This section must include a problem statement starting with, e.g., “This paper considers the problem of determining …”, “The main problem of the firm is how to ...”, and etc., either in the beginning or at the end of the section.

4. OSCM concepts/tools that can be applied - Describe what specific OSCM concepts/tools can be applied to the problem and why they are appropriate to the problem. This section should make it clear that you understand the concepts/tools you are about to use.

5. Application of OSCM concepts/tools - Choose an OSCM concept/tool or a set of OSCM concepts/tools among the ones provided in section 4 and apply it to propose a solution to the problem. - This section should include your work/calculations in detail to show how you have applied the OSCM concept/tool(s) to develop the solution.

6. Analysis of expected results - Analyze the expected results of the proposed solution. - The expected results may include cost/revenue impact and/or improvement of supply chain performance. You must be specific to receive full credit. - Discuss the pros and cons of the suggested solution.

7. Conclusion The meaning of an OSCM problem will become clearer as you study this course (see the textbook contents). An OSCM problem may involve process design and improvement, supply chain management, capacity planning, inventory management, quality management, project management, production planning and control, forecasting, facility location and layout, supplier management, etc. You are encouraged to find a problem from work if you have relevant work experience, so that you may apply the concepts/tools learned from this course at work. However, if you want to find a problem from business articles/cases, you can find one from any journals/newspapers such as The Wall Street Journal, Business Week, Forbes, Harvard Business Review, and so on. Or you can surf the Internet to find an interesting

1. Using the class Date that you defined in Exercise O3, write the definition of the class named Employee with the following private instance variables:

• first name               -           class string
• last name                -           class string
• ID number             -           integer (the default ID number is 999999)
• birth day                -           class Date
• date hired               -           class Date
• base pay                 -           double precision (the default base pay is $0.00)

The default constructor initializes the first name to “john”, the last name to “Doe”, and the birth day and hired day to the default date (1/1/1960).

In addition to the constructors, the class has the following public instance methods:

• void readPInfo(Scanner scan ) that uses the Scanner object parameter to read the values for the instance variables first name, last name, ID number, birth day, and date of hire.
• void readPayInfo(Scanner scan ) that uses the Scanner object parameter to read the value for the base pay instance variable.
• String getPInfoString( ) that returns a string in the following format:

                  NAME: <lastName + “, “ +   firstName>

                  ID NUMBER: <Id-Number>

                BIRTH DAY: <string-birth-day>

DATE HIRED: < string-date-hired >

• void setBpay( double newBpay ) that sets the value of the base pay to the new value, newBpay.
• double getBpay( ) that returns the value of the base pay instance variable.
• double getGpay( ) that returns the value of the gross pay (which is the base pay).
• double computeTax(   ) that computes the tax deduction on the gross pay and returns it as follows:

If gross pay is greater than or equal to 1000, 20% of the gross pay;

If 800 <= gross pay < 1000, 18% of gross pay

If 600 <= gross pay < 800, 15% of gross pay

Otherwise, 10 % of the gross pay.

• String getPayInfoString( ) that returns a string in the following format:

                  GROSS PAY: <gross-pay>

                  TAX DEDUCTION: <tax-deduction>

                NET PAY: <Net-pay>

1. Define another class named ExerciseO4 that contains the method main that does the following:

1. Define an object and instantiate it with the default constructor, then output its personal information (by calling the instance methods getPInfoString( ).
2. Define an object and initialize its instance variables as follows:

John   Doe   111111   10/25/1990   11/15/2010 750.00

And then output its personal and pay information (by calling the instance methods getPInfoString( ) and getPayInfoString( )).

3. Define an object, read its personal and pay information (by calling the methods readPInfo(Scanner scan ) and readPayInfo(Scanner scan )) , and then output its personal and pay information (by calling the instance methods getPInfoString( ) and getPayInfoString( )).

1. Define an object and instantiate it (or read the values for its instance variables) with an invalid date (date of birth or date of hire).

excercise 03 is the code written below

import java.util.Scanner;

class Date {

   private int month; // to hold the month (1 – 12)

   private int day; // to hold the day (1 – 31)

   private int year; // to hold the year 1960 - 2019

   static final String[] monthList = { " ", "January", "February", "March", "April", "May", "June", "July", "August",

           "September", "October", "November", "December" };

   public Date() // default constructor

   {

       month = 1;

       day = 1;

       year = 1960;

   }

   public Date(int newMonth, int newDay, int newYear) // constructor

   {

       month = newMonth;

       day = newDay;

       year = newYear;

       checkDate();

   }

   public void inputDate(Scanner scan) // use the Scanner object to read the month and the day

   {

       month = scan.nextInt(); // read the month

       day = scan.nextInt(); // read the day

       year = scan.nextInt(); // read the year

       checkDate();

   }

   private void checkDate() // to validate the month and the day

   {

       final int[] daysPerMonth = { 0, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };

       if ((month < 1) || (month > 12) || (day < 1) || (day > daysPerMonth[month]) || year < 1960 || year > 2016) {

           System.out.println("Invalid date");

           System.exit(0);

       }

   }

   String getStringDate() // returns the string consisting of the month followed by the day

   {

       return (monthList[month] + " " + day+" "+year);

   }

   public int getMonth() // to return the month

   {

       return (month);

   }

   public int getDay() // to return the day

   {

       return (day);

   }

   public int getYear() // to return year

   {

       return (year);

   }

   public boolean equalTo(Date obj) {

       return (month == obj.month && day == obj.day && year == obj.year);

   }

   //which Date object is greater

   public static boolean isGreaterThan(Date obj1, Date obj2) {

       if(obj1.year > obj2.year)

           return true;

       else if(obj1.year == obj2.year) {

           if(obj1.month > obj2.month)

               return true;

           else if(obj1.month == obj2.month) {

               if(obj1.day > obj2.day)

                   return true;

           }

       }

     

       return false;

   }

}

public class Test {//driver class

   /*------- Program is executed with a month and a day as command line arguments -----*/

   public static void main(String[] args) {

       Date defaultDate = new Date(); // to hold today’s month and day

       System.out.println(defaultDate.getStringDate());

     

       /*------------------------------------ read today’s month and day ---------------------*/

       Date today = new Date(3, 25, 2016); // set Today's date

       System.out.println("Todays day is:\t"+today.getStringDate());

     

       /*------------------------------------ read dueDate month and day ---------------------*/

       Date dueDate = new Date();

       Scanner input = new Scanner(System.in);

       System.out.println("Enter today’s month, day and year:");

       dueDate.inputDate(input);

       /*------------------------------------ compare today and dueDate ---------------------*/

       if (today.equalTo(dueDate))

           System.out.println("Your project is on time");

       else {

           if(Date.isGreaterThan(today, dueDate))

             System.out.println("Your project is late");

           else

               System.out.println("Your project is early");

       }

     

       /*------------------------------------ inavlid date ---------------------*/

       Date invalidDate = new Date(25, 4, 2000);

   }

}

Answer the following in Java programming language

Create a Java Program that will import a file of contacts (contacts.txt) into a database (Just their first name and 10-digit phone number). The database should use the following class to represent each entry:
public class contact {
   String firstName;
   String phoneNum;
}

Furthermore, your program should have two classes.
(1) DatabaseDirectory.java:
   This class should declare ArrayList as a private datafield to store objects into the database (theDatabase) with the contacts names and phone numbers
       private List <contacts>theDatabase = new ArrayList(); (example from textbook)

So now you can use this statement:
theDatabase.add(new contact("Mary Smith", "8007894562");

to add a new entry to your database.

   This class should also hold the following methods:
   (1) Display All Contacts
       - as name suggests, should display all entries in database
   (2) Search Contact by Name
- uses String name
       - should return the contact or tell user if the contact does not exist
   (3) Add/Edit Contact
- uses String name and String number
       - ask user if they want to add or edit
       - prompt user for name they want to add or edit
       - prompt user for phone number
       - display all info before asking the user if they want to save
   (4) Remove Contact
- uses String name
       - search name of contact to remove
       - if contact exists, ask user if they are sure they want to delete the contact
       - remove contact

(2) Database.java:
   This is a driver class that will display the main menu with it's selections. This driver class should execute the methods held in the DatabaseDirectory.java class. The database should continue to show the main menu until the user prompts the program to exit.

Your program should closely follow this same output:

Phone Number Database
----------------------------------------------------
Main Menu:
(1) Display All Contacts
(2) Search Contact by Name
(3) Add or Edit Contact
(4) Remove Contact
(5) Exit Database
----------------------------------------------------
Please enter choice: 2
Enter the name of the contact: Jennifer

Name: Jennifer
Phone #: 8001234567
----------------------------------------------------
Main Menu:
(1) Display All Contacts
(2) Search Contact by Name
(3) Add or Edit Contact
(4) Remove Contact
(5) Exit Database
----------------------------------------------------
Please enter choice: 1
----------------------------------------------------
Name           Phone Number
Jennifer       8001234567
Karen           8004567854
Lowell           5206689875
----------------------------------------------------
Main Menu:
(1) Display All Contacts
(2) Search Contact by Name
(3) Add or Edit Contact
(4) Remove Contact
(5) Exit Database
----------------------------------------------------
Please enter choice: 5
Thank you for using this database!

Any extra comments would be greatly beneficial for my understanding of this assignment, thank you in advance.

This assignment is to give you practice using enums, string variables, and string functions. In order to get full credit for the program you must use these three topics.

You are to write a program that will read a series of names of people from a data file that has been created with extra blank spaces and reformat the names into a standardized format.

The datafile is mp6names.txt. It is arranged with the information for one person on each line. The first character on the line will be either ‘M’ or ‘F’ indicating the gender of the person, and the second character will be either ‘M’, ‘S’, or ‘D’ indicating married, single or divorced. You may assume that there will be no bad data here. The remainder of the line is the person’s name in the form:

Last_name, First_name Middle_Initial.

Note that there will always be a comma immediately after the last name and, if the person has middle initial, it will always be followed by a period. However, there could be any number of blank spaces in between each part of the name and some people do not have middle initial.

Your task is to clean up the name and print it out in the standard format, e.g. Mr. Bill T. Jones with the appropriate title and exactly one space between each part of the name.

You are REQUIRED to use functions, enums, string variables and string functions in the solution to this problem. Define an enum for the Marital Status of the person (with the values SINGLE, MARRIED and DIVORCED) and write a function that reads in the character from the file and returns the appropriate enum value.

Read the name from the file into a string variable and write another function that uses the functions of the string class (e.g. find(), substr() etc.) to clean up the name and create a new string variable containing the name in the new format.

Finally, add the appropriate title to the name and print it out. All males will have the title “Mr.” – married females will have “Mrs.” and single or divorced females will have “Ms.”

Continue doing this until the end of file is reached. Your output must include the original name as read from the file followed by the new name in the standardized format.   For formatting purposes you may assume that no name will have more than 30 characters.

This is just a SUGGESTED method and for each step you may want to include output for debugging purposes to insure that your program is working correctly. Feel free to design your own modules as you like. A sample output from the first few lines of the data file follows:

Original name                  Standardized name

Bach,   Johann    S.         Mr. Johann S. Bach
Curie,     Marie A.            Mrs. Marie A. Curie
Parker, Alice   M.             Ms. Alice M. Parker

1) Name the tissues layers and tissues types that are found in the mucosal layer of the trachea

2) Name types of tissues that are found in the submucosal layer of the trachea.

3) name types of tissues that are found in the fibrocartilaginous layer of the trachea.

4) discuss the role of goblet cells and cilia in filtering inhaled air.

Create a view named ReservationCustomer_VW. It consists of the reservation ID, trip ID, trip name, trip date, customer number, customer last name, customer first name, and phone number for trips whose guide is Glory Unser or Susan Kiley. Show the SQL Server code for this view.