1-

 Purpose 

This Assignment is designed to let you familiar with the design of a database. How an E-R model is developed based on logic links which are usually shown in certain descriptions? How different data/factors are organized into different tables? How many-to-many relationship is eliminated? How a design is implemented in a software? Through completing the assignment, you will have the skills for designing and developing a database. Also, you will have a better understanding of the development of information systems. The assignment accounts for 150 points or 8.3% of your final mark.

 

Background Information for the Database Development

Pipefitters Supply Company accepts orders over different media. When an order arrives, one of the salespersons enters it as a sales order. The sales order includes the customer's name and a list of the inventory items that the customer wishes to purchase.  This inventory list includes the quantity of each inventory item and the price at which Pipefitters is currently selling the item. When the order is ready to ship, Pipefitters finish an invoice and records the sale. Sometimes, some of the inventory items a customer has ordered are not in stock. In those cases, Pipefitters will ship partial orders. Customers are expected to pay their invoices within 30 days. Most customers do pay on time; however, some customers make partial payments over two or more months. Each customer may have many sales orders, many sales, and many cash receipts. Sales orders and sales can each have many inventory items, and each inventory item can appear on many sales orders and many sales.

 

Tasks & Requirements

1. Study the above description carefully to understand how a revenue cycle is worked in Pipefitters Supply Company.
2. Based on the identification of entities and relations between the entities to draw an E-R model for the Pipefitters Supply Company.
3. Based on the original E-R model eliminate many-to-many relations and form an implementable E-R model (following the normalization rules)
4. Determine the contents of each table according to the business practices
5. Use Microsoft Access to make associated tables (You can access Microsoft Access in SOM's computer lab at Bunnell 111)
6. Link all tables by Microsoft Access's relationship tool
7. Copy the relationship of your databased shown in Microsoft Access to a word document
8. Write a report words to address
   1. What are frustrations for you to generate a small database?
   2. Can you image the usage of database design in your career development?
   3. Do you consider using a small database to organize the data you collected for your course project? Why or why not?
   4. What are your suggestions for improving this Assignment? 
9. Submit your report in the format of word with the chart of database. 

 

 

2-

Collect necessary data and write  research paper to show how ICT (Information and communication technology) has changed the world in a particular area, and how people are coping with the changes.

3-

Agile, Traditional, and Servant Leader

Earlier in the semester, Bill Flury presented a project where he used an iterative approach to upgrade the Assembly Chamber in the New York State Capitol building in Albany, NY. 

Building on that presentation, the knowledge learned throughout the semester, and the approach that Jeff Denton uses on the projects he describes, discuss how and where Jeff applied techniques or principles from each of the following: 

•  
  • Agile techniques
  • Traditional (predictive) techniques
  • Servant leader mindset

After that, please provide:

•  
  • An example of where you have used agile techniques in your experience
  • An example of where using an agile technique would have improved a situation or project

Note: both agile and predictive techniques can be fast, so "deciding on the fly" does not mean it is agile. That can apply to both agile and predictive approaches. 

Remember to adhere to journal requirements. '

 

4-

On your class project ( internet company)  identify realistic change requests that you might receive. You will work with your project partner on this exercise, if you have one. 

• Identify 3 requests that are tempting, but are not in scope.
• Identify 3 requests that would be in scope.
• Identify 3 clearly out of scope requests you would realistically get from the customer, a team member or management.

Classify or label each change so I know which category the change falls into. Present the change request with the response you would provide as the project manager. Do you accept the change? Why or why not? 

There is no template to finish on this exercise, and you do NOT have to finish change request form, change log, or issue log. In Word or Excel, simply describe the change in 1-2 sentences and your response in senteces, or enough for me to understand both the request and response.  

  

5-

For your class project (Internet Company) design a one-page report that includes the key information that your stakeholders will need on a weekly basis. The report should be informative and quick/easy to read. If you are not sure of the information to include, put yourself in your customer's and sponsor's shoes. If you were the customer or sponsor of your class project, or if you hired a contractor to build a home for you and you lived too far away to physically visit the site regularly, what information would you need in order to know what is going on with the project and that concerns are being properly addressed? If you need more ideas, Brenda Breslin's presentation in week 3 may help, along with our other class resources (textbook, articles, guest speakers).

Be creative! Have some fun with this. I want you to make an original format that works for your class project. 

You will submit two reports.

1. One will be a blank version, or template, of your one-page report with brief instructions for each area or field.  Templates with instructions are needed so that everyone understands the report and finish it consistently. This avoids the surprise when people interpret a report or finish a report differently than you intended.
2. The second is a finished report providing a current status of your class project. I realize the data will be made up, and that is fine, but it is helpful to populate a template with information to make sure it works as you intended.

Like the WBS, you can make and submit this report in Word, Excel, Powerpoint, or neatly hand drawn. If youmake it in another software program, please attach the native file as well as a pdf version to ensure that I can read it. 

If you are working with someone on the class project, you will work together on this assignment and receive the same grade. 

If you would like my Stoplight templates, let me know when you submit your homework. I will attach the two templates when I grade your assignment. I am not sending the files now so that you come up with your own one-page report.  If you have a preferred way to convey status information thoroughly and succinctly on one page other than color-coded assessments, such as Red-Yellow-Green, it is fine to use that approach.  

What is important here is clarity, brevity, and content.

 

6-

Final Project Outline

• The outline for the final project should be approximately include key sections / themes of the project, and a sentence or two for each of those major sections describing what they will include, or the basis for them.  Make sure to check the requirements for the Final Project to determine whether you're generate a paper or creating a presentation (your choice) and to get some added info on expectations.
• Sample outline structures can be found at: https://owl.purdue.edu/owl/general_writing/the_writing_process/developing_an_outline/types_of_outlines.htmlLinks to an external site.

This should be a well-structured outline, and not just a few sentences. This is a chance to collect your thoughts, and get feedback on directions before going into the final project efforts. If you have any questions about this, please feel free to contact me and I would be happy to discuss.

If you're having difficulty deciding on a topic idea, (a major threat or vulnerability) please look back to Cyber Attack Methods.  If you still have trouble, please contact me early and we can discuss a topic either via email or on Zoom. Now would be a good idea to review APA guidelines before you begin writing as well, to ensure you aren't having to undo formatting later. 

 

7-

This is the last part of the 3 part cybersecurity risk assessment.

Part of the purpose of this stage is to understand that risk awareness and assessment often requires a team to accomplish. This means that sometimes the team may prioritize things differently than you would have or did. It also means that they may identify risks that you otherwise hadn't thought about. This is one of the benefits of including a broader range of perspectives in risk planning, and getting a better assessment of potential concerns. Additionally, it's important to analyze what the limitations or strengths of particular methods might be in trying to identify risk and prioritize it.

For this stage, you'll aim to:

Analyze the Risk Matrix produced by the class, discussing how you might prioritize risk within the organization you assessed.

Feedback on the Process: Reflect on the entire risk assessment experience, suggesting potential improvements to the process.

Future Forecasting: Think about potential future risks, especially with emerging technologies. How might these impact universities in the years ahead?

Reflection on Scores: Compare the class's risk scores to your own and identify any discrepancies. Were there risks the class emphasized that you hadn't considered, or vice versa?

Group Analysis Feedback: Evaluate the overall exercise, highlighting the pros and cons of group-based risk analysis. Were there any oversights or new insights gained from the collective perspective?

 should include specific recommendations of controls that you might include to address these risks. Are there controls that would address multiple risks?

The Risk Matrix generated by the class is available here in full size (Images also included below): 202303 Online Risk Scoring Matrix.pdf

Actions

 

Overall risk scoring skewed toward a high perceived Impact of events with lower to moderate perceived Likelihood. You may also want to look back at the full table of risks to see the full description of events. As for the Knowledge scores, the bubble size indicates the level of knowledge people felt about particular risks. Larger bubbles = Lower Knowledge scores and smaller bubbles = higher knowledge scores (this can relate to how confidently we understand each risk). Does the level of knowledge or understanding around risks influence how we prioritize them?