Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started