Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Classmates database

19/03/2021 Client: saad24vbs Deadline: 2 Day

2929 unread replies.3636 replies.

In this sixth module, you will practice getting data back out of your database and manipulating data that are resident there. There are many ways for querying data and many ways to aggregate, group, and join your data. In this module’s readings, you learned all about data manipulation language (DML), which is used to pull data out of a database and to manipulate data within the database. For the following discussion, you will get some practice with querying by doing some roleplay of real-world scenarios with your classmates.

Step I

Select an ER diagram that you have worked on during one of the discussions in a prior module. This ER diagram should be in at least third normal form and contain at least three tables and at least two relationships. Post an initial message, in which you do the following:

1. Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates will provide answers based on the requirements. Answers to your three requests should contain at least one JOIN; an aggregation function ; a GROUP By clause; and a WHERE or HAVING clause. Some examples:

1. All sales transactions that occurred in the month of March

2. All students enrolled in IT371 for the Fall 2018 semester

3. The total amount spent per month on hair products

2. Write descriptions for two modifications for data already in the database. Some examples:

1. Change Bobby Ray’s last name to “Jones”

2. Change student number 64’s birth date to 1/1/2001

3. Write descriptions for two deletions for data already in the database. Some examples:

1. Delete student number 23

2. Delete all students enrollments for IT371 for the Fall 2018 semester

4. Attach your ER diagram to your post

or

Step II

Select at least three classmates whose diagrams and queries sound . Write DML statements for each query and post them as replies to your classmates. Do not use a query generator or graphical tool to write these; write them on your own and test them in your chosen DBMS before posting. Try to pick classmates whose requirements have not been answered.

Consult the Discussion Posting Guide for information about writing your discussion posts. It is recommended that you write your post in a document first. Check your work and correct any spelling or grammatical errors. When you are ready to make your initial post, click on the "Reply". Then copy/paste the text into the message field, and click "Post Reply."

To respond to a peer, click “Reply” beneath her or his post and continue as with an initial post.

Evaluation This discussion will be graded using a rubric. Please review this rubric prior to beginning your work. View the rubric by clicking on the gear icon Image of gear icon at the top right side of this page or on the Course Rubrics page within the Start Here module. All discussions combined are worth 24% of your final course grade.

Class Mate # 1

SETH JAMES
MondayNov 13 at 4:50pm

Manage Discussion Entry

Step One

1. Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates will provide answers based on the requirements. Answers to your three requests should contain at least one JOIN; an aggregation function ; a GROUP By clause; and a WHERE or HAVING clause.

· Show all customers that reside in 28460

· Show all customers that spent over $5,000.00 in calendar year 2017

· Show total customer count

2. Write descriptions for two modifications for data already in the database.

· Change the Last name of Rebecca Smith to “Jones”

· Change the email address for employee 170515000001

3. Write descriptions for two deletions for data already in the database.

· Delete invoice 2017061015310001

· Delete employee 170707000001

-SJ

Capture.JPG

C:\Users\Ernie\Desktop\Seth ER Diagram Capture.jpg

Classmate # 2

PAUL NOWAK
SundayNov 12 at 8:54pm

Manage Discussion Entry

1. What movies were released in 1993?

2. What movies has Mel Gibson directed and acted in?

3. How many movies are in .avi format?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Grade Tutor
Quick Mentor
Engineering Exam Guru
Essay Writing Help
24/7 Assignment Help
Professional Accountant
Writer Writer Name Offer Chat
Top Grade Tutor

ONLINE

Top Grade Tutor

Give me a chance, i will do this with my best efforts

$105 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$112 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$125 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$148 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$170 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have read and understood all your initial requirements, and I am very professional in this task.

$58 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Raf dress regulations medals - General healthcare technology trends particularly related to data information - Assignment on marketing mix of pepsi - What is make to stock - Information technology for managers reynolds pdf - Ideal diode equation derivation - Causes of prejudice by vincent parrillo - Pcs property cleaning services - Anatomical terms worksheet answers - Similarities between egypt and philippines - Which does john rutherford use as strong evidence in support of the construction of the erie canal? - Diversity swot analysis example - Historical context chart - 27b agnes street south gladstone - Mcgraw hill marketing simulation answers - Science school certificate past papers - Math Questions - Fe2o3 c balanced equation - Philosophy unit 5 Discussion - Dictionary yahoo hong kong - How to play scene it dvd game - Powerpoint presentation on sonography - Case study - Kyra is using rectangular tiles - W-4 - Theodore boone kid lawyer sparknotes - You're the Boss - Compact laminate cut to size - Inquiries5 - Kinross to perth bus 56 - C06 Online Exam 1_02 SCORE 100 PERCENT - Colour royale 1.5 activator instructions - Special purpose financial reports definition - Jeep brand positioning - Minish cap absent minded scholar - New heritage doll company capital budgeting case analysis - San diego police incident report - ME - Main - Dis 2 - Maslow's hierarchy of needs nursing priority - Cold case by julia platt leonard summary - Adverse possession victoria checklist - Purchase Evaluation - Thinker doer feeler innovator - Dau acq 101 answers - Diamond leaf willow tundra - MGT-321: Intro to International Busines - 221 mill street lake wendouree - Autodesk sketchbook add ons - How to calculate available seat miles - Microsoft linux integration services - Solving higher order differential equations - Case Study - Business and Society 400 word essay - Theory tables psych 645 - How to apply ion boardroom theme - Full draft peer review response - Mission statement of abercrombie and fitch - Data Visualization - Assignment 5 professional cover letter - Differences between maslow's hierarchy and alderfer's erg theory - Week 9 - Projectile motion video analysis lab answers - I won't always cry mummy poem - Bksb diagnostic test online - Preparation of benzoic acid from benzonitrile lab report - Information systems infrastructure evolution and trends - How business process as services - To allot work to teammates - Cross exchange rate problems and solutions - The least squares regression line minimizes the sum of the - Economy - Acsm guidelines for exercise testing and prescription online - Use the web or other resources to research at least two criminal or civil cases in which recovered files played a significant role in how the case was resolved. - How to date a browngirl junot diaz summary - Emotional intelligence in social work practice - José y paco / llamar / una vez por semana (imperfecto) - Annual performance development plan for teachers qld - Frank partridge vc public school - Community policing through environmental design - Acoustical metal pan ceilings - How to light a bunsen burner worksheet - Amazon prime video swot analysis - What is the main question on which Descartes focusses in the First Meditation - Assg - The round house discussion questions and answers - Plagiarism checker usf - The wheel of retailing concept - Tongue tied kingston analysis - Army asco code list - Use of mobile phones in schools essay - Follansbee trick or treat times - Munro by kresley cole release date - Wilson parking royal north shore hospital - What are the three major categories of elements - Individual Article Presentation Business ethics. - Difference between categorical and quantitative data - Assignment 2: Safety Training Manual - Who are the johnsons in a raisin in the sun - Angelina jolie world refugee day speech transcript - Discussion question on Unilever's case