Moving+from+the+model+to+the+database

** Each entity in the data model becomes a table in the database. **
Each attribute of a data model becomes a column (field) in the database.



In the above example, the entity is PUPIL, and so becomes a table called pupil in the database. The attributes are Pupil ID, Forename, Surname and DOB. Each of these become a column (field) in the pupil table in the database.