Access Design Problem

I am working on a db design problem and have finished the database. I would like someone to look at it and make some suggestions. I have included the files needed for your evaluation on overall design thus far. I am new to this.

Thank you in advance.

Sam
241JRC02Aaccdb.accdb
dbDesignProb.docx
James CoatsComputer Info. Sys. StudentAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Yes it is a homework assignment. Should I delete the question?
No, ...but bear in mind we cannot "solve" this for you (even if it wasn't)

What I posted above should get you started.

Pay close attention to the "OrderDatails" (Many--To--Many) table in the Northwind sample database....

You can post back with any questions, ..
But remember, this site is not really a site to provide "absolute" design advice...

Keep us posted...
;-)

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Your word doc reads like this is a Homework assignment.
If this is the case we cannot directly give to a "solution"

Please know that It is very difficult to just look at a design and offer any real "suggestions", without knowing the full scope and breadth of this system.
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Yes it is a homework assignment. Should I delete the question?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Jeffrey CoachmanMIS LiasonCommented:
First impressions...
It is not typical for an Employee to be associated with a Product...
I don't see any element there designating the employees department.
Yo need to adopt a more streamlined naming convention
In most cases, the Primary key in a table will be an Autonumber field.
...
etc

The good news is that your requirement here (at a very basic level) match with the original "Northwind" sample database.
MS used to have a direct link, ...but I think you can still find it here:
http://download.cnet.com/Access-2000-Tutorial-Northwind-Traders-Sample-Database/3000-2251_4-10742880.html
(Here, all precautions apply for downloaded files)

JeffCoachman
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
I understand that and I know you can't solve the problem as it is very elementary and there is likely more than one way to solve each problem. Thank you very much for the links as I am sure they will help. I don't have the Northwind on my Access 2013 but I am guessing I can install a download from MS via the link you sent me.

Thank again.
0
 
Jeffrey CoachmanMIS LiasonCommented:
there is likely more than one way to solve each problem.
Yes, ...It was not clear form the Word Doc, ...what the ultimate goal would be
...But you seem to be off on a good start...
;-)
I don't have the Northwind on my Access 2013
There is a newer version of the Northwind sample database, ....but it is *much* more complicated than a beginner could understand.
I am guessing I can install a download from MS via the link you sent me.
The link I posted is not an official MS site/link
as I said, MS used to have a link to the original file,. but I have not seen it in years.

If you can get a hold of a machine running Access 2003 or older, ...the Northwind database is a Template you can just "Open"

;-)

JeffCoachman
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Thank you, I did find it after looking at the link you sent me. You are correct it is quite complicated. I'm not sure I can actually understand much of it. But it may give me some ideas.
0
 
Jeffrey CoachmanMIS LiasonCommented:
The design is almost identical to what your requirement is here:
Employees
customers
products
orders
...etc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.