Project #27762 - SQL Database

I need to create a database called studentPOS410

 

Then i need to create the 2 tables below with the coloumns 

 

Employee (Table)

• Social_Security_Number 

• Last_Name  

• First_Name 

• Address 

• City 

• State 

• Zip_Code 

• Telephone_Area_Code 

• Telephone_Number 

• Email_Address 

• Job_Title_Code 

• Hire_Date 

• Salary 

 

Job_title  (Table) 

• Job_Title_Code 

• Job_Title 

• Exempt (holds exempt status which is either 1 or 0) 

• Minimum_Salary 

• Maximum_Salary 

 

 

Enter ten records into the Employee table. 

 

Enter five records into the Job_title table. 

 

Include all SQL statements (i.e. create, insert, etc) used to 

complete each task of your assignment. Submit a Microsoft 

Word document (using the template attached ) 

including these statements. Do not include screenshots, rather include the SQL 

scripts in the Word document. Label each script with the number 

of the query and use the order in which each query is listed in 

the assignment. 

 

Subject Computer
Due By (Pacific Time) 04/15/2014 10:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy