Relationships problem

[Helpmepls]

THIS IS THE FINAL VERSION:
https://ibb.co/hprbaw

Do you think it's good enough?

[ranman256]

i think you have video cards backwards....

1 video card (name, model)
has many prices (depending on source)

[June7]

No, don't think this is correct. 4 tables are feeding keys into Video Cards field of Video Cards table.

What are your data entities and how are they related? From the image, not sure need more than 1 table. Unless each video card can have multiple price records, multiple benchmark records, multiple specification records, and multiple release dates - why break up video card attributes into multiple tables?

Can each specification record be associated with multiple video cards?

The two benchmark tables should probably be 1 table with another field for the benchmark type (4K or 1080p). Why would each benchmark table not be linked to both Buyer's Guide and Release Dates?

I anticipate a failing grade. Post the assignment parameters.

Advise no spaces nor punctuation/special characters (underscore only exception) in name convention. Better would be BuyerGuide or Buyer_Guide.

[Helpmepls]

No, don't think this is correct. 4 tables are feeding keys into Video Cards field of Video Cards table.

What are your data entities and how are they related? From the image, not sure need more than 1 table. Unless each video card can have multiple price records, multiple benchmark records, multiple specification records, and multiple release dates - why break up video card attributes into multiple tables?

The two benchmark tables should probably be 1 table with another field for the benchmark type (4K or 1080p). Why would each benchmark table not be linked to both Buyer's Guide and Release Dates?

I anticipate a failing grade. Post the assignment parameters.

Advise no spaces nor punctuation/special characters (underscore only exception) in name convention. Better would be BuyerGuide or Buyer_Guide.

Yeah,I realize it's a fail but i still have around 18 hours to fix it.What I need to do is have 5-7 tables 2 or 3 of which should be only 2 rows.I've never worked with access to any suggestion on what I should include in those tables would be extremely helpfull. ;(
Edit:I'll get 5 hours of sleep and I really hope I figure this out in the morning.

[orange]

You have to start with a clear description of the business you are trying to support with a database. No one can tell you if the the tables and relationships are correct until they have a business description and facts to compare to.

[June7]

Are you required to use documenting video card attributes as the purpose of this db? There many examples of Entity Relationship Diagrams (ERD's) available. A common one is a customer orders structure.

We don't know the requirements and if you can't identify data entities and relationships how can we be expected to?

[Helpmepls]

Are you required to use documenting video card attributes as the purpose of this db? There many examples of Entity Relationship Diagrams (ERD's) available. A common one is a customer orders structure.

We don't know the requirements and if you can't identify data entities and relationships how can we be expected to?

There are no requirements other than what what I wrote on my previous post.I'm currently trying to make 1 or 2 tables out of my 7 tables and I hope I figure what to do after that.Maybe I'll add one Orders and one Customers table as well.

UPDATE:Tings are going well.For now I have 3 tables - Video Cards connected to Orders and Customers connected to orders.Any idea how to expand on that?

[orange]

There are no requirements

I'm currently trying to make 1 or 2 tables out of my 7 tables

I hope I figure what to do after that

Maybe I'll add one Orders and one Customers table as well

Interesting approach. Good luck.

As mentioned earlier, in the tried and true approach, step1 is to create a brief, clear description of WHAT you're trying to do.

[Helpmepls]

Interesting approach. Good luck.

As mentioned earlier, in the tried and true approach, step1 is to create a brief, clear description of WHAT you're trying to do.

I passed the exam already.You can see the final version of the database in the first post.Tanks to June7's guidelines i made my research and did what I needed to do.Thanks!

[orange]

Congrats on passing the exam!
If you have a copy of the exam, I'm sure some readers would like to see what the original question/problem/requirement was.

[Helpmepls]

Yeah,of course!Could you just tell me how to upload the files here?

[June7]

See guidelines at bottom of my post.