Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

computer science major ,database course .pls solve it as fast as you can 75% D1 2:07 docs.google.com/forms :D IV - SQL Queries: Consider the following

image text in transcribed computer science major ,database course .pls solve it as fast as you can

75% D1 2:07 docs.google.com/forms :D IV - SQL Queries: Consider the following Relational schema and Relations instances. (30 points) Employee (Empid, EmpName, Department, ContactNo,Emailld,EmpHeadld) EmpSalary (Empld, Salary,IsPermanent) Project (Empld, Project,StartYear, EndYear) Write SQL queries that will do the following Employee EmpidEmpName Department 181 Isha E-101 102 Priya E-104 103 Neha E-101 104 Rahul E-102 105 Abhishek Contact No Emailta Empleaded 1234567891 1sha@gmail.com 105 1234567892 priya@yahoo.com 103 1234567893 neha@gmail.com 101 1234567894 rahul@yahoo.com 105 1234567895 abhishek@gmail.com 102 E-101 Project 2000 EmpSalary Empid Salary 101 102 103 5000 104 1900 105 2300 10000 IsPermanent Yes Yes No Yes Yes Emp Id Project Start Year End Year 1010-1 2010 2010 102 -2 2010 2012 103 p-1 104 p-4 2015 105 P-4 2015 2013 2014 Create the table EmpSalary, set the referential integrity cascade when user update or delete an employee. *

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions