Use the attached file to create a data dictionary similar to the metadata tables shown in Table 1-1 to document your choices. (NO VOLUNTEERS). For each Table in the relational schema provide the following information for each field/data element: field name, definition/description, data type, format, allowable values, whether the field is required or optional, whether the field is indexed and the type of field, whether it is a primary key, whether the field is a foreign key, and the table that is referenced by the foreign key field. A template of this will be provided for consistency.  Page 239 Project Assignments P2.  Please complete a minimum of 8 relations including: Person_T, Employee_T, Physician_T, PhysicianDX_T, Diagnosis_T, and at least four others.

  • 6 years ago
  • 15