Relational Database Help

[S. Cole]

Hi!

I need help with creating a relational database and normalizing it.
I've been studying the process of creating a relational database,
however I am unsure if I am doing it correctly. Below is a sample
list I have created (on paper)of my database design.

Can someone review and let me know if I am doing everything correctly
and give me suggestions for improvement?

SAMPLE DATABASE:
Customers Table
· CustID
· LastName
· FirstName
· Address1
· Address2
· City
· Province
· PostCode
· Country
· Phone
· SubscriptionID (email)

Transactions Table
· TransID
· CustID
· Date
· PaymentStatus
· PendingReason
· PaymentDate
· Memo

Orders Table
· OrderID
· TransID
· ItemID
· TotalOrder (mc_gross)
· TxnFee (mc_fee)
· Currency (mc_currency)

Items Table
· ItemID
· CatalogID
· Name
· Description
· Price
· PicUrlTn
· PicUrlFull

Catalogs Table
· CatalogID
· Name
· Description
· Statement
· ValidFromDate

Subscription Table
· SubscriptionID
· CustID
· Email
· Status (Active/Inactive)

OrderStatus Table
· StatusID
· OrderID
· Date
· ReasonID

StatusReasons Table
· ReasonID
· Title
· Description
Many Thanks,
S. Cole

[BDR]

Looks ok - Start writing your code to work with it and then you'll find
out if you've done everything correctly; (adjust and modify your tables,
fields, and indexes as necessary) MySql is very forgiving in this
aspect.... :-)

S. Cole wrote:

Hi!

I need help with creating a relational database and normalizing it.
I've been studying the process of creating a relational database,
however I am unsure if I am doing it correctly. Below is a sample
list I have created (on paper)of my database design.

Can someone review and let me know if I am doing everything correctly
and give me suggestions for improvement?

[BDR]

Looks ok - Start writing your code to work with it and then you'll find
out if you've done everything correctly; (adjust and modify your tables,
fields, and indexes as necessary) MySql is very forgiving in this
aspect.... :-)

S. Cole wrote:

Hi!

I need help with creating a relational database and normalizing it.
I've been studying the process of creating a relational database,
however I am unsure if I am doing it correctly. Below is a sample
list I have created (on paper)of my database design.

Can someone review and let me know if I am doing everything correctly
and give me suggestions for improvement?

[S. Cole]

BDR <jo*@noemail.com> wrote in message news:<3F************@noemail.com>...

Looks ok - Start writing your code to work with it and then you'll find
out if you've done everything correctly; (adjust and modify your tables,
fields, and indexes as necessary) MySql is very forgiving in this
aspect.... :-)

S. Cole wrote:

Hi!

I need help with creating a relational database and normalizing it.
I've been studying the process of creating a relational database,
however I am unsure if I am doing it correctly. Below is a sample
list I have created (on paper)of my database design.

Can someone review and let me know if I am doing everything correctly
and give me suggestions for improvement?

Thanks!!
S. Coel

[S. Cole]

BDR <jo*@noemail.com> wrote in message news:<3F************@noemail.com>...

Looks ok - Start writing your code to work with it and then you'll find
out if you've done everything correctly; (adjust and modify your tables,
fields, and indexes as necessary) MySql is very forgiving in this
aspect.... :-)

S. Cole wrote:

Hi!

I need help with creating a relational database and normalizing it.
I've been studying the process of creating a relational database,
however I am unsure if I am doing it correctly. Below is a sample
list I have created (on paper)of my database design.

Can someone review and let me know if I am doing everything correctly
and give me suggestions for improvement?

Thanks!!
S. Coel