Description
Unformatted Attachment Preview
CIS 340 – Business Information Systems Development I
Mini Project 2
Purpose
Learn how to solve problems using Object-Oriented Design/Programming concepts.
Description
You will be using the Eclipse IDE for your Java programming.
Overview
An area library is considering letting patrons checkout electronic devices such as tablets and eReaders. It is
therefore commissioning a prototype of a Device Management and Checkout System (DMCS) by a group of
talented CIS developers studying Object-Oriented Design/Programming!
To begin, the library would like to start building a basic list of devices they have in stock. Having a prototype
would give them the ability to see both possibilities and shortcomings, refine their own requirements and
expectations, and then go to a software development consultant. In their basic prototype, the library would
like a demonstration of a simple system which allows maintenance of device information.
Following are the general specifications of what the library wants. While there are some specifics provided,
the library leaves the nitty-gritty implementation details in the good hands of its capable developers team.
The library maintains a list of electronic devices. Each device has a Stock Keeping Unit (SKU) code, which is an
alphanumeric code up to 6 letters long. Each device also has a name. The library would like to keep track of
whether or not a device is available to loan. Devices that are checked out already are considered “not
available”, whereas devices that are “available” can be checked out.
Since the library is commissioning an object-oriented prototype, they would really like objects to model
devices. Each device “object” should have in it all the attributes which need to be tracked.
The library has heard arrays are a good way to store a series of logically related objects although they don’t
know much about them. They hope that their talented developers will come up with some sophisticated
design that would be reusable and extensible in the years to come!
For its management purposes, the library would like the following. A main menu should present the user with
options. Users should be able to see a list of devices, add a new device, edit an existing device, search for a
device by name, and check out a device. The main menu should ask which option the user would like to select
and perform that action. After completion, the user should be brought back to the main menu. The main
© Copyright Arizona Board of Regents | K. Roumina
1
menu should also allow users to cleanly exit the application. Also, needless to say, the library would prefer if
its application did not crash! That would be a bad result for the development team.
Sample Output
Instead of screenshots, please review the videos posted to this item on the course site. Posted videos cover
the required functionality and error-handling features.
Requirements
1. General
a. Name your project MP2
b. Use object-oriented design to create classes and utilize instance and methods
i. There should be little to no use of static variables and methods
2. Features/Specifics
The application should allow the user to:
a. Display a list of devices
b. Add a new device
i. Ask users for details of each device that must be tracked: SKU, name, and availability
c. Edit an existing device
d. Search all device names and display a list of all matching devices
e. Check out a device. This should allow users to see a list of all available devices and select one to
check out
f. Provide the ability to cleanly exit the application
The application should have data for a minimum of 5 devices already preloaded into the array when
the application starts. The ArrayList should have a minimum size of 10.
Hints and Recommendations (All Optional)
•
•
•
•
•
•
•
•
You are free to vary the format of the project. The look of the program, should be clean and pleasing to
the eye. Columns should be cleanly delineated.
You have a fair degree of flexibility in modeling your project design, implementing methods, etc.
You may use E15/16 and/or A7 as your template in getting started.
The ArrayLists for objects should always be outside the object.
Have a DisplayMenu method in your primary class. Implement your menu calls using a do-while loop.
Do not call your DisplayMenu method over and over from other methods.
Use System.exit(0) to cleanly exit applications.
If you find yourself repeating code, try to have it structured such that it is in one method and you
should call that method again rather than type redundant code.
You might be interested in having a Utilities class, in which you could store common utility methods
that read numbers, insert pauses/”Press any key” statements, etc.
© Copyright Arizona Board of Regents | K. Roumina
2
•
•
Create static methods, readInteger, Pause, etc. Do any error handling within these methods, so that
the vast majority of your code remains clean and easier to implement as well as read. If you wrote
methods previously for exercises or assignments, you can reuse them.
Create one method to write the header of the application and reuse it on every screen.
Suggested Sequence of Activities
•
•
•
•
•
•
•
Design/Create your Device class as one of the first things you do.
Once you have your Device class, you can create your array of devices in an external class.
Once you have successfully created the array, create a method to load sample data, i.e. create data for
5 sample devices and store it in the array.
Then start working through each feature – displaying devices, adding devices, etc.
Your goal should be to do iterative development such that you are always adding functionality to a
program that is running error-free. Each iteration of your project works but each successive iteration
has something new that is added to it.
Look at your code again after it is working and take out all redundant and duplicate code – create
reusable classes and methods as much as possible.
Finally, clean up variable and method names, comment code properly, and make the code look clean
and readable!
Deliverables
All CIS 340 submissions must adhere to standards detailed in the following documents (available on the
course site) for full credit.
•
•
•
CIS 340 Assignment Submission Instructions
CIS 340 Programming Conventions
CIS 340 Commenting Guide
Note: Assignments will be scored on source code AND output, with the emphasis on the source code.
© Copyright Arizona Board of Regents | K. Roumina
3
Purchase answer to see full attachment
Purchase answer to see full attachment
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
View attached ex...
Completion Status:
100%
Review
Review
Anonymous
Excellent resource! Really helped me get the gist of things.
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
AutoPark Management System
continue with the scenario from W2 Assignment 2–AutoPark Management System. In a 2- to 3-page Microsoft Word document, c ...
AutoPark Management System
continue with the scenario from W2 Assignment 2–AutoPark Management System. In a 2- to 3-page Microsoft Word document, create a report that includes the following:Apply the following activities to the AutoPark Management System:Data designArchitectural designComponent level designUI designIn your design make sure to classify at least two places where design patterns can be used and justify your choices.Support your responses with examples.Cite any sources in APA format.
Murach's Visual Basic 2015 Extra Exercise 18-1
Read Chapters 17 & 18 in Murach's Visual Basic 2015Complete extra exercise 18-1. Starter project and instructions here: We ...
Murach's Visual Basic 2015 Extra Exercise 18-1
Read Chapters 17 & 18 in Murach's Visual Basic 2015Complete extra exercise 18-1. Starter project and instructions here: Week 5 Assignment.zip.
DAT210 University of Phoenix Week 4 How Can Rails Help Ruby Discussion
Wk 4 Discussion - How Can Rails Help Ruby? [due Thurs]Post a total of 3 substantive responses over 2 separate days for ful ...
DAT210 University of Phoenix Week 4 How Can Rails Help Ruby Discussion
Wk 4 Discussion - How Can Rails Help Ruby? [due Thurs]Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students. Due Thursday Respond to the following in a minimum of 175 words: Rails is a software library that extends the Ruby programming language. Rails is also a framework for building websites establishing conventions for easier collaboration and maintenance. It was created to help design dynamic websites with a database backend. Discuss how Rails has helped Ruby developers build large scalable websites faster. Due Monday Reply to at least 2 of your classmates. Be constructive and professional in your responses.Wk 4 - Write a Ruby Program [due Mon]Assignment ContentThe college IT department manager no longer wants to use spreadsheets to calculate grades. The manager has asked you to create a program that will input the teachers' files and output the students' grades. Write a Ruby program named formatfile.rb, which can be run by typing ruby widgets.rb. In your Ruby environment, the program must read an input file formatted in CSV format, named input.csv. Each record contains data about a student and their corresponding grades. The data will look similar to the following: Student Name, assignment1, assignment 2, assignment 3, assignment 4 John Adams, 90, 91, 99, 98Paul Newman, 90, 92, 93, 94Mary Smith, 95, 96, 99Be careful to follow the output format exactly, including spacing. The output of your program must look like the following: Student Assignment AverageJohn Adams 94.5 Compress your files into a ZIP folder. Review the readings for this week from Ruby on Rails Tutorial if you have additional questions on deploying Ruby applications. Submit the ZIP file.
programming
In this homework you use Netbeans to create two different unique and complete demonstrations of
Porous Defenses such as M ...
programming
In this homework you use Netbeans to create two different unique and complete demonstrations of
Porous Defenses such as Missing Encryption of Sensitive Data, Use of Hard-coded Credentials, Missing
Authorization, Missing Authentication for Critical Function, Incorrect Permission Assignment for Critical
Resource, Incorrect Authorization, Execution with Unnecessary Privileges, and Reliance on Untrusted
Inputs in a Security Decision. You will demonstrate and describe how to fix each of the problems.
Therefore a total of four code samples will be created. Two with Porous Defenses and two will have the
issues fixed.
Assignment Details
Be sure you have carefully read and understand the materials in weeks 5 and 6.
1. Select 2 CWE/SANS Top 25 vulnerabilities under the category of Porous Defenses from one of
these specific issues:
a. Missing Encryption of Sensitive Data
b. Use of Hard-coded Credentials
c. Missing Authorization
d. Missing Authentication for Critical Function
e. Incorrect Permission Assignment for Critical Resource
f. Incorrect Authorization
g. Execution with Unnecessary Privileges
h. Reliance on Untrusted Inputs in a Security Decision
CPT 307 Ashford University Week 3 Features of Linked List Program in Java Project
Prior to beginning work on this assignment, read Chapter 2 in Data Structures Essentials, Chapter 4 in Data Structures and ...
CPT 307 Ashford University Week 3 Features of Linked List Program in Java Project
Prior to beginning work on this assignment, read Chapter 2 in Data Structures Essentials, Chapter 4 in Data Structures and Algorithm Analysis (Links to an external site.), Interface list <E> (Links to an external site.), and the Java – The LinkedList Class (Links to an external site.) tutorial.Students: Be sure to download and save a PDF version of your textbook for future reference. It will be used in later courses within your program, including the final, capstone course. Zybooks limits online access to your course textbooks to a 12-month period. (Zybook Download Instructions)For this assignment, you will continue in your role as a junior software developer from your Week 2 assignment. Your team is still working on the software contract that your company won for the United States Department of Defense. The team lead has tasked you with developing a Java program that uses a linked list to insert and remove items. Because you do not have your secret clearance yet, a senior developer will later take your code and modify it for the requirements of the contract.In this coding assignment you will utilize the Java syntax and techniques you learned while reviewing the required resources for Week 3. You may select appropriate variable names as long as proper Java syntax is used. You will also submit your source code.Input:In the input section, utilize Java syntax and techniques to add five items into a list abstract data type (ADT). Select a list for your program. List examples include students, athletes, days of the week, cities, etc. All input can be hard coded into the Java code.Processing and Output:In the processing section, after the elements are added to the list ADT, the following processes must be completed in the following order:Print out the contents of the original list. (Output)Using the list add(int index, E element) method, insert an element of your selection into the specified position in the list. (Processing)Print out the updated contents of the list.Using the list remove(int index) method, remove an element at the specified position in the list.Print out the updated contents of the list.Your code must include the following as comments:Name of programAuthor/student’s nameCourse name and numberInstructor’s nameDate submittedIn a Word document, explain how you utilized functions of lists in your Java program in a minimum of 200 words. Paste the image of your results and your source code into the document. Submit your Word document to Waypoint for grading.Take a screen shot of the results page and save the image. When you are finished with your Java program, zip the file. Next, submit the zip folder that contains the running source code to the Week 3 Zip File Submission page. If you need more guidance, review the Zip File Quick Start Guide . Be sure that you are sharing the zip folder with your instructor only. Your instructor will run your source code to ensure that the functionality runs correctly.In a Word document, express the various types of algorithms, including searching and sorting used in your Java program in a minimum of 200 words. Paste the image of your results and your source code into the document. Submit your Word document to Waypoint for grading.
Columbus State Community College National Investment Database Report
National InvestmentsThis is the fifth of a multi-part case study for a company called National Investments. Part of your w ...
Columbus State Community College National Investment Database Report
National InvestmentsThis is the fifth of a multi-part case study for a company called National Investments. Part of your work over the course of the semester will be to design and build a database for this fictional company. Though fictitious, the narrative and issues discussed are very real for many companies. You must read these case studies carefully and thoroughly to fully understand their business and their needs. This is part of the requirement for building effective and efficient databases.Case Study Part 5It's All Coming Together Nicely! In your previous assignment you created your database using SSMS. Now, you may have had to change your design once you started implementing the tables and the relationships, and that's ok. Read that again—changes are OK! The process of developing a database is always an incremental one and subject to many revisions before your design goes into production.One of the things that you need to remember is that when you encounter resistance (SSMS won't let you do what you are trying to do, creating relationships is a struggle, etc.) this is a sign that you need to step back and think through your design decisions. Often, resistance is a sign that there might be issues with the design you are attempting to implement.In several follow up meetings you wanted to know what the most important components of this new system are to the company—not to individual people—but to the organization. As you learn more about the most important components you also learn about some elements that might be missing from your design. Here are your findings:Most Important Components of New Database System
AUM
Assets Under Management. This company lives and dies by this number. The way the company makes money is by charging a percentage amount of AUM from each investor. This percentage amount is called a "Management Fee."Oh—did we forget to mention that we need to record that % management fee in the database?And, this % management fee can be different for different investors. For example, for company ABC who has a 401K account with National Investments, we charge a flat fee of 1.5% on the total AUM of that company. Hence, if we manage $2.3 Million in AUM ($2,300,000.00) then National Investments makes $34,500 profit for the year. But for company DEF, for example, the flat fee might be 1.02%. These fees can be different because the acquisition of new business is always a process of developing relationships that are meaningful to both parties, and these relationships never are the same from investor to investor.The incentive is obvious, manage higher AUM and make more money. This is achieved through the investor investing more money and National Investments growing that investment over time.So, not only do we need to track the AUM from each investor (or investing company) and the management fee, we also need to be able to know—very quickly—what the total AUM is for all investors and investing companies and the total average management fee. This will allow us to know how much money we will make each year. So, while one company's management fee is 1.5% (.015 X AUM) another's might be 0.7% (.007 * AUM). We would want to know the average management fee times the sum total of all AUM (avg. mgmt. fee X total AUM) = annual revenue generated. For example, if the average management fee is 0.95% (.0095) -- just less than 1% -- and the total AUM is $6,423,792,992.32 ($6.424 billion) then the annual revenue generated by National Investments is $61,026,033.43 ($61 million).Basically, we are saying that National Investments makes 0.95 cents per year for every 100 dollars of AUM.
Ticker and Shares
It is critical that this database be able to distinguish the Tickers and number of shares by each investor or investing company. For example, two different investors might own shares of General Motors (Ticker: GM). One might own 108,00 shares while the other owns 72,169 shares. This means that National Investments owns a total number of 180,169 shares of GM, but we must be able to keep track of how that total number of shares breaks down by investor or investing company.
Share Price
Critical to the calculation of AUM is the number of shares owned of a particular investment like GM and the current price of each of those shares.For example, on January 2, 2020, each share of GM stock was worth $37.38. Due to the Coronavirus outbreak, on April 1, 2020, each share of GM stock was only worth $19.28. This clearly represents a threat to the overall financial well-being, not only of our investors, but also to National Investments as a company.
Total AUM
Oh, did we forget to mention that we need to know—at any moment—what the total AUM is for National Investments? Again, this is the total AUM for each investor or investing company calculated as the sum total of Company Shares X Share Price. Not only will this number change from day-to-day but stock prices fluctuate throughout each business day, as well.A trading day might open down due to global issues in China or Japan but may rise through the day as investor confidence rises through the day. Or, the markets could open high in a morning but bad news: a terrorist attack somewhere in the world, a cut in oil production, an airline disaster, the start of a global pandemic, or any number of adverse events will drive the value of the stock market down as investors begin to panic, sell their stock or move their money into less volatile investment opportunities.Note: this number/value does not need to be stored in the database. And, it probably shouldn't be because you would have to think through the process of how it would get updated every time there is a change to a share price value. But, the design of your database should be such that we can report this value as needed.Assignment:Purpose:This assignment is all about modifying the design and implementation of your database when you find further information that was not revealed earlier and getting data into your database. This will then allow you to create T-SQL queries to report on that data.In the process of adding data to your database you often find your design either isn't optimal—in one or several areas—or might not work at all in which case you need to go back and rework some of the design and implementation of your database.When using SSMS, there are two ways to enter new data into your database tables: using the T-SQL INSERT statement or using the Edit Table feature in SSMS. Inserting Data into Table via SSMS Edit:Steps:
Right-click on the name of the table into which you wish to enter data.
Select the "Edit Top 200 Rows" option from the resulting menu.
You will now see the edit panel with all columns pre-filled with NULL values.
Fill in your data on the row with the asterisk * on the left of the row.
Right-Click on Table:Select "Edit Top 200 Rows":Edit Panel:
Note 1: Just because a column is pre-filled with NULL doesn't mean that the column will allow a null value. In my example, the email address does NOT allow NULL values—therefore I must enter an email address—in this example.
Note 2: In my example, the Id column is an auto-incrementing column (an "identity specification" column). This means that I MUST leave the null value here. Because this is an auto-incrementing field, once I am finished entering data for the row the next available Id value will be filled in more me.
Fill in your Data:
Note 1: To move through each column simply press the Tab key. To go back a column hold the Shift key and then press the Tab key.
Note 2: When you reach the last column in your row simply Tab one more time and the database will attempt to add your new row.
Note 3: If any data in your row violates any rules or constraints then the row will not be added, and you will receive an error message. If you receive any error messages you will have to spend time to diagnose the problems and fix the issues causing such problems. This may be as simple as ensuring a column is not NULL if it doesn't allow NULL values. It may be something more severe in that the data violates a foreign key constraint in which you will need to modify the design of the impacted tables before you can add your data.
Task:In preparing your progress report you will need to perform all the following:1. You will need to add data to the tables in your design that matches the data in the supplied Excel documents. If your database design doesn't accommodate a given piece of data you must modify your design and implementation to ensure that all data provided in the spreadsheet can be added.a. You may any other data you wish and as your design requires. If your design is such that the needed data is not supplied in the spreadsheet you will need to simply "mock" up some sample data and add it into your database.b. Important: Your instructor cannot provide you with specific information how to complete this step. Each person's database design will be different and therefore, how data must be entered will be different from person to person.2. Write a paragraph from you about your experiences (good or bad) adding data to your database. Did everything go smoothly? If everything was not perfect or not as smooth as you would otherwise like what went wrong and how did you fix it?3. Write a paragraph describing any changes that you needed to make to your database design and implementation as a result of the materials provided in this4. White a series of T-SQL SELECT queries to report the data that you have inserted into your database.a. There is no specific "look-and-feel" for your reports/queries. We basically want to see the company information, and then the stock information.b. One query must calculate the total AUM for each company (of which there are two on your spreadsheet). These can all be separate queries.c. You will copy the T-SQL query statements that you write into your progress report, making sure that you carefully document what each query does and what it produces.Criteria:Much of your work in this assignment is that of adding data to your implemented database, changing the design of your database if your data needs dictate such, and then writing T-SQL queries to report on the data has been added.Submission:
You will submit a single document in either Word of PDF format to Blackboard. This document will be your Progress Report to the partners at National Investments.FAQsQ. I am getting errors when I try to add data to my database. What should I do?A. You will need to figure out where the errors are coming from and fix the source problem. Your instructor cannot help you here. Each person's database design is unique and a problem for one person may not be the same problem for another person.
Make sure the data you are entering for a column matches the data-type for that column.
Make sure that you do not have any NULL values for a column that requires data.
Make sure that you are not violating a referential constraint. This usually occurs either when you are entering data for a child table before that of the parent table, or when the foreign key does not match the primary key in the parent table.
Note: In the case of an error due to something being wrong in the table relationships, you may have to delete the relationship constraint, attempt to add the data, and then recreate the relationship—this often will show you where such an error might be.Q. My database design doesn't have all the columns that the spreadsheet has. What should I do?A. You will have to change the design of your database such that all the data provided in the spreadsheet can be entered into your database.Q. Where do I get the latest stock prices from?A. You can use https://finance.yahoo.com. Simply go to this site, enter the ticker symbol for the company you wish to find data on and report on the "Previous Close" value as shown below:Enter the company's ticker symbol into the site's search bar. In this example, we are looking for Apple, Inc. whose ticker is AAPL:The current stock price and performance will appear. The "Previous Close" price is what you are looking for as it represents the most recent value of the stock before the current day's activity:Q. Earlier in this project guide it says it is important to know the total AUM for National Investments and to be able to report on the Tickers and Shares for each investor or investment company, but the reporting requirements for the progress report doesn't mention needing to report on this data. Am I responsible for writing these queries?A. There is no need create the queries for this data—yet. The queries you are being asked to write simply show the data you have entered plus the AUM for each of the two sample investors. In Project #6 you will write some more sophisticated queries—so, stay tuned.Q. The sample data provided (in the next section shows specific stocks from companies like Apple, JPMorgan Chase, and GM, for example. Do I have to enter these stocks into my database?A. Yes. We want to see this specific data entered into your database. You can add any other data that you wish, but we want to see these company's stocks in your database at a minimum.Example DataTwo Example Clients: Example portfolio for Allegany Fire Department Pension: Example portfolio for City of Ferguson Municipal Workers 401K:Notes:
The share prices shown in the images are only examples. You will need to look up the latest share prices. Enter your share prices into a copy of the Excel workbook that you can download below.
The AUM in the Clients tab will automatically be updated when you complete the Price entry in the two Holdings tabs.
Similar Content
Group discussion part 1 and part 2 (350-450 words each)
.Discussion Prompt #1Please watch the film, And the Band Played On. This film may be available on the Internet through fr...
Basic SQLite Exercise
Answer the following questions using the data provided.
10.11 (More simple aggregation without grouping) Ba...
Junit Testing Discussion
you will implement test cases for a Book class. For the Book, you should include:A title and author, plus any other proper...
AACHS Javascript Code 3 Programs Question
// ===== PRINT HISTOGRAM ======
// Given an array of integers [2, 1, 2, 101, 4, 95, 3, 250, 4, 1, 2, 2, 7, 98, 123, 99,...
CSCI 221 UCF C++ Unified Modeling Language Project
1
CSCI 221, Fall 2021
Exam I: Wednesday, September 29, 2021
Problem
1
2
3
4
5
6
Description
Linux commands
Git
Makefile...
Standards and Design, Programming Essentials, programming homework help
Standards and DesignPlease respond to ONE of the following discussion topics and submit it to the discussion forum as a si...
Mae Mse Rmse.edited
MAE(Mean Absolute Error ) is used to evaluate the regression problem accuracy. Error is an absolute difference between the...
Paper 1
An economy is an area of production and distribution of goods and or services. Economics studies how the society manages a...
Temp9
-- coding: utf-8 -import random import tkinter class Card: ‘9’, ‘10’, ‘jack’, ‘queen’, ‘king’] self.su...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
AutoPark Management System
continue with the scenario from W2 Assignment 2–AutoPark Management System. In a 2- to 3-page Microsoft Word document, c ...
AutoPark Management System
continue with the scenario from W2 Assignment 2–AutoPark Management System. In a 2- to 3-page Microsoft Word document, create a report that includes the following:Apply the following activities to the AutoPark Management System:Data designArchitectural designComponent level designUI designIn your design make sure to classify at least two places where design patterns can be used and justify your choices.Support your responses with examples.Cite any sources in APA format.
Murach's Visual Basic 2015 Extra Exercise 18-1
Read Chapters 17 & 18 in Murach's Visual Basic 2015Complete extra exercise 18-1. Starter project and instructions here: We ...
Murach's Visual Basic 2015 Extra Exercise 18-1
Read Chapters 17 & 18 in Murach's Visual Basic 2015Complete extra exercise 18-1. Starter project and instructions here: Week 5 Assignment.zip.
DAT210 University of Phoenix Week 4 How Can Rails Help Ruby Discussion
Wk 4 Discussion - How Can Rails Help Ruby? [due Thurs]Post a total of 3 substantive responses over 2 separate days for ful ...
DAT210 University of Phoenix Week 4 How Can Rails Help Ruby Discussion
Wk 4 Discussion - How Can Rails Help Ruby? [due Thurs]Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students. Due Thursday Respond to the following in a minimum of 175 words: Rails is a software library that extends the Ruby programming language. Rails is also a framework for building websites establishing conventions for easier collaboration and maintenance. It was created to help design dynamic websites with a database backend. Discuss how Rails has helped Ruby developers build large scalable websites faster. Due Monday Reply to at least 2 of your classmates. Be constructive and professional in your responses.Wk 4 - Write a Ruby Program [due Mon]Assignment ContentThe college IT department manager no longer wants to use spreadsheets to calculate grades. The manager has asked you to create a program that will input the teachers' files and output the students' grades. Write a Ruby program named formatfile.rb, which can be run by typing ruby widgets.rb. In your Ruby environment, the program must read an input file formatted in CSV format, named input.csv. Each record contains data about a student and their corresponding grades. The data will look similar to the following: Student Name, assignment1, assignment 2, assignment 3, assignment 4 John Adams, 90, 91, 99, 98Paul Newman, 90, 92, 93, 94Mary Smith, 95, 96, 99Be careful to follow the output format exactly, including spacing. The output of your program must look like the following: Student Assignment AverageJohn Adams 94.5 Compress your files into a ZIP folder. Review the readings for this week from Ruby on Rails Tutorial if you have additional questions on deploying Ruby applications. Submit the ZIP file.
programming
In this homework you use Netbeans to create two different unique and complete demonstrations of
Porous Defenses such as M ...
programming
In this homework you use Netbeans to create two different unique and complete demonstrations of
Porous Defenses such as Missing Encryption of Sensitive Data, Use of Hard-coded Credentials, Missing
Authorization, Missing Authentication for Critical Function, Incorrect Permission Assignment for Critical
Resource, Incorrect Authorization, Execution with Unnecessary Privileges, and Reliance on Untrusted
Inputs in a Security Decision. You will demonstrate and describe how to fix each of the problems.
Therefore a total of four code samples will be created. Two with Porous Defenses and two will have the
issues fixed.
Assignment Details
Be sure you have carefully read and understand the materials in weeks 5 and 6.
1. Select 2 CWE/SANS Top 25 vulnerabilities under the category of Porous Defenses from one of
these specific issues:
a. Missing Encryption of Sensitive Data
b. Use of Hard-coded Credentials
c. Missing Authorization
d. Missing Authentication for Critical Function
e. Incorrect Permission Assignment for Critical Resource
f. Incorrect Authorization
g. Execution with Unnecessary Privileges
h. Reliance on Untrusted Inputs in a Security Decision
CPT 307 Ashford University Week 3 Features of Linked List Program in Java Project
Prior to beginning work on this assignment, read Chapter 2 in Data Structures Essentials, Chapter 4 in Data Structures and ...
CPT 307 Ashford University Week 3 Features of Linked List Program in Java Project
Prior to beginning work on this assignment, read Chapter 2 in Data Structures Essentials, Chapter 4 in Data Structures and Algorithm Analysis (Links to an external site.), Interface list <E> (Links to an external site.), and the Java – The LinkedList Class (Links to an external site.) tutorial.Students: Be sure to download and save a PDF version of your textbook for future reference. It will be used in later courses within your program, including the final, capstone course. Zybooks limits online access to your course textbooks to a 12-month period. (Zybook Download Instructions)For this assignment, you will continue in your role as a junior software developer from your Week 2 assignment. Your team is still working on the software contract that your company won for the United States Department of Defense. The team lead has tasked you with developing a Java program that uses a linked list to insert and remove items. Because you do not have your secret clearance yet, a senior developer will later take your code and modify it for the requirements of the contract.In this coding assignment you will utilize the Java syntax and techniques you learned while reviewing the required resources for Week 3. You may select appropriate variable names as long as proper Java syntax is used. You will also submit your source code.Input:In the input section, utilize Java syntax and techniques to add five items into a list abstract data type (ADT). Select a list for your program. List examples include students, athletes, days of the week, cities, etc. All input can be hard coded into the Java code.Processing and Output:In the processing section, after the elements are added to the list ADT, the following processes must be completed in the following order:Print out the contents of the original list. (Output)Using the list add(int index, E element) method, insert an element of your selection into the specified position in the list. (Processing)Print out the updated contents of the list.Using the list remove(int index) method, remove an element at the specified position in the list.Print out the updated contents of the list.Your code must include the following as comments:Name of programAuthor/student’s nameCourse name and numberInstructor’s nameDate submittedIn a Word document, explain how you utilized functions of lists in your Java program in a minimum of 200 words. Paste the image of your results and your source code into the document. Submit your Word document to Waypoint for grading.Take a screen shot of the results page and save the image. When you are finished with your Java program, zip the file. Next, submit the zip folder that contains the running source code to the Week 3 Zip File Submission page. If you need more guidance, review the Zip File Quick Start Guide . Be sure that you are sharing the zip folder with your instructor only. Your instructor will run your source code to ensure that the functionality runs correctly.In a Word document, express the various types of algorithms, including searching and sorting used in your Java program in a minimum of 200 words. Paste the image of your results and your source code into the document. Submit your Word document to Waypoint for grading.
Columbus State Community College National Investment Database Report
National InvestmentsThis is the fifth of a multi-part case study for a company called National Investments. Part of your w ...
Columbus State Community College National Investment Database Report
National InvestmentsThis is the fifth of a multi-part case study for a company called National Investments. Part of your work over the course of the semester will be to design and build a database for this fictional company. Though fictitious, the narrative and issues discussed are very real for many companies. You must read these case studies carefully and thoroughly to fully understand their business and their needs. This is part of the requirement for building effective and efficient databases.Case Study Part 5It's All Coming Together Nicely! In your previous assignment you created your database using SSMS. Now, you may have had to change your design once you started implementing the tables and the relationships, and that's ok. Read that again—changes are OK! The process of developing a database is always an incremental one and subject to many revisions before your design goes into production.One of the things that you need to remember is that when you encounter resistance (SSMS won't let you do what you are trying to do, creating relationships is a struggle, etc.) this is a sign that you need to step back and think through your design decisions. Often, resistance is a sign that there might be issues with the design you are attempting to implement.In several follow up meetings you wanted to know what the most important components of this new system are to the company—not to individual people—but to the organization. As you learn more about the most important components you also learn about some elements that might be missing from your design. Here are your findings:Most Important Components of New Database System
AUM
Assets Under Management. This company lives and dies by this number. The way the company makes money is by charging a percentage amount of AUM from each investor. This percentage amount is called a "Management Fee."Oh—did we forget to mention that we need to record that % management fee in the database?And, this % management fee can be different for different investors. For example, for company ABC who has a 401K account with National Investments, we charge a flat fee of 1.5% on the total AUM of that company. Hence, if we manage $2.3 Million in AUM ($2,300,000.00) then National Investments makes $34,500 profit for the year. But for company DEF, for example, the flat fee might be 1.02%. These fees can be different because the acquisition of new business is always a process of developing relationships that are meaningful to both parties, and these relationships never are the same from investor to investor.The incentive is obvious, manage higher AUM and make more money. This is achieved through the investor investing more money and National Investments growing that investment over time.So, not only do we need to track the AUM from each investor (or investing company) and the management fee, we also need to be able to know—very quickly—what the total AUM is for all investors and investing companies and the total average management fee. This will allow us to know how much money we will make each year. So, while one company's management fee is 1.5% (.015 X AUM) another's might be 0.7% (.007 * AUM). We would want to know the average management fee times the sum total of all AUM (avg. mgmt. fee X total AUM) = annual revenue generated. For example, if the average management fee is 0.95% (.0095) -- just less than 1% -- and the total AUM is $6,423,792,992.32 ($6.424 billion) then the annual revenue generated by National Investments is $61,026,033.43 ($61 million).Basically, we are saying that National Investments makes 0.95 cents per year for every 100 dollars of AUM.
Ticker and Shares
It is critical that this database be able to distinguish the Tickers and number of shares by each investor or investing company. For example, two different investors might own shares of General Motors (Ticker: GM). One might own 108,00 shares while the other owns 72,169 shares. This means that National Investments owns a total number of 180,169 shares of GM, but we must be able to keep track of how that total number of shares breaks down by investor or investing company.
Share Price
Critical to the calculation of AUM is the number of shares owned of a particular investment like GM and the current price of each of those shares.For example, on January 2, 2020, each share of GM stock was worth $37.38. Due to the Coronavirus outbreak, on April 1, 2020, each share of GM stock was only worth $19.28. This clearly represents a threat to the overall financial well-being, not only of our investors, but also to National Investments as a company.
Total AUM
Oh, did we forget to mention that we need to know—at any moment—what the total AUM is for National Investments? Again, this is the total AUM for each investor or investing company calculated as the sum total of Company Shares X Share Price. Not only will this number change from day-to-day but stock prices fluctuate throughout each business day, as well.A trading day might open down due to global issues in China or Japan but may rise through the day as investor confidence rises through the day. Or, the markets could open high in a morning but bad news: a terrorist attack somewhere in the world, a cut in oil production, an airline disaster, the start of a global pandemic, or any number of adverse events will drive the value of the stock market down as investors begin to panic, sell their stock or move their money into less volatile investment opportunities.Note: this number/value does not need to be stored in the database. And, it probably shouldn't be because you would have to think through the process of how it would get updated every time there is a change to a share price value. But, the design of your database should be such that we can report this value as needed.Assignment:Purpose:This assignment is all about modifying the design and implementation of your database when you find further information that was not revealed earlier and getting data into your database. This will then allow you to create T-SQL queries to report on that data.In the process of adding data to your database you often find your design either isn't optimal—in one or several areas—or might not work at all in which case you need to go back and rework some of the design and implementation of your database.When using SSMS, there are two ways to enter new data into your database tables: using the T-SQL INSERT statement or using the Edit Table feature in SSMS. Inserting Data into Table via SSMS Edit:Steps:
Right-click on the name of the table into which you wish to enter data.
Select the "Edit Top 200 Rows" option from the resulting menu.
You will now see the edit panel with all columns pre-filled with NULL values.
Fill in your data on the row with the asterisk * on the left of the row.
Right-Click on Table:Select "Edit Top 200 Rows":Edit Panel:
Note 1: Just because a column is pre-filled with NULL doesn't mean that the column will allow a null value. In my example, the email address does NOT allow NULL values—therefore I must enter an email address—in this example.
Note 2: In my example, the Id column is an auto-incrementing column (an "identity specification" column). This means that I MUST leave the null value here. Because this is an auto-incrementing field, once I am finished entering data for the row the next available Id value will be filled in more me.
Fill in your Data:
Note 1: To move through each column simply press the Tab key. To go back a column hold the Shift key and then press the Tab key.
Note 2: When you reach the last column in your row simply Tab one more time and the database will attempt to add your new row.
Note 3: If any data in your row violates any rules or constraints then the row will not be added, and you will receive an error message. If you receive any error messages you will have to spend time to diagnose the problems and fix the issues causing such problems. This may be as simple as ensuring a column is not NULL if it doesn't allow NULL values. It may be something more severe in that the data violates a foreign key constraint in which you will need to modify the design of the impacted tables before you can add your data.
Task:In preparing your progress report you will need to perform all the following:1. You will need to add data to the tables in your design that matches the data in the supplied Excel documents. If your database design doesn't accommodate a given piece of data you must modify your design and implementation to ensure that all data provided in the spreadsheet can be added.a. You may any other data you wish and as your design requires. If your design is such that the needed data is not supplied in the spreadsheet you will need to simply "mock" up some sample data and add it into your database.b. Important: Your instructor cannot provide you with specific information how to complete this step. Each person's database design will be different and therefore, how data must be entered will be different from person to person.2. Write a paragraph from you about your experiences (good or bad) adding data to your database. Did everything go smoothly? If everything was not perfect or not as smooth as you would otherwise like what went wrong and how did you fix it?3. Write a paragraph describing any changes that you needed to make to your database design and implementation as a result of the materials provided in this4. White a series of T-SQL SELECT queries to report the data that you have inserted into your database.a. There is no specific "look-and-feel" for your reports/queries. We basically want to see the company information, and then the stock information.b. One query must calculate the total AUM for each company (of which there are two on your spreadsheet). These can all be separate queries.c. You will copy the T-SQL query statements that you write into your progress report, making sure that you carefully document what each query does and what it produces.Criteria:Much of your work in this assignment is that of adding data to your implemented database, changing the design of your database if your data needs dictate such, and then writing T-SQL queries to report on the data has been added.Submission:
You will submit a single document in either Word of PDF format to Blackboard. This document will be your Progress Report to the partners at National Investments.FAQsQ. I am getting errors when I try to add data to my database. What should I do?A. You will need to figure out where the errors are coming from and fix the source problem. Your instructor cannot help you here. Each person's database design is unique and a problem for one person may not be the same problem for another person.
Make sure the data you are entering for a column matches the data-type for that column.
Make sure that you do not have any NULL values for a column that requires data.
Make sure that you are not violating a referential constraint. This usually occurs either when you are entering data for a child table before that of the parent table, or when the foreign key does not match the primary key in the parent table.
Note: In the case of an error due to something being wrong in the table relationships, you may have to delete the relationship constraint, attempt to add the data, and then recreate the relationship—this often will show you where such an error might be.Q. My database design doesn't have all the columns that the spreadsheet has. What should I do?A. You will have to change the design of your database such that all the data provided in the spreadsheet can be entered into your database.Q. Where do I get the latest stock prices from?A. You can use https://finance.yahoo.com. Simply go to this site, enter the ticker symbol for the company you wish to find data on and report on the "Previous Close" value as shown below:Enter the company's ticker symbol into the site's search bar. In this example, we are looking for Apple, Inc. whose ticker is AAPL:The current stock price and performance will appear. The "Previous Close" price is what you are looking for as it represents the most recent value of the stock before the current day's activity:Q. Earlier in this project guide it says it is important to know the total AUM for National Investments and to be able to report on the Tickers and Shares for each investor or investment company, but the reporting requirements for the progress report doesn't mention needing to report on this data. Am I responsible for writing these queries?A. There is no need create the queries for this data—yet. The queries you are being asked to write simply show the data you have entered plus the AUM for each of the two sample investors. In Project #6 you will write some more sophisticated queries—so, stay tuned.Q. The sample data provided (in the next section shows specific stocks from companies like Apple, JPMorgan Chase, and GM, for example. Do I have to enter these stocks into my database?A. Yes. We want to see this specific data entered into your database. You can add any other data that you wish, but we want to see these company's stocks in your database at a minimum.Example DataTwo Example Clients: Example portfolio for Allegany Fire Department Pension: Example portfolio for City of Ferguson Municipal Workers 401K:Notes:
The share prices shown in the images are only examples. You will need to look up the latest share prices. Enter your share prices into a copy of the Excel workbook that you can download below.
The AUM in the Clients tab will automatically be updated when you complete the Price entry in the two Holdings tabs.
Earn money selling
your Study Documents