sql - table design issue for normalizing multiple catogories sharing similar data -
I'm a little confused in a table design
Method 1) I have a phonecard table with the first method I can select all the phone numbers and filter the employee phone number by specifying the type. Method 2) In the second method, I can select all from joining two tables and get employee phone number.
I have the same problem with addresses. I have employees, customers, employees and other people know that I have googled and still can not choose which is the right way which is the right way and why others And no other better design for this?
Method 1 Method 2 Edit: Employees and customers can have multiple phone numbers. And with address details. The phone should be referenced to me Update: If the customer / employee can have multiple phones then it will be better to define multiple-to-many relationships like additional table
Employee ID. Name 1 e customer ID. Name 1c phone_book type | Fk_id | Phone E1 123123123 C1451323123
employee ID | Name 1 e customer ID. Name 1c staff_phone_book emp_id | Phone 1 1231233434 2 6273343423 customer_phone_book cus_id | Phone 1 5231233434 2 1251233434
employee ID | Name | Phone_id 1 E1 Customer ID | Name | Phone_ id 1c2 phone_book phone_id | Phone 1 123123123 2 451323123
employee and
customer tables (from FK to
phone_book table)
customer_phone phone_id | customer_id (reference to customer table) 1 1 2 1
Comments
Post a Comment