I’m doing an online exam system but I’m struggling with the database Structure,
I am creating two tables one Platforms table and one game table and I am getting an error saying that it can not find PLATFORMID in sql statment but I don’t understand why
I am creating a workout app using MySQL and Prisma, and I am struggling to design a schema for the data.
I intend to create a table with millions of rows, organized in the following way:
I have the following database schema that I have come up with:
I have a problem where I need to design a record system for storing building inspections.
I have a query I built up with a little help from web searching, however it is not efficient with the large dataset I have. I set the query running 10 days ago and it’s not finished. I have no idea how far it has actually gotten either. I’m fairly sure that the ORDER BY part isn’t required, I don’t know how much extra it is adding to the process.
I have multiple many to many relations related with one main entity.
I need help in combining columns of one column into another column, specifically by just inserting the column values just under another column.
I’m trying to understand how databases work by creating a movie theater database in MySQL. I created the following requirements and attempted to sketch out my ER diagram based on 3NF. A lot of resources said I should use associative tables, so I attempted to, but I am not sure if I am understanding the relationships between them correctly. Is this a good database design for the requirements? Are the associations correct?
enter image description here