Home » Other » Training & Certification » Need a exact queries (Oracle 8i)
Need a exact queries [message #308295] Sun, 23 March 2008 19:11 Go to next message
Messages: 1
Registered: March 2008
Junior Member
I have created all the tables as follows.....

//Create STUDENT table

create table student
(regno varchar(20),
name varchar(20),
major varchar(20),
bdate date,
primary key(regno));

//Create COURSE table

create table course
(course# int,
cname varchar(20),
dept varchar(20),
primary key(course#));

//Create ENROLL table

create table enroll
(regno varchar(20),
course# int,
sem int,
marks int,
primary key(regno,course#),
constraint fk10
foreign key(course#) references course(course#));

//Create TEXT table

create table text
(book_isbn int,
book_title varchar(30),
publisher varchar(20),
author varchar(20),
primary key(book_isbn));

//Create BOOK_ADOPTION table

create table book_adoption
(course# int,
sem int,
book_isbn int,
primary key(course#,sem),
constraint fk11
foreign key(course#) references course(course#));

I need the exact queries for the following questions.... please help me....

(1) Produce a list of text books(include course #,Book,ISBN,Book
title)in the alphabetical order for courses offered by the
'CS' department that use more than two books.

(2) List any department that has all it adopted books published
by specific publisher.
Re: Need a exact queries [message #308296 is a reply to message #308295] Sun, 23 March 2008 19:27 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
You need to post what you have tried and the results that you got. We don't do your homework for you here. Please read the forum guidelines, highlighted in yellow at the top of the forum page.

Previous Topic: RAC Interview Questions
Next Topic: PL/SQL function (merged)
Goto Forum:

Current Time: Fri Mar 05 20:50:00 CST 2021