So my Database professor decided that we should design a database with like 4 tables and hundreds of records and we had to write like 100 queries to produce a specific output from the tables we designed. All in less than a week. This is the first time I'm learning about databases, mind you.

You are lucky. Databases are great to learn. I suppose you are working with a relational database. Graph databases such as Neo4j are also valuable for certain systems.

The 4 table database you mentioned can be accomplished in under a week. Carefully plan it before coding.
Please let us know how it goes. Good luck!

Oh I already completed the assignment. It was Hyper-SQL. For my first time learning, though, I was on Google and SO all week.

Depends what you hold in the tables and what level of normalisation you go to (4th normal form is what you would expect) but should be do-able in a week I think

@bluescreen It was Boyce-Codd Form.

@Trey50Daniel yeah 4th normal is typical in most cases