Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create Schema the following schemas I) Student (Student_id, name,gender , age, address) II) Course (course_id, name, credit hours) ii) Department (id, Name, location) Insert at

Create Schema the following schemas

I) Student (Student_id, name,gender , age, address)

II) Course (course_id, name, credit hours)

ii) Department (id, Name, location) Insert at least 6 dummy record in schemas having first record of "Micheal" in students table.

a) Select (name, age) from student table and (course, credit hours) from course table with the help of sql join query, assign all course subjects to "Micheal" Only.

b) Select top 3 records with minimum age and maximum age from student table.

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_2

Step: 3

blur-text-image_3

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

Logistics Lifeline Supply Chain Strategies

Authors: Ehsan Sheroy

1st Edition

7419377502, 978-7419377503

More Books

Students also viewed these Databases questions

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago

Question

Write down the Limitation of Beer - Lamberts law?

Answered: 1 week ago