Tag: design

Categories
Writers Solution

Understand and apply the key features of advanced Web design and programming features (MVC and Razor)

Developing Web Application
Individual Assessment
Project
March 2021
Individual Assessment:
Weightage: 25%
Report deadline: Week 12
This assessment relates to the following Learning Outcomes:
LO1 Understand and apply the key features of advanced Web design and programming features (MVC and Razor)
LO2 Create a web application by using web server controls, event handlers, application state, and session state
LO3 Develop client-server applications with form validations using client-side scripting and server-side database connectivity
LO4 Analyze security requirements and build websites with authentication and authorization features
LO5 Enforce quality and reliability to debug, troubleshoot, deploy, and monitor Web applications
Overview:
In this project, you are required to design and develop your own personal portfolio website. The labs will help you to acquire the basic knowledge to complete the website. It is highly recommended that you complete your lab work each week. You can also refer to online resources.
Web Requirements:
Develop a web application with ASP.NET MVC using C# and RAZOR & Visual Studio 2013/2015/2017. Your website should contain following pages
Home Page Requirements
• You should add a home controller in your project with having index view.
• The purpose of the website should immediately be clear from the home view.
o It must contain the short introduction of yourself and your career ambition. For Example: “John Carter”. Software Developer. I design and develop
ASP.NET web applications o A short paragraph (40-80 words) about your career ambition.
• Make this view more creative than rest of your views. Add images, visually appealing design.
• Try to reflect your style and personality. First impression count!
Contact Page Requirements
• Give this view an appropriate name. In this view you need to add a contact form.
• The form must contain the name, email, and comment fields.
• You must apply the appropriate validation rules on these fields to make sure that use have entered the correct email or name is not just numbers.
Requirements of five additional pages
• In addition to the home and contact pages, you are given creative freedom to design and develop the rest of your personal website yourself with only a few specific requirements, but you must have a portfolio page to show case your projects.
• You need to design and develop five more web pages for your personal website for a total of seven that specifically reflect the career focused purpose of the website.
• Some suggestions (but you may think of your own) are shown below:
o About, Achievements, Bio, Blog, Career, Design, Education, Experience, Gallery, Hobbies, Journal, Ideas, Photography, Portfolio, Testimonials, Travel.
Database Requirements
• In portfolio page you need to list your projects. These projects must include the project title, Year of completion, Company Name, Description.
• You need to create a database for storing each project details as shown below
Title Year of
Completion Company Description
Student Management System 2019 VIT I have developed the student record system where all students’ details are managed.
IoT based bushfire system 2018 AuGov In this system we have develop a wireless sensor network to detect bushfires in dense forest
Timetable Generation 2017 VIT I used a genetic algorithm to develop a automatic time table generation software
• And as a register user you can add, update, and delete the projects.
Submission Guidelines
• You need to put all explanation about the steps you took to create your application, and screenshots of your web application in one report (.doc/pdf) file.
• Submit all your code files and a report file in a zip folder on Moodle before the due date.
• Your submission folder name should be “Project_X_YY.doc” (where X is your name and Y is your student ID).
• The Late penalty applies on late submission, 10% per day would be deducted.
• Incidence of plagiarism will not be tolerated and would be penalized.
Marking Guide: 25 Marks
Task Description
Design Created appropriate webpages using MVC pattern as well as Razor and information is displayed according to the requirements
Database Create database with the mentioned tables, filled appropriate data, allow register user to edit, delete, add and see the details
Controls and
Event Handlers Appropriate web server controls, event handlers, application state, and session state have been used
Quality Enforce quality and reliability to debug, troubleshoot, deploy, and monitor web application

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals Understand and apply the key features of advanced Web design and programming features (MVC and Razor)

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG
Categories
Writers Solution

Develop an Operating Systems Design Document with your proposal for an enterprise that you selected by looking at emerging technologies and architectures to see how they might support future requirements

Key Assignment

Project: You will finish your Key Assignment project in this last week, which was to develop an Operating Systems Design Document with your proposal for an enterprise that you selected by looking at emerging technologies and architectures to see how they might support future requirements.

In the previous 4 weeks, you were first asked to select a real or fictitious enterprise that plans to upgrade its operating systems for movement to a distributed and virtual environment. Each week, you contributed with proposals for particular components of the operating system that culminated in an overall Key Assignment operating systems design report as follows:

Part 1 Tasks (Objectives from Week 1–4):

Week 1: Description of the enterprise operating system’s overall technical challenge and the proposed solution as it relates to the processor and core in a distributed environment

Week 2: Description of the proposed solutions as they relate to scheduling algorithms

Week 3: Description of the proposed solution as it relates to an operating system concurrency mechanism

Week 4: Identification of security risks and mitigation strategies to deal with the risks

Part 2 Tasks (Objectives for Week 5):

finally, you are given the assignment to explore emerging computing technology and computer system architectures to assist you in making recommendations on how to extend present operating system functions to support new requirements. This is your final assignment, which is a proposal based on what you perceive are the present operating system challenges as well as near future challenges for the enterprise you selected.

The project deliverables are the following:

Update the Operating Systems Design Document title page with the new date and project name.

Update the previously completed sections based on instructor and peer review feedback.

Add the following new content:

Future considerations using emerging technology

Identify and describe at least 3 emerging technologies or architectures that have the potential for supporting future requirements.

Discuss the specific current or future enterprise strategic requirements that could benefit from the emerging technologies

Discuss the potential benefits for adopting these emerging technologies.

Name the document “YourName_CS_IP5.doc.”

Submit the document for grading.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials

GET SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Develop an Operating Systems Design Document with your proposal for an enterprise that you selected by looking at emerging technologies and architectures to see how they might support future requirements

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

design a survey you can use to conduct a pre-and post-assessment for your capstone

Assessment Description

Based on your needs analysis and your capstone preparation, design a survey you can use to conduct a pre-and post-assessment for your capstone. The survey should include success indicators to help you collect data about the effectiveness of the project.

While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

GET SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services design a survey you can use to conduct a pre-and post-assessment for your capstone

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Intro to sys analysis & design

Attached are 3 PDFs. The 1st 2 are copies of Chapter 1 of “Intro to sys analysis & design”. The 3rd is a copy of the questions to be answered.  Please answer questions 1-10 with at most 2 full questions, no need for a full paragraph per question.  The files are attached in order. 

GET SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Intro to sys analysis & design

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Analyze the organizational design of the selected agency’s human resource management in relationship to the entire organization.

ASSIGNMENT 2: EVALUATION OF AGENCY’S PUBLIC PERSONNEL ADMINISTRATION, PART 2

Due Week 5 and worth 250 points

Refer to the Scenario for Assignments 1, 2, 3, and 4.

Write a four (4) page paper in which you:

  1. Analyze the organizational design of the selected agency’s human resource management in relationship to the entire organization. Assess its strengths and weaknesses. (Title this section “Organizational Design”)
  2. Assess the agency in terms of its global or international linkages, highlighting its application of theory to its approach to personnel management. (Title this section “Global Linkages and Personnel Management”)
  3. Analyze at least three (3) of the major components of the agency’s human resource system’s goals and practices regarding the recruitment and hiring of a qualified workforce. (Title this section “Personnel Recruitment and Hiring Practices”)
  4. Evaluate the agency’s approach to training and programs provided for new and existing employees for the development of knowledge, skills, and overall competencies, highlighting the strengths and weaknesses. (Title this section “Employee Skills Training”)
  5. Recommend at least two (2) actions the agency could take to improve in the areas of recruiting and training a qualified workforce. (Title this section “Recruiting and Training Recommendations”)
  6. Appropriately incorporate at least four (4) quality sources. A quality source can be either popular, such as a news article, or scholarly, such as peer reviewed works. In the case of public administration, government websites are appropriate quality resources. Note: Wikipedia, SparkNotes, and similar websites do not qualify as academic resources. Visit the Strayer University Library at http://research.strayer.edu to conduct research.

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, revisions of the previous assignment, and the reference page are not included in the required assignment page length.

The course learning outcome associated with this assignment is:

  • Evaluate the major components of the public personnel management system

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills. Click here to access the rubric for this assignment.

GET SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Analyze the organizational design of the selected agency’s human resource management in relationship to the entire organization.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

The Power of Good Design(https://www.vitsoe.com/gb/about/good-design) and select three of the ten principles noted for good design.

Review The Power of Good Design(https://www.vitsoe.com/gb/about/good-design)  and select three of the ten principles noted for good design. Next in R, utilize these three principles in a problem that you will solve. First note the problem to solve, the dataset (where the information was pulled from), and what methods you are going to take to solve the problem.  Ensure the problem is simple enough to complete within a two-page document. For example, I need to purchase a house and want to know what my options are given x amount of dollars and x location based on a sample of data from Zillow within each location. Ensure there is data visualization in the homework and note how it relates to the three principles selected.

GET SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services The Power of Good Design(https://www.vitsoe.com/gb/about/good-design) and select three of the ten principles noted for good design.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

APIs and JSON modern design including responsive design and media queries server-side technologies such as Node

ASSIGNMENT INFO
You are going to build a website. The point of this assignment is to demonstrate your competency in the areas outlined in this course – so your site is going to have to demonstrate your skills in:
HTML
CSS
JavaScript
AJAX
the use of APIs and JSON
modern design including responsive design and media queries
server-side technologies such as Node.js
development tools such as VS Code and Git
workflows/best practices when it comes to development, such as research, handling errors and continuous work on your site over the semester
You will choose the topic of the website… your coach will provide the design that you will reproduce with your content. There are no explicit requirements – that is, there is no checklist of things to include – you will include enough content in your site to demonstrate your competencies. You will continuously seek feedback on your site throughout the semester to know if you are effectively demonstrating competency or not. Your coaches will also negotiate new features with you throughout the semester to ensure your site is comprehensive enough.
** YOU MAY NOT USE A PRE-BUILT TEMPLATE (e.g. BOOTSTRAP).
Milestone schedule:
There are no required milestones or due dates that any part of your site needs to be completed by. You are encouraged to work continuously and at the pace you feel comfortable with. However, as a guide, below is a suggested milestone schedule if it helps you plan your time. This is broken into 2-weekly sprints.
SPRINT 1 (week 1 & 2)
Basic HTML structure completed.
All pages planned and basic navigation implemented.
Basic CSS/styling completed.
SPRINT 2 (week 3 & 4)
Content planned – initial JSON structure planned or API selected for use.
Style improvements – responsive design – media queries etc.
SPRINT 3 (week 5 & 6)
Dynamic loading of JSON or API data/dynamic creation of content.
AJAX implemented for asynchronous data loading.
SPRINT 4 (week 7 & 8)
Further design enhancements/refinements – integration of Bootstrap?
Some interactive UI/UX elements – JavaScript (navbar? side panel?)
SPRINT 5 (week 9 & 10)
Server set up.
Basic server functionality implemented.
Pages re-written as templates?
SPRINT 6 (week 11 & 12)
Data moved to server-side? API written?
Server enhancements – routing?
SPRINT 7 (week 13 & 14)
Advanced JavaScript UI/UX functionality? (‘fancy’ features?)
jQuery integration?
SPRINT 8 (week 15 & 16)
Final refinements
Deployment

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals APIs and JSON modern design including responsive design and media queries server-side technologies such as Node

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Crime Prevention Through Environmental Design

 You need to begin thinking about your Research Paper. The subject is CPTED (Crime Prevention Through Environmental Design) Best Practices. Please download the Research Paper Template and begin your research. Instructions are in the template. Need a paper in the below format. 

NEED BY SUNDAY MORNING

NO PLAGIARISM 

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Crime Prevention Through Environmental Design

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Architecture and design represent one important side of delivering a security posture.

Length: Minimum of 400 words

Students will be required to create 1 new thread, and provide substantive comments on at least 3 threads created by other students. Make sure to explain and backup your responses with facts and examples. This assignment should be in APA format and have to include at least two references.Question:Architecture and design represent one important side of delivering a security posture. That’s what this book is all about: How does one go about achieving an architecture and an architectural design that represent the security needs for a system ?

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Architecture and design represent one important side of delivering a security posture.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.

ASSESSMENT 2 BRIEF
Subject Code and Title MIS602 Data Modelling and Database Design
Assessment Database Implementation
Individual/Group Individual
Length N/A
Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:
b) Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.
Submission Due by 11:55pm AEST/AEDT Sunday end of Module 4.2
Weighting 35%
Total Marks 100 Marks
Task Summary
In this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests from an existing database and develop appropriate SQL statements to satisfy those requirements.
Context
Being able to query a database is a fundamental skill that is required by all information systems professionals who work with relational databases. In this assessment, you will utilize the basic query skills that are typically used to extract information for analysis, reporting and data cleansing in a data management setting. Timely provisioning of key business information promotes effective communication and enhanced solution delivery.
Task Instructions

  1. Please read the attached MIS602_Assessment 2_Data Implementation_ Case study.
  2. Examine the relational model and ER diagram and derive the SQL queries to return the required information.
  3. Provide SQL statements and the query output for the following:
  4. List all the customers who live in any part of CAULFIELD. List only the Customer ID, full name, date of birth and suburb (5 marks)
  5. List all of the active staff. Show their Staff ID, full name and weekly salary assuming that they work a 38 hour week (3 marks)
  6. Which plan has the most expensive contract to break? (5 marks)
  7. Which brands of mobile phone does this company sell? List only the unique brand names (3 marks)
  8. Which customer is not able to purchase a phone? Use a query to explain why. Hint: Review the customer data (3 marks)
  9. How many of each phone plan have been sold? (5 marks)
  10. What is the average age of an Apple phone user? (8 marks)
  11. What are the first and most recent mobile phone purchases? (3 marks)
  12. i. For calls made in 2018 how many calls were made on the weekend? (5 marks) ii. For calls made in 2018 how many calls were made on each day of the weekend? (3 marks)
    MIS602_Assessment _2_Brief_Database Implementation_Module 4.2 Page 1 of 3
  13. Provide a listing of the utilization of each tower and its location i.e. how busy each tower is based on the number of connections. Put the busiest tower at the top of the list (3 marks)
  14. Did any users on the ‘Large’ plan exceed their monthly allowance during August 2018? (8 marks)
  15. The company is upgrading all their 3G towers from to 5G.
    i. How many towers will be upgraded? (1 mark)
    ii. what SQL will be needed to update the database to reflect the upgrades? (2 marks)
  16. i. List the full name, join date, resigned date of each staff member and name, join date and resigned date of their manager (3 marks) ii. What do you observe with the data? (2 marks)
  17. How much revenue was generated in 2017 by each plan from call charges. Format the output as currency i.e. $123.45 (8 marks)
  18. List the customers who made phone calls longer than 200 minutes (5 marks)
  19. Which customers have more than one mobile phone? List the customer name, suburb and state. Order by the customer name (8 marks)
  20. Are there any mobile phone plans that are currently unused? This can be obtained a number of ways. Demonstrate this by using the following two query types
    i. Nested subquery (3 marks)
    ii. Outer join (3 marks)
  21. List the oldest and the youngest customers in the postcodes 3000 and 3102. Show the customer full name age and suburb details (3 marks)
  22. i. Create a view that shows the popularity of each phone colour (1 mark) ii. Use this view in a query to determine the least popular phone colour (2 marks)
  23. The billing team is getting returned mail because of bad customer addresses. This is causing a loss in revenue.
    i. Review the customer data and find at least 3 issues (3 marks)
    ii. Provide the SQL statements to correct the data problems (2 marks)
    Total 100 marks
  24. The database used for this assignment is available in ‘MIS602_Assessment 2_Database SQL Files’ folder. Please download the files from this folder.
  25. All statements and first 10 lines of output need to be neatly presented. Please save all your SQL statements and output into a single word document and submit it via the Assessment link in the main navigation menu.
    Referencing
    It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing
    Submission Instructions
    Submit Assessment 2 via the Assessment link in the main navigation menu in MIS602 Database Modelling and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
    Academic Integrity Declaration
    I declare that except where I have referenced, the work I am submitting for this assessment task is my own work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure viewable online at http://www.torrens.edu.au/policies-and-forms
    I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.
    MIS602_Assessment 2_Brief_Database Implementation_Module 4.2 Page 2 of 3 Assessment Rubric Assessment Criteria Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% ? Correct and complete queries ? Display only required information ? Demonstration of additional AQL knowledge 100% Queries are incorrectly answered with marks only sufficient to attain a F(ail). Queries correctly answered with sufficient marks to attain a (P)ass Queries correctly answered with sufficient marks to attain a (C)redit. Display only required information. Queries correctly answered with sufficient marks to attain a (D)istinction. Display only required information Display additional SQL knowledge such as column formatting, table alias, additional calculations etc Queries correctly answered with sufficient marks to attain a (HD) High Distinction. Display only required information. Display additional SQL knowledge. Well formatted queries. Results returned in a meaningful order. MIS602_Assessment 2_Brief_Data Implementation Module 4.1 Page 3 of 3

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery– capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Confidential- It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays