Topic 1

1. What topic are you considering for your critical annotated bibliography? In other words, on what general area of interest are you going to locate 12 scholarly articles?

2. Find one article for your annotated bibliography using the tips mentioned in the video tutorial.  Then list the source in APA format and write your summary/critique of 150-200 words.

Topic 2

1. Now that you’ve perused various articles on a topic using OneSearch, has your topic changed or become more focused in any way?  If so, please describe how it has changed.  If not, please tell us what your topic is again.

2. Find another article for your annotated bibliography, this time using subject terms, as Library Tutorial #2 describes.  List the subject terms you used.

3. List the source in APA format and write your summary/critique of 150-200 words.

Topic 3

1. Select two different additional databases on the right-hand side of the OneSearch interface, as the video tutorial describes.  What additional databases did you choose?  Why did you choose these particular databases?

2. Did you find any additional potential articles for your research?  If so, please post the name of one of these articles and why you feel it’s useful to you.  If not, please describe the types of articles you found through this new method and why you felt that they didn’t have the potential to add to your research.

Airlines offer a variety of products ranging from the no-frills air transportation to international first class featuring amenity-filled cubicles with fully reclining seat/beds and attentive in-flight service. This assignment is intended to illustrate the variety of airline product offerings available and stimulate thinking about how best to serve the diverse wants and needs of passengers.

Europe’s Ryanair is well known for its cheap fares and bare-bones service. Europe’s old line network carriers including British Airways, Air France/KLM and Lufthansa, on the other hand, offer more choices and features within Europe and to major destinations worldwide. In Asia, low-cost-airlines are rapidly expanding in the marketplace. Air Asia and Jetstar are two of the larger LCCs (along with their various subsidiaries). Asia also is home to many full-service airlines such as Japan Airlines, Air China, Cathay Pacific, Singapore, and Korean Air.

In a short research paper, compare and contrast a chosen LCC with a full-service airline using Doganis’ 5 key product features as a framework (price, schedule, comfort, convenience, and image). Choose one or two city-pairs served by both carriers on which to base the comparison. Summarize your findings and emphasize critical differences. Extensive data, such as the ancillary fee structure, may be best presented in a table. Discuss the passenger segment(s) targeted by each airline. Next, compare the airlines’ profit history using a common metric such as margin on total revenue. Conclude with an evaluation of each carrier’s overarching business strategy. Explain your assessment of the most profitable strategy.

Upon reading the paper, a potential passenger should have the information needed to choose between the two airlines on the selected city-pair(s). Note:  Before beginning your research, ensure that the needed data are available from the airlines’ websites and other online sources.

Use APA style including a title page, table(s) or charts as appropriate, citations, reference list, running head, page numbers, and section headings. Of course, an introduction and conclusion are always appropriate. There is no page number requirement, but about six pages, not including title page, reference list, and appendices, should be sufficient.   

Assignment 3: Database Models: Does One Size Fit All?

In this assignment, you will conduct some initial research into the different types of database models and choose two in which to delve deeper. After your research, you would have gained a good understanding of the various database models and for what purpose each is best suited.

Tasks:

Different database models are used for a variety of reasons. Using the Argosy University online library resources, scholarly or professional resources, your course textbook, and the Internet, research and familiarize yourself with the hierarchical database model and the relational database model.

Based on your research, create a 3- to 5-page paper in a Microsoft Word document, which includes:

·         Similarities and differences between the two database models

·         Real-world examples of each type of database model

·         Recommendations for a database model for each of the following applications:

o    A human resources system that will track employee information such as home address, department, position, and salary

o    A criminal identification system that will collect suspect information such as name, height, weight, and gender at one location and then transmit the information to a central repository

o    A manufacturing system that will track inventories of raw materials and finished goods

Write in a clear, concise, and organized manner; demonstrate ethical scholarship in accurate representation and attribution of sources (i.e., APA); and display accurate spelling, grammar, and punctuation.

Submission Details:

·         Save the paper as M1_A3_Lastname_Firstname.doc.

·         By Wednesday, July 6, 2016, submit your paper to the M1 Assignment 3 Dropbox.

Case 9.1: Unprofessional Conduct?

Transcript of Case 9.1 Unprofessional Conduct

Located on page 342 of your textbook

1. Do you believe the Board of Education violated her right to privacy? Were they justified in firing her? Explain two to three (2-3) major reasons why or why not.
2. Was Pettit’s behavior unprofessional or immoral? Do you believe she was unfit to teach? Provide a rationale for your position.
3. If teachers have good performance inside the classroom, should they also be held to a higher moral standard outside the classroom? Explain why or why not. 
4. Analyze five (5) behaviors you believe would show unprofessional or immoral conduct for a teacher.

Assignment 1: LASA 2: Building the Human Resources Database

Description of LASA:

For this assignment, you will build the database that you designed in M3 Assignment 2 LASA 1 and populate it with employee information. Then, you will execute Structured Query Language (SQL) statements against the database in order to insert, update, modify, and display the information contained in the database.

Scenario:

The president of Altair Software has reviewed and approved the database design that you completed in M3 Assignment 2 LASA 1. You will now build, configure, and populate the database. Additionally, since Altair Software is a fast-growing company, there have been several changes in salary and personnel since you designed the database. You will need to write SQL statements to insert, update, and remove records in the database, as well as a statement to display the records and run them against the database to see the results. The changes are as follows:

1.     Both vice presidents easily surpassed their goals and objectives for the prior year and are being given salary raises. The new salary for the vice president position is $80,000.

2.     To attract talented programmers directly out of college, Altair Software has decided to raise the base salary for both Programmer I and Programmer II by $5,000 to $40,000 and $50,000, respectively.

3.     Programmer Arlene Smith was recruited by a competitor but in order to keep her with Altair Software, the company promoted her to the newly created position of Programmer III, with a salary of $60,000.

4.     Altair Software hired two new employees:

a.      

b.     

5.     Sales Representative Eric Smith left Altair Software to return to school to earn a bachelor’s degree.

6.     Programmer I, Bob Smith, moved out of state.

Tasks:

Note: As you complete the steps below, be sure to save your work often.

A.    Create the Database for the Company

1.     Using Microsoft Access 2010, create the tables that you designed inM3 Assignment 2 LASA 1. Be sure to use your third normal formtables. Enter each data field name in each table and save each table as you work.

2.     Open each table in Design View (right-click the table in the navigation pane and click Design View) and set the appropriate field to be thePrimary Key.

3.     While in Design View, ensure that each field is configured for the right type of data (text or number, for instance) and set the field size appropriately.

4.     On the Database Tools tab, in the Relationships group, clickRelationships. Using your entity-relationship diagram as a guide, create the appropriate relationships between the tables by matching the appropriate data fields from each table.

5.     Open each table (double-click the table in the navigation pane) and manually enter the appropriate company data. When you are done, each table should contain the same data that was entered in your spreadsheet from M3 Assignment 2 LASA 1.

B.    Display the Information in the Database

6.     Create an SQL query to display all the information in the database by following the steps below:

a.     On the Create tab, in the Queries group, click Query Design.

b.    Select all the tables in your database by holding the Ctrl key and clicking on each of the tables.

c.     Click the Add button and then the Close button. The tables will be added to Design View window and you will see the relationships between the tables displayed.

d.    Refer to M3 Assignment 2 LASA 1 and add each of the data fields in the order in which they are listed in M3 Assignment 2 LASA 1 to the query by double-clicking each field name in the appropriate table. You will see the query being built in theDesign View window.

e.     On the Query Tools Design tab, in the Results group, click theRun button. This will execute the query against the database.

f.     Review the report. When you are satisfied, close the results of the query and click Yes when prompted to save the changes. Name the query “Display Employee Information”.

g.    The query will now appear in the navigation pane. Right-click the query in the navigation pane, select Export, and then clickPDF or XPS.

Save the PDF as M5_A1_Lastname_Firstname_EmpInfoBefore.PDF.

Note: For components C, D, and E, you will use SQL View to write simple SQL statements to modify the database. To enter SQL View, complete the following steps:

1.     On the Create tab, in the Queries group, click Query Design.

2.     When prompted to add tables, click the Close button.

3.     On the Query Tools Design tab, in the Results group, click on the down arrow below the word View and select SQL View. This is where you will compose your SQL statements.

4.     To run your SQL statements against the database, click the Runbutton in the Results group.

C.    Insert Records into the Database

1.     Create an SQL query to create a new position entitled “Programmer III” with a salary of $60,000. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Insert New Position”.

2.     Create an SQL query to create a new employee record for Frances Smith. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Insert New Programmer”.

3.     Create an SQL query to create a new employee record for Greg Smith. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Insert New Sales Representative”.

D.    Update Records in the Database

1.     Create an SQL query to update Arlene Smith to Programmer III. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Update Employee”.

2.     Create an SQL query to update the salary for the Vice President position to $80,000. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Update Vice President Salary”.

3.     Create an SQL query to update the salary for the Programmer I position to $40,000. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Update Programmer I Salary”.

4.     Create an SQL query to update the salary for the Programmer II position to $50,000. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Update Programmer II Salary”.

E.    Delete Records from the Database

1.     Create an SQL query to delete Eric Smith from the database. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Delete Sales Representative”.

2.     Create an SQL query to delete Bob Smith from the database. Run the query against the database. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Delete Programmer I”.

3.     Create a 1- to 2-page Microsoft Word document that includes answers to the following questions:

a.     When an employee leaves Altair Software, the company deletes the employee record from the human resources database. Is this a good practice? Why or why not? How would you suggest the company handle employee separations?

Save the document as M5_A1_Lastname_Firstname_GoodPractices.doc.

F.    Display the Information in the Database

1.     Repeat Step B.6.g and name the PDF as M5_A1_Lastname_Firstname_EmpInfoAfter.PDF.

G.    Compile SQL Queries and Database Reports for Submission

1.     For each of the ten SQL queries you have created, perform the following steps:

a.     Open the query in Design View (right-click the query in the navigation pane and click Design View).

b.    On the Query Tools Design tab, in the Results group, click on the down arrow below the word View and select SQL View.

c.     Copy the entire SQL statement and paste it into a Microsoft Word document.

2.     Create a 2- to 3-page document in Microsoft Word and paste all of the SQL statements you created in Step E.3. Label each statement with the appropriate name, e.g., “Update Employee”.

Save your document as M5_A1_Lastname_Firstname_SQLStatements.doc.

Submission Details:

·         Save your deliverables (including your database) as M5_A1_Lastname_Firstname.zip.

·         By Monday, August 1, 2016, submit both the files to the M5 Assignment 1 LASA 2 Dropbox.

LASA 2 Grading Criteria and Rubric

All LASAs in this course will be graded using a rubric. This assignment is worth 300 points. Download the rubric and carefully read it to understand the expectations.