Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
One to one relationship shares same primary key. Phone Table {*CustomerID (foreign key), *phone number (text)}, here phone table and customer table share same primary key! I'm thinking to get your ebook in the near future. I'm little bit overwhelmed with what i have right now. -
Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
Phone Table {*CustomerID (foreign key), *phone number (text)} This is one to one relationship, so every customer will have three records since every customer will have to store 3 phone numbers (cell - home - work). Assuming it is a must for a customer to store 3 numbers. -
Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
First of all, i'm glad to be part of your forum members! Hi to everybody... **************************************** * represents primary key As far as i see, this design is good. I need your confirmation I followed 1NF, 2NF, 3NF, and one to many relationships guidelines. -Seller Table...
