Design a database about Chinese railway like 12306 website and provide command line interface for that.
Basic Requirements
1. The information of trains and stations must be authentic, and you need to insert those authenic data as much as possible. Your data contains all train informations of departure stations and destination stations in GUANG DONG province at least.
2. For all main processes or requirements that you are designed, given command line interface that can be invoked by outer layer.
3. Your system should provide two different users (Different from user privilege in database), the one is passenger the other is administer.
Passenger can search train information, reserve tickets, refund a tickets, query order form etc.
Administer can add, delete or update a train or station, etc.
4. Keep security and prevent SQL injection.
5. Enrich system requirements based on all decriptions above.
Challenging Requirements
1. Optimize your database by using user privilege, index, view, procedure or trigger in a reasonable way.
2. Adding more complex requirements: such as journey recommendation, etc.
3. Using connection pool, ORM frames or others frames resonably.
4. Better interface design, like using GUI, webpage or wechat mini-program, etc. (Encourage to learn, but not much feedback about the grade in this course)
5. Support high concurency munipulation. Such as ticket reserving simulation.
