1. Please create the following database model which can be forward engineered into a database using...

 

Transcribed Image Text:

1. Please create the following database model which can be forward engineered into a database using MySQL. 70 points Table Name: Employee Column Name Personld EmployeeID FName MName LName DOB Gender Ethnicity PersonalEmail WorkEmail Department Building OfficeNumber Table: Department. Column Name Department Department Description Division Table: Division Column Name Division Data Type Integer Number Integer Number Character up to 45 Character up to 45 Character up to 60 Date (YYYY/MM/DD) Character - 1 Character up to 45 Character up to 100 Character up to 100 Character up to 30 Character up to 20 Character up to 10 Data Type Character up to 30 Character up to 100 Character up to 10 Data Type Character up to 10 Remarks Normally this would be an Auto Increment, but do not do this due to the being able to write inserts. This is the Primary key. Not Null, Unique, Alternate Key Not Null Not Null Not Null Not Null Not Null Not Null Can Be Null, Unique, Alternate Key Can Be Null, Unique, Alternate Key Not Null, Foreign Key, Referencing field of the same name in the Department Table Not Null Not Null Remarks Primary Key Not Null, Alternate Key Not Null, References field of the same name in the Division table Remarks Primary Key 1. Please create the following database model which can be forward engineered into a database using MySQL. 70 points Table Name: Employee Column Name Personld EmployeeID FName MName LName DOB Gender Ethnicity PersonalEmail WorkEmail Department Building OfficeNumber Table: Department. Column Name Department Department Description Division Table: Division Column Name Division Data Type Integer Number Integer Number Character up to 45 Character up to 45 Character up to 60 Date (YYYY/MM/DD) Character - 1 Character up to 45 Character up to 100 Character up to 100 Character up to 30 Character up to 20 Character up to 10 Data Type Character up to 30 Character up to 100 Character up to 10 Data Type Character up to 10 Remarks Normally this would be an Auto Increment, but do not do this due to the being able to write inserts. This is the Primary key. Not Null, Unique, Alternate Key Not Null Not Null Not Null Not Null Not Null Not Null Can Be Null, Unique, Alternate Key Can Be Null, Unique, Alternate Key Not Null, Foreign Key, Referencing field of the same name in the Department Table Not Null Not Null Remarks Primary Key Not Null, Alternate Key Not Null, References field of the same name in the Division table Remarks Primary Key

Answer rating: 100% (QA)

To create the specified database model that can be forwardengineered into a MySQL database you would ... View the full answer