titles.title id = titleauthors.title id and titles.pub id = publishers.pub id and price >

(select avg(price)

from titles)

drop view highBandH go

create view highBandH as select * from highaverage

where pub name = Binnet & Hardley go

drop view numberl go

create view numberl

as select au lname, phone

from authors

where zip like 944

drop view number2 go

create view number2

as select au lname, phone

from numberl

where au lname like [M-Z]* go

drop view numbers go

create view numberS

as select au lname, phone

from number2

where au Iname = MacFeather go

drop view accounts go

create view accounts (title, advance, gross sales) as

select title id, advance, price * ytd sales from titles where price > $15 and advance > $5000

drop view categories go

create view categories (Category, Average Price)

as select type, avg(price)

from titles

group by type

/*Конец*/

Приложение Д

Список литературы

Дейт, К.

Введение в системы баз Эаяиь(х.-М.:Наука.-1980.- 463с. Мартин, Дж.

Организация баз doHHbLX в вычислительных сис/иел/ах.-М.гНаука.-1980.- 560с. ANSI SQL Standart.

The 1992 ISO-ANSI SQL standart is available through ANSI as document X3.135-1992 and through ISO as document ISO/IEC 9075:1992.

ANSI is located at 11 West 42nd Street, New York, N. Y., 10036; 212-642-4900. Codd, E.F.

A Relational Model of Data for Large Shared Data Banks , Communications of the ACM 13, no. 6 (June 1970) 377-87. Codd, E.F.

Is Your DBMS Really artowa/. Computerworld, October 14, 1985, 1-9. Authors proposes tvielve criteria for testing relational database management systems. Codd, E.F.

Does Your DBMS Run by the Rules? Computerworld, October 21, 1985, 49-55. Details on the thirty essential features of the relatioal model. Date, C.J.

Database: A Primer. Reading, Mass.: Addison-Wesley Publishing Company, 1983. Date, C.J.

An Introduction to Database Systems, Volume 2, Reading, Mass.: Addison-Wesley Publishing Company, 1983. Date, C.J.

An Introduction to Database Systems, vol. 1, 4th ed., Reading, Mass.: Addison -Wesley Publishing Company, 1986. Date, C.J.

Relational Database: Selected Writings. Reading, Mass.: Addison-Wesley Publishing Company, 1986. Date, C.J.

A Guide to the SQL Standart. Reading, Mass.: Addison-Wesley Publishing Company, 1987. The third edition (1993) is written with Hugh Darwin and includes SQL-92. Epstein, Robert

Relational Performance: Understanding the Performance of Relational DBMSs. Emeryville, Cahf.: Sybase, Inc., 1986. Photocopy. Gane, Chris

Developing Business Systems in SQL Using ORACLE on the IBM-PC. New York: Rapid System Development, Inc., 1986. IBM Corporation

SQL/Data System Terminal Users Reference for VSE. Endicott, N.Y.: IBM СофОга11оп, 1984. Informix Software, Inc.

Informix Guide to SQL: Reference. Englewood Cliffs, N.J.: Informix Press, Prentice-Hall, Inc., 1995 Kent, William

A Simple Guide to Five Normal Forms in Relational Database Theory , in Communications of the ACM 20, no.2 (February 1983): 120-25 Koch, George, and Kevin Loney

ORACLE: The Complete Reference, 3rd ed. Berkeley, Calif.: Osborne McGraw-Hill, 1995. Larson, Bruce L.

The Database Experts Guide to Database 2. New York: McGraw-Hill Book Company, 1988. Melton, Jim and Alan R Simon

Understanding the New SQL: A Complete Guied. San Mateo, Calif.: Morgan Kaufmann Publishers, 1993. Microsoft Corporation

Transact-SQL Reference: Microsoft SQL Server Version 6.0. Redmond, Wash.: Microsoft Софога11оп, 1995. Perkinson, R. C.

Data Analysis: The Key to Data Base Design. Wellesley, Mass.: QED Information Sciences, Inc., 1984. Relastional Database Systems, Inc.

INFORMIX-SQL Reference Manual. Menlo Park, Calif.: Relational Database Systems, Inc., 1986.

Приложение Д. Список литературы 309

Relational Technology

INGRES Quick Reference Summary SQL Release 5.0. Alameda, Calif.: Relational Technology, 1986. Ross, Ronald G.

Entity Modeling: Techniques and Application. Boston: Database Research Group, Inc., 1987. Sachs, Jonathon, et al.

SQL* Plus Reference Guide. Belmont, Calif.: ORACLE Coфoration, 1987. Sybase, Inc.

Sybase SQL Server Reference Manual, vols.l and 2. Emeryville, Calif.: Sybase, Inc., 1995. Sybase, Inc.

Sybase SQL Anywhere: Users Guide, vols.l and 2. Emeryville, Calif.: Sybase, Inc., 1995. van der Lans, Rick E.

Introdaction to SQL. Reading, Mass.: Addison-Wesley Publishing Company, 1988.