Create following database schema in SQL. Insert the values in the tables. Add Screen shots of your outputs and queries i

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Create following database schema in SQL. Insert the values in the tables. Add Screen shots of your outputs and queries i

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply