Please Help!!! I'm super Confused

[PubCrawl]

Hi guys,



Not only have I just discovered this forum, I only learned of Microsoft Access' existence today!

I'm currently doing a uni assignment, which requires me to use the program and despite attending the lectures, I am stuck straight away.

I'm happy to send over the full assignemnt and corresponding data, but here's task 1, which I am stuck on.
.


I honestly thought this would be simple enough until I looked at the excel spreadsheet that has the data in it and saw this:



In this assingment background, it states what fields the ComputerParts table needs to be include:
About the computer parts (ComputerParts), he wants to keep:
 ComID: the ID number used to distinguish each PC, which comes from the Computer table (e.g.,
1000)
 HWID: the ID that identifies the specific brand of hardware used to build the PC (e.g., 10000)
 Quantity: the number of the particular hardware component used in the PC (e.g., 1)
 The combination of ComID and HWID will be unique in the table. That is, every hardware used in a
particular computer will be recorded only once and if multiple number of the same hardware (e.g.
RAM) is used then its recorded in the Quantity field.

I do not understand how to format this correctly, given how the data "Computer Hardwares IDs" section is presented. I'm guessing this a super stupid question, but I just don't get it.


Please help.

[orange]

We don't do homework assignments. We offer advice/suggestions to problems or questions that you post.
See the Database Planning and Design in my signature for various articles, videos and examples.

There is a Similar Threads area at the bottom of this page that may be helpful.

[Micron]

I guess they leave it up to you to figure out db normalization and relationships on your own? I don't see much of value in the "similar threads" list on this thread.
So now you have the two main subject areas you need to review before beginning. Your research material on normalization should include the topic of junction tables.