Lawyer's office database

Database project for a law office created using Oracle.

database.mp4

• Created a SQL script that generates a full logicaldatabase structure
• Added sequences and triggers with sample test data
• Created SELECT query to select data from tablesusing different operators in WHERE (UPDATE & NVLtest)

• Added:
  • group by & having select
  • subqueries and perspectives
  • Indexes and TCS (Transaction Control System) - Transactions
  • INSERT INTO loop
  • Implicit cursors
  • Explicit cursors

For the purposes of the project, names of tables, data, descriptions, etc. are in Polish

License

MIT