Submit in a word document, template attached. Be careful, make sure to avoid plagiarism and to use quotation marks and proper citation as required. Length should be one page. Use APA format for citations and the required References page. Remember that the significant portion of your analysis should be in your own words. Attached is the assignment, template, and prior paper to use as a guide. 

Please find attachment. It is a coding homework with instructions in it. 

 Week 8 Assignment 2 Create an ERD

Create an ERD

Preparation

In this assignment, you will be drawing an Entity Relationship Diagram (ERD) or Database Design Diagram. The following videos and documents will assist you:

Entity Relationship Diagram (ERD) Tutorial – Part 1.

Entity Relationship Diagram (ERD) Tutorial – Part 2.

Ultimate ER Diagram Tutorial (Entity Relationships Diagrams).

Scenario

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.

Instructions for the Database Design Diagram

Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram. Otherwise, you may draw the diagram by hand with a pen and paper. If you draw the diagram by hand, then take one or more pictures of the diagram with your cell phone or laptop camera, place the images into a Word document, and submit the document. Otherwise, if you use software to create the Database Design Diagram, then take one or more screen captures of the diagram, place the screen captures into a Word document, and submit the document. Submissions that are not in .doc or .docx format will not be graded.

Include the following in the document:

Draw the entities of the database and the attributes of each entity, based on your research and/or common knowledge of a college and the information tracked by a college.

Create the appropriate relationships between each entity within the diagram.

This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.

The specific course learning outcome associated with this assignment is:

Draw a database design diagram that depicts the attributes and relationships of the entities.

Note: All Assignments must be submitted into Blackboard. The whole Assignment (e.g. Assignment 1, 2, and 3) which includes both required images and written portion must be submitted into “one” MS Word document. All images pasted/copied into the MS Word document must contain an image label as to what the image represents. Assignments not submitted into “one” MS Word document will not be graded. Students must apply labels to their Database individual screen shots for Assignment 3.

This Video will help you understand “Assignment Two’s” challenge:

Watch Media

By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution’s policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.

Institution Release Statement

Discussion Topic

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 Day 3 

Recall an information system that you have used regularly, such an online banking system, a payroll system, or an airline reservation system. Imagine you were involved in the beta testing of that system.

Respond to the following in a minimum of 175 words: 

• What criteria would you have used to judge whether this system was ready for general distribution?
• What would you do if the system continued to fail a specified criterion? 

Please select one of the following topics, research their current background, analyze the purpose of requirements, and design/implement a new information system including a relational database gathering and justify its role in any development process. Then write the term paper.

1. Data Warehousing Systems
2. Data Visualization/Virtual Reality Information Systems
3. Artificial Intelligence and Expert Systems
4. Data Mining Systems
5. Decision Support Systems
6. Knowledge-Base Information Systems

Including Subjects in the Selected Topic:

1. Describe how the database supports the selected topic
2. Discuss what the database has a role to implement the selected topic
3. Discuss your idea about to improve the current topic in accordance with the database progress
4. Draw each component for the database and explain their function related with the topic
5. What is the future work for improving your research?

Assignment Instructions:

1. No ZIP file
2. The submitted assignment must be typed by ONE Single MS Word/PDF file
3. At least 15 pages and 5 references
4. Use 12-font size and 1.5 lines space
5. No more than 4 figures and 3 tables
6. Follow APA style and content format: IGU follows the APA(American Psychological Association) for writing style in all its courses which require a Paper or Essay.

http://www.apastyle.org/ (Links to an external site.)

Project Construction Format:

You should follow the following content format:

Title: Topic

Name:  Logan Lee

ID: 123-45-567

Abstract:

1. Introduction
2. Background 

• Current Issues and Suggest Topics

1. Methods, Techniques, and Evaluations
2. Future Works
3. Summary

• References

We  have n stations along a river, numbered 1 to n in the direction of the  current. You can rent a boat at any station i, go down the river to a  station k> i, return the boat and pay a fee c (i, k) for the tour. It  is possible that c (i, k) is greater than c (i, j) + c (j, k), with j  being an intermediate station between i and k. In this case, it is  cheaper to rent a boat from i to j and then another from j to k. Give an  efficient algorithm that calculates the minimum cost of a trip from 1  to n. Depending on n, how long does your algorithm consume?

   Part1) What are the privacy issues with data mining? Do you think they are substantiated? 

   225 Words + 2 References

   Part2) 

   a) Define data mining. Why are there many names and definitions for data mining?

   b) What are the main reasons for the recent popularity of data mining?

   c) Discuss what an organization should consider before making a decision to purchase data mining software.

   d) Distinguish data mining from other analytical tools and techniques.

   e) Discuss the main data mining methods. What are the fundamental differences among them?

   Min 180 words answer for each question in part 2.

Checklist:

APA Formatting

Part1 and Part2 needs to attached as two separate docs

Atleast 2 references for each part

Plagiarism report

Complete the module tutorial

See assignment 10-45 

Provide the answers to all the descriptive statistics, stated in the problem.  

Correct output is required.  Also, presenting the work in a very professional and visually appealing manner is required to get full credit.  

Do Not send the final results in a protected view.

Make sure your formulas are included in the worksheet,  This allows me to change the numbers and confirm that the new answer is calculated correctly.

 10-45. Because of the employees’ increased use of IS resources for private purposes at Campus Travel, you have announced that a new acceptable use policy will be implemented. You have set up a website for the employees to provide feedback to the proposed changes; the results of this survey are stored in the file EthicsSurvey.csv. Your boss wants to use the survey results to find out what the greatest concerns in terms of ethical implications are for the employees, so you are asked to do the following: 

■ Complete the spreadsheet to include descriptive statistics (mean, standard deviation, mode, minimum, maximum, and range) for each survey item. Use formulas to calculate all statistics for the responses to the individual questions.  (Hint: In Microsoft Excel, you can look up the necessary formulas in the category “Statistical”; you will have to calculate the ranges yourself.) 

■ Format the means using color scales to highlight the items needing attention.

 ■ Make sure to professionally format the pages before submitting them to your instructor. 

Please see the attachment for question and follow the instructions. Need it by 5pm EST