Sql programming

Completing the task for practical work 1.

1. 
   ENTITY RELATIONSHIP DIAGRAM
   

2. 
   SAMPLE SCHEMA DIAGRAMS
   

Completing the task for laboratory work 1.
Table Creation:

Variant №1.








Variant №2.


Variant №3.



Table Descriptions:
Variant №1.

1. 
   DESC PUBLISHER;
   
2. 
   DESC BOOK;
   
3. 
   DESC BOOK_AUTHORS;
   
4. 
   DESC LIBRARY_BRANCH;
   
5. 
   DESC BOOK_COPIES;
   
6. 
   DESC CARD;
   
7. 
   DESC BOOK_LENDING;
   

Variant №2.

1. 
   DESC SALESMAN;
   
2. 
   DESC CUSTOMER1;
   
3. 
   DESC ORDERS;
   

Variant №3.

1. 
   DESC ACTOR;
   
2. 
   DESC DIRECTOR;
   
3. 
   DESC MOVIES;
   
4. 
   DESC MOVIE_CAST;
   
5. 
   DESC RATING;
   

Insertion of Values to Tables:
Variant №1.








Variant №2.


Variant №3.


Selections:
Variant №1.

1. 
   SELECT * FROM PUBLISHER;
   
2. 
   SELECT * FROM BOOK;
   
3. 
   SELECT * FROM BOOK_AUTHORS;
   
4. 
   SELECT * FROM LIBRARY_BRANCH;
   
5. 
   SELECT * FROM BOOK_COPIES;
   
6. 
   SELECT * FROM CARD;
   
7. 
   SELECT * FROM BOOK_LENDING;
   

Variant №2.

1. 
   SELECT * FROM SALESMAN;
   
2. 
   SELECT * FROM ORDERS;
   

Variant №3.

1. 
   SELECT * FROM ACTOR;
   
2. 
   SELECT * FROM DIRECTOR;
   
3. 
   SELECT * FROM MOVIES;
   
4. 
   SELECT * FROM MOVIE_CAST;
   
5. 
   SELECT * FROM RATING;
   

Queries on the task for laboratory work 1.
Conclusions on the implementation of the work: