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:

Posted on

Planning the DBLC

“Planning the DBLC” Please respond to the following:

Posted on

Deliverable 2: Business Requirements

Project Deliverable 2: Business Requirements
Due Week 4 and worth 150 points
This assignment consists of two (2) sections: a business requirements document and a Gantt chart or 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 for which it is written. 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. 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 an eight to ten (8-10) page original business requirements document for the project plan using the template provided. Note: The template can be found in the Student Center of the online course shell.
a. Describe the project including the following:
i. Describe the scope and analyze how to control the scope.
ii. Identify possible risks, constraints, and assumptions.
iii. Describe the integration with other systems and infrastructure. Note: Database and interface design, security, and networking should be considered.
iv. Define relevant terms that will be used throughout project.
b. 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 Gantt Chart / Project Plan
Use Microsoft Excel or an open source alternative, such as Open Project, to:
2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 1: Project Plan Inception, with all the project tasks.
The specific course learning outcomes associated with this assignment are:

  • Apply integrative information technology solutions with project management tools to solve business problems.
  • Use technology and information resources to research issues in information technology.
  • Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.
Posted on

mobile computing options

Customers use mobile devices for a wide range of shopping and  commercial activities. Mobile devices are becoming an attractive way to  pay for products or conduct banking. Select an organization with which  you regularly do business but not one you have used in a previous  discussion.
o Describe the benefits this organization provides through its mobile computing options. 
o What risks most concern you in using this app? How would you mitigate these risks?

Posted on

Krista Soria

Carefully read, summarize and respond to the following text by Krista Soria  as preparation to our library session. Your response should be between 400-600 words and include a brief summary and discussion. Appropriate response/discussion includes your evaluation or criticism of arguments found in the reading, your own suggestions for extending or modifying these arguments, finding points of connection or contradiction between readings, application of ideas found in the reading to analyze a specific issue of interest to you, and reflections on personal experiences touched on by the reading. Citations are appreciated. Please write and save your posts in a word document or equivalent for your records and upload acceptable files (doc, docx, rtf, pdf) under the corresponding Canvas assignment. Bring a copy of your response to class or be able to access your copy in class.