| Need a exact queries [message #308295] |
Sun, 23 March 2008 19:11  |
praveenkumar2006
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  |
 |
Barbara Boehmer
Messages: 9088
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
