Questions

1. What's the purpose of the template1 and template0 databases?
2. What are the database-access privileges?
3. How can we use tablespace to tune the database server's performance? 
4. What's the difference between a user and a group in PostgreSQL?
5. What's the name of the schema that already exists in the template database?
6. Give the usages of arranging database objects in schema.
7. What are the table types in PostgreSQL?
8. The SHOW command shows the setting value—how can you get more information about a certain setting, such as context?
9. List the basic data types in PostgreSQL.
10. Is there a performance difference when dealing with the VARCHAR and TEXT data types? 
11. How can you represent VARCHAR(20) in another data type in PostgreSQL?
12. Describe the TIMESTAMP and TIMESTAMP WITH ZONE data types.
13. Which numeric data types should be used when we want to store data accurately? 
14. Translate the following ER diagram into a relational schema: