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

The degree of support for human services is influenced by - Regional container lines sri lanka - Federal reserve bank of st louis page one economics answers - Burke litwin model strengths and weaknesses - How to calculate cpk in excel - Bransford and johnson 1972 summary - Environmental effects on microbial growth lab report - Consumer Behavior Assignment 2 - Collision theory of reaction rates - Output unit level costs - Hipaa data backup plan - Byron bay cookie jar - Principles of macroeconomics libby rittenberg and timothy tregarthen pdf - Tvm solver graphing calculator - In the following piece, what is the form in the passage from 0:11 to 0:44? - Q & Q A7 - 2/20 patty street mentone - Medial meniscus tear old icd 9 cm code - N mm2 in pa - Aglc referencing microsoft word - Estas faldas elegantes están de moda - Develop a hypothesis relating to the amount of dissolved oxygen - Using prenumbered checks and having an approved invoice - Insead global executive mba - Sarah-reply to discussion board - Research paper and ppt - Durable fragrant timber crossword - Emergency light installation instructions - Fully human in a virtual space - Steam client ip address - Nursing - Example of a character sketch bible study - Building vocabulary: angiosperm reproduction - Gartner penetration testing magic quadrant - A woman's hands poem by eva bezwoda analysis - Similarities between taming of the shrew and 10 things - Fire sprinkler pipe fabrication - Domestic building contracts regulations - I kb plus ladder - Meichenbaum self regulated learning - Sculpting Success: Portfolio Management Assignment Writer Extraordinaire - Dell xps 8500 motherboard sata ports - Mn national guard open vacancy - Occupational health and safety risk register - Best sound level meter app for android - John of plano carpini primary source - Api hydrostatic test procedure - Research article - Transformation process in operations management examples - Stylestics - Hilltop hoods exit sign chords - Trans world airlines inc v hardison - Off the plan stat dec - Crb auto finance overnight payoff address - Ecotourism discussion questions - Wk 1 - Advisory Memo: Employment Issues [due Mon] - Tower hamlets penalty charge - Article Critique - Emerson process management educational services - Medical report about improvement system for practical issues, a computer related task or function in an area of healthcare that is relevant - Cetco waterstop rx 101 data sheet - Gcse product design project ideas - Xsu spring concert - Wolverton sexual health clinic - The basic problem portrayed by the traditional phillips curve is - Fitness fanatics is a regional chain of health - Do you think this amendment could be passed today explain - Assignment: Ethics: Do No Harm - Risk acceptance mitigation transference avoidance - Informative speech on walt disney - Mass media ethics case studies - Callista roy - Barns green primary school - Smart energy answers whirlpool - Dissolving solid sodium hydroxide in water is exothermic or endothermic - Cultural diversity what role does it play in patient safety - Effective training systems strategies and practices 5th edition test bank - Funny persuasive speech topics - Almarai financial analysis - 8 steps of research process - King solomon's mines analysis - In 508 bce, who instituted the first athenian democracy by establishing a council of five hundred? - Calculate the inductance of a solenoid containing - Unit 2 DB - 84199 jenny b gift cards - Pegging currency to gold and guaranteeing convertibility - Arabic gcse speaking questions - Dramatic techniques used in romeo and juliet - Border collie association nsw - Section 129 conveyancing act 1919 - Research Article UploadAssignment - What is an informative text - Ethical dilemma examples in pediatric nursing - Test 7 segment display - Telestar international case study solution - Business government and society pdf - Conclusion to acid base titration lab report - Define accounting what are its objectives - Po box 30425 salt lake city 84130 - Installation ceremonies for every group