Author: chris

What is the purpose of the system unit?

2. List and define five primary components of the motherboard.

3. List and define the three primary subunits of the CPU.

4. List and describe the two major categories of software.

5. Which internal components are connected by SATA cable?

6. Why is it best to install the CPU heatsink and fan prior to placing the motherboard inside the system unit?

7. What is the difference between centralized and distributed processing?

8. In the context of network communications, describe the difference between a protocol and a standard.And, explain why each is an important feature of networks.

9. What is the purpose of the operating system?

10. What is the purpose of the power supply?

11. Draw and explain the IPO model.

12. What is the purpose of the API and why is it important to the computer systems?

13. List and define three types of computer categories.

Lab 2: Work with Dictionary and Create Relational Database (60 pts.)

iLAB OVERVIEW

Scenario and Summary

In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.

MySQL provides two primary types of file management: dictionary-managed files and MySQL Workbench-managed files. As part of this iLab, you will need to supply some information as to how you would use both of these approaches, and you will have to discuss some of the advantages of each.

For Step 3, you need access to your database instance. If you have any difficulties connecting your database instance, let’s take error messages, screen shots, descriptions of the situation to the graded threads and work as a team to resolve issues.

Now you are ready to proceed.

Deliverables

Your assignment will be graded based on the following.

For Steps 1, 2, 3 and 4 create a single Word document and include the answers or solutions to all problems. Be sure to label your document and include your name and course number in the heading. Save your document as “yourname_Lab_2.docx.”

Submit both “yourname_Lab_2.docx” to the Dropbox for this week.

iLAB STEPS

STEP 1: Create Data Dictionary for provided elements

As the DBA for your company, you have decided to install a new version of the MySQL database to replace the current database version being used. The old database has become a constant headache and seems to be causing an overload on the disk drive’s I/O channels. Further analysis has also shown that two primary large tables are the main points of access. The new tables will be DEPT, EMPLOYEE, and BONUS.

Describe how you plan to compile the Data Dictionary and decide on the table’s structure with the new MySQL database.

Given list of elements:

Compile Data Dictionary (in alphabetic order):

Place and save your answers in a Word document named “yourname_Lab_2.docx.”

STEP 2: Create SCHEMA and database tables in MySQL Workbench

2.a Create SCHEMA

Launch MySQL Workbench;

Click File and choose ‘New Model’;

Add Diagram:

Name: new schema name;

Press ‘Enter’ and new SCHEMA will be added;

2.b Create tables

a) In Model overview (top part of the screen) Click ‘Add Diagram’; Navigation pane shows new schema in Catalog Tree;

b) Place a new table on the free part of screen;

c) Fill:

Table Name:

Column Name, Datatype; PK; NN; UQ;BIN; UN; ZF;AI; Default;

Press ‘Enter’

d) Continue to add all tables;

2.c Foreign key creation

a) Click on the bottom of the Form ‘Foreign key’ to establish the reference to parent table;

b) Choose the Reference table and Reference column;

c) Choose Foreign key options On Update and On Delete; Enter.

2.d Save database

a)     Choose ‘File’ on the Toolbar and Save Model as on your folder.

Established database are visible on Home page.

STEP 3: Create and configure a new connection to the MySQL Server

Part 1 Create a new connection to the MySQL Server

Launch to MySQL Workbench Home page;

To add a connection, click the [+] icon to the right of the MySQL Connections title. This opens the Setup New Connection form:

Figure 3.1 Setup New Connection Form

Important note:

The Setup New Connection form features a Configure Server Management button (bottom left) that is required for the MySQL connection to perform tasks that requires shell access to the host. For example, starting/stopping the MySQL instance or editing the configuration file Fill out the connection details and optionally click Configure Server Management to execute the Server Management wizard. Click OK to save the connection.

Important

All connections opened by MySQL Workbench automatically set the client character set to utf8. Manually changing the client character set, such as using SET NAMES …, may cause MySQL Workbench to not correctly display the characters.

New connections are added to the Home page as a tile, and multiple connections may be opened simultaneously in MySQL Workbench.

Part 2 Configure a New MySQL Connection

Click on ‘Local Instance MySQL’ and enter password;

Local Instance MySQL screen appears;

Click MySQL Workbench Home, click database to be connected;

EER Diagram screen appears;

Choose Database on Toolbar and ‘Forward Engineering’ on scroll menu;

Forward Engineer to Database screen appears

Set parameters for Connecting to a DBMS:

Stored Connection:   Select from saved connection settings; Click ‘Next’;

Set Options for Database to be Created appears

Select DROP objects before each CREATE object;

Leave selected Include model attached script; Click ‘Next’;

Select Objects to Forward Engineer screen appears, enter password again;

Select Export MySQL Table Objects and click ‘Next’;

Review the SQL script to be Executed screen appears for your review and saving to file or copy to Clipboard; Click ‘Next’;

Forward Engineering Progress screen appears, enter password again;

Forward Engineering Progress shows the executed tasks.

Click ‘Close’.

Please add Management, INSTANCE and PERFORMANCE screenshots for the created database to lab Report.

STEP 4: Insert data to tables using MySQL Workbench

Copy INSERT statements for the given tables into the notepad;

Launch to MySQL Workbench Home page;

Choose created database instance; enter password;

New screen appears with the Connection name;

Choose in Navigator your schema’s name;

Copy script from Notepad to screen ‘Query 1’;

Highlight executable rows, choose ‘Query’ on the Toolbar and Execute (All or Selection);

Output will display the results of the execution.

Please select counters and rows in database tables and add screenshots to lab Report.

Assignment 2: Required Assignment 1—Genesis Energy Cash Position Analysis

The Genesis Energy operations management team is now preparing to implement the operating expansion plan. Previously, the firm’s cash position did not pose a challenge. However, the planned foreign expansion requires Genesis Energy to have a reliable source of funds for both short-term and long-term needs.

One of Genesis Energy’s potential lenders tells the team that in order to be considered as a viable customer, Genesis Energy must prepare and submit a monthly cash budget for the current year and a quarterly budget for the subsequent year. The lender will review the cash budget and determine whether or not Genesis Energy can meet the loan repayment terms. Genesis Energy’s ability to repay the loan depends not only on sales and expenses but also on how quickly the company can collect payment from customers and how well it manages its supplier terms and other operating expenses. The Genesis Energy team members agreed that being fully prepared with factual data would allow them to maximize their position as well as negotiate favorable financing terms.

The Genesis Energy management team held a brainstorming session to chart a plan of action, which is detailed here.

• Evaluate historical data and prepare assumptions that will drive the planning process.
• Produce a detailed cash budget that summarizes cash inflow, outflow, and financing needs.
• Identify and compare interest rates, both short-term and long-term, using debt and equity.
• Analyze the financing mix (short/long) and the cost associated with the recommendation.

Since this expansion is critical to Genesis Energy expanding into new overseas markets, the operations management team has been asked to prepare an executive summary with supporting details for Genesis Energy’s senior executives.

Working over a weekend, the management team developed realistic assumptions to construct a working capital budget.

1. Sales: The marketing expert and the newly created customer service personnel developed sales projections based on historical data and forecast research
2. Other cash receipt: Rental income $15,000 per month
3. Production material: The production manager forecasted material cost based on cost quotes from reliable vendors, the average of which is 50 percent of sales
4. Other production cost: Based on historical cost data, this cost on an average is 30 percent of the material cost and occurs in the month after material purchase
5. Selling and marketing expense: Five percent of sales
6. General and administrative expense: Twenty percent of sales
7. Interest payments: $75,000—Payable in December
8. Tax payments: $15,000—Quarterly due on 15th of April, July, October, and January
9. Minimum cash balance desired: $25,000 per month
10. Cash balance start of month (December): $15,000
11. Available short-term annual interest rate is 8 percent, long-term debt rate is 9 percent, and long-term equity is 10 percent. All funds would be available the first month when the firm encounters a deficit
12. Dividend payment: None

Based on this information, do the following:

1. Using the Cash Budget spreadsheet, calculate detailed company cash budgets for the forthcoming and subsequent years. Summarize the sources and uses of cash, and identify the external financing needs for both the forthcoming and subsequent years.

   Download this Excel spreadsheet to view the company’s cash budget. You will calculate the company’s monthly cash budget for the forthcoming year and quarterly budget for the subsequent year using this information.

2. In an executive-level report, summarize the company’s financing needs for the forecast period and provide your recommendations for financing the planned activities. Be sure to comment on the following:
   1. Your recommended financing solution and cost to the firm: If Genesis Energy needs operating cash, how should it fund this need? Are there internal policy changes with regard to collections or payables management you would recommend? What types of external financing are available?
   2. Your concerns associated with the firm’s cash budget. Is this a sign of weak sales performance or poor cost control? Why or why not?

Write a 7-page paper in Word format. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M3_A2.doc.

By Wednesday, November 11, 2015, deliver your assignment to the M3: Assignment 2 Dropbox.

Civil Protest and Civil Rights
Think about how the civil rights movement took shape in the 1950s. The difficulties of confronting a deeply ingrained social order like segregation were significant, and challenging that order often meant very real risks, including death. Nonetheless, in events like the Montgomery bus boycott of 1955, the sit-in wave that began in Greensboro, North Carolina, in 1960, and uncountable “freedom rides” and public marches, civil rights activists—led mostly by blacks but with substantial help from white allies—successfully challenged the old order. Consider the difficulties civil rights activists faced in organizing at the grassroots and convincing national-level political leaders to support the cause.
Instructions:
Write an essay of 500 to 1000 words that explains how civil rights advocates successfully challenged and overthrew the system of segregation.
Your essay should include:
Discussion of the factors that led to increased activism and solidarity at the grassroots level
Discussion of the role that elected officials within the federal government played in guaranteeing citizenship rights to all Americans

The product is Coca-Cola

Write a 1,050- to 1,400-word paper in which you research the current customer base, consumer behavior, demographics, psychographics, lifestyle, geographic area, benefit segmentation, and user segmentation for the product or service.

Identify the ideal target market for your Learning Team’s selected product or service. Include the following:

• Provide a specific description of the target market, which should be measurable, accessible, sustainable, differentiable, and actionable.
• Estimate the size of the market and estimated penetration percentage.
• Create an initial marking positioning statement based on your current research.
• Provide justification for your answers.

Format your paper consistent with APA guidelines.

2 (Single Spaced)
1 source

Article found at http://www.wsj.com/articles/comcasts-nbcuniversal-agrees-to-invest-in-buzzfeed-1439927427?

Must include the following:
A detailed overview (generally at least one page in length) of the article, including main points and issues covered.
? Quotations should be limited in quantity, clearly indicated as quotes and typically come from the item reviewed. Instructor reserves right to examine submissions for plagiarism (a form of cheating) and to penalize excessive direct quotations.
? A choice of at least four important aspects (topics, concepts, ideas)—of these, at least TWO must be considered favorable by you and at least ONE must be considered unfavorable. The favorable aspects should be headed as “Areas of Agreement” and be backed by a substantial discussion. The unfavorable aspect[s] should also receive a substantial discussion and be headed as “Areas of Disagreement.”
? Finally, create an essay question clearly specific to the article but one that you believe could be competently answered by anyone in the class that read the article. This question should be labeled “Essay Question.”

Please read the requirements and NO  plagiarism

Read the case study titled “A Patient Information System for Mental Health Care”, located in Chapter 1 of your textbook.

Write a three to five (3-5) page paper in which you:

1. Create a Software Requirement Specification (SRS) that includes the following:
   1. A detailed description of both user and system requirements. At least four (4) user requirements and four (4) system requirements should be provided.
   2. A detailed description of both functional and nonfunctional requirements. At least four (4) functional requirements and four (4) nonfunctional requirements should be provided.
   3. A detailed requirement specification written in structured natural language.
2. Structure and present the requirements in a logical and consistent manner.
3. Develop a use case diagram to summarize the functional requirements of the system through the use of Microsoft Visio or its open source alternative, Dia. Note: The graphically depicted solution is not included in the required page length.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in Visio or an equivalent such as Dia. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

• Analyze and describe functional and nonfunctional requirements in software engineering.
• Describe the key components in requirements elicitation and analysis.
• Use technology and information resources to research issues in software engineering.
• Write clearly and concisely about software engineering using proper writing mechanics and technical style conventions.

As we are learning through this class a culture can be defined as a system of knowledge and a way of looking at the world that is shared by a relatively large group of people.  Cultural knowledge includes shared beliefs, values and attitudes that are developed over a period of time and communicated to other members of the culture through the significant symbols of the culture.  As Hofstede suggests, we learn our culture as a type of mental programming that works much like the way the underlying code of a computer program works.  The “code” of culture guides behavior and affects how we respond to people and situation.

The goal of this assignment is for you to research your culture and to develop a paper outlining what you have discovered.  You are to contact members of your culture and seek out additional resources (our textbook, other books, web sites, and the like) as needed. Upon completion of this analysis you will present me with an individual paper which answers, in detail (providing examples to support your answers when appropriate), to the following questions below:

Defining Culture as a Part of Identity

1. How do you define your culture?

Please Note: in answering this question consider the following:  Usually we think of defining our culture in terms of nationality or a country of origin.  One may say, for instance, I am Polish, or Polish-American.  Groups of people may also define themselves in light of ethnic or racial characteristics.  A person’s sense of identity may also be rooted in a religious heritage or any other demographic aspect such as gender, sexual orientation, social class or in light of membership in an age cohort.  Sometimes, an organizational structure such as being affiliated with the military or a particular type of community such as a rural community or a vacation spot can also serve as a way of defining our culture.

2. Are there particular values that are especially meaningful to your culture?

Please note: Examine how Hofstede has contrasted two types of cultural orientations:  Individualistic cultures emphasize the independence and autonomy of an individual.  In individualistic cultures a person is self-directed and pursues individual goals or strives to please oneself.  Collectivistic cultures emphasize the harmony of the group and the pursuit of group goals over individual endeavors.  This may mandate greater conformity and concerns about the security of the group as a whole.  Provide examples for your answer.

Family Structure and Traditions

3. What are some (list a couple) of the customs or family traditions that you have learned as a member of your culture?  Provide some examples.

4. How do the rules and traditions of your culture affect the way that family members relate to one another?  For instance, do people in the family have certain roles or particular levels of status based on cultural traditions? Provide some examples.

5. How do factors such as religion or a cultural philosophy of life affect family communication? Provide some examples.

6. How does your family culture affect the formation of gender roles? Provide some examples.

Culture and Speech Communities-Significant Symbols and Communication Norms

7. Is a language other then English used in your household?  If so-what language(s) are spoken?

8. What are some examples of nonverbal communication that you can trace to your culture?  For instance attitudes of what is required, expected or desirable nonverbal expressiveness, or rules that govern nonverbal behavior.

9. How does your family trace its roots?  Is there, for instance, a story about how members of your family came to the U.S. or are there important historical events that led your family’s decision to immigrate?  Are there specific places such as an ancestral home or particular hometown that members of the family relate to in order to find a sense of rootedness?

10. How does your culture teach you to relate to people in other communities?  For instance, are there rules or expectations about how to relate to people outside of your own community?

Work and Leisure,

11. What are some of the values and attitudes related to work in your culture?  What kind of work is meaningful?  How important is work or professional standing in the ways that members of your community develop a self-concept?

12. How important is leisure?  What are important games or leisure time activities that people in your culture enjoy?  Do these activities teach attitudes and values?

Living in a Post-Modern World

13. How much does your cultural community embrace technology?

14. How adaptive is your cultural community to social and cultural changes, especially in light of issues confronted by living in a fast-paced, transient world on the move?

15. Are members of your culture able to preserve a sense of distinctive cultural identity in a pluralistic (multi-cultural) environment?

Summary

16. Overall, what do you think you like best about your culture?  How is this a source of cultural pride?

17. What is the most important thing you learned about how your own culture affects your self-concept and how you communicate?

As stated above you are to answer these questions and present this to me as a paper. The format of this paper should follow the format above-with you writing out the questions and answering them (complete with your examples) below the question. Once completed this can be submitted to me by the due