MAT 2051 Unit 2 Discussion DQ1 Relational Databases

MAT 2051 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.