Database Design for Storing Certificate


Perform the following tasks:

Part I - Database Design

In the previous homework, the certificate you generated is only self-signed. In other words, the certificate chains back to itself. In this part of the homework, you are to design a relational database scheme in the form of a ER diagram that can store general x.509 certificate.

Here is the list of requirement for the database schema:


Part II - MySQL Schema

Use the design in Part I and create the corresponding MySQL schema. The schema should contain any DDL and DML SQL statements needed to create the tables as well as populating the initial data set. You could modify your previous homework to generate certificates that have sub-CAs.



What to handin: