CODEWITHSUNDEEP
phpsqldatabasedatabase-designphpmyadmin
Aaron F
Aaron F

Reputation: 33

Can I have a database table with no relation any other table?

Im working on a school project that requires me to create a basic database based on Olympic Games. Here is my current Relational Model View:

relational model view

My question is, can I have my 'olympics' table sitting in my database with no relationships between any other tables?

The reason I am looking to include this is to display information about the current Olympic Games in general such as the year and location. Will this cause problems for me? I should also mention that my database only needs to contain at least four tables and is to run some basic queries. This is not a real world project but a practical for working with queries. Any other advice or feedback would be greatly appreciated.

Upvotes: 1

Views: 77

Answers (2)

Walter Mitty
Walter Mitty

Reputation: 18940

There may be a relationship hidden in there that you don't quite realize. As you begin to track events, you will likely have an EventDate. That date has a year in it. And that year is related to the Year in your Olympics table

Upvotes: 1

SevincQurbanova
SevincQurbanova

Reputation: 366

Yes, you can have a table with no relation to other tables.

Upvotes: 0

Related Questions