design database

[azhar2006]

Hello all
I am trying to e for my own business
As I began to read and normalization here in the Forum


Attach a picture of the database tables
Any suggestions you me
I should be grateful to you Forum
Regards
Az2006

[orange]

Customer, City, Date, Item interesting. But what is the business? Where and How do these thinks fit?
Orders, Purchase, Manufacture?
It would be more beneficial at this point if you described your business and rules in 5 or 6 sentences so the reade has some idea of what your data model is trying to support.

See this tutorial for the process.
Good luck with your project.

[azhar2006]

Thank you very much orange

[ItsMe]

azhar,

It is easier for us to understand your posts when you type longer sentences. The meaning of your phrases are lost in translation when you type short sentences.

Can you provide answers to Orange's questions?

[azhar2006]

Thank you
Yes, it is Orders Purchase
I am trying to include
1. Products / table tblitem
2. Date of sale of a product / table tblDate
3. Customers / table tblCustomer
4. The problem is in the sale of these products

[orange]

azhar2006,

Watch these videos (youtube)
Video tutorials:
If you google for videos "normalization langer" you will find a series of free videos by Dr.Art Langer. These are quite good for learning by Watching/Listening rather than reading.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

Here are some other links that may be helpful to you.
Database Design Principles http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck.