Pivotal Software Engineer interview questions

Draw a database diagram with an electronic drawing program. Write SQL to retrieve all Test Plans that a particular user has approved a Phase on. Return only data for Test Plans. Ensure there are no duplicate rows in the results. Independent of tasks 1 and 2, write Pythonic code for the above scenario. Write code to store the information in Python classes, in a manner that would allow fields to be added easily in the future. Write code for a user list interface. Feel free to use any frontend library/framework (although React is preferred). Plain Javascript/CSS is fine as well. Please do not use a styling framework like Bootstrap or TailWind, and do not use pre-made components from a third-party library.