• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Database Fundamentals > Understanding Relational Databases

Understanding Relational Databases

The solution to your problem is to break the employee list into two separate tables. The first table, the employee list, remains just that—an employee list. To link employees to other records, you add one new column to the list, a column containing a unique identifier for each employee. It might be an employee ID, a social security number, or a sequential value that is incremented as each new employee name is added to the list. The important thing is that no two employees have the same ID.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint