Data users work with directly by entering, updating and viewing.
User Data
Data users work with directly by entering,
updating and viewing.
For our purposes, data will be generally stored
in tables with some relationships between tables.
Each table has one or more columns. A set of
columns forms a database record.
Recall our example database for the bank. What
were some problems we discussed ?
Here is one improvement - split into 2 tables
Customer Table
Accounts Table
The customer table has 4 records and 5 columns.
The Accounts table has 7 records and 3 columns.
Note relationship between the two tables -
customerid column.
How should we split data into the tables? What
are the relationships between the tables? There are questions that are answered
by Database Modeling and Database Design.