ce4cae38c04fe29b68d93f07b3e886a650e772cb LastName Xu Wexford Trees Tran Thomas Steward Purney Pulinski Phelps Murray Morris McMurphy Luikin Levinson

You are a new database analyst and you are given the following flat file in csv to design a database in SQLITE:

EMPLOYEE(1).csv

1.The following specifications are provided:

  • LastName (text, 25 characters, required)
  • FirstName (text, 20 characters, required)
  • MiddleName (text, 20 characters, not required)
  • BirthMo (text, 2 characters, required)
  • BirthDa (text, 2 characters, required)  
  • BirthYr (text, 4 characters, required)  
  • HireMo (text, 2 characters, required)  
  • HireDa (text, 2 characters, required)  
  • HireYr (text, 4 characters, required)  
  • Grade (text, 2 characters, required)  
  • Rate (decimal, required) 
  • Title (text, 7 characters, required)  
  • SSN (text, 9 characters, required) 

Also note the following key:

  • Transcr = transcriptionist
  • Assemb = assembler
  • Secret = secretary
  • FileCl = file clerk 
  • Analys = Analysts 

2.Construct a database following the specifications above. Also design an appropriate primary key.

If anyone is willing to explain this process for me using SQL code I would be immensely grateful!

Thank you!