Answered: Consider the following Staff relational…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Consider the following Staff relational schema: STAFF (STAFFNO, NAME, DOB, GENDER, DOJ, DESIGNATION, BASIC_PAY, DEPTNO) GENDER must take the Value ‘M’ or ‘F’ DEPT (DEPTNO, NAME) SKILL (SKILL_CODE, DESCRIPTION, CHARGE_OUTRATE) STAFF_SKILL (STAFFNO , SKILL_CODE) PROJECT (PROJECTNO, PNAME, START_DATE, END_DATE, BUDGET,PROJECT_MANAGER_STAFFNO) WORKS (STAFFNO, PROJECTNO, DATE_WORKED_ON, IN_TIME,OUT_TIME) i. The primary keys are underlined. Identify the foreign keys and draw schema diagram ii. Create the above mentioned tables and populate the tables iii. Note: Read all questions and populate values accordingly. iv. Include the constraints as mentioned above. v. Develop a SQL query to list the details of staff who earn less than the basic pay of all staff. vi. Create a view that keeps track of DeptNo, DeptName and number of staff in each department. vii. Develop a SQL query to list the details of staff who have more than three skills. viii. Create an index on StaffNo in Works table

Expert Solution