Posted on

project plan

This assignment consists of two (2) sections: a business requirements document and a project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.
Procuring quality business requirements is an important step toward the design of quality information systems. Completion of a quality requirements document allows user needs and expectations to be captured, so that infrastructure and information systems can be designed properly. Your company, which is a data-collection and analysis company that has been operating less than two (2) years, is seeking to create a repository for collected data beyond standard relational databases. Your ten (10) terabyte data warehouse is expected to grow by 20% each year. You are mindful of data warehousing best practices which will aid you immensely in your requirements gathering effort. Using the requirements document provided in the course shell, you are to speculate on the needs of the company. You must consider current and future requirements; however, assumptions should be realistic and carefully considered.
Section 1: Business Requirements Document

  1. Write a four to six (4-6) page original business requirements document for the project plan using the template provided. Note: The template is provided under the Additional Resources in the Student Center tab of the online course shell.
    • Describe the project including the following:
      • Describe and define the scope of the project.
      • Speculate as to how to control the scope.
      • Identify possible risks, constraints, and assumptions.
      • Describe the relationship and integration between systems and infrastructure. Note: Database and Data Warehousing, Analytics, Interfaces and Cloud Technology, and Infrastructure and Security should be considered.
      • Speculate upon potential outsourcing or offshoring needs.
      • Identify and justify the necessary resources including staffing that are necessary.
      • Define relevant terms that will be used throughout project.
    • Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

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.

Section 2: Revised Project Plan
Use Microsoft Project to:

  1. Update the project plan from Project Deliverable 1: Project Plan Inception, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

The specific course learning outcomes associated with this assignment are:

  • Evaluate an organization through the lens of non-IT senior management in deciding how information systems enable core and supportive business processes as well as those that interface with suppliers and customers.
  • Use technology and information resources to research issues in information systems.
  • Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.
Posted on

skills of providing Web page content and structure with HTML and Web page style and layout using CSS

Continue to build on the skills of providing Web page content and structure with HTML and Web page style and layout using CSS. Demonstrate the skill of creating a dynamic Web page that includes JavaScript client-side programming. Demonstrate the skill of creating a Web page that delivers audio and/or video content. Design and develop a Web site that includes at least two Web pages that meet the following requirements.
The design of all Web pages in the site must include:
a header at the top of the page,
a horizontal navigation bar below the header,
required content below the navigation bar.
One Web page must include dynamic content created by client-side programming using JavaScript.
JavaScript programming code can be either
embedded in the head element or
included in an external JavaScript file that is linked to the Web page.
You may
write your own JavaScript code or
obtain the JavaScript code from a provider of free code.
Ensure the JavaScript programming code is free of errors that cause it to fail to execute.
Ensure the JavaScript code is called to execute.
Ensure the JavaScript programming code is included in the Web site.
Validate the HTML in the Web page.
One Web page must deliver audio and/or video content.
Deliver the content to older browsers
using the embed element
that falls back to Flash.
Deliver the content to modern browsers
using the video and/or audio elements.
Ensure the content plays in all modern browsers.
Ensure the media files are included in the Web site.
Validate the HTML in the Web page.
Use at least one external CSS file to
provide style, presentation, and layout to the Web pages in the Web site.
Validate the CSS style rules.
Zip (compress) the Visual Studio Web site folder into a .zip file format to submit.

Posted on

describe the design for a small Web sites

Develop a 5-6 page Word document that describes the design for a small Web site that meets the following specifications.
The Web site includes four or more Web pages designed according to current usability guidelines.
One page must be the Home page.
One page must be a subscription page that allows the user to become a member or subscribe to your organization and performs HTML data validation.
The Web site must incorporate the use of the following:
Images and Audio
At least one table (NOT for page layout)
At least one form
Navigation
Other valid HTML elements
Produce a cohesive site that is easy to navigate.
The Web site must include external CSS used to format and layout each Web page.
Validate the HTML in each Web page.
Validate the CSS style rules in each CSS.
The design document must include details about your design, technologies employed, potential challenges and explanations regarding your validation process. Include a title page.
Add the design document to the Visual Studio Web site folder.
Submit the Word Design document and the Web site into a .zip file.
Please add your file.
You will be graded on the design and functionality of the Web site. You will be graded on the usability of the Web site. You will be graded on the ability to include the required Web pages and the required HTML elements in the Web site. You will be graded on the use of CSS to format and layout Web pages. Points will be deducted for a missing or incomplete site plan. Points will be deducted for missing required Web pages. Points will be deducted for any missing required elements and/or attributes. Points will be deducted for any HTML or CSS validation errors including any missing accessibility requirements

Posted on

information system fundamentals

chapter 5,6 (Subject name : information system fundamentals)

Information Systems for Business and Beyond
David T. Bourgeois, Ph.D.
Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
saylor.org
Information Systems for Business and Beyond © 2014 David T. Bourgeois, is licensed
under a Creative Commons Attribution (CC BY) license made possible by funding from
The Saylor Foundation’s Open Textbook Challenge in order to be incorporated into
Saylor.org’s collection of open courses available at http://www.saylor.org. Full license
terms may be viewed at: http://creativecommons.org/licenses/by/3.0/legalcode
Contents
1Introduction
Part 1: What Is an Information System? Chapter 1: What Is an Information System?
5David T. Bourgeois
Chapter 2: Hardware 14David T. Bourgeois
Chapter 3: Software 26David T. Bourgeois
Chapter 4: Data and Databases 39David T. Bourgeois
Chapter 5: Networking and Communication 52David T. Bourgeois
Chapter 6: Information Systems Security 64David T. Bourgeois
Part 2: Information Systems for Strategic Advantage Chapter 7: Does IT Matter?
76David T. Bourgeois
Chapter 8: Business Processes 85David T. Bourgeois
Chapter 9: The People in Information Systems 94David T. Bourgeois
Chapter 10: Information Systems Development 104David T. Bourgeois
Part 3: Information Systems Beyond the Organization Chapter 11: Globalization and the Digital Divide
120David T. Bourgeois
Chapter 12: The Ethical and Legal Implications of Information Systems 129David T. Bourgeois
Chapter 13: Future Trends in Information Systems 144David T. Bourgeois
150Answers to Study Questions 162Bibliography
iv Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
saylor.org
Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
Introduction
Welcome to Information Systems for Business and Beyond. In this book, you will be introduced to the concept of information systems, their use in business, and the larger impact they are having on our world.
Audience
This book is written as an introductory text, meant for those with little or no experience with computers or information systems. While sometimes the descriptions can get a little bit technical, every effort has been made to convey the information essential to understanding a topic while not getting bogged down in detailed terminology or esoteric discussions.
Chapter Outline
The text is organized around thirteen chapters divided into three major parts, as follows:
• Part 1: What Is an Information System? Chapter 1: What Is an Information System? – This chapter provides an overview of information systems, including the history of how we got where we are today. Chapter 2: Hardware – We discuss information systems hardware and how it works. You will look at different computer parts and learn how they interact. Chapter 3: Software – Without software, hardware is useless. In this chapter, we discuss software and the role it plays in an organization. Chapter 4: Data and Databases – This chapter explores how organizations use information systems to turn data into information that can then be used for competitive advantage. Special attention is paid to the role of databases. Chapter 5: Networking and Communication – Today’s computers are expected to also be communication devices. In this chapter we review the history of networking, how the Internet works, and the use of networks in organizations today. Chapter 6: Information Systems Security – We discuss the information security triad of confidentiality, integrity, and availability. We will review different security technologies, and the chapter concludes with a primer on personal information security.
• Part 2: Information Systems for Strategic Advantage Chapter 7: Does IT Matter? – This chapter examines the impact that information systems have on an organization. Can IT give a company a competitive advantage? We will
1Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
saylor.org
Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
discuss seminal works by Brynjolfsson, Carr, and Porter as they relate to IT and competitive advantage. Chapter 8: Business Processes – Business processes are the essence of what a business does, and information systems play an important role in making them work. This chapter will discuss business process management, business process reengineering, and ERP systems. Chapter 9: The People in Information Systems – This chapter will provide an overview of the different types of people involved in information systems. This includes people who create information systems, those who operate and administer information systems, those who manage information systems, and those who use information systems. Chapter 10: Information Systems Development – How are information systems created? This chapter will review the concept of programming, look at different methods of software development, review website and mobile application development, discuss end- user computing, and look at the “build vs. buy” decision that many companies face.
• Part 3: Information Systems beyond the Organization Chapter 11: Globalization and the Digital Divide – The rapid rise of the Internet has made it easier than ever to do business worldwide. This chapter will look at the impact that the Internet is having on the globalization of business and the issues that firms must face because of it. It will also cover the concept of the digital divide and some of the steps being taken to alleviate it. Chapter 12: The Ethical and Legal Implications of Information Systems – The rapid changes in information and communication technology in the past few decades have brought a broad array of new capabilities and powers to governments, organizations, and individuals alike. This chapter will discuss the effects that these new capabilities have had and the legal and regulatory changes that have been put in place in response. Chapter 13: Future Trends in Information Systems – This final chapter will present an overview of some of the new technologies that are on the horizon. From wearable technology to 3-D printing, this chapter will provide a look forward to what the next few years will bring.
For the Student
Each chapter in this text begins with a list of the relevant learning objectives and ends with a chapter summary. Following the summary is a list of study questions that highlight key topics in the chapter. In order to get the best learning experience, you would be wise to begin by reading both the learning objectives and the summary and then reviewing the questions at the end of the chapter.
2 Information Systems for Business and Beyond
saylor.org
Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
For the Instructor
Learning objectives can be found at the beginning of each chapter. Of course, all chapters are recommended for use in an introductory information systems course. However, for courses on a shorter calendar or courses using additional textbooks, a review of the learning objectives will help determine which chapters can be omitted.
At the end of each chapter, there is a set of study questions and exercises (except for chapter 1, which only offers study questions). The study questions can be assigned to help focus students’ reading on the learning objectives. The exercises are meant to be a more in-depth, experiential way for students to learn chapter topics. It is recommended that you review any exercise before assigning it, adding any detail needed (such as length, due date) to complete the assignment.
Introduction 3
saylor.org
Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
Part 1: What Is an Information System?
saylor.org
Saylor URL: http://www.saylor.org/courses/bus206 Attributed to: David T. Bourgeois, Ph.D.
Chapter 1: What Is an Information System?
David T. Bourgeois
Learning Objectives
Upon successful completion of this chapter, you will be able to:
• define what an information system is by identifying its major components; • describe the basic history of information systems; and • describe the basic argument behind the article “Does IT Matter?” by Nicholas Carr.
Posted on

Teleconferencing

 
Project Objective
Chatting or Teleconferencing is a process of using technology to bring human beings and their ideas together in spite of the geographical obstacles. A broadcast Chat server has two types of broadcasting and the first one is Public and for this case the message is broadcast to all connected users and the other one is Private and this means the broadcasting will be limited between two clients. Through the help of this chat server, the users can easily communicate and also keep in touch with each other. The end users have the capability to share all kinds of information with other users also such as sending of various files, records and emails. The Broadcasting Chat Server Project that is required to run this project is JRE or the Java Run time Environment software and the users interact with the server through a Graphical User Interface.
Proposed System
The proposed system is a chat application that works in two forms and the first one is the List form. In this form, all the names of the systems connected to a network are drafted. These names can later be utilized for communication with the assistance of mouse event, or in simple language such as a click or a double click.
Secondly, there is the Chat form and it is called only when an element is selected from the List form. In this form, a connection is created between the host system and the selected system with the help of a socket. Additionally, all the end users will see other logged in user’s details very efficiently including their logged in time, time spent online and also their personal data like name and messages. The server will provide advanced security feature which will be maintaining the log in information of the users and the user’s list with details.

Broadcasting Chat Server Modules

 
Server Application: The server application module handles the section of messages being sent and received by the broadcasting server. This module is associated with the SSL techniques and TCP/IP networking technologies. This module contains certain intrinsic logic’s which allow it to convey data about sent messages, appropriate routes of dispatching as well as receiving messages.
Client Application: This module grants access to the user or the client to get logged in with authentic username and password. The client or the user of the system can go through the definite process of message sending in this category with other users of the system.

Software Requirements

· Oracle
· Jdk
· Eclipse
· Netbeans
· notepad

Hardware Requirements

· Hard Disk – 2 GB.
· RAM – 1 GB.
· Processor – Dual Core or Above.
· Mouse.
· Keyboard.
· Monitor.
· Printer.

Technologies Used

· Java
The server is designed to execute only on machines which support the windows operating system and will use approximately 700 lines of code. Some features of the application are as follows:
· This application is used for sending messages from one client to all clients. To be precise, the server grabs a message from the sender client and conveys it to all clients. If any client wants to join the chatting session then he/she executes the client application on client end, enters the login name and clicks on the login button and starts the chatting with every client.
· The server is maintaining the list of user names including the client name. After creating the connection with server, the client sends the user name to server and server holds it in the arraylist and conveys this arraylist to all clients.
Limitations of the application are as follows:
· This application is used for conveying and receiving the messages but the message is displayed to every client. This means that the application is unable to offer the private chat feature and it is comparable to a multi-party conference.
· Before running the client application, the user has to makes sure the server application is running. If server is not in the execution state then one can’t start the chatting.
 
System documentation
Installing and operating a newly designed system or modifying an existing application requires a comprehensive record of that system’s design. Documentation is essential in diagnosing flaws and making adjustments. Additionally, it serves as a method of communication among the individuals responsible for building, implementing and maintaining the system.
Training
An important element in creating a training plan is to assess the technical skills of those who will actually use the system on a daily basis. For this case, Technical novices will need more in-depth, step-by-step instruction in basics, whereas more experienced computer users will hastily pick up the basics and benefit from more education that explains to them how to use more complicated or advanced features of the software.
 

  1. Test Matrix—Once your proposal/requirements document unambiguously describes EVERYTHING that your project will do it is time to produce a test matrix. This is simply a list (done in Excel or equivalent) of all your system’s requirements. In other words, each row of the spreadsheet will contain one of the system’s requirements. For example, if your system is supposed to allow up to ten simultaneous users then the requirement entry would say, “Ten simultaneous users”. Doing this allows you to easily list all of the system’s requirements so that you’ll remember to design and test each one. The Test Matrix, once approved, will be “frozen” and used during the final demonstration to ensure that each requirement has been adequately fulfilled. Make sure you include ALL of your requirements in this matrix. Remember that the Test Matrix will be used as a grading tool when you demonstrate your project at the end of the term. For each item in the list, you must clearly describe WHAT the feature or function does and also clearly describe HOW it will be tested or verified (will something be measured? will a file be checked? should something happen within a certain period of time? Etc)
Posted on

research report based on Optimal database design

A researching report should be prepared about 1 of these topics :
1-Database security system.
2-Optimal database design.
3-Database management system types and architectures.
4-Database management systems languages and interfaces.
requirements:
1-collect  3  scientific published papers from any digital library, or more but no less.
2-the writer need to read the papers carefully prepare her/his own report to summarize,discuss,and may suggest some new ideas on what she/he read.
3-Do not copy or rephrase written statements in the papers.
4-The collected scientific papers should be submitted with the report.
 

Posted on

Tour Operator Agency Database   

Assignment 5: Tour Operator Agency Database
The  Strayer Oracle Server may be used to test and compile the SQL Queries  developed for this assignment. Your instructor will provide you with  login credentials to a Strayer University maintained Oracle server.
A  multinational tour operator agency has gained new business growth in  the North American market through the use of social media. Its operation  has expanded by 50% within six months and the agency requires an  enhanced data management strategy to sustain their business operations.  Their existing data repository for its reservation processing system is  limited in business intelligence and reporting functionalities. The tour  operator seeks a database management specialist to assist them in  leveraging their data sources to enable them to forecast and project  tour sales appropriately.
Imagine  that you have been hired to fulfill their need of enhancing the data  repository for their current reservation processing system. Upon  reviewing the system, you find that the data structure holds redundant  data and that this structure lacks normalization. The database has the  following characteristics:

  • A  table that stores all the salespersons. The table holds their employee  id, first name, last name and “Tours sold” field. The “Tours sold” field  is updated manually.
  • A  table that stores tour customer data and tours sold. The table holds  customer name, address, city, state, zip code, tour(s) selected, number  of persons in tour, and total amount paid. The current structure will  show the customer more than once, if the customer books multiple tours.
  • A  tour table that is used as a tour rate sheet which holds the tours  offered and the cost per person. Tour rates vary every three (3) months  depending on the tourist season.

Write  a three to four (3-4) page paper in which you propose an enhanced  database management strategy. Your proposal should include the  following:

  1. Design a data model that will conform to the following criteria:
    1. Propose  an efficient data structure that may hold the tour operator’s data  using a normalization process. Describe each step of the process that  will enable you to have a 2nd Normal Form data structure.
    2. Create naming conventions for each entity and attributes.
    3. Conclude  your data model design with an Entity Relationship Model (ERM) that  will visually represent the relationships between the tables. You may  make use of graphical tools with which you are familiar. Note: The graphically depicted solution is not included in the required page length.
  2. Construct  a query that can be used on a report for determining how many days the  customer’s invoice will require payment if total amount due is within 45  days. Provide a copy of your working code as part of the paper.
  3. Using the salesperson table described in the summary above, complete the following:
    1. Construct  a trigger that will increase the field that holds the total number of  tours sold per salesperson by an increment of one (1).
    2. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to.
  4. Support  the reasoning behind using stored procedures within the database as an  optimization process for the database transactions.

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 any chart or drawing tool with which you  are familiar. 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:

  • Explain the fundamentals of how data is physically stored and accessed.
  • Compose conceptual data modeling techniques that capture information requirements.
  • Design a relational database so that it is at least in 3NF.
  • Prepare  database design documents using the data definition, data manipulation,  and data control language components of the SQL language.
  • Use technology and information resources to research issues in the strategic implications and management of database systems.
  • Write  clearly and concisely about topics related to the strategic planning  for database systems using proper writing mechanics and technical style  conventions.
Posted on

Logical and Physical Design

“Logical and Physical Design” Please respond to the following: