DBMS110 – M06 Lab Assignment

Study smart, not hard. Entrust your coursework writing to our expert writers for excellent results!
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.
25+ Subjects
From Literature to Law – we have MA and Ph.D. experts in almost any academic discipline, for any task.
Any Paper
We can write, proofread, paraphrase, format, edit or rewrite your any paper, whether it’s a review or a term paper.
High Quality
All the papers we deliver to clients are based on credible sources and are quality-approved by our editors.
Fast Turnaround
Our writers can complete a standard essay for you within 1-3 hours and a part of a dissertation – in 2-5 days.
High Quality
All the papers we deliver to clients are based on credible sources and are quality-approved by our editors.
Next
Why Customers
Become Our Regulars
We put decades of writing experience to work for you and are passionate about helping you succeed. Let the figures tell our story!
10
Years in Writing Business
97%
Orders Delivered on Time
3,500+
Experts on Our Team
9/10
Report Better Grades
That's Why We Are Here 24/7
[display_slider_reviews]
We can help you reach your academic goals hassle-free.
We can help you reach your academic goals hassle-free.

There are 19 questions listed below. Based on the content in the M06 Readings, answer each question. After completing, save, and execute your scripts in Oracle Application Express.  Upload a copy of each of your scripts to IvyLearn.

  • M06_LastNameFirstName_Queries
  • M06_LastNameFirstName_Joins

*Note: For your statements to work, you will need to execute the scripts provided with this assignment. To help with identifying tables that are needed, the ERD of the Academic Database has been included on the very last page of this activity.

 

(2 points each) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. Based on data in the Academic Database, complete the following:

  1. Write a simple query to view the data inserted in the student table created for the Academic Database.
  2. Write a query to retrieve the marks obtained by the student for each exam attempted.
  3. The faculty of the different Departments realized that the marks entered in Exam Results were showing a decreased value of 7 marks for each entry. Display the marks by adding 7 points to the grades obtained by each student.
  4. Display the First Name and Email Address as “The email address of <FIRST_NAME> is
    <EMAIL_ADDR>”.
  5. Display the department name and the HOD of the department from the Department table.
  6. Display the distinct Department ID from the Course table.
  7. Display the course details for the Spring Session (Session ID 100).
  8. Display the details of the students who have scored more than 93.
  9. Display the course details for departments 20 and 30.
  10. Display the details of students whose first name begins with the letter “M”.
  11. Display the details of students who have opted for courses 190 or 193.
  12. Display the course details offered by department 30 for the Fall Session (Session ID 200).

(2 points each) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_Joins (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. To help with identifying tables that are needed to do joins, the ERD of the Academic Database has been included on the very last page of this activity. Based on the data given (shown below) for the Academic Database, complete the following:

  1. Display the name of courses offered and the name of each session it is offered in.
  2. Display the name of courses offered in the Fall session.
  3. Display the course details and students who have enrolled for those courses.
  4. Display the course details and students who have enrolled for those courses for department 30.
  5. Will the given statement execute successfully? If not, what must be changed? Explain your answer in a comment in your script. Make the appropriate changes and include in the script.

SELECT COURSE_NAME, GRADE, EXAM_ID

FROM COURSE_NAME d JOIN EXAM_RESULT a

USING (a.COURSE_ID)

 

  1. Explain what output would be generated when the given statement is executed. Include your answers in a comment in your script.

SELECT COURSE_NAME, GRADE, EXAM_ID

FROM COURSE d JOIN EXAM_RESULT a

ON a.COURSE_ID

BETWEEN 190 AND 195

  1. Explain what output would be generated when the given statement is executed. Include your answers in a comment in your script.

SELECT *

FROM EXAM_RESULT

CROSS JOIN EXAM_TYPE

 

(2 points) In the script created above, include the following comments:

  • At the beginning of the script include your name, the date, and the name of the script and a summary of what the script will do.
  • Throughout the script, include comments to describe briefly what each section of script will do.

 

For fields that are marked as *, these are required/mandatory fields.

For fields that are marked as °, these are optional fields.
Primary key and foreign key fields have been labeled accordingly.

[wpecpp name=”DBMS110 ” price=”40.00″ align=”center”]

 

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
WeCreativez WhatsApp Support
STUCK with your assignment? When is it due? Get FREE assistance.
👋 Hi, how can I help?