Create following database schema in SQL. Insert the values in the tables.
Add Screen shots of your outputs and queries in this file. Provide a proper title to each screenshot. After adding all screenshots, upload your file here.
Hint: You can take help from Unit no. 5 to do this assignment.
Database Schema EMPLOYEE F.K. Ename San Bdate Address Dnumber P.K DEPARTMENT EK Dname Dnumber Dmgr_ssn PK DEPT LOCATIONS F.K. Dnumber Dlocation P.K FK PROJECT Pname Pnumber P.K. Plocation Dnum WORKS ON F.K. EK San Pnumber Hours P.K EMPLOYEE Ename S Bate Address Smith John B. 123456789 1965-01-09 731 Fondren, Houston, TX Wong, Franklin 333445555 1955-12-08 638 W Houston, TX Zelaya, Alicia 999887777 1968-07-19 3321 Case SpringTX Wallace, Jennifer S. 987654321 1941-06-20 2013. Belar, TX Drumber 5 5 4 4 DEPARTMENT Dame Drumbet nga Research 5 333445555 Administration 4 987654321 Headquarters + 888665555 DEPT LOCATIONS Drumber Docation 1 Houston 4 Stafford 5 Belar Sugarland Houston WORKS ON San 123456789 123456789 066884444 453453453 453453453 987654321 888665555 Pub Hours 1 325 2 7.5 3 40.0 1 200 2 200 20 150 20 NU PROJECT Pane Product Product Product Computation Reorganation Neben Pero Pocation Drum + Bellare 5 2 Sugarland 5 3 Houston 5 10 Stafford 4 20 Houston 1 30 Stafford
Create following database schema in SQL. Insert the values in the tables. Add Screen shots of your outputs and queries i
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am