ITS-538 – Database systems – project2

Summary:

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

  • 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. 

Required Software:

  • MS Visio by Microsoft OR
  • ERD PLUS, Open Source Offering. This offering is cloud-based, and you do not need to download any clients. You will need to create an account (username and password), link to this offering follows: https://erdplus.com 

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:

  • project overview/ expectations.
  • Open MS Visio
  • Click on the Software Database Template in the main window
  • Select the Database Model Diagram Template to open a new file.
  • Save the File and ensure to have in your file name PROJECT2_LastName_FistInitial.

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.
  • You will use the MS Visio tool, or the ERD PLUS open source offering to complete this step.

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 RELATIONSHIPSet 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.

Step 7: Upload your Work 

  • Save the File and ensure to have in your file name PROJECT2_LastName_FistInitial. 

Rubric:

1. ER Model (MS Visio OR ERD PLUS)

2. Entities: Minimum of three entities are represented

3. Attributes: Minimum of two attributes for each Entity. Most would require more than two attributes, and I am only requiring two per entity.

4. Relationships: Minimum three relationships are presented.

5. Cardinality is defined and specific for each relationship with Crow’s foot notation.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Project Mgmt – Discussion

> Describe the various sources of systems and software components.

> Describe how to plan purchases and acquisitions, as well as the steps in the procurement process.

> Explain how to conduct procurement, including its inputs, processes, and outputs.

> What is a statement of work? Why is it so important to procurement?

Need 4 pages in APA format with peer-reviewed citations. No need for introduction or conclusion.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

281 QUESTION

  

In order to complete assignment #6 you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #6). Use examples from the readings, lecture notes and outside research to support your answers. The assignment must be a minimum of 1-full page in length with a minimum of 2 – outside sources. Please be sure to follow APA guidelines for citing and referencing source. Assignments are due by 11:59 pm Eastern time on Sunday.

Chapter 10Immunomedics was alerted that there was some negative buzz about the company in a chat room. The poster used a pseudonym, and therefore the company was unable to identify the poster for lawsuit purposes. The only information the company could ascertain was the poster’s ISP. So the company decided to subpoena the ISP for identity information of the poster in order to file suite against the poster. How should the courts handle these cases, where the company’s complaints may, or may not rise to the level of an actionable legal claim?Chapter 11Please read Question #5 on page 362 and then answer the following questions.Should Craigslist be subject to liability for FHA violations? Why or why not? Cite appropriate legal principles when explaining your answer. 

 Question 5 pg 362

Users of the popular Internet website Craigslist are able to post advertisements for housing that permit statements regarding the preference, limitation, or discrimination of others based on race, religion, sex, or family status. The Fair Housing Act (FHA), however, prohibits making, printing, or publishing a notice, statement, or advertisement for sale or rental of dwellings indicating preference, limitation, or discrimination based on protected classes. As such, Chicago Lawyers Committee for Civil Rights Under Law, Inc. brought suit against Craigslist alleging a violation of the FHA. In defense, Craigslist claimed that it was immune from liability based on Section 230(c)(1) of the CDA, which protects interactive computer services from liability for unlawful third-party content. Should Craigslist be subject to liability for FHA violations? Why or why not? Cite to appropriate legal principles when explaining your answer. 48

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

231

 

Analyze techniques to effectively compose a major IT document after watching the videos or by conducting research by addressing the questions below:

Video: How to format a book in MS Word (Part III: Front matter, back matter and section breaks): https://www.youtube.com/watch?v=R-5kJl5rN6E
Video – Front Matter, Body & End Matter in Technical Documents: https://study.com/academy/lesson/front-matter-body-end-matter-in-technical-documents.html(This is not a mandatory video you must watch; however, there is a special offer for 7 days usage–Try it first for 7 days. Special Offer!)

  • Explain the purpose of front matter in a technical document and provide examples.
  • Explain the items found in the body of a technical document.
  • Explain the purpose of back (end) matter in a technical document and provide examples.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Analysis of this case scenario (Professional Practice Ethics class)

_ Case scenario:

Charlie and Carol are students at a university in a computer science program. Each writes a program for a class assignment. Charlie’s program happens to uncover a flaw in a compiler that causes the entire computing system to fail; all users lose the results of their current computation. Charlie’s program uses acceptable features of the language; the compiler is at fault. Charlie did not suspect his program would cause a system failure. He reports the program to the computing center and tries to find ways to achieve his intended result without exercising the system flaw. The system continues to fail periodically, ten times (beyond the first failure). When the system fails, sometimes Charlie is running a program, but sometimes Charlie does not. The director contacts Charlie, who shows all his program versions to the computing center staff. The staff concludes that Charlie may have been inadvertently responsible for some, but not all, of the system failures, but that his latest approach to solving the assigned problem is unlikely to lead to additional system failures. On further analysis, the computing center director notes that Carol has had programs running each of the first eight (of ten) times the system failed. The director uses administrative privilege to inspect Carol’s files and finds a file that exploits the same vulnerability as did Charlie’s program. The director immediately suspends Carol’s account, denying Carol access to the computing system. Because of this, Carol is unable to complete her assignment on time, she receives a D in the course, and she drops out of school.

_ Requirements:

A. Analyse of the case scenario should have the following details clearly mentioned:

1. What are the ethical issues in the case?
2. Gather the relevant information about the case including all the stakeholders, any related facts, details, etc.
3. Find all the consequences of the case, the rights of each person involved etc.
4. Analyze the case from different points of view.
5. Explain how the problem could be solved USING the ethical model that you chose by applying the principles that you have learned so far or feel free to search for the relevant ones to be required to solve the case.
6. How can the problems found in the case be prevented in the future?

B. Will be scored based on the following:

+ Clear Analysis of the case study and relevant modules (40 points)
+ The document looks clear, neat, and presentable format with appropriate headings and subheadings (10 points)
+ All the details specified in the instructions above (50 points)

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

discussion question

Explore the advantages and limitations of utilizing media-sharing websites, where you can share your photos and videos with others. Discuss the potential benefits that come with using these platforms, as well as the drawbacks that users should be mindful of. Share your perspectives on the impact of media-sharing websites on communication, self-expression, and privacy. Engage in a conversation about the pros and cons of these platforms, considering their influence on how we share and consume visual content in today’s digital landscape.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Implementation and Support Plan

Joan’s team at Healthy Harvest is ready to review how to implement and maintain the new online store app. 

Prepare a 5- to 6-page implementation and support plan using the Healthy Harvest Implementation and Support Plan template

The template includes sections for you to document the following information:

  • Recommend an implementation strategy for the app, including testing and verification processes. Support your recommendation by explaining the advantages of the process.
  • Outline the documentation requirements, which include instructions on using the system and training and supporting users.
  • Outline the maintenance and support recommendations of the store app. Include:
  • Required changes
  • Enhancements
  • Scaling
  • Optimization

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

complete and submit the second Careers in Practice (Skills Review) Hotel Management Cost Analysis starting on page 180

 

For Project 2 part 1, complete and submit the second Careers in Practice (Skills Review) Hotel Management Cost Analysis starting on page 180. Please note on page 181, the number of days is in the month is in cell B5 (not C5) and on page 182, for items 9 and 10 you are to enter the function to calculate the highest and lowest Cleaning Expense (not the Actual Occupancy again). Submit your completed Excel file here.

 

E6:E16. Use a paste method that does not remove the border at the bottom of cell E16.

Saylor URL: http://www.saylor.org/books Saylor.org
182
4. Enter a function in cell C17 on the Historical Costs worksheet that sums the values in the range
C5:C16. Copy the function and paste it into cells D17 and F17. Use a paste method that does not
change the border on the right side of cell F17.
5. Copy the formula in cell E16 and paste it into cell E17. Use a paste method that does not change
the border at the bottom of cell E17.
6. Sort the data in the Historical Costs worksheet based on the values in the Actual Occupancy
column in descending order (largest to smallest). For any duplicate values in the Actual
Occupancy column, sort using the values in the Cleaning Expenses column in descending order.
7. On the Cost Analysis worksheet, enter a function into cell B3 that shows the highest value in the
range D5:D16 in the Actual Occupancy column on the Historical Costs worksheet.
8. On the Cost Analysis worksheet, enter a function into cell B4 that shows the lowest value in the
range D5:D16 in the Actual Occupancy column on the Historical Costs worksheet.
9. On the Cost Analysis worksheet, enter a function into cell C3 that shows the highest value in the
range F5:F16 in the Actual Occupancy column on the Historical Costs worksheet.
10. On the Cost Analysis worksheet, enter a function into cell C4 that shows the lowest value in the
range F5:F16 in the Actual Occupancy column on the Historical Costs worksheet.
11. On the Cost Analysis worksheet, format cells B3 and B4 with a comma and zero decimal places.
Format cells C3 and C4 with US dollars with zero decimal places.
12. On the Cost Analysis worksheet, enter a formula in cell B5 that subtracts the lowest actual
occupancy value from the highest actual occupancy value. Copy this formula and paste it into cell
C5.
13. Enter a formula in cell C6 on the Cost Analysis worksheet that calculates that variable cost
portion for the cleaning expenses per month. As mentioned in the introduction to this exercise,
the cleaning expense contains costs that increase with each room that is cleaned. This is known as
a variable expense and can be estimated by dividing the Actual Occupancy High Low Difference
(cell B5) into the Cleaning Expenses High Low Difference (cell C5). Format the output of this
formula to US dollars with two decimal places.
14. Enter a formula in cell C7 on the Cost Analysis worksheet that calculates the fixed cost portion
for the cleaning expenses per month. This is the amount of money that will be spent on cleaning

Saylor URL: http://www.saylor.org/books Saylor.org
183
expenses no matter how many rooms are cleaned. Since we have calculated the variable cost
portion of the cleaning expense, we can now use it to calculate the fixed expense. To do this,
subtract from the High Cleaning Expense (cell C3) the result of multiplying the variable expense
(cell C6) by the High Actual Occupancy (cell B3). Format the result of the formula to US dollars
with zero decimal places.
15. Enter the number 3500 in cell C2 on the Cleaning Cost Estimatesworksheet. Format the
number with commas and zero decimal places.
16. Apply a yellow fill color to cell C2 on the Cleaning Cost Estimatesworksheet. This is being
formatted to indicate to the user of this worksheet that a number is to be entered into the cell.
17. On the Cleaning Cost Estimates worksheet, enter a formula in cell C3 that calculates the
estimated cleaning expenses given the number that was entered into cell C2. Now that we have
calculated the variable and fixed expenses on the Cost Analysis worksheet, we can use the
results to estimate the cleaning expenses. The formula is a + bX, wherea is the fixed cost, b is the
variable cost, and X is the activity level that is typed into cell C2. The fixed cost is added to the
result of multiplying the variable cost by the activity level in cell C2. Format the output of the
formula to US dollars with zero decimal places.
18. Save the workbook by adding your name in front of the current workbook name (i.e., “your
name Chapter 2 CiP Exercise 2”).

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

White Page

 Choose one of the Business Scenario Options to establish the audience and business perspective for your Emerging Technology Analysis Report.

 F. The NASCAR industry intends to implement the emerging technology you choose to augment current operations, amplify data collection,storage and usage, and to provide fans, investors, and companies with the most current capabilities possible. 

  • Consider the Topic Options presented under each of the Emerging Technology Categories and choose one topic option
  •  
    Digitalized Ecosystems Topic Options:5.1)Blockchain for Data Security 
Instructions

In your role as a consultant in your chosen business scenario, write a white paper that includes:

  • An executive summary or abstract (integrate business scenario description)
  • A detailed technical description of the purpose (what it does) and function (how it works) of the topic option you chose
  • Why this chosen technology solves the business problem or satisfies needs

Assessment Requirements/Submission Requirement:

  • 1000 words minimum, not including references
  • 3 scholarly references

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

CIS498 Final Project: Project Plan

 

Final Project: Project Plan

Due Week 10 and worth 300 points

This assignment consists of three (3) sections: a written project plan, a revised Gantt chart or project plan, and a project plan PowerPoint presentation. You must submit the three (3) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

While taking all business and project parameters into consideration, make quality assumptions to support the following requirements.

Section 1: Written Project Plan

You are now in the final stage of the project plan development. All previous documentation will be combined into one (1) document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team and the venture capital group. The project plan is very detailed which is appropriate to accomplish the monumental task of implementation. However, the executive team is only interested in a ten (10) minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive group that your solution is optimal.

1. Write an eight to ten (8-10) page executive summary in which you provide a high-level technical overview of your project where you address the following:

  1. Describe the scope of the project and control measures.
  2. Describe the goals and objectives of the project.
  3. Give a detailed, realistically estimated cost analysis of the entire project.
  4. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization.
  5. Provide all aspects of the information technology implementation into the project plan.
  6. Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
  • Include charts or diagrams created in MS Visio and MS Project as appendix of the Word document. Make reference of these files in the body of the Word document.

Section 2: Revised Gantt Chart / Project Plan

Use Microsoft Project or an open source alternative, such as Open Project, to:

2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 4: Infrastructure and Security, with all the project tasks.

Section 3: Project Plan PowerPoint Presentation

Additional to your detailed executive summary you must present your findings to the executive team and the venture capital group that, along with the executive summary, will convince the group that your solution is optimal.

3. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you:

a. Illustrate the concepts from your written report in Section 1 of this assignment.

b. Create bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.

c. Use a professional technically written style to graphically convey the information.

The specific course learning outcomes associated with this assignment are:

  • Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations.
  • Evaluate the issues and challenges associated with information technology integration.
  • Summarize the competitive advantage that information technology affords to organizations.
  • Use technology and information resources to research issues in information technology.
  • Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

 My Original project was based on a company named bicycle trader which essentially was very similar to “Ebay” in its function, if that’s relevant. 

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now