Question: Create database and insert data to store information of employees as following: NHANVIEN HONV TENLOT TENNV MANV NGSINH DCHI PHAI LUONG MA_NQL PHG PHONGBAN TENPHG

Create database and insert data to store

Create database and insert data to store information of employees as following: NHANVIEN HONV TENLOT TENNV MANV NGSINH DCHI PHAI LUONG MA_NQL PHG PHONGBAN TENPHG MAPHG TRPHG NG_NHANCHUC DIADIEM_PHG MAPHG DIADIEM DEAN TENDA MADA DDIEM_DA PHONG PHANCONG MA NVIEN SODA THOIGIAN THANNHAN MA NVIEN TENTN PHAINGSINH QUANHE Bng 1: NHNVIN HONY TENLOT TEN MANV NGSINH DCHI PHAI LUONG | MA NQLT PHG Dinh Ba Tien 12345678909/01/1955 Nam 30000 333445555 5 Nguyen Thanh Tung 333445555 08/12/1945 Nam 40000 888665555 5 Bui Thuy Vu 999887777 | 19/07/1958 Nam 25000 987654321 4 Le Thi Nhan 987654321 | 20/06/1931 Nu 43000 888665555 4 731 Tran Hung Dao, Q1, TPHCM 638 Nguyen Van Cu, Q3, TPHCM 332 Nguyen Thai Hc, Q1, TPHCM 291 Ho Van Hue, QPN, TPHCM 975 Ba Ria, Vung Tau 543 Mai Th Luu, Q1, TPHCM 980Le Hong Phong Q10, TPHCM 450 Trung Vuong HaNoi Nguyen Manh Hung 666884444 15/09/1952 Nam 38000 333445555 5 Tran Thanh Tam 453453453 31/07/1962 Nam 25000 333445555 5 Tran Hong Quan 987987987 29/03/1959 Nam 25000 987654321 4 Vuong | Ngc Quyen 888665555 | 10/10/1927 Nu 55000 1 Bng 2: PHONGBAN TENPHG MAPH Nghien cuu 5 Dieu hanh 4 Quan ly 1 TRPHG NG NHANCHUC 333445555 22/05/1978 987987987 01/01/1985 888665555 | 19/06/1971 Bng 3: DIADIEM_PHG MAPHG DIADIEM 1 TP HCM 4 HA NOI 5 VUNG TAU 5 NHA TRANG 5 Bng 4: THANNHAN MIA NVIEN | TENTNT PHAI NGSINH QUANHE THOIGIAN 32.5 333445555 333445555 333445555 987654321 123456789 123456789 Quang Khang Duong Dang Duy Chau Nu Nam Nu Nam Nam Nu 05/04/1976 Con gai 25/10/1973| Con trai 03/05/1948 Vo chong 29/02/1932 Vo chong 01/01/1978| Con trai 31/12/1978 Con gai Bng 6: PHANCONG MA NVIEN SODA 123456789 1 123456789 2 666884444 3 453453453 1 453453453 2 333445555 3 333445555 10 333445555 20 999887777 30 999887777 10 987987987 10 987987987 30 987654321 30 987654321 20 888665555 20 7.5 40.0 20.0 20.0 10.0 10.0 10.0 Bng 5: DEAN TENDA MADA San pham X 11 San pham Y 2 San pham Z 3 Tin hc hoa 10 Cap quang 20 Dao tao 30 DDIEM DA VUNG TAU NHA TRANG TP HCM HA NOI TP HCM HA NOI PHONG 5 5 5 4 1 4 30.0 10.0 35.0 5.0 20.0 15.0 Create database and insert data to store information of employees as following: NHANVIEN HONV TENLOT TENNV MANV NGSINH DCHI PHAI LUONG MA_NQL PHG PHONGBAN TENPHG MAPHG TRPHG NG_NHANCHUC DIADIEM_PHG MAPHG DIADIEM DEAN TENDA MADA DDIEM_DA PHONG PHANCONG MA NVIEN SODA THOIGIAN THANNHAN MA NVIEN TENTN PHAINGSINH QUANHE Bng 1: NHNVIN HONY TENLOT TEN MANV NGSINH DCHI PHAI LUONG | MA NQLT PHG Dinh Ba Tien 12345678909/01/1955 Nam 30000 333445555 5 Nguyen Thanh Tung 333445555 08/12/1945 Nam 40000 888665555 5 Bui Thuy Vu 999887777 | 19/07/1958 Nam 25000 987654321 4 Le Thi Nhan 987654321 | 20/06/1931 Nu 43000 888665555 4 731 Tran Hung Dao, Q1, TPHCM 638 Nguyen Van Cu, Q3, TPHCM 332 Nguyen Thai Hc, Q1, TPHCM 291 Ho Van Hue, QPN, TPHCM 975 Ba Ria, Vung Tau 543 Mai Th Luu, Q1, TPHCM 980Le Hong Phong Q10, TPHCM 450 Trung Vuong HaNoi Nguyen Manh Hung 666884444 15/09/1952 Nam 38000 333445555 5 Tran Thanh Tam 453453453 31/07/1962 Nam 25000 333445555 5 Tran Hong Quan 987987987 29/03/1959 Nam 25000 987654321 4 Vuong | Ngc Quyen 888665555 | 10/10/1927 Nu 55000 1 Bng 2: PHONGBAN TENPHG MAPH Nghien cuu 5 Dieu hanh 4 Quan ly 1 TRPHG NG NHANCHUC 333445555 22/05/1978 987987987 01/01/1985 888665555 | 19/06/1971 Bng 3: DIADIEM_PHG MAPHG DIADIEM 1 TP HCM 4 HA NOI 5 VUNG TAU 5 NHA TRANG 5 Bng 4: THANNHAN MIA NVIEN | TENTNT PHAI NGSINH QUANHE THOIGIAN 32.5 333445555 333445555 333445555 987654321 123456789 123456789 Quang Khang Duong Dang Duy Chau Nu Nam Nu Nam Nam Nu 05/04/1976 Con gai 25/10/1973| Con trai 03/05/1948 Vo chong 29/02/1932 Vo chong 01/01/1978| Con trai 31/12/1978 Con gai Bng 6: PHANCONG MA NVIEN SODA 123456789 1 123456789 2 666884444 3 453453453 1 453453453 2 333445555 3 333445555 10 333445555 20 999887777 30 999887777 10 987987987 10 987987987 30 987654321 30 987654321 20 888665555 20 7.5 40.0 20.0 20.0 10.0 10.0 10.0 Bng 5: DEAN TENDA MADA San pham X 11 San pham Y 2 San pham Z 3 Tin hc hoa 10 Cap quang 20 Dao tao 30 DDIEM DA VUNG TAU NHA TRANG TP HCM HA NOI TP HCM HA NOI PHONG 5 5 5 4 1 4 30.0 10.0 35.0 5.0 20.0 15.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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 General Management Questions!

USE library; INSERT INTO staff VALUES( 10001,'Stuart', 'Anne', '206-527-0010', 'Anne.Stuart@libray.com'); INSERT INTO staff VALUES( 10002,'Stuart', 'George', '206-527-0011',...

Create ER diagram that will represent your database project for your target task. Make sure you clearly show the entity, attribute, relationship between the entities, and specify the multiplicity....

please help , the TA's arent Deliverables To complete this assignment, submit the following three files to Webcourses: 1. An SQL file (i.e. save the file with file extension.sql) containing the SQL...

This assignment aims to develop a broad knowledge of storing and managing data to satisfy the organizational requirements. These will be reinforced by developing the practical skills required for...

Background: ( Stepsatbottom *) 1. CREATE TABLE statements: a. Define columns using four data types: CHAR, VARCHAR, DATE, DATETIME b. Specify NOT NULL to the column in primary key c. Specify...

1. Create database in PhpMyadmin and modify .env file in laravel 2. Create migration to identify the table structure by adding First name and Last Name. 3. Run migration to insert data into database....

SQL. Please help with example code on how to Create a table, insert data into table, then create a query to pull data. Implementation/SQL Introduction: You finally get to create your database. The...

a . Draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies.b . Remove all partial dependencies, and draw the new dependency diagrams. Identify...

database developers often create SQL scripts that create a whole database, and insert data at the same time. Select one: True False You could import data into a database from a CSV file, an Excel...

..il AT&T 8:07 AM moodle.latech.edu SQL Lab Assignment This assignment counts as one lab in the LAB category of your grade & is worth 100 points. This is an INDIVIDUAL assignment Copying other's code...

QUESTION 23 If the discount rate used for evaluating the social cost of carbon (SCC) is reduced from 7% to 1%, does the SCC: O Rise Fall Neither Both

Considering the below pension fund investment strategy consider the following: The asset allocation policy for the defined benefit fund is silent on the use of active asset allocation (AAA), which...

Which of the following items would affect the balance of accumulated other comprehensive income ( AOCD ) ? Multiple Choice Foreign currency translation adjusement. Income from discontinued...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...