Realizing the Database Design
Upload a copy of each of your scripts to IvyLearn.
M05_LastNameFirstName_CreateTables
M05_LastNameFirstName_Constraints
M05_LastNameFirstName_Alter
M05_LastNameFirstName_InsertInto
M05_LastNameFirstName_Update
*Note: For fields that exist in multiple tables, data type and size should be the same (i.e. ProjDeptID exists in ProjDept, Employee, and Task tables; the datatype for the ProjDeptID in each of these tables should be the same). When creating tables, consider data that is dependent on each other (i.e. primary key fields must always be created before foreign keys can reference them). For the data entry is time consuming; be sure to allot enough time to complete the data entry portion of this assignment. To successfully insert your statements, use the same table names that used in when creating the tables for this assignment. When entering data, conside
M05_LastNameFirstName_CreateTables
M05_LastNameFirstName_Constraints
M05_LastNameFirstName_Alter
M05_LastNameFirstName_InsertInto
M05_LastNameFirstName_Update
*Note: For fields that exist in multiple tables, data type and size should be the same (i.e. ProjDeptID exists in ProjDept, Employee, and Task tables; the datatype for the ProjDeptID in each of these tables should be the same). When creating tables, consider data that is dependent on each other (i.e. primary key fields must always be created before foreign keys can reference them). For the data entry is time consuming; be sure to allot enough time to complete the data entry portion of this assignment. To successfully insert your statements, use the same table names that used in when creating the tables for this assignment. When entering data, conside
