Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
(OP)
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 {*SellerID (number), first name (text), last name (text), address (text), city (text), CountryID (foreign key), phone number (text), date hired (date)}
-Customer Table {*CustomerID (number), first name (text), last name (text), address (text), city (text), CountryID (foreign key), SellerID (foreign key) }
-Car Table {*CarID (number), manufacturer (text), model (text), car year (text) }
-Purchased Car Table {*CarID (foreign key), *CustomerID (foreign key), date purchased (date)}
-----
These tables have multivalued fields...
Country Table {*CountryID (number), country name (text)}
A customer can store several phone number (home, cell, work):
Phone Table {*PhoneID (number), CustomerID (foreign key), phone number (text)}
****************************************
* 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 {*SellerID (number), first name (text), last name (text), address (text), city (text), CountryID (foreign key), phone number (text), date hired (date)}
-Customer Table {*CustomerID (number), first name (text), last name (text), address (text), city (text), CountryID (foreign key), SellerID (foreign key) }
-Car Table {*CarID (number), manufacturer (text), model (text), car year (text) }
-Purchased Car Table {*CarID (foreign key), *CustomerID (foreign key), date purchased (date)}
-----
These tables have multivalued fields...
Country Table {*CountryID (number), country name (text)}
A customer can store several phone number (home, cell, work):
Phone Table {*PhoneID (number), CustomerID (foreign key), phone number (text)}
RE: Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
Phone Table {*PhoneID (number), CustomerID (foreign key), phone number (text)}
to this --
Phone Table {*CustomerID (foreign key), *phone number (text)}
if you don't understand why, pls ask
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
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.
RE: Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
each customer can have many phone numbers
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: Simple SQL/Database RDBMS Schema - Beginner Level - What Do You Think?
I'm thinking to get your ebook in the near future. I'm little bit overwhelmed with what i have right now.