Capella MAT2051 Unit 2 Discussion (dq1+dq2) Latest 2019 October

MAT2051 Discrete Mathematics

Unit 2 Discussion

DQ1 Relational
Databases

Relations
and functions play important roles in computer applications, systems
management, database management, and error management. In this discussion, you
will look at relational databases and their functions and applications.

Databases
are common computer and Internet technology applications. Online banking,
shopping, iPhones, music, video, personal files, businesses, governments, and
academic institutions all use databases to store, process, and retrieve
information, including images, video, and music.

Suppose you
are a database manager and oversee a large database with the following four
tables: EMPLOYEE, DEPARTMENT, SUPPLIER, and BUYER.

Now, turn
to page 168 in the text. Under Exercises, you will see these four tables listed
as 3.6.4, 3.6.5, 3.6.6, and 3.6.7.

Part 1:
Table and Database Operations

Complete
the odd problems from 5 through 15 on page 169.

Write out
each question fully.

Write a
sequence of table operations to answer the query required for each question.

Provide the
final answer to the query for each question.

Part 2:
Researching the Web for Database Applications

Create two
paragraphs that describe two current database application packages. For
example, you might choose Oracle and SQL Server.

Read about
what these packages offer, how they are alike, how they are different, and what
applications they are best suited for.

What
language is commonly used to manipulate and communicate with database
applications? Offer a few examples of statements from this language.

Review the
Discussion Participation Scoring Guide prior to posting.

Response
Guidelines

Read your
peers’ posts and respond to two. Do you agree with your peer’s assessment of
the problem? Explain.

DQ2 Practice
Problem Set Review

This
discussion allows you to work with your peers to complete and understand the
assigned problem set for this unit. Remember, two initial posts and two
response posts are required. Further posts are optional and recommended:

For the
first post, select a problem from this unit’s problem set, write it out fully,
solve it fully, and post it.

The second
post can be a problem you cannot solve or another fully solved problem from the
problem set. If there is a problem in the problem set that you are confused
about, write it out fully and show any work that you have started. Note that
you are stuck and ask for help. If you are able to solve every problem in the
set without difficulty, post at least one other fully solved problem from the
set as your second post.

The third
and fourth posts are responses. Response guidelines are provided below and in
every discussion.

Take
advantage of this discussion area to work together as a class on the problem
set. Post as many problems as you can and review as many of your peers’ posts
as you can. Ask questions. Offer answers. If you are stuck on a problem, post
your question. Working as a team will help each person gain a better
understanding of the problem set and the concepts covered in this unit.
Although the problem sets are not graded they will help you prepare for the
quizzes in this course.

Response
Guidelines

The third
and fourth posts, the response posts, are your chance to help your peers.
Explore the posts made by your peers and find people who are stuck. Help at
least two peers through the problems they are stuck on. If you are unable to
locate a peer who is stuck, you may instead choose a peer post, write out your
solution to the same problem, and compare solutions and methods. The goal of
this area is for the entire class to work together as a group on the entire
problem set. You are also expected to complete and understand the problem set
on your own in preparation for the quizzes and final exam.