1: Create database, named Test4. Question 2: (2 point) Create 2 table as following: A. tblEmployee:...

 

Transcribed Image Text:

1: Create database, named Test4. Question 2: (2 point) Create 2 table as following: A. tblEmployee: employeeCode(PK), varchar(10) employeeName, varchar(30), not null gender, bit, not null address, varchar(50), null departmentCode(FK from tblDepartment), null B. tbIDepartment: departmentCode (PK), varchar(10) departmentName, varchar(30), not null personNumber, int, not null Question 3: (2 point) Insert data for 2 above tables, each table 10 records Question 4: (5 point) Access data A. Display information on female employees who do not live in Hanoi. B. Display the employee name and department name of employee with middle name "Thanh". C. Display department information with the least female staff. D. Show employees in the department with the least number of people. E. Sort the list of employees by department code decreasing, if overlapping then increasing by gender. 1: Create database, named Test4. Question 2: (2 point) Create 2 table as following: A. tblEmployee: employeeCode(PK), varchar(10) employeeName, varchar(30), not null gender, bit, not null address, varchar(50), null departmentCode(FK from tblDepartment), null B. tbIDepartment: departmentCode (PK), varchar(10) departmentName, varchar(30), not null personNumber, int, not null Question 3: (2 point) Insert data for 2 above tables, each table 10 records Question 4: (5 point) Access data A. Display information on female employees who do not live in Hanoi. B. Display the employee name and department name of employee with middle name "Thanh". C. Display department information with the least female staff. D. Show employees in the department with the least number of people. E. Sort the list of employees by department code decreasing, if overlapping then increasing by gender.

Answer rating: 100% (QA)

Create data base script USE master GO Object Database Test4 Script Date 23122021 155856 CREATE DATABASE Test4 CONTAINMENT NONE ON PRIMARY NAME NTest4 FILENAME NCProgram FilesMicrosoft SQL ServerMSSQL1... View the full answer