Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1. (10 marks). Consider the following relational schema. Student course Id Name Address cho chame 1 Ahmad Amman 1903321 Database 2 Maha Aminan 1902212

image text in transcribed

Question 1. (10 marks). Consider the following relational schema. Student course Id Name Address cho chame 1 Ahmad Amman 1903321 Database 2 Maha Aminan 1902212 Management 3 Mona Amman 1902112 E-commerce + Mahdi Aminan 19033-41 Fundamental 5 Suha Amman 1903442 simulation Registration credit 2 3 3 2 3 id cho Mark Regdate 1 1903321 90 12-09-2006 1 1902212 80 12-10-2006 2 1903341 85 18-06-2006 2 1903321 90 21-09-2006 3 1903321 70 01-08-2006 3 1902212 84 15-07-2006 01) Write a PL/SQL code to get the following output. 1 Ahmad Amman 1903321 Database 2 credit hours in September 1902212 Management 3 credit hours in October 2 Maha Amman 1903341 Fundamental 3 credit hours in June 1903321 Database 2 credit hours in September 3 Mona Amman 1903321 Database 2 credit hours in August 1902212 Management 3 credit hours in July 4 Mahdi Amman didn't take any subject S Suha Amman didn't take any subiect

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

Students also viewed these Databases questions