Introduction and ER to SQL

This first Lab Exercise starts with an introduction to the Oracle system and three basic ER to SQL exercises:

1. Read the Oracle introduction and set it up on your account.
   
   
2. Consider exercise 3.13 of the book.
   
   
   • Make the exercise. If there are elements in the given diagram which you cannot translate, mention that in your solution and give an explanation. Try to avoid this situation as much as possible.
   • Write in a file generate313.sql the SQL statements for generating the tables.
   • Also write in a file destruct313.sql the SQL statements for deleting the tables.
   • Think of some imaginary data and write in a file fill313.sql the SQL statements for filling the tables with this data.
   
   
   
3. Do the same for the exercises 3.14 and 3.15 of the book.