Produce an ER Model for the following scenario (presented in Step 1 below) and business need, for the Pythagoras Math Academy.

Deliverables:

· ER Model for the scenario presented.

· You have the option to use MS Visio (if you have the software) to produce your ER Model.

· Alternatively, if you do not have MS Visio, you can use the ERD PLUS (Open source ER Modeling Software) and produce your ER Model.

Lab Steps:

Step 1: Read and understand the Scenario and Business needs presented below. Define and document the ENTITIES, and RELATIONSHIPS, required to address the business needs. The nouns in the scenario below will give the ENTITIES that you will need. Finally, the verbs will describe the RELATIONSHIPS.

Scenario and Business Need:

The Pythagoras Math Academy is in need to develop a database to keep track and control of his students, teachers, and classes offered.

Teachers are able to teach multiple courses. But they are required to be certified on the course they are teaching. For example, only a group of teachers are certified to teach Algebra, and other Geometry.

Students can take multiple courses. Courses are taught by teachers with the proper certification and have multiple certs as needed.  Courses are taught in one of the classrooms at one of the School’s several sites.

Each classroom is optimized to serve the needs for a course (for example some courses might require computer labs and whiteboards). The school needs to keep track of the math courses delivered in each of the sites.

Step 2: For this project, you are required to use MS Visio or ERD PLUS to produce the deliverables.

If you are using MS Visio follow the steps below:

· Open MS Visio

· Click on the Software Database Template in the main window

· Select the Database Model Diagram Template to open a new file.

If you are using ERD PLUS.

· From the ERP PLUS main interface, select DOCUMENTS –> NEW DIAGRAM (NAME YOUR DIAGRAM) –>ER DIAGRAM –> CREATE

Step 3: Define and Database ENTITIES

· Add an entity for each Table you identified in the Scenario and Business Need.

Step 4: ADD the required ENTITY ATTRIBUTES  

· Add the required Attributes for each Entity that you feel would help to define each Entity as needed.

· Select one of the attributes to be PRIMARY KEY (PK)

Step 5: Define RELATIONSHIPS

· Use the Crow’s Feet Notation.

· Drag and drop (draw) relationships between the entities you defined.

· Connect the ends to the two entities for each relation.

· Defined the Primary Key for the parent entity.

Step 6: Define CARDINALITY RELATIONSHIP

Set the cardinality for each of your relationships defined in Step 5.  

For MS Visio: select a relationship line in the drawing area that is connecting two entities. In the Database Properties window, select the miscellaneous category. Select the cardinality for the selected relationship.

• In this challenge, you are tasked with creating a Python script for analyzing the financial records of your company. You will give a set of financial data called budget_data.csv. The dataset is composed of two columns: Date and Profit/Losses. (Thankfully, your company has rather lax standards for accounting so the records are simple.)
• Your task is to create a Python script that analyzes the records to calculate each of the following:
  • The total number of months included in the dataset
  • The net total amount of “Profit/Losses” over the entire period
  • The average of the changes in “Profit/Losses” over the entire period
  • The greatest increase in profits (date and amount) over the entire period
  • The greatest decrease in losses (date and amount) over the entire period
• As an example, your analysis should look similar to the one below:
• Financial Analysis
----------------------------
Total Months: 86
Total: $38382578
Average  Change: $-2315.12
Greatest Increase in Profits: Feb-2012 ($1926159)
Greatest Decrease in Profits: Sep-2013 ($-2196167)
• In addition, your final script should both print the analysis to the terminal and export a text file with the results.

 To begin, choose a business or organization that you would like to evaluate – it can be where you work, a school (UMGC), a place of worship, government entity (e.g., DMV, Secretary of State, courthouse, etc.), or any other type of organization. Since the focus of the analysis will involve information technology, the best type of organization to choose is one where you can envision technology playing a key role in improving products, processes, or services.  

The corporate board of directors has asked you to provide a portfolio of your research into the expansion of the company into the country you presented on in Wk 4.

Include an overall corporate code of ethics based on your review of professional associations, such as IEEE, ACM, SANS, ISACA, ASIS, and ISC(2). Include the following in your portfolio:

• Based on the ethical challenges identified in Wk 4, choose and depict 2 risks to the corporation related to each challenge in a 1-page table using either Microsoft® Word, Microsoft® PowerPoint®, or Microsoft® Excel.
• A 1- to 2-page corporate code of ethics using Microsoft® Word based on your review of professional associations, such as IEEE, ACM, SANS, ISACA, ASIS, and ISC(2), and the ethical challenges identified
• A 1- to 2-page concise synopsis of classical ethical theories
• A 1- to 2-page process to logically evaluate ethical dilemmas as they arise with the expansion of the company into the country you have chosen. Ensure that the process reflects the code of ethics you provide; for example, your process could start with identifying which part of the code applies to a particular new dilemma and move through assessing the various choices you could make, along with any resulting consequences. The end goal is to help your corporation manage complex ethical questions with a variety of stakeholders.

Note: All references need to adhere to APA guidelines, and images should not be copied unless you’ve obtained author permission or used copyright-free images.