We are making a database project, where the requirement is to design and develop a database for a quiz portal. Have completed the ER diagram and database schema.
We need SQL queries that run on PostgreSQL, for the creation of the tables, with all relations such as foreign keys and primary keys. You can find the link for the database below.
Link: https://www.postgresql.org/
The requirement document is added below, and the queries we are required for the ER diagram and Database schema are attached below.
Please have a look and let me know if more details are needed. Details about the files are attached.
Copy of projecr_er: A pic of the ER diagram.
DB Schema: The DB schema for which we need to write queries.
Queries.pdf: List of operations for which we will need queries.
Phase 1: The requirements for the project just help for understanding what is being done.
Phase 2: The requirements and details of what being done, just for reference.
0 comments