Data, Information, And Knowledge Assignment

now that you know the definitions of data, information and knowledge, compare and contrast all three terms using the following scenario:

Big Bank runs a free daycare service for all of its employees. The company wants to easily identify employees who use the service and where it is best for parents to pick up their kids based on the multiple locations. The bank locations are all in the city of Chicago. Each location has at least 75 employees. The bank consistently is ranked within the top 100 places to work. Each location offers at least one restaurant on site. Food trucks are brought in once a month for variety.Each employee can have multiple children enrolled in the daycare center.Employees can be described by their employee ID number, first name, last name, phone number, and work location.Children can be described by their first name, last name, gender, and date of birth.Because children are provided with lunch and snacks, it is important to track dietary restrictions (e.g., gluten-free, vegetarian, vegan, food allergies, etc.).Each child is assigned to one of three rooms based on age, maturity, and parents work location.

Develop a 1-page document to compare and contrast the terms data, information, and knowledge. Alternatively, create an infographic using an infographic maker such as Piktochart, Venngage, or Canva.

Include the answers to the following questions in your document or infographic:Why does it matter if an information system developer mixes up the terms data, information, and knowledge?What consequences might result in designing an information system if the terms were interpreted improperly?

Advertisements

Information System Overview Assignment

We interact with information systems every day. For example, libraries have systems that enable you to search for, reserve, and check out books; utilities maintain systems that enable customer service representatives to answer questions about your bill; and your grocery store checkout station is connected to multiple systems that enable the store executives to determine staffing levels, inventory levels, advertising, and promotion efforts.

Select an information system you use on a regular basis.

Create an overview that explains the following:The type of the information systemThe evolution of the selected type of information system. (e.g. the evolution of student financial aid systems in general)How the information system affected jobs and careers. (e.g. before financial aid systems were developed and which jobs supported the function of financial aid that do not exist today due to technology)The names of the components used and a description of the purpose or role of each. (Hint: Use information system components you learned so far.)The benefits this system evolution has brought to you, the organization implementing the change, and other people or organizations within the community

Present your recommendation in one of the following ways:

A 2-page Microsoft® Word document or

A 12 slide Microsoft® PowerPoint® presentation with detailed speaker notes and appropriate animations

Note: You can include diagrams developed with Microsoft® Visio®, Microsoft® PowerPoint®, or another software application approved by your Instructor if you feel it will enhance your recommendation.

Case Study 2: Data Breaches and Regulatory Requirements

Due Week 6 and worth 100 points
The National Institute of Standards and Technology (NIST) provides an extensive amount of information, resources, and guidance on IT and information security topics. The Federal Information Security Management Act (FISMA) provides standards and guidelines for establishing information security within federal systems. However, there have been, and continues to be, numerous security incidents including data breaches within federal systems. Review the information about FISMA at the NIST Website, located at http://csrc.nist.gov/groups/SMA/fisma/index.html. Additionally, review the information, located at http://www.govtech.com/blogs/lohrmann-on-cybersecurity/Dark-Clouds-Over-Technology-042212.html, about the data breaches within government systems. Select one (1) of the data breaches mentioned to conduct a case analysis, or select another based on your research, and research more details about that incident to complete the following assignment requirements. Write a three to five (3-5) page paper on your selected case in which you:

  1. Describe the data breach incident and the primary causes of the data breach.
  2. Analyze how the data breach could have been prevented with better adherence to and compliance with regulatory requirements and guidelines, including management controls; include an explanation of the regulatory requirement (such as from FISMA, HIPAA, or others).
  3. Assess if there are deficiencies in the regulatory requirements and whether they need to be changed, and how they need to be changed, to mitigate further data breach incidents.
  4. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Assignment 5: Tour Operator Agency Database 

Due Week 6 and worth 90 points

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.

Data communications systems

Research

Data communications systems that can be use in airports, such as Cisco’s IP Communication.

Assignment

Prepare a 1 to 2-page paper that discusses how this type of system can be used to and the benefits to the entity that has the system installed.

• 500-word minimum, not including Reference or Cover Page

• Current APA format

• Double Spaced

• Minimum of 2 references (e.g., scholarly, peer-reviewed, from reputable sources), in the Reference section at the end of the paper.

Assignment 3: University Database

Due Week 3 and worth 120 points  A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. Imagine that you have been hired as a database consultant to assist in the development of a data design strategy for the student records.   You met with various university subject matter experts and have determined the following after performing various business analysis processes: •Faculty groups are divided by core competencies that the university offers. For example, there are groups such as the Art Faculty, Computer Technology Faculty, Language Faculty, and Science Faculty. Each faculty member has an assigned Dean and is designated to teach at one particular campus and school. They are able to teach as many courses as required.. •Courses are categorized by course code and title. Certain courses have prerequisites and the university has asked for this to be cataloged as well.. •There are various schools within each campus. For example, the Los Angeles campus holds the following schools: School of Science, School of Law, and School of Computer Technology. Additionally, each school offers different professional study programs such as Forensic Computer Science, Marine Biology, Business Management, and Civil Engineering to name a few. . •The study path for students requires that they be enrolled in a specific professional study program. The professional study program requires the students to complete a specific set of core courses. The university also requires that an online grade book be available. The online grade book should show grades awarded to students for specific courses and the term they completed the course.. •The university identifies each student by his or her name, date of birth, social, and professional study program..  Using these findings, write a three to four (3-4) page paper in which you: 1.Analyze the university’s requirements and provide a proposal to organize all the required data elements. The proposal should include the following: a.Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements. Note: The graphically depicted solution is not included in the required page length.. b.Describe any assumptions or limitations for each relationship. For example, professors are able to teach more than one course or students can only be enrolled in one program.. . 2.Create the primary key and foreign keys using a UML Class diagram for each table.. 3.Suggest at least four (4) types of business intelligence reports that could help the university in course management, student enrollment, or historical tracking. Support your answer by providing specific business functions that these reports could assist executives of the university.. 4.As an alternative for development of the database, you are considering outsourcing the functions above. Research the Internet and other media sources for vendors who develop registrar and school management database systems. a.Suggest three (3) vendors that developed and are employing efficient registrar and school management database systems and support your reasons to choose from one (1) of these three (3) vendors.. b.Compare and contrast the key aspects that each system offers. Examples of system aspects include but not limited to cloud based, pricing model, open source, etc.. . 5.Use at least three (3) 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.. •Include charts or diagrams created in any chart or drawing tools 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: •Describe the role of databases and database management systems in managing organizational data and information.. •Recognize the historical development of database management systems and logical data models.. •Design and implement a database solution to solve a proposed business problem.. •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..

Security Fundamentals

Your electronics manufacturing company is working on a new product. The board of directors thinks that this product will revolutionize the travel industry and generate huge profits for the company. To protect this product during the research and development cycle, the company is planning to install a new network consisting of a dozen computers. Your company selected you to lead a team that will develop a subset of a security plan for the network.

In 1-2 pages, write a report on the following:

  • Propose a detailed plan that focuses on password policies and authentication methods to protect the project from becoming public during the research and development phase.
  • Include an estimated cost of your plan.