Surname 1Student NameInstructor NameCourse NumberDateQuestion 1-- ------------------------------------------------------ Schema CompanyA-- ----------------------------------------------------CREATE SCHEMA IF NOT EXISTS `CompanyA` DEFAULT CHARACTER SET utf8 ;USE `CompanyA` ;-- ------------------------------------------------------ Table `CompanyA`.`Employees`-- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `CompanyA`.`Employees` (`EmployeeID` INT NOT NULL,`FirstName` VARCHAR(55) NOT NULL,`LastName` VARCHAR(55) NOT NULL,`Gender` VARCHAR(45) NOT NULL,`DateOfBirth` DATE NOT NULL,`Age` INT NOT NULL CHECK(Age BETWEEN 20 AND 60),`JoinedDate` DATE NOT NULL,`PhoneNumber` VARCHAR(45) NOT NULL,`Email` VARCHAR(45) NOT NULL,`CurrentStatus` VARCHAR(55) NOT NULL,`JobRoles` INT NOT NULL DEFAULT 101,Surname 2PRIMARY KEY (`EmployeeID`),UNIQUE INDEX `EmployeeID_UNIQUE` (`EmployeeID` ASC))ENGINE = InnoDB;SET SQL_MODE=@OLD_SQL_MODE;SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;Question 2Generally, an aadhar number is personal identification number which is unique to everyone. Inour case we need to assign each employee a unique identification number which will be used torepresent each employee and can be searched so that you get the details of the employee. For itoccupy big numbers of people it is made to be a 12 digit number.Alter Table EmployeesAdd column AadharNumber BIGINT(20) Not ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.
