For each of the four tables, list the fields or pieces of data you want to track about each of these entities. Make sure that every field is directly related to only that entity (table). Field names should not include blank spaces as those spaces can cause programming issues later. This exercise does not require the actual development of the database in database management system, but it is a good practice to keep the spaces out. To avoid spaces, field names can be two words run together like EmpNumber or they can include an underscore like Emp_Number (do not use hyphens, they are used for other purposes in IT processing, such as subtraction). Choose at least FIVE fields for each of the four tables . Begin with the table name in all caps, follow that with the field names in parentheses separated by commas. The first field name MUST be a primary key for the table. A primary key uniquely identifies every instance of the table, just like your student ID identifies you and only you in CSC’s student table. For the primary key, avoid using fields like email address, birthdate, phone, or other fields that could identify multiple instances in the table, for example, a husband and wife could share an email address and it is therefore not unique to either. Use only absolutely unique fields like employeeNumber, SocialSecurityNumber, BarCodeNum, VIN_Number, etc. The primary key should appear first in the list of field names and it should be in italics. An example for a Student table follows:
CUSTOMER (StudentNumber , StudFName, StudLName, StudAddress, StudHighSchool)
For this step, use the format described and illustrated above to declare the fields in all four tables.