Description

DBMS can help us to manage data conveniently, and also can improve the efficiency of data retrieval greatly, so that your work of the project Part 1 is mainly divided into three parts below:
1. Designing a relational database using postgres according to the given data.
2. Finding ways to import whole data into your database
3. Comparing data retrieval implemented by yourself using C/C++, Java, python or any other language with DBMS to find the differences.
Task Requirements:

Task 1: Database design
Design a database by PostgreSQL allowing to manage all information mentioned in course_info.json and select_course.csv in this document.
Your design needs to follow the requirements of the three normal forms
Use primary key and foreign keys to indicate important attributes and relationships about your data
Every table should be involved in a link. No isolate tables included. (每个表要有外键，或者有其他表的外键指向)
Your design should contain no circular links (对于表之间的外键方向，不能有环)
Each table should always have at least one mandatory (“Not Null”) column(including the primary key but not the id column)
Tables with no other unique columns than possibly a system-generated ID is not allowed. (除了主键自增的id之外，需要有其他unique约束的列)
Use appropriate types for different fields of data
Your design is as easy to expand as possible. (Especially in three-person’s group)

Task 2: Import data
Design scripts to import data into your database from those two files ( course_info.json and select_course.csv).
Finding ways to improve the efficiency of time consuming during your importing process, and make comparison between different importing ways.
Make sure all data is successfully imported. (Especially in three-person’s group)
Task 3: Compare database and file
Store the data into a database table. Then use DML (Data Manipulation Language) in SQL to do simple analysis of your db. Record the execution time of your algorithm.
Store the data into a file, and then load it into RAM. The data in RAM can be any format you preferred. Design an algorithm to simple analysis of your file. In this case, you can reorganize data into some other format for faster retrieval. Record the execution time of your algorithm.
You can do some of the following advanced requirements (but not limit to the following ones) to challenging yourself. (Three-person’s group should do better in this part)
1. High concurrency and transaction management
2. User privileges management
3. Database index and file IO
4. Compare performance of multiple databases with file system over different operation systems

Report Structure:

(The words in report for three-person’s group should be larger than 2000)
Part 1. Group Info and Contribution
Need to write down the specific contribution content and the percentage of each team member.
Part 2. Task 1
Provide a clearly formatted diagram of table structure that generated by datagrip.
Given clearly explanations for the designing of your database, tables and some of columns (if need).
Part 3. Task 2
Introduce how to design scripts of importing data, and given the main code of your script.
Introduce how to improve the efficiency of importing process, and given the main code and experimental data of your efforts. To make sure the experiments should be reasonable and the comparisons should be fare.
Part 4. Task 3
1. Data and environment
Introduce the data (If you reorganized), operating system and the programming language you choose. How you organize the data.
2. Experiment design
List all comparisons item by item, and to introduce what you want to prove in experiments, then show your results in tables and figures, and analysis the differences of different methods.
In this part, you need to introduce what you want to prove in the experiments. DO NOT copy any text from Internet.
Several website can give you some ideas to research, but those are only theory description:
1. Advantage of database management system over file system
2. Advantages of Database Management System
3. Characteristics and benefits of a database
What to submit:

2. A SQL file about your create table query.
3. Submit necessary scripts (all scripts in task2 are needed).