Creating the Database Objects
Before creating the database objects, the team reviewed the ERDs and verified that the
records designs were in 3NF. In addition, they verified that the new payroll system permitted
cross-platform access because the ESIP system required data from the payroll master file.
They discovered that the payroll package used a standard data format called open database
connectivity (ODBC) that supported links to the Access database. After planning the system,
they started creating the objects.