Question: 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,

1: Create database, named Test4. Question 2: (2 point) Create 2 table 

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.

Step by Step Solution

3.53 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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 full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!