Ashford University Online: 2015

понедельник, 28 декабря 2015 г.

INF 322 Week 5 Final Project Customer service

Focus of the Final Project

1. Use the Access database you created in Week 3: Customer Service Database 2. Output 3 queries using SQL code and not the standard access view:

A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.
An update query that changes one or more customer records but not all records.
A delete query that removes one or more customer records but not all records.

Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.

Report on Customers in Database showing Names, State, and Phone Numbers.

Create a report showing contact name and birthdays. Do not show records without a birthday.

Analyze the data populated in the Database to show referential integrity. This includes a statement showing what

the affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of

data.

All data and screen shots should be included in a Word document with a brief explanation of the actions you

performed.

Carefully review the Grading Rubric in the online classroom for the criteria that will be used to evaluate your assignment.

INF 322 Week 5 DQ 2 Bending the Rules

Bending the Rules. Chapter 15 discusses bending or breaking the rules. Can you think of a situation where you would apply this practice? List an example and which rule you would be bending or breaking. Respond to at least two of your classmates’ postings.

INF 322 Week 5 DQ 1 Views

Views. There are three types of views. Pick one of them and provide a definition, an example of that type of view, and when you would use the view. If you have ever purchased anything online and returned to the vendor Web site, many views of data will be accessible when you login, including your previous orders, their catalog of product, and even your shipping and credit card information. Think of examples like this before you respond. Respond to at least two of your classmates’ postings.

INF 322 Week 4 DQ 2 Business Rules

Business Rules. There is a great deal of information to consider when planning business rules. Now that you have read Chapter 11, think of a business rule from a place you have been employed at and use that in an example. This could be around defining user access or field specific data, deciding if a field is required or if a field has data validation. How effective was the application of the business rule? Please be specific in your example. Respond to at least two of your classmates’ postings.

INF 322 Week 4 DQ 1 Table Relationships

Table Relationships. Chapter 10 discusses table relationships. Define one type of relationship (one-to-one, one-to-many, many-to-many and self-referencing relationships) and provide an example of this type of data relationship. Respond to at least two of your classmates’ postings.

INF 322 Week 3 DQ 2 Determining System Requirements

Determining System Requirements. Identify the database or process you would like to begin to think about for your future database design. After you have developed a database idea, you need to plan the interviewing of your users. Interviewing will give you a better understanding of user needs, wants, and desires, as well as help you to determine your system requirements. What questions should you ask? How do you think this will help you in determining your table and field requirements? When do you think it would be important to make these decisions? Respond to at least two of your classmates’ postings.

INF 322 Week 3 DQ 1 Keys

Keys. Why is a Key important in a database? How does it help with Referential Integrity? Chapter 8 lists three compelling reasons why Keys are crucial to table structure. There is an example of a table and its’ key in Figure 8.2. Respond to at least two of your classmates’ postings.

INF 322 Week 3 Assignment Customer Service Database

Customer Service Database. Show a SQL Query and screenshot your results in a Word document to submit to your instructor. There will be 4 results with explanations required for this assignment.

Part 1

1. Create a “Customer Service Database” using New in MS Access and select from Microsoft Online on left, double-click business and then double click on “Customer Service.” On right, click Download. (**Note: The Customer Service Database is no longer available as part of MS Access 2010. Please download the zip file of the database within the online course).

2. This will create a file on your hard drive called “customer service.accdb”. It will also open this file in Access. If you get a security warning, you can click on the security warning in Access option and set the selection to enable content and click ok.

3. Maximize the Shutter Bar to show the tables, queries/views and reports. Note: You are not seeing tables in this view and that can be changed. Click on the down arrow in the shutter view next to the database name “Customer Service” and click on “Tables and Related Views”

Save your database.

You should now be able to use MS Access and the database created to complete the assignment.

Part 2

1. Add 10 customers to the database.
2. Using SQL query, update one customer. Show before and after data as well as the SQL Code.
3. Add an eleventh customer and then delete them with a SQL Query, Show before and after data as well as the

SQL Code.
4. Write a report showing your customers identify the primary key in the table you are reporting on. Show the

results of your Report via a screen shot.
5. Upload a copy of the database using “Customer Service” and student First and Last name as the file name.

All data and screen shots should be included in a word document with a brief explanation of the actions you performed.

INF 322 Week 2 DQ 2 Interviewing the Users

Interviewing the Users. This week’s reading contained a section on interviewing the users. Why is this process important? Think about who uses the tool, what they use it for, and what is important for them to get the job done. Have you ever been involved in any of these types of interviews? If so, share your experience. Respond to at least two of your classmates’ postings.

INF 322 Week 2 DQ 1 Improved Processes

mproved Processes. Databases are installed to help solve problems, improve processes, or provide a benefit to the organization. Do you have a scenario that you can share where you believe a Database helped/could help improve a process at your work or at another organization with which you are familiar? It can be for a new application or to replace an existing application or process. Respond to at least two of your classmates’ postings.

INF 322 Week 2 Database Modeling

Database Modeling. After reading this week’s article, “Modeling for the Future,” expand on the subject of Database Modeling. There are several tools listed and reviewed in the article. Research these tools further, or identify other modeling tools, and write a 2-3 page, APA-style paper focused on one tool of your choice. You are allowed to compare tools, but apply your findings and comparison to your research as if you were selecting the tool for use at your employer. What are the benefits and the possible shortcomings of using the tool? How would this tool help you meet your database modeling needs? Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts.

INF 322 Week 1 DQ 2 Running Access

Running Access. If you have not already done so, install Microsoft Access 2010 (this is a free 60-day trial for MS Office Professional 2010). In the response to this forum, note that you have successfully installed the product and what you experienced in the install and as you first opened the tool. We will all start with a sample database to get familiar with Access in Week 2. If you have any issues or unexpected results, this is a great place to share your experience. Respond to at least two of your classmates’ postings.

INF 322 Week 1 DQ 1 Databases

Databases. Everyone has had some experience with data. Even if you are new to the Database world you have this experience since your personal information is data in many places. List an example of a database and how you interact with that database. One example might be as a customer receiving monthly bills. Another example might be your personal information collected at a medical office. Respond to at least two of your classmates’ postings.

INF 322 Entire Course

Week 1

Week 2

Improved Processes. Databases are installed to help solve problems, improve processes, or provide a benefit to the organization. Do you have a scenario that you can share where you believe a Database helped/could help improve a process at your work or at another organization with which you are familiar? It can be for a new application or to replace an existing application or process. Respond to at least two of your classmates’ postings.

Week 3

Customer Service Database. Show a SQL Query and screenshot your results in a Word document to submit to your instructor. There will be 4 results with explanations required for this assignment.

Part 1

1. Save your database.

2. You should now be able to use MS Access and the database created to complete the assignment.

Part 2

SQL Code.
4. Write a report showing your customers identify the primary key in the table you are reporting on. Show the

results of your Report via a screen shot.
5. Upload a copy of the database using “Customer Service” and student First and Last name as the file name.

All data and screen shots should be included in a word document with a brief explanation of the actions you performed.

Week 4

Week 5

Focus of the Final Project

1. Use the Access database you created in Week 3: Customer Service Database 2. Output 3 queries using SQL code and not the standard access view:

1. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.

2. Report on Customers in Database showing Names, State, and Phone Numbers.

3. Create a report showing contact name and birthdays. Do not show records without a birthday.

4. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what

the affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of

data.

5. All data and screen shots should be included in a Word document with a brief explanation of the actions you

performed.

Carefully review the Grading Rubric in the online classroom for the criteria that will be used to evaluate your assignment.

INF 231 Week 5 DQ 2 Modern Technology

Cell phones are rapidly becoming very powerful and they provide many uses beyond just texting and talking. Look back at each week and provide examples of how some of the items you have learned are used in these devices. Please use three examples. Respond to at least two of your classmates’ postings.

INF 231 Week 5 DQ 1 Input and Output

Input and Output are necessary functions with any code. Define I/O and identify some of the elements needed in C++ that would use input or create output. Remember that input is not just from your keyboard and can be from a file or database. Additionally, output isn’t necessarily to a screen or a printer and can be to a file or a database. If you can’t think of any examples from the text or your own experiences, visit this Sample C++ Source Code website. You can use examples for any situation or device. Respond to at least two of your classmates’ postings.

INF 231 Week 5 Assignment Final Project

The Final Project consists of building an executable monetary conversion program to be submitted by the final day of the course.

Focus of the Project

For the program, you will write a utility that converts dollars to coins. It is a simple program that must have the following:

Multiple outputs to the screen

At least one input

The use of integers and strings

Looking or repetition with Do..While, If..Else

Must have some output text to show correct value of coins that would be converted from the dollars.

Code must include comments explaining your reason for the code section or what the code is doing

Code must compile

Dollar amounts should be round numbers with 2 decimals points (i.e. 47.00, 47.37, 47.50). If value is less than 1 or 0, the program should break or exit.

Turn in your source code (.cpp file) to your instructor with your filename including your first and last name and your compiled executable

INF 231 Week 4 DQ 2 Character Arrays

Chapter 7 continues the discussion of arrays. Arrays include multiple data types and can include characters. Understanding that you can use characters in an array, give an example of how you would use a character array and what data could be stored in this array. See page 351 for an example. Respond to at least two of your classmates’ postings.

INF 231 Week 4 DQ 1 Arrays

Define an Array and why you would use one. Provide an example that is not from the text. Respond to at least two of your classmates’ postings.

INF 231 Week 4 Assignment UML

To complete the following assignment, go to this week's Assignment link in the left navigation.

UML

Using the assigned journal article for the week, compose a two page paper on the Unified Modeling Language (UML). What is the function of UML? Why was it developed? What has been its impact on modeling? You are also welcome to reference additional UML resources.

Carefully review the Grading Rubricfor the criteria that will be used to evaluate your assignment.

INF 231 Week 3 DQ 2 Repetition Statements

When would you use a repetition statement? Why? See chapter 5 for one example of the use of the for statement. Respond to at least two of your classmates’ postings.

INF 231 Week 3 DQ 1 Control Statements

What is a Control Statement? There are several types of control statements; define two control statements and use your own example in your definition. Respond to at least two of your classmates’ postings.

INF 231 Week 2 DQ 2 Classes and Structures

Describe the class structure of C++ programming. What are the key contents of classes? Respond to at least two of your classmates’ postings.

INF 231 Week 2 DQ 1 Programming Practices

Good Programming practices are necessary but different in every environment. Identify one practice mentioned in the text and research some others. What makes these good? Can you think of a reason why one would not use the good practice? Respond to at least two of your classmates’ postings.

INF 231 Week 2 Assignment Text Printing Program

Section 2.2 of Chapter 2: First Program in C++: Printing a Line of Text is an example of a “text printing program.” Use this example and instructions, but change the text to be an output. Add the following text:

Name:

Course Name:

Famous Quote:

INF 231 Week 1 DQ 2 Running Applications

Install the application provided with the text. You should be installing Microsoft Visual C++ 2005. Depending on your operating system, you may need to download and run alternate software. XP users may need the following patch to get the Visual C++ software to run: Service Pack 1. Windows Vista and Windows 7 users are advised to download a similar opensource C++ program:DEV C++ by Bloodshed, instead of the software provided with the text.

You will also need to copy the zip file that provides the C++ libraries:Libraries.zip. Please read these Instructions on downloading the zip files to your hard drive.

As part of this exercise you will also use the sample code below to test the application, compile the code and communicate that your application was installed and working.

This is the sample code:

#include <iostream>

#include <string>

using namespace std;

int main()

{

string str1("Alpha");

string str2("Beta");

string str3("Omega");

string str4;

// assign a string

;

cout << str1 << "\n" << str3 << "\n";

// concatenate two strings

+ str2;

cout << str4 << "\n";

// concatenate a string with a C-string

+ " to " + str3;

cout << str4 << "\n";

// compare strings

if(str3 > str1) cout << "str3 > str1\n";

if(str3 == str1+str2)

cout << "str3 == str1+str2\n";

/* A string object can also be

assigned a normal string. */

;

cout << str1;

// create a string object using another string object

string str5(str1);

cout << str5;

// input a string

cout << "Enter a string: ";

cin >> str5;

cout << str5;

return 0;

}

The code above is a simple program that will output some string statements and then ask for one input and close after you enter text and then hit enter.

Try to change the text once you are successful and rename your source file. Play around with the strings. Report your experience and your efforts to the discussion board. Respond to at least two of your classmates’ postings

INF 231 Week 1 DQ 1 Hardware and Software

Hardware and Software are in many items we use in our daily lives. Name a few items in your house or office that have some sort of hardware and software. Look beyond your computer and other devices used with your computer. Thinking of the software that they may have, what does the software provide and how does it make the device/hardware better? Respond to at least two of your classmates’ postings.

INF 231 Course

INF 231 Week 1 DQ 1 Hardware and Software

INF 231 Week 1 DQ 2 Running Applications

INF 231 Week 2 Assignment Text Printing Program

INF 231 Week 2 DQ 1 Programming Practices

INF 231 Week 2 DQ 2 Classes and Structures

INF 231 Week 3 DQ 1 Control Statements

INF 231 Week 3 DQ 2 Repetition Statements

INF 231 Week 4 Assignment UML

INF 231 Week 4 DQ 1 Arrays

INF 231 Week 4 DQ 2 Character Arrays

INF 231 Week 5 Assignment Final Project

INF 231 Week 5 DQ 1 Input and Output

INF 231 Week 5 DQ 2 Modern Technol

INF 220 Week 5 DQ 2 Moral Dimensions of Information Systems

Refer to page 413 Figure 12-1 in your text – The Relationship Between Ethical, Social, and Political Issues in an Information Society. “The introduction of new information technology has a ripple effect, raising new ethical, social, and political issues that must be dealt with on individual, social, and political levels. These issues have five moral dimensions: information rights and obligations, property rights and obligations, system quality, quality of life, and accountability and control.” Give a business example of each. Respond to at least two of your classmates’ postings.

INF 220 Week 5 DQ 1 Impact of the Internet

The Internet may not make corporations obsolete, but corporations will have to change their business models. Do you agree? Why or why not? Respond to at least two of your classmates’ postings.

INF 220 Week 5 Assignment Final Paper

Product Description

Final Paper

The final paper will demonstrate the students’ ability to assimilate, synthesize, and apply the concepts of management information systems; specifically how information systems transform business; how information systems help to solve business problems; how information systems support major business functions, and how information systems affect business careers.

Focus of the Final Paper

Your final paper should demonstrate understanding of information systems and how they contribute to forming competitive advantage in business. Prepare a 4-6 page paper that addresses the following questions in narrative form (APA form and style). Be sure to provide examples and supporting rationale throughout the paper.

How are information systems transforming business and what is their relationship to globalization?
Why are information systems so essential for running and managing a business today?
What exactly is an information system? How does it work? What are its people, organization, and technology components?
How will a four-step method for business problem solving help you solve information system-relations problems?
Identify and describe the major features of a business that are important for understanding the role of information systems.
Describe the information systems supporting the major business functions: sales and marketing, manufacturing and production, finance and accounting, and human resources.
How will information systems affect business careers and what information systems skills and knowledge are essential?

INF 220 Week 4 DQ 2 Supply Chain Management

Supply chain management is less about managing the physical movement of goods and more about managing information. Discuss the implications of this statement. Respond to at least two of your classmates’ postings.

INF 220 Week 4 DQ 1 Security in Business

Respond to the following: “Security isn’t simply a technology issue, it’s a business issue.” Be sure to include business examples in your post. Respond to at least two of your classmates’ postings.

INF 220 Week 4 Assignment Evaluating Security Software

Use the Web to research and evaluate security products from two competing vendors, such as antivirus software, firewalls, or antispyware software. For each product, describe its capabilities, for what types of businesses it is best suited, and its cost to purchase and install. Which is the best product? Why?

INF 220 Week 3 DQ 2 RFID

Should all major retailing and manufacturing companies switch to RFID? Why or why not? Respond to at least two of your classmates’ postings.

INF 220 Week 3 DQ 1 Database Development

To what extent should end users be involved in the selection of a database management system and database design? Respond to at least two of your classmates’ postings.

INF 220 Week 3 Assignment Network Design

In a two-page APA formatted paper, provide analysis answering the following:

Network design is a key business decision as well as a technological decision. Why? Provide an example of a company you believe has a good network design, providing supporting rationale on why that network is effective and what types of business decisions or reports can be made from its utility.

INF 220 Week 2 DQ 2 Hardware and Software Selection

Why is selecting computer hardware and software for the organization an important business decision? What factors should be considered? Respond to at least two of your classmates’ postings.

INF 220 Week 2 DQ 1 Role of BPR

What is the role of business process reengineering (BPR) in enhancing competitiveness? Give examples to illustrate your answer. Respond to at least two of your classmates’ postings.

INF 220 Week 2 Assignment Identifying Opportunities

Select a company described in the Wall Street Journal, Fortune, Forbes, or another reputable business application. Visit the company’s Web site to find additional information about that company and see how the firm is using the Web. On the basis of this information, briefly identify important business processes and the firm’s business strategy. Suggest information systems that might give that particular business a competitive advantage, including those based on Internet technology. Your paper should be two double-spaced pages in length (excluding title page) and in APA format. Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts.

INF 103 Week 2 Using Microsoft Word What Does the Library Have to Offer

Using Microsoft Word: What Does the Library Have to Offer? Write a one-to two-page essay that describes the benefits of using the Ashford University Library. What are the differences between scholarly resources and popular resources? What are some key things to remember when searching for sources within the Ashford University Library (e.g. databases, FindIt@AU search tool)? How will you be most effective and efficient in finding resources that fit your research needs?

INF 220 Week 1 DQ 2 Organizational Performance

How do enterprise applications, collaboration and communication systems, and intranets improve organizational performance? Give examples to illustrate your answer. Respond to at least two of your classmates’ postings.

INF 220 Week 1 DQ 1 Information Systems and Globalization

Information Systems and Globalization

How are information systems transforming business and what is their relationship to globalization? Give examples to illustrate your answer. Respond to at least two of your classmates’ postings.

INF 220 Week 1 Assignment UPS and the Utility of Information Systems

UPS and the Utility of Information Systems

After reading chapter one, watch the video: (Real Media Player can be downloaded for free at www.real.com) and read the additional write-up on page 16 of your text. Answer the questions listed below using APA format. Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts. The paper should not exceed 2 double-spaced pages (excluding title page).

United Parcel Service's operations are driven by its information systems technology. Beginning as a local delivery service in 1907, UPS expanded on the West coast initially, reached New York in the 1930s, and went international in the 1970s. Today, UPS delivers over 14 million packages daily to 200 countries and territories. A $1.5 billion technology investment in the 1980s buoyed the growth of UPS. The investment enabled the development of the International Shipments Processing System (ISPS), which is the key to the company's overseas operations. The technology infrastructure enables UPS to offer its customers services in addition to the basic shipment of packages. UPS drivers play an important role in the company's services by capturing information at the endpoints of each delivery segment. Volume, cultural differences, and hardware readiness all impact the development and continued growth of UPS.

What external factors affect international operations at UPS?
How do these factors cause UPS to adjust its operations?
What are the inputs, processing, and outputs of UPS’ tracking system.
What technologies are used by UPS? How are these technologies related to UPS’ business model and business objectives?

понедельник, 28 декабря 2015 г.

Product Description

понедельник, 28 декабря 2015 г.