The ER Model for Arkansas, Inc. database is based on the following business rules. - A department hires many employees. Each employee is hired by one department. - An employee is assigned to more than one project. Each project is assigned many employees. - Each project’s budget cannot be greater than $1 million. - A project’s end date cannot be earlier than its start date. - Each employee cannot be assigned more than 20 hours to a project. 

• Requirements.
• 
  
• 1) Based on the ER Model, write SQL DD (Data Definition) statements to create all the tables for the Arkansas, Inc. database. We discussed SQL DD last week. (8 points). • First, you’ll need to do relational modeling. In other words, you need to map the ER model to the relational model (i.e., table structure with PK and FK) • For each column, use the data type and length that you think appropriate. • Implement all necessary data integrity rules (e.g., entity integrity constraint, key constraint, referential integrity constraint, and semantic integrity constraints). • If necessary, make explicit assumptions. 
• 
  
• 2) Write SQL DD (Data Definition) statements to change the Salary column in the Employee table to EmpSalary. (1 point) 
• 
  
• 3) Write SQL statements to add a new column, named Zipcode (data type: VARCHAR, length: 10) to the Employee table. (1 point) 
• 
  
• 4) For this assignment, we are not actually creating the database in MS SQL Server. Just write the SQL statements to create the tables in Word and submit it via the submission link for grading.
• 
  

Answer rating: 100% (QA)

Here are the SQL DD statements to create all the tables for the Arkansas Inc database SQL Create the Department table CREATE TABLE Department Departme... View the full answer