Entity Relationship Diagram

 

Entity Relationship Diagrams are used to help show how information in a system is organized. This assignment will have you analyze data from a business situation, construct an ERD, and explain process of normalization and reasons when denormalization may be important.

Assignment Instructions and Requirements

Avery’s gym has partnered with a partner physical therapy business to provide treatment for some of its gym members. Gym members have the option to participate in special physical therapy sessions.

The main feature of this partnership provides gym members with the options to participate in physical therapy sessions. Each Physical Therapy Session must include a gym member, a trainer, and a therapist. Each session generates a unique Claim. Sessions also need to record the date, time and purpose of the sessions. Physical therapy sessions are billed back to insurance and claims must be filed with each physical therapy session.

You have been tasked with developing an Entity Relationship Diagram to help show this part of the larger gym system. You have also been asked to explain the importance of both normalization and denormalization of data structures.

You have been given a report as an example of some of the information generated by the system, and the file contains the following fields. Hint: unique IDs may need to be created to correctly generate the data model.

  1. Physical Therapy Session
  2. Session Date
  3. Session Time
  4. Session Details/Purpose
  5. Member Name
  6. Member Address
  7. Member Phone
  8. Member Age
  9. Member Email
  10. Insurance Number
  11. Insurance Name
  12. Insurance Address
  13. Insurance Plan details
  14. Trainer Name
  15. Trainer Phone
  16. Trainer Email
  17. Trainer Specialty
  18. Therapist Name
  19. Therapist Phone
  20. Therapist Email
  21. Therapist Specialty
  22. Insurance Claim Number
  23. Claim Cost

Complete the following two tasks:

  1. Normalize the data. Organize the information into data fields appropriate for a relational database. Analyze the information provided and normalize the data to create a database model.
  2. Based on that information construct an ERD. Use Visio. Identify primary and foreign keys. For each entity, develop appropriate and thorough attributes. Use crow’s feet to show relations between entities.
  3. Explain the importance of normalization: provide a summary of the steps necessary for each 1NF, 2NF, 3NF and importance. A minimum of 120 words is expected.
  4. Explain denormalization and explain the main reasons for it. A minimum of 60 words is expected.

IT214 Week 4

Discussion:

What property does “Row, Row, Row Your Boat” and “Frere Jacques” have in common?
Would any tune work just as well? Suggest one as a test case.

Respond to at least two other students 

NLU LOGO

Why Data Analysis

 

Module 1: What is Data Analytics?

Project Proposal Instructions

For your final project and presentation in this course, you will need to propose a dataset to analyze. This proposal has four parts, in which you will choose your dataset, provide the background for that dataset including why you chose it and from where, provide information on the data itself, and provide an image from your imported data.

This assignment is due by 11:59 CT on Sunday.

Deliverables:

A word document containing writing, tables, and images from Part 1, Part 2, Part 3 and Part 4.
Your chosen dataset

PART 1: CHOOSING A DATASET

For the project in this course you will need to choose a dataset to analyze. This dataset will need to meet the following requirements:

  • has at least 5 fields (at least three should be numeric)
  • has at least 100 rows
  • data is labeled

Recommended sites to find a dataset:

PART 2: DATASET BACKGROUND

Write a summary describing the topic of the dataset. Include: why you chose that dataset, where it came from, and what kind of problem you could solve with it.

PART 3: DATASET INFO

Provide information on the dimensions of the dataset. Include information on the fields and their data types. Be sure to state if they are continuous/numeric or categorical?

PART 4: IMPORT YOUR DATASET

Provide an image of the results of importing your dataset and using the head() function for printing.

National Louis UniversityNLU LOGO 

week 12 ERM

After reading the required articles this week, please write a research paper that answers the following questions: 

  • What are mobile forensics and do you believe that they are different from computer forensics?
  • What is the percentage of attacks on networks that come from mobile devices?
  • What are challenges to mobile forensics?
  • What are some mobile forensic tools?
  • Should the analysis be different on iOS vs Android?

Your paper should meet the following requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page. 
  • Follow APA7 guidelines. Use Calibri, 11 pt . Your paper should include an introduction, a body with fully developed content, and a conclusion. 
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. 

Data visualization

This week we watched a short video on how storytelling and the aims of data visualization go hand in hand. The narrator of the video discusses the aims of data visualization. The narrator states that the aims of data visualization is to, “Maximize how quickly and accurately people decode information from graphics.” The narrator also talks about some shortcomings (disadvantage) of the techniques used to create data visualization for storytelling. Select and discuss one of the mentioned shortcomings. Then discuss what we have learned in this course that can assist with overcoming your selected shortcoming.

Reference: O’Reilly (2015, July 14). Using Storytelling to Effectively Communicate Data Tutorial | Aims Of Data Visualization. Retrieved from https://www.youtube.com/watch?v=3JWK5gRI9p0

– 1 complete page

– 2 references

Discussion

 Please watch the following videos:

Chapter 6 Part 1

Chapter 6 Part 2

Chapter 7 Part 1

Chapter 7 Part 2

C Please watch the following videos:Chapter 6 Part 1

Chapter 6 Part 2

Chapter 7 Part 1

Chapter 7 Part 2

Chapter 8 Part 1

Chapter 8 Part 2

Chapter 8 Part 3

Create a Word document with a summary stating you watched all of the Week Three Python videos. 

system analysis and design

 Develop two required BPM diagrams:

  • One for the THS providers (such as doctors, nurse practitioners) showing existing and planned use of the mobile platform for reviewing patient/consumer clinical results.
  • One for the THS providers showing existing and planned use of the mobile platform for placing test orders to treat patient/consumers.
  • Develop three separate use case tables for each of the BPM diagrams that will be developed:
    • One for the THS providers (such as doctors, nurse practitioners) showing existing and planned use of the mobile platform for reviewing patient/consumer clinical results.
    • One for THS providers showing existing use of the mobile platform for placing test orders to treat patient/consumers.
    • One for THS providers showing planned use of the mobile platform for placing test orders to treat patient/consumers
  • Articulate the content of both the BPM diagrams and use case tables for both consumers and providers in detail.
  • Analyze two different scholarly papers that address mobile consumer applications in the health industry and mobile applications used by providers in the health industry.
    • The two scholarly papers that you analyze must be researched and may not include resources in the course.
  • Discuss your proposed end user requirements illustrated in your BPM diagrams and use cases for the consumer mobile application for THS.
  • Discuss your proposed end user requirements illustrated in your BPM diagrams and use cases for the provider mobile application for THS.
  • Evaluate at least five types of costs associated with developing these applications (the consumer and provider mobile applications for THS) based on both the in-house and purchased software development options discussed in your text.

Write a Python program

  

Program 1

Write a Python program that will ask the user to enter the grade of 5 students. The grade can be a range of integer values from 0 to 100. When the user is entering the grade for each student, the python program must check if the input value of the grade is between 0-100. If it is not, the program must print the following message “Wrong Grade”. If the value of the grade is greater than 60,  print” Pass grade” else print “Fail grade”.

Program 2 

Write a python program that will calculate the square, cube, and the fourth power of the numbers from 1 to 10. Hint, finish the following table. 

  

Each of these programs will also need the Word document completed that will attach. One for each program. Thank you!

  

Write a C++ program to solve the following problem: 

Determine the amount of money in dollars in a change purse given the number of quarter, dimes, nickels, and pennies. Prompt the user for the number of each type of coin. Test data: 3 quarters, no dimes, 5 nickels, and 23 pennies. Submit the source code with the output at the bottom as a comment. The source code must contain comment statements with your name and the title of the project. The output must contain the same information created through cout statements. In addition to the comments with your name, have at least four other meaningful comments.