Question: Design a Database Schema for the Employee Table Create the database with the name HerzingUniversityRecords Make columns based on your Java classes variables [ Name

Design a Database Schema for the Employee Table
Create the database with the name HerzingUniversityRecords
Make columns based on your Java classes variables [Name, Title, HireDate, etc.]
Chose the best variable for the primary key and discussed why this variable was chosen as the primary key.
Add another column stating the type of employee [Professor, Administrator, Faculty]. This column will not be in the Java class as a variable but is a critical separator.
Start to fill the data in with some example data inputs (2 or 3 will be ok)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!