Database Structure Analysis - Assignment Example

SQL> create table a1_language ( language varchar2(15) constraint language primar y key); Table created. SQL> insert into a1_language values ('Romanian'); 1 row created. SQL> insert into a1_language values ('English'); 1 row created. SQL> insert into a1_language values ('French'); 1 row created. SQL> insert into a1_language values ('German'); 1 row created. SQL> insert into a1_language values ('Afrikaans'); 1 row created. SQL> insert into a1_language values ('Spanish'); 1 row created.

SQL> insert into a1_language values ('Catalan'); 1 row created. SQL> insert into a1_language values ('Portuguese'); 1 row created. SQL> insert into a1_language values ('Italian'); 1 row created. SQL> insert into a1_language values ('Turkish'); 1 row created. SQL> insert into a1_language values ('Lithuanian'); 1 row created. SQL> insert into a1_language values ('Russian'); 1 row created. SQL> insert into a1_language values ('Japanese'); 1 row created. SQL> insert into a1_language values ('Slovenian'); 1 row created.

SQL> insert into a1_language values ('Norwegian'); 1 row created. SQL> insert into a1_language values ('Chinese'); 1 row created. SQL> insert into a1_language values ('Serbian'); 1 row created. SQL> insert into a1_language values ('Slovak'); 1 row created. SQL> insert into a1_language values ('Czech'); 1 row created. SQL> insert into a1_language values ('Polish'); 1 row created. . l ( issn varchar2(9) constraint issn primary key, tit le varchar2(100), url varchar2(110), publisher_id number(3), keyword varchar2(18 0), start_year number(4), end_year number(4) ); Table created.

SQL> commit; Commit complete. SQL> insert into a1_journal values ('1222-569X','Annals of the University of Ora dea : Economic Science','http://steconomice.uoradea.ro/anale/en_index.html',114, 'financial accounting, banking, management, marketing, statistics',2005,NULL); i nsert into a1_journal values ('1311-0160','Balkan Journal of Medical Genetics',' http://versita.metapress.com/content/120841/',118,'genetics, genetic engineering ',2007,NULL);