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

Examine the relational model and ER diagram and derive the SQL queries to return the required information

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.
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 Deliverycapitalessaywriting.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. Examine the relational model and ER diagram and derive the SQL queries to return the required information

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