The target of this small project is to have a better understand of relational database systerm. This project is based on Oracle 12c, and the client is Oracle SQL developer.
In the first stage of this project, I and my teamate designed the ER-diagram and Relational diagram, wrote some basic sql statements to build tables and relations, plus sample data.
In the second stage of this project, we add more features such as stored procedure, trigger, complex query (including subquery), more operation(aggregated functions) as well as access control.