Tag: database

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
Categories
Writers Solution

design and build a database for a company, Oopsy Cell repair.

For this individual project you will design and build a database for a company, Oopsy Cell repair. The write up for the company is provided in the paragraph below. To complete this project, you will bring to bear all that you have learnt in this class. First, you will need to design a database by constructing an ERD. Next, you need to identify all relevant attributes and normalize to complete your database design. Next, you will construct a SQL database with relevant tables, based on your design, and populate it with data (4-5 rows data for each table will be enough). You will then come up with 5 complex query questions (defined as ones involving joins or subqueries) and the sql query code solutions. Your project submission must contain your ERD, a copy of your database diagram, and the five query questions and a snapshot of the output of the five queries. Limit your project document to no more than 4-5 pages, single spaced 12-point font. You are welcome to make reasonable assumptions, but make sure you note them in your project report. Limit your project to no more than 10-12 entities.

 Oopsy Cell Repair (OCR) is a Chicago based company with 9 locations in and around Chicago and its suburbs. Founded in 2012, OCR offers repair services to customers who are facing problems with their cell phones. Reflecting the slogan, “All will be well, with us working on your Cell”, OCR offers various services at a fixed price including screen replacement, battery replacement, data retrieval, data removal, etc. OCR can repair multiple brands of cell phones including Apple, Samsung, Nokia, Google, etc. OCR prides itself in providing upfront and transparent pricing for its services. Each of the nine locations is headed by a location manager along with 4-6 service employees. All service employees are trained to do all repairs, so there is no employee specialization or departmentalization. Further, to create a single contact point for the customer, one employee is in charge of all the repairs to a customer’s phone. OCR is seeking your help to create a database that can capture all relevant information for their business

  • 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
    • 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. design and build a database for a company, Oopsy Cell repair.
    • 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.

    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

manages the database management systems for a multitude of large corporations

As a middle manager for a cloud provider company, you are responsible for the team that manages the database management systems for a multitude of large corporations. While assisting a client with some troubleshooting, one of your employees gains some insight into their database structure. It later comes to your attention through a co-worker, that said the employee has an inside scoop about an upcoming business transaction that the client is pursuing and, if he played his cards right, he could be rich!  What do you do?  Why?

    • 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
      • 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. manages the database management systems for a multitude of large corporations
      • 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.

      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

creating a database of your own

Overview

In this project, you will be able to apply what you learned in this module to something familiar, by creating a database of your own.

Objectives

  1. Create, open and close a database,
  2. Create and use tables, queries, forms and reports
  3. Design a database to satisfy a collection of requirements
  4. Create queries using text and numeric data in criteria
  5. Sort data and join tables in queries
  6. Add, change, delete, search and filter records

Instructions

The database you use in this Project will be the same database you will use for your Discussion for this Module. Read instructions for both assignments before starting.

You will be using this database for Projects in future modules. Keep that in mind as you develop, as you will be continually adding to this database.

Identify a database that could be useful to you personally or professionally. You may start out relatively simple, but keep in mind that your database will become more complex the semester progresses.

Along with the database, create a doc, rtf, or PDF file with information about who the intended user of the capstone is and what the purpose of the capstone is. Please check spelling and grammar and use complete sentences. This file should be put into the D2L folder alongside the capstone.

  • Explain the purpose of your database and who will be using it.
  • Create the design of your database, including names of tables, primary keys, and types of relationships.
  • Create the database in Access based on your design
    • Tables with all fields according to your database design, and at least 5 records.
    • Form – your choice for the purpose of the form
    • Query – What do you want to know from your database information?
    • Describe the purpose of the Form and the Query you created
  • Save and Name your database and include your LAST NAME in the file name.

Upload your database and the planning document you created to the folder. Save a copy to use in the next module. Use the feedback received after this is graded to make changes so that it will be ready to go for the next Module.

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
  • 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. creating a database of your own
  • 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.

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

Create a set of Navigation Forms, using Command Buttons to make your database easy to navigate.

Overview

You now have all the parts of your database working correctly, including Tables, Forms, Queries, Reports. You have used Commands, Controls and Look-up Fields to make your database easier to use. In this Module, you will be adding the finishing touches to your database!

Objectives

  1. Create and modify macros, sub macros, and a menu form with command buttons and with an option group
  2. Create datasheet forms, user interface macros, navigation forms, data macros, and control layouts
  3. Create custom categories and groups in the Navigation Pane
  4. Encrypt a database and set password, lock and split a database.

Instructions

The final and finishing touch to your database will be Navigation Forms and of course, Security! The requirements of this assignment include:

  1. Create a set of Navigation Forms, using Command Buttons to make your database easy to navigate. You may need to draw this, much like you did your database design, to decide how you want the Navigation system to work. It needs to include the following techniques:
  2. Create and/or modify Macro(s)
  3. Create Navigation Form, including Command Buttons, and User Interface Macros
  4. Create Custom Categories and Groups in the Navigation Pane of the Database
  5. Encrypt the database and set password.
  6. Lock the Database
  7. Write a summary of the changes you made to the database, including providing the password for the database. In your summary, include reasoning or justification for each of the changes you made.

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
  • 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. Command Buttons to make your database easy to navigate
  • 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.

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

Develop an extensive “written” Big Data toolbox that will accommodate all of the conventional database methodologies

Assignment

As the senior data analyst for Exact, LLC, an information clearinghouse, you have been tasked to develop a comprehensive Big Data toolbox that will be used by all of the Data Analysts in your department. The use of this toolbox will allow your company to stay ahead of its competitors.

Instructions

Develop an extensive “written” Big Data toolbox that will accommodate all of the conventional database methodologies such as SQL Server, NoSQL, and NewSQL. This toolbox should compare the various tools and techniques required for moving data. Include an instruction set that explains how to use each of the tools listed. In addition, you need to prioritize the issues pertaining to data governance and how it applies to the use of these tools to keep your company ahead of its competitors. Your toolbox needs to consist of at least 3 pages and be professionally written using Word.

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. Develop an extensive “written” Big Data toolbox 
  • 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.

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

ABI/INFORM Collection database

From the CSU Online Library, choose an article within either the ABI/INFORM Collection database or the Business Source Ultimate database on the topic of the ethics of drug testing in the employment setting.

After reading the article, write a 500-word article critique by addressing each of the following items:

– Briefly introduce and summarize the article.
– Do the author’s arguments support his or her main point?
– What evidence supports the main point?
– How could the topic of this article apply to your personal or professional life?
– How could the topic apply to an organization you have observed?
– How would you explain the role of leadership in corporate culture, and how would you describe        leadership styles and how they affect ethical decision-making?
– Are there any inherent unethical practices with drug testing, though it is technically legal?
– What conclusions can you draw about the ethical issues facing business leaders?

The Unit II Article Critique should be at least 500 words in length, double-spaced, and written in Times New Roman, 12 point font.

SEE SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

In the article “Defining Privacy in Employee Health Screening Cases: Ethical Ramifications Concerning the Employee/Employer Relationship”, Michele Simms discusses the legal definitions of employee privacy and how that definition impacts on the ethicality of employee health screening. The author of this article explores who decisions by the federal court that involved employer HIV and drug testing (Simms, 1994). From this analysis, the author concludes that the psychological impact of employee health screening will determine the legal definitions of privacy and hence employers must take into consideration such psychological impact when determining the ethicality of their employee screening requirements.

The author’s argument in this article largely aligns with the main point that the article intents to make. For instance, the author defines privacy and how it relates to ethics. More importantly, the author demonstrates…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….. ABI/INFORM Collection database 

NOTE THAT WHAT YOU HAVE JUST READ IS A SAMPLE PAPER ABOUT THE TOPIC. CLICK THE ORDER BUTTON TO ORDER YOUR OWN PAPER

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

U.S. Securities and Exchange Commission’s EDGAR database website SEC.gov

The following programmatic competencies:

3.1: Use financial statements in order to evaluate the efficiency and effectiveness of an organization.

5.3: Evaluate budgeting and accounting reports to determine the financial strength of an organization or financial proposal.

The purpose of this assignment is to analyze an annual SEC report in order to evaluate the financial strength, efficiency, and effectiveness of an organization. Visit the Company Filings search page of the U.S. Securities and Exchange Commission’s EDGAR database website (SEC.gov), located in the Topic Materials. Search publicly traded companies and choose one to use for this project. Submit your selected company to the instructor for approval. Locate the company’s most recent annual report (10K) and download it.

Read and analyze the “Management Discussions and Analysis of Financial Condition and Results of Operations” and “Financial Statements and Supplementary Data” sections of your selected company’s annual report. Based on the information found, calculate the relevant ratios and write a 500-750 word analysis providing an assessment of the following with a determination of whether your company of choice is favorable or unfavorable:

  1. Liquidity
  2. Effectiveness
  3. Leverage
  4. Profitability

Conclude with an evaluation of the overall financial strength, efficiency, and effectiveness of the organization based on your findings. 

Categories
Writers Solution

SaleCo_DW database

Description

Using the data provided in the SaleCo_DW database, solve the following problems.

  1. What is the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales?

  2. What is the SQL command to list the total sales by customer, month and product, with subtotals by customer and by month and a grand total for all product sales?

  3. What is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total for all sales?

  4. What is the SQL command to list the total sales by month and product category, with subtotals by month and a grand total for all sales?

  5. What is the SQL command to list the number of product sales (number of rows) and total sales by month, with subtotals by month and a grand total for all sales?

  6. What is the SQL command to list the number of product sales (number of rows) and total sales by month and product category with subtotals by month and product category and a grand total for all sales?

  7. What is the SQL command to list the number of product sales (number of rows) and total sales by month, product category and product, with subtotals by month and product category and a grand total for all sales?

  8. Using the answer to Problem 6 as your base, what command would you need to generate the same output but with subtotals in all columns? (Hint: Use the CUBE command).https://onlineessay-writingservices.blogspot.com/2019/12/the-australian-college-of-business.html
Categories
Writers Solution

NoSQL database management system

For each of the following four cases, select the type of NoSQL database management system that would fit best the needs of each unique situation described below. Be sure to also include an applicable diagram and sample script for each situation.

  1. The database has to support a relatively complex hierarchical internal record structure that may vary for each record.
  2. The key requirement for the database is to access a specific record as quickly as possible without any concern regarding the internal structure of the record.
  3. The data are particularly well suited to be organized as a network of associations between the data items.
  4. It is important that the DBMS provides quick access to each of the records by a key value, but, in addition, it has to also allow easy access to the components of each record.

In order to successfully complete this activity, you’ll need to do some outside research on NoSQL. Pages 322-323 in the textbook discuss NoSQL from a high level. Start there then find outside sources to use to complete this activity. Additionally, I’ve included some text from another book I’ve used in the past for this topic, attached here, for your assistance in completing the activity.