advanced-queries

Assignment Description

Graduate Programs Discussion Boards

Discussion Boards (DB) are a key component of online learning. They foster active participation of learners and dialog with fellow learners and instructors. Graduate-level courses require learners to create original posts to course DBs and to engage in dialogue by responding to posts created by others throughout the course. Original posts and responses should be substantive, and if references are made to the works of others, APA guidelines for in-text citations and references apply.

Minimum Weekly DB Expectations

  • Post an original and thoughtful Main Post to the DB prompt.
  • Respond to at least 2 other posts from learners and/or the instructor (Response Posts).
  • The first contribution (Main Post or Response Post) must be posted before midnight (Central time) on Friday of each week.
  • Two additional responses are required after Friday of each week.
  • For DB assignment prompts with a Part One and Part Two, Part One should be addressed in the first week of the unit with a Main Post and minimum of 2 Response Posts, and Part Two should be addressed in the second week of the unit with a Main Post and a minimum of 2 Response Posts.

More on DBs

At the end of each unit, DB participation is assessed based on level of engagement and the quality of the contribution to the discussion. DBs allow learners to learn through sharing ideas and experiences as they relate to course content. Because it is not possible to engage in two-way dialogue after a conversation has ended, no posts to the DB are accepted after the end of the unit. Learners must demonstrate an appropriate depth of understanding of course content to receive credit for having submitted substantive posts. Typically, this is achieved with 3–4 strong paragraphs for Main Posts and 2–3 strong paragraphs for Response Posts.

Discuss the following in the Discussion Board:

  • Think of a purpose for creating a database and describe the database. Explain why you would want to use a database for this purpose.
  • What example could you offer that would demonstrate using a subquery?
  • What example could you offer that would demonstrate using a join?
  • In your view, would you prefer using subqueries, or joins, and why?
  • What are some performance considerations when determining whether to use subqueries or joins?

In your own words, post a substantive response to the Discussion Board question(s) and comment on other postings. Your response should address the DB question(s) and move the conversation forward. You will be graded on the quality of your postings, including mastery of the concept as well as critical thinking. If asked for your opinion, do not simply state that it is a good or bad idea; elaborate on your reasons and argument. Include enough detail to substantiate your thinking as well as your position on the questions or comments.

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

Grading Criteria

Project Criteria Exceeds: 90%–100% Very good: 80%–89% Meets: 70%–79% Needs Improvement: Below 70%

Content
(40%)

Response covers all topics indicated in the assignment and adds additional content. The writing was of collegiate level with no errors in spelling or grammar. Response covers most topics indicated in the assignment. The writing was of collegiate level with one or less errors in spelling or grammar. Response covers many topics indicated in the assignment. The writing was of collegiate level with two or less errors in spelling or grammar. Response covers none to some of the topics indicated in the assignment. The writing was less than collegiate level with errors in spelling or grammar.

Interaction
(40%)

Multiple learner interactions per week that add to the discussion. Responses show evidence of critical analysis with questions to other classmates. At least three learner interactions per week that add to the discussion. Responses show evidence of critical analysis. No less than two learner interactions per week that add to the discussion. Responses show evidence of critical analysis. Zero to one learner interaction per week in the discussion board. Response lacks evidence of critical analysis.

Supporting Analysis
(20%)

Analysis exceeded minimum requirements. Appropriate sources were used to support analysis and were properly referenced. Basic analysis provided to support discussion. When appropriate to support discussion, appropriate sources were cited and properly referenced. Some limited analysis provided to support discussion. When appropriate to support discussion, sources were cited, appropriate, and properly referenced. No or inaccurate analysis, no sources were cited when needed, analysis and/or sources were not appropriate. When sources used, were not properly referenced.

Reading materials:

http://dba.fyicenter.com/faq/sql_server/Using_Subqueries_with_the_EXISTS_Operators.html

Titlesortable Typesortable Publishersortable Editionsortable ISBNsortable Termsortable Course Codesortable

Modern Database Management by Hoffer, Kenkataraman

e-Book – VitalSource Pearson 12 9780134402109 2001C ITCO630-01

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now