Description
Store ten basketball player names and their and their points scored in the last game in a text file such as Notepad. There will be one score per player..
Write a Windows Forms application in C# to retrieve the names and the scores.
Display the player name with the highest score and the average points scored for all players..
Show what is being written in the new file.
Hint: You might consider adding delimiters between the data values in the original text file to simplify retrieving and processing the data.
_________________________________________________________________________________________________________________
Using Microsoft® Visual Studio®, develop the details of each section using the program in Week Two.
Review the following for an example:
- Adding students - The following data should be collected from student users:
- First name
- Last name
- Student ID number
- Address
- Phone
- Degree program
- Adding faculty members - The following data should be collected from faculty users:
- First name
- Last name
- Faculty ID number
- Address
- Phone
- College program
- Adding courses - The following data should be collected:
- Course number
- Course description
- Start date
- End date
- Location
- Number of credits
- Faculty ID number
The program should store user inputs in flat files.
Hint: Use a class to create custom types.
This is a two part project and for project two everything is already there with the attached file all we have to do is adding the data in. The data is in the Word file that I will provide once a tutor pick this assignment up.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Here is ...
Completion Status:
100%
Review
Review
Anonymous
Great study resource, helped me a lot.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
BMIS 510 Liberty University Mom & Pop Pizza Enterprise System Case Diagram
Modeling Exercise 3 Instructions Overview For this modeling exercise, you will revisit the scenario given in the Modelin ...
BMIS 510 Liberty University Mom & Pop Pizza Enterprise System Case Diagram
Modeling Exercise 3 Instructions Overview For this modeling exercise, you will revisit the scenario given in the Modeling Exercise 2 Instructions document and consider the following, additional information. Materials Required To complete this deliverable, you will need the following materials This documentMicrosoft WordLucidChart.com, http://draw.io, StarUML (http://staruml.io), PlantUML (http://plantuml.com), or Microsoft Visio Scenario During your first visit to the restaurant, you conducted interviews with several people to better understand their responsibilities and job functions. The following descriptions are from the notes taken during that initial visit. Owner: The owner created the Mom & Pop Pizza 8 years ago and is now looking at opening a second store by year 10. In the planning for this, his family has convinced him that franchising the operation could be very successful. One large barrier to franchising is that of a consistent repeatable process. Therefore, the owner has decided to contact you to design an enterprise IT system that would be scalable to support a multi-state franchise. That being said, the owner has no vision of what this system would look like. He is a pizza chef, not an IT consultant/designer. Manager: The manager runs the day-to-day operations, as well as the hiring/firing/training; the manager is required to schedule all employees. Finally, the manager is responsible for inventorying and ordering the supplies needed. He orders supplies once a week. Hostess: The hostess greets customers and takes reservations over the phone. The hostess also takes delivery/takeout orders and arranges for delivery drivers. The hostess also seats customers when tables become available. Waiter: The waiter takes customer orders, delivers orders to one of the cooks, and takes drinks and food to the customers. The waiter also delivers the bill to the customer, takes money (or credit cards) to the hostess for processing, and returns change (or credit card receipt for signing). Cook: The cook receives orders from the wait staff and prepares the customer’s selections. Food Prep: The food prep prepares sauces and dough for cook’s use; he/she also prepares salad and all other side dishes. Busboy: The busboy cleans tables after customers leave, preparing the tables for the next customers. The busboy also delivers dirty dishes to the dishwasher. Accountant: The owner has traditionally filled the accountant role. He tallies receipts at the end of the day and makes bank deposits. He pays all the bills on a bi-weekly basis. He accounts for all employee hours, and every 2 weeks, he prepares payroll checks. He files all IRS and tax documentation and manages the health and benefits plans of the employees. Instructions With a revised business process in hand, it is time to begin identifying the key ways that you anticipate the users will interact with M&P PIES. To do that, you will create a use case diagram and 5 use case scenarios to model those interactions. It is important to note that a use case reflects the direct interaction that a user will have with the system, not an activity that takes place outside the system. For example, we would not want to create a use case for preparation of sauces, unless we were designing the system to have some role in that activity. For this third exercise, develop a use-case diagram showing all actors and use cases for the proposed, to-be system, and then choose 5 use cases from your use-case diagram and write a detailed use case scenario for each one. You will need to refer back to the to-be process description given in Modeling Exercise 2 instructions, as well as the notes provided above from the user interviews. As you complete this exercise, keep the following in mind: Refer to the Modeling Exercise grading rubric before you begin this exercise.Even though we are now modeling the use cases for a technology system, the use cases should still avoid references to any specific technology. The purpose of this diagram is to visually communicate with the client the way we expect them to use the new system. As such, your diagram should be easy to read for a non-technical person, follow correct UML syntax for use case diagrams (see the UML textbook), and include a proper title and legend (you will need to draw the legend manually, using the unique shapes used in the diagram along with a short textual description of what each shape represents).Be sure to model your use cases such that they represent actual interactions with the system and not activities that would occur outside the context of the new system.Don’t forget to include a system boundary in your use-case diagram.There are no set-in-stone solutions for this exercise. Just as in the real world, there are no off-the-shelf solutions for every IT challenge. It is not our intention to limit your creative knowledge designs.The instructor may make suggestions or add additional requirements in the weekly announcements for each modeling exercise, so be sure to heed those suggestions as you prepare your models, or you may lose points. Submit this assignment by 11:59 p.m. (ET) on Sunday of Module/Week 6.
Networking Foundations & Points Dedicated to Line Processing Lab Report
Given a list of courses and their prerequisites, compute the order in which courses must be taken so that when taking a co ...
Networking Foundations & Points Dedicated to Line Processing Lab Report
Given a list of courses and their prerequisites, compute the order in which courses must be taken so that when taking a courses, all its prerequisites have already been taken.All the files that the program would read from are in Unix formatYou must create a directed graph corresponding to the data in the file.The graph will have as many vertices as different courses listed in the file.You can represent the vertices and edges however you want. For each line in the file, the code can extract the first course and the prerequisites for it.If you cannot process each line in the file correctly, you can use a modified input file that shows on each line, the number of courses, but you would lose the 15 points dedicated to line processing. If your program works with the "easy files", in order to make it easy for the TAs to know which file to provide, please name your C program courses_graph_easy.c.
GMU Why You Think that Requirements Engineering Has Proven Difficult in Practice Ques
Instructions Several of the questions use the scenario below. Please read carefully, and perhaps store or print separately ...
GMU Why You Think that Requirements Engineering Has Proven Difficult in Practice Ques
Instructions Several of the questions use the scenario below. Please read carefully, and perhaps store or print separately where you can read it when answering these questions."You are on a team to develop an on-line system for the Marymount University graduation petition. The student will fill out an application which will be available from the Registrar’s Web page. The students use their username and password to log into the application and the system validates that the user ID is a current student and identify their major and any specialty and minor. The students enter further information when they estimate when they will be graduating. The Registrar’s Office records the information in a separate Excel file that includes which students are thought to be walking in the spring ceremony and passes on the information to the appropriate school Dean. The Dean sends it to the student’s advisor who looks at the degree plan and documents which classes are needed before graduation and send this information back to the Dean. The Dean notifies the students of their requirements and notifies the Registration Office of whether it is likely that the student will graduate at the time they indicated. The Registrar’s updates their Excel spreadsheet accordingly."1- Give three reasons why you think that requirements engineering has proven difficult in practice2- In your own words, describe the four phases of the requirements engineering process with one sentence describing each phase3- In a use-case, the "actor" is an important concept. Who are the actors in the scenario above?4- For a use case diagram, what information is recorded on the right side of the diagram. Give an example from the scenario above.5- In what type of SDLCs would you expect to make use of the use case methodology and why?6- Write a user story in the required format for the student applying for the graduation petition in the scenario above7- In what type of SDLCs would you expect to make use of the user story methodology and why?8- Explain the role of the "epic" user story and how it differs from the usual user story.9- Write a user story for the Dean's office in the distribution of validation requests to advisors10- Write two conditions of acceptance for either the student entering their graduation petition (question 6) or the Dean's office distributing the request (Question 9)
Lab 4: Structured Query Language (SQL), assignment help
Lab 4: Structured Query Language (SQL)Due Week 7 and worth 75 pointsRefer to the database design crested in Lab 2: Modifyi ...
Lab 4: Structured Query Language (SQL), assignment help
Lab 4: Structured Query Language (SQL)Due Week 7 and worth 75 pointsRefer to the database design crested in Lab 2: Modifying a Database Design to complete this Lab. Perform the following steps in MySQL:Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine the field values). Create a query with all fields from the student table, where the student's last name is "Smith".Create a query that includes students’ first names, last names, and phone numbers.Create a query that includes instructors' first names, last names, and courses they teach. Include the following screen shots in a Microsoft Word document to show the completion of the steps above:Screen shot depicting the tables created within MySQL.Screen shots depicting the records added into each table.Screen shots depicting the SQL code and the query results from each of the queries created.Your assignment must follow these formatting requirements:Submit the lab as a Microsoft Word document.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 is not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.Click here to view the grading rubric for this assignment.
CSCI 2370 Columbus State Community College Database Creatiion Lab
This will be a test of what you have learned this quarter and opportunity for you to show some of those skills. As
many o ...
CSCI 2370 Columbus State Community College Database Creatiion Lab
This will be a test of what you have learned this quarter and opportunity for you to show some of those skills. As
many of you go into the world, there will be opportunities to create database systems for other people. But it is
generally not enough to simply say yes or give a high level description of what you're going to deliver. So this
assignment was created to give you the framework for how to tackle a consulting opportunity as a database
system developer.
You may choose the specific entity of your choice. Could be a school, a retail establishment, education, etc. It's up
to you. Pick a domain that you somewhat understand. Don't pick something that is imaginary. This should be
something relatively simple and straightforward.
Your deliverables - I expect this to be in the form of a report. It should be very clear on the technical
recommendations and what you completed.
- High level description of the business. This description should encompass the points of interests in your
future data model such as Customer, Employee, Sales, etc.
-Visio Diagram displaying the entity relationships. Should include cardinality, primary and foreign
keys. There should be a minimum of 6 tables.
-Implement your Diagram.
-Populate data into tables. No empty tables.
-Recommend 2 views that might make it easier for them to perform business related analysis.
-Implement the Views. -Recommend a Trigger for solving a problem in your diagram. When data is inserted here this should
happen etc.
-Implement your Trigger. -Recommend 2 Procedures for addressing a problem the business might experience. Print invoices for
all pending payments?
-Implement the Procedures. needs to be done in SQL, once complete I will transfer it to Oracle database to complete the assignment.
University of the Cumberlands Network Survey Design & Plan Presentation
Project Part 1: Network Survey
Introduction
Network defenses rely first on understanding the current configuration of host ...
University of the Cumberlands Network Survey Design & Plan Presentation
Project Part 1: Network Survey
Introduction
Network defenses rely first on understanding the current configuration of hosts, services, and protocols in use within the organization. Before it is possible to plan to change anything, you must first understand what is present and where it is located within the network. The initial phase of any network security realignment process involves identifying existing resources.
Scenario
You have been working as a technology associate in the information systems department at Corporation Techs. The Corporation Techs’ management is concerned that they are losing business to a competitor whose bids are too accurately just under the bids offered by Corporation Techs––by an exact amount. A security firm was contracted to conduct a review of Corporation Techs' systems, identifying unauthorized access to the Web server as a potential source of compromise due to the shared reporting and public Web site functions. The packet trace and vulnerability scans gathered during this review are available for your use.
The Web server provides public access to the organization's static Web site for contact information, while sales team members in the field transfer contract and bid documents using a site secured with a logon and password. Corporation Techs has budgeted for new networking hardware but does not want to add additional servers due to cooling issues. Your manager has asked you to create a security plan that will prevent unauthorized access, while making sure that both public and secured Web access remain available.
Tasks
The data and information you need to complete this part of the project are provided to you. (See the Required Source Information and Tools section at the beginning of this document.) In this part of the project, you need to conduct a survey of the existing hosts, services, and protocols within Corporation Techs' network. Specifically, you need to:
1.Access the PCAP data using NetWitness Investigator.
2.Identify hosts within the Corporation Techs’ network.
3.Identify protocols in use within the Corporation Techs’ network.
Develop a list of hosts and services provided by each.
Create a professional report detailing the information above as the initial document for development of the network security plan.
Write the network survey results as detailed in the instructions above.
Project Part 2: Network Design
Introduction
As discussed so far in this course, the configuration of a network affects the options available for security and network defense. Using the network survey produced during the first part of this project, together with host vulnerability assessments and access requirements, you need to design an updated network structure.
Scenario
You have been working as a technology associate the information systems department at Corporation Techs for a while now. You have discovered so far that all of Corporation Techs’ computer systems share the same Class C public IP address range, including workstations along with servers providing authentication, e-mail, and both secure and public Web sites.
Your next task in this project is to construct a basic network design. An important requirement for the network design is to reduce the number of public addresses needed as the subnet lease results in very high ISP costs.
Tasks
Construct a basic network design, separating private and public services within the Corporation Techs’ network. To do so, you must:
1.Access the PCAP files using NetWitness Investigator, and browse the Nmap scan (XML format), topology fisheye chart (PDF format), and Nessus report (HTML format).
2.Identify vulnerabilities and clear-text information transfer.
3.Conduct research and determine the best network design to ensure security of internal access while retaining public Web site availability.
4.Identify any opportunities for reduced ISP costs through port redirection or address translation.
5.Design a network configuration, identifying network gateways, port or address redirection systems, and the location of hosts within private and protected network segments.
6.Create a professional report detailing the information above as supportive documentation for the network security plan.
Create a report that includes a basic network diagram and research results.
Final Project: Network Security Plan
Scenario
You have been working as a technology associate in the information systems department at Corporation Techs for three months now. You have conducted a network survey and developed a basic network design intended to provide security for private network resources and publically exposed Web services.
Your manager specified that all information transferred between the sales team in the field and the organizational servers must be protected against snooping. The manager also wants the secured reporting site to be available only through the organization's private network so that an outsourced network-based intrusion detection system (NIDS) service can log all connections.
Tasks
You need to recommend a network design and identify hardening strategies intended to meet the requirements. To do so, you must:
1.Access the PCAP and other scan data for this project.
2.Conduct research and determine the best network design to meet the stated requirements.
3.Research hardening strategies and identify recommended mitigation strategies for identified vulnerabilities.
4.Identify mechanisms for secure network access by remote users, both in terms of secure Web access as well as reporting access conducted using the private network.
5.Develop a network security plan including network realignment, hardening practices, and policies for remote resource access.
6.Identify expectations from recommended changes and provide justification for each recommendation in simple language so that primary stakeholders are able to understand it.
Create a professional report detailing the information above, presented as a recommendation for a network security realignment project for Corporation Techs. Include persuasive justification and measurable expectations as part of this recommendation.
Write the network design results as detailed in the instructions above. Your plan should be made using a standard word processor format compatible with Microsoft Word.
Similar Content
Numerical methods final project, programming homework help
All of the assignment...
The University of Texas at Arlington Hangman Game Programming Project
TASK 1: HANGMAN GAME (EASY VERSION)Save your program as HW9_Hangman.javaImplement a Hangman game. The computer will choose...
University of Maryland Conversational Platforms the Future Discussion
Conversational AI is a chatbot that is designed to interact with humans via text or audio messages. The future of conversa...
University of California San Diego R Studio Programming Code
...
COP 3337 FIU Polymorphism & ArrayList Command Java Programming Exercise
The project will create a class called Major. The Major class will be the base class for the variety of different major op...
BGSH Dutch Oven Bread Code Question
The instructions are in the document. Write pseudocode for the C++ code. (in a .txt file ONLY) and a C++ program following...
Programming Chapter Questions
1. all of the choices listed are uses of Excel 2. The cell address first lists the row name and then the column name...
Footprinting
Passive scanning is a vulnerability scanning technique that depends on the information acquired from network data and capt...
Sql Assignment
/* What is the total distance flown by all of the planes in January 2013? */ SELECT SUM(distance) as "Total Distance" FROM...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
BMIS 510 Liberty University Mom & Pop Pizza Enterprise System Case Diagram
Modeling Exercise 3 Instructions Overview For this modeling exercise, you will revisit the scenario given in the Modelin ...
BMIS 510 Liberty University Mom & Pop Pizza Enterprise System Case Diagram
Modeling Exercise 3 Instructions Overview For this modeling exercise, you will revisit the scenario given in the Modeling Exercise 2 Instructions document and consider the following, additional information. Materials Required To complete this deliverable, you will need the following materials This documentMicrosoft WordLucidChart.com, http://draw.io, StarUML (http://staruml.io), PlantUML (http://plantuml.com), or Microsoft Visio Scenario During your first visit to the restaurant, you conducted interviews with several people to better understand their responsibilities and job functions. The following descriptions are from the notes taken during that initial visit. Owner: The owner created the Mom & Pop Pizza 8 years ago and is now looking at opening a second store by year 10. In the planning for this, his family has convinced him that franchising the operation could be very successful. One large barrier to franchising is that of a consistent repeatable process. Therefore, the owner has decided to contact you to design an enterprise IT system that would be scalable to support a multi-state franchise. That being said, the owner has no vision of what this system would look like. He is a pizza chef, not an IT consultant/designer. Manager: The manager runs the day-to-day operations, as well as the hiring/firing/training; the manager is required to schedule all employees. Finally, the manager is responsible for inventorying and ordering the supplies needed. He orders supplies once a week. Hostess: The hostess greets customers and takes reservations over the phone. The hostess also takes delivery/takeout orders and arranges for delivery drivers. The hostess also seats customers when tables become available. Waiter: The waiter takes customer orders, delivers orders to one of the cooks, and takes drinks and food to the customers. The waiter also delivers the bill to the customer, takes money (or credit cards) to the hostess for processing, and returns change (or credit card receipt for signing). Cook: The cook receives orders from the wait staff and prepares the customer’s selections. Food Prep: The food prep prepares sauces and dough for cook’s use; he/she also prepares salad and all other side dishes. Busboy: The busboy cleans tables after customers leave, preparing the tables for the next customers. The busboy also delivers dirty dishes to the dishwasher. Accountant: The owner has traditionally filled the accountant role. He tallies receipts at the end of the day and makes bank deposits. He pays all the bills on a bi-weekly basis. He accounts for all employee hours, and every 2 weeks, he prepares payroll checks. He files all IRS and tax documentation and manages the health and benefits plans of the employees. Instructions With a revised business process in hand, it is time to begin identifying the key ways that you anticipate the users will interact with M&P PIES. To do that, you will create a use case diagram and 5 use case scenarios to model those interactions. It is important to note that a use case reflects the direct interaction that a user will have with the system, not an activity that takes place outside the system. For example, we would not want to create a use case for preparation of sauces, unless we were designing the system to have some role in that activity. For this third exercise, develop a use-case diagram showing all actors and use cases for the proposed, to-be system, and then choose 5 use cases from your use-case diagram and write a detailed use case scenario for each one. You will need to refer back to the to-be process description given in Modeling Exercise 2 instructions, as well as the notes provided above from the user interviews. As you complete this exercise, keep the following in mind: Refer to the Modeling Exercise grading rubric before you begin this exercise.Even though we are now modeling the use cases for a technology system, the use cases should still avoid references to any specific technology. The purpose of this diagram is to visually communicate with the client the way we expect them to use the new system. As such, your diagram should be easy to read for a non-technical person, follow correct UML syntax for use case diagrams (see the UML textbook), and include a proper title and legend (you will need to draw the legend manually, using the unique shapes used in the diagram along with a short textual description of what each shape represents).Be sure to model your use cases such that they represent actual interactions with the system and not activities that would occur outside the context of the new system.Don’t forget to include a system boundary in your use-case diagram.There are no set-in-stone solutions for this exercise. Just as in the real world, there are no off-the-shelf solutions for every IT challenge. It is not our intention to limit your creative knowledge designs.The instructor may make suggestions or add additional requirements in the weekly announcements for each modeling exercise, so be sure to heed those suggestions as you prepare your models, or you may lose points. Submit this assignment by 11:59 p.m. (ET) on Sunday of Module/Week 6.
Networking Foundations & Points Dedicated to Line Processing Lab Report
Given a list of courses and their prerequisites, compute the order in which courses must be taken so that when taking a co ...
Networking Foundations & Points Dedicated to Line Processing Lab Report
Given a list of courses and their prerequisites, compute the order in which courses must be taken so that when taking a courses, all its prerequisites have already been taken.All the files that the program would read from are in Unix formatYou must create a directed graph corresponding to the data in the file.The graph will have as many vertices as different courses listed in the file.You can represent the vertices and edges however you want. For each line in the file, the code can extract the first course and the prerequisites for it.If you cannot process each line in the file correctly, you can use a modified input file that shows on each line, the number of courses, but you would lose the 15 points dedicated to line processing. If your program works with the "easy files", in order to make it easy for the TAs to know which file to provide, please name your C program courses_graph_easy.c.
GMU Why You Think that Requirements Engineering Has Proven Difficult in Practice Ques
Instructions Several of the questions use the scenario below. Please read carefully, and perhaps store or print separately ...
GMU Why You Think that Requirements Engineering Has Proven Difficult in Practice Ques
Instructions Several of the questions use the scenario below. Please read carefully, and perhaps store or print separately where you can read it when answering these questions."You are on a team to develop an on-line system for the Marymount University graduation petition. The student will fill out an application which will be available from the Registrar’s Web page. The students use their username and password to log into the application and the system validates that the user ID is a current student and identify their major and any specialty and minor. The students enter further information when they estimate when they will be graduating. The Registrar’s Office records the information in a separate Excel file that includes which students are thought to be walking in the spring ceremony and passes on the information to the appropriate school Dean. The Dean sends it to the student’s advisor who looks at the degree plan and documents which classes are needed before graduation and send this information back to the Dean. The Dean notifies the students of their requirements and notifies the Registration Office of whether it is likely that the student will graduate at the time they indicated. The Registrar’s updates their Excel spreadsheet accordingly."1- Give three reasons why you think that requirements engineering has proven difficult in practice2- In your own words, describe the four phases of the requirements engineering process with one sentence describing each phase3- In a use-case, the "actor" is an important concept. Who are the actors in the scenario above?4- For a use case diagram, what information is recorded on the right side of the diagram. Give an example from the scenario above.5- In what type of SDLCs would you expect to make use of the use case methodology and why?6- Write a user story in the required format for the student applying for the graduation petition in the scenario above7- In what type of SDLCs would you expect to make use of the user story methodology and why?8- Explain the role of the "epic" user story and how it differs from the usual user story.9- Write a user story for the Dean's office in the distribution of validation requests to advisors10- Write two conditions of acceptance for either the student entering their graduation petition (question 6) or the Dean's office distributing the request (Question 9)
Lab 4: Structured Query Language (SQL), assignment help
Lab 4: Structured Query Language (SQL)Due Week 7 and worth 75 pointsRefer to the database design crested in Lab 2: Modifyi ...
Lab 4: Structured Query Language (SQL), assignment help
Lab 4: Structured Query Language (SQL)Due Week 7 and worth 75 pointsRefer to the database design crested in Lab 2: Modifying a Database Design to complete this Lab. Perform the following steps in MySQL:Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine the field values). Create a query with all fields from the student table, where the student's last name is "Smith".Create a query that includes students’ first names, last names, and phone numbers.Create a query that includes instructors' first names, last names, and courses they teach. Include the following screen shots in a Microsoft Word document to show the completion of the steps above:Screen shot depicting the tables created within MySQL.Screen shots depicting the records added into each table.Screen shots depicting the SQL code and the query results from each of the queries created.Your assignment must follow these formatting requirements:Submit the lab as a Microsoft Word document.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 is not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.Click here to view the grading rubric for this assignment.
CSCI 2370 Columbus State Community College Database Creatiion Lab
This will be a test of what you have learned this quarter and opportunity for you to show some of those skills. As
many o ...
CSCI 2370 Columbus State Community College Database Creatiion Lab
This will be a test of what you have learned this quarter and opportunity for you to show some of those skills. As
many of you go into the world, there will be opportunities to create database systems for other people. But it is
generally not enough to simply say yes or give a high level description of what you're going to deliver. So this
assignment was created to give you the framework for how to tackle a consulting opportunity as a database
system developer.
You may choose the specific entity of your choice. Could be a school, a retail establishment, education, etc. It's up
to you. Pick a domain that you somewhat understand. Don't pick something that is imaginary. This should be
something relatively simple and straightforward.
Your deliverables - I expect this to be in the form of a report. It should be very clear on the technical
recommendations and what you completed.
- High level description of the business. This description should encompass the points of interests in your
future data model such as Customer, Employee, Sales, etc.
-Visio Diagram displaying the entity relationships. Should include cardinality, primary and foreign
keys. There should be a minimum of 6 tables.
-Implement your Diagram.
-Populate data into tables. No empty tables.
-Recommend 2 views that might make it easier for them to perform business related analysis.
-Implement the Views. -Recommend a Trigger for solving a problem in your diagram. When data is inserted here this should
happen etc.
-Implement your Trigger. -Recommend 2 Procedures for addressing a problem the business might experience. Print invoices for
all pending payments?
-Implement the Procedures. needs to be done in SQL, once complete I will transfer it to Oracle database to complete the assignment.
University of the Cumberlands Network Survey Design & Plan Presentation
Project Part 1: Network Survey
Introduction
Network defenses rely first on understanding the current configuration of host ...
University of the Cumberlands Network Survey Design & Plan Presentation
Project Part 1: Network Survey
Introduction
Network defenses rely first on understanding the current configuration of hosts, services, and protocols in use within the organization. Before it is possible to plan to change anything, you must first understand what is present and where it is located within the network. The initial phase of any network security realignment process involves identifying existing resources.
Scenario
You have been working as a technology associate in the information systems department at Corporation Techs. The Corporation Techs’ management is concerned that they are losing business to a competitor whose bids are too accurately just under the bids offered by Corporation Techs––by an exact amount. A security firm was contracted to conduct a review of Corporation Techs' systems, identifying unauthorized access to the Web server as a potential source of compromise due to the shared reporting and public Web site functions. The packet trace and vulnerability scans gathered during this review are available for your use.
The Web server provides public access to the organization's static Web site for contact information, while sales team members in the field transfer contract and bid documents using a site secured with a logon and password. Corporation Techs has budgeted for new networking hardware but does not want to add additional servers due to cooling issues. Your manager has asked you to create a security plan that will prevent unauthorized access, while making sure that both public and secured Web access remain available.
Tasks
The data and information you need to complete this part of the project are provided to you. (See the Required Source Information and Tools section at the beginning of this document.) In this part of the project, you need to conduct a survey of the existing hosts, services, and protocols within Corporation Techs' network. Specifically, you need to:
1.Access the PCAP data using NetWitness Investigator.
2.Identify hosts within the Corporation Techs’ network.
3.Identify protocols in use within the Corporation Techs’ network.
Develop a list of hosts and services provided by each.
Create a professional report detailing the information above as the initial document for development of the network security plan.
Write the network survey results as detailed in the instructions above.
Project Part 2: Network Design
Introduction
As discussed so far in this course, the configuration of a network affects the options available for security and network defense. Using the network survey produced during the first part of this project, together with host vulnerability assessments and access requirements, you need to design an updated network structure.
Scenario
You have been working as a technology associate the information systems department at Corporation Techs for a while now. You have discovered so far that all of Corporation Techs’ computer systems share the same Class C public IP address range, including workstations along with servers providing authentication, e-mail, and both secure and public Web sites.
Your next task in this project is to construct a basic network design. An important requirement for the network design is to reduce the number of public addresses needed as the subnet lease results in very high ISP costs.
Tasks
Construct a basic network design, separating private and public services within the Corporation Techs’ network. To do so, you must:
1.Access the PCAP files using NetWitness Investigator, and browse the Nmap scan (XML format), topology fisheye chart (PDF format), and Nessus report (HTML format).
2.Identify vulnerabilities and clear-text information transfer.
3.Conduct research and determine the best network design to ensure security of internal access while retaining public Web site availability.
4.Identify any opportunities for reduced ISP costs through port redirection or address translation.
5.Design a network configuration, identifying network gateways, port or address redirection systems, and the location of hosts within private and protected network segments.
6.Create a professional report detailing the information above as supportive documentation for the network security plan.
Create a report that includes a basic network diagram and research results.
Final Project: Network Security Plan
Scenario
You have been working as a technology associate in the information systems department at Corporation Techs for three months now. You have conducted a network survey and developed a basic network design intended to provide security for private network resources and publically exposed Web services.
Your manager specified that all information transferred between the sales team in the field and the organizational servers must be protected against snooping. The manager also wants the secured reporting site to be available only through the organization's private network so that an outsourced network-based intrusion detection system (NIDS) service can log all connections.
Tasks
You need to recommend a network design and identify hardening strategies intended to meet the requirements. To do so, you must:
1.Access the PCAP and other scan data for this project.
2.Conduct research and determine the best network design to meet the stated requirements.
3.Research hardening strategies and identify recommended mitigation strategies for identified vulnerabilities.
4.Identify mechanisms for secure network access by remote users, both in terms of secure Web access as well as reporting access conducted using the private network.
5.Develop a network security plan including network realignment, hardening practices, and policies for remote resource access.
6.Identify expectations from recommended changes and provide justification for each recommendation in simple language so that primary stakeholders are able to understand it.
Create a professional report detailing the information above, presented as a recommendation for a network security realignment project for Corporation Techs. Include persuasive justification and measurable expectations as part of this recommendation.
Write the network design results as detailed in the instructions above. Your plan should be made using a standard word processor format compatible with Microsoft Word.
Earn money selling
your Study Documents
