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.
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.
Important information for writing discussion questions and participation
Welcome to class
Hello class and welcome to the class and I will be your instructor for this course. This is a -week course and requires a lot of time commitment, organization, and a high level of dedication. Please use the class syllabus to guide you through all the assignments required for the course. I have also attached the classroom policies to this announcement to know your expectations for this course. Please review this document carefully and ask me any questions if you do. You could email me at any time or send me a message via the “message” icon in halo if you need to contact me. I check my email regularly, so you should get a response within 24 hours. If you have not heard from me within 24 hours and need to contact me urgently, please send a follow up text to
I strongly encourage that you do not wait until the very last minute to complete your assignments. Your assignments in weeks 4 and 5 require early planning as you would need to present a teaching plan and interview a community health provider. I advise you look at the requirements for these assignments at the beginning of the course and plan accordingly. I have posted the YouTube link that explains all the class assignments in detail. It is required that you watch this 32-minute video as the assignments from week 3 through 5 require that you follow the instructions to the letter to succeed. Failure to complete these assignments according to instructions might lead to a zero. After watching the video, please schedule a one-on-one with me to discuss your topic for your project by the second week of class. Use this link to schedule a 15-minute session. Please, call me at the time of your appointment on my number. Please note that I will NOT call you.
Please, be advised I do NOT accept any assignments by email. If you are having technical issues with uploading an assignment, contact the technical department and inform me of the issue. If you have any issues that would prevent you from getting your assignments to me by the deadline, please inform me to request a possible extension. Note that working fulltime or overtime is no excuse for late assignments. There is a 5%-point deduction for every day your assignment is late. This only applies to approved extensions. Late assignments will not be accepted.
If you think you would be needing accommodations due to any reasons, please contact the appropriate department to request accommodations.
Plagiarism is highly prohibited. Please ensure you are citing your sources correctly using APA 7th edition. All assignments including discussion posts should be formatted in APA with the appropriate spacing, font, margin, and indents. Any papers not well formatted would be returned back to you, hence, I advise you review APA formatting style. I have attached a sample paper in APA format and will also post sample discussion responses in subsequent announcements.
Your initial discussion post should be a minimum of 200 words and response posts should be a minimum of 150 words. Be advised that I grade based on quality and not necessarily the number of words you post. A minimum of TWO references should be used for your initial post. For your response post, you do not need references as personal experiences would count as response posts. If you however cite anything from the literature for your response post, it is required that you cite your reference. You should include a minimum of THREE references for papers in this course. Please note that references should be no more than 5 years old except recommended as a resource for the class. Furthermore, for each discussion board question, you need ONE initial substantive response and TWO substantive responses to either your classmates or your instructor for a total of THREE responses. There are TWO discussion questions each week, hence, you need a total minimum of SIX discussion posts for each week. I usually post a discussion question each week. You could also respond to these as it would count towards your required SIX discussion posts for the week.
I understand this is a lot of information to cover in 5 weeks, however, the Bible says in Philippians 4:13 that we can do all things through Christ that strengthens us. Even in times like this, we are encouraged by God’s word that we have that ability in us to succeed with His strength. I pray that each and every one of you receives strength for this course and life generally as we navigate through this pandemic that is shaking our world today. Relax and enjoy the course!
Hi Class,
Please read through the following information on writing a Discussion question response and participation posts.
Contact me if you have any questions.
Important information on Writing a Discussion Question
- Your response needs to be a minimum of 150 words (not including your list of references)
- There needs to be at least TWO references with ONE being a peer reviewed professional journal article.
- Include in-text citations in your response
- Do not include quotes—instead summarize and paraphrase the information
- Follow APA-7th edition
- Points will be deducted if the above is not followed
Participation –replies to your classmates or instructor
- A minimum of 6 responses per week, on at least 3 days of the week.
- Each response needs at least ONE reference with citations—best if it is a peer reviewed journal article
- Each response needs to be at least 75 words in length (does not include your list of references)
- Responses need to be substantive by bringing information to the discussion or further enhance the discussion. Responses of “I agree” or “great post” does not count for the word count.
- Follow APA 7th edition
- Points will be deducted if the above is not followed
- Remember to use and follow APA-7th edition for all weekly assignments, discussion questions, and participation points.
- Here are some helpful links
- The is a great resource
