Employee (emp_id, emp_name, Emp_Status,department, contact_no, email_id, emphead_id) Department (dept_id, dept_name, dept_off, depthead, empid) Salary (empid, salary) Project (projectid, dept_id, duration) Country (C-id, c_name) Client (client_id, client_name, c_id) Emp_project (empid, project_id, client_id, startyear, endyear, status) Select the detail of the employee whose name start with P. 1. 2. How many permanent candidates take salary more than 5000 excluding non-permanent staff? 3. Select the details of the employee who work either for department E-104 or E-102. 4. What is total salary that is paid to permanent employees in each department and which department pay highest salaries above 100000.

Q: PROBLEM 9 The Darby Company manufactures and distributes meters used to measure electric power…

A: The answer is given below for your reference

Q: Give two representations for the following graph: 2 3 b 1

A: Two Representations of a graph are  Adjacency Matrix and Adjacency List

Q: Suppose you are making an SRS for University System. Mention any 5 requirements Management for this.

A:

Q: How can you Rename a file or folder using My Documents? Write steps.

A: My Document: My Documents and Documents are Microsoft Windows folders that house computer documents…

Q: What exactly should I fix in the code or in the database so that this system will work? link of…

A: You may be on table columns and their default values, or stored procedures and their call argument…

Q: What is the new sematic elements in HTML5? i. ii. iii. iv. a. i and iv b. ii and iii c. i, iii…

A: Answer:

Q: Given a network address of 218.35.50.0, 5 needed subnets, determine the following and Fill up the…

A: Answer is given below.

Q: Simulate each block(full adder and combination circuit) from the carry-look- ahead adder(picture…

A: In digital electronics, the full adder is developed to overcome the drawbacks of the half adder.

Q: [111 37 1. Let A 2046 137 a) What size is A? b) What is the third column of A? c) What is the second…

A: Question 1: a) The size of a matrix is defined as: (number of rows) x (number of columns). For…

Q: Is there a difference between a system subsystem and a logical division?

A: Subsystem is derived from system and it is an integral part of a larger system.

Q: Rewrite the following code using one if statement. For the purpose of Canvas grading, only indicate…

A: After rewriting the above code  it becomes If(x==0 || y==0) { ..... }

Q: Write a function func3 (n) that takes as an input a positive integer, n, and returns a dictionary…

A: The following are steps need to be taken for the given program: Create an empty dictionary Using n…

Q: You have 6 roses with you, and now you need to decide what bouquets to make in order to maximize…

A: The answer is given in the following steps for your reference.

Q: In your own words, describe what happens at every step of our network model, when a node on one…

A:

Q: My task is to extract a pdf file using python and output it in my sublime text IDE. What I need is…

A: To get total pages we can use PyPDF2.PdfFileReader and save it in a variable, after that we can loop…

Q: Given a network address of 218.35.50.0, 5 needed subnets, determine the following and Fill up…

A: Bartleby allows experts to answer only one question at a time. So first question will be answered…

Q: Present state с 0 0 1 1 A 0 0 0 0 В 0 0 0 0 O Input X 0 1 0 1 011 Next state A B с 101 FF inputs T 0…

A:

Q: Create program that uses commands: 1.Accept a command line argument which is the purchase data file…

A: File Content: 200 CSCO 24.0050 IBM 130.00100 AAPL 94.28 Program: #include <iostream>#include…

Q: nstructions: modify the code below and add these features to this dice game: Multilevel…

A: Answer : we have combined the three programs and it is run fine

Q: In Free-Play Mode, LEGO Star Wars: The Skywalker Saga will frequently and inexplicably swap the…

A:

Q: Supporting a travel agency, TORS maintains tour information and provides reservation facilities for…

A:

Q: Use the substitution method to obtain the exact value of T(n) in the following recurrence. Show all…

A: Steps in the Substitution Method:Expand the parenthesis to simplify the given equation.One of the…

Q: Exercise 2: Write a C program that uses standard functions to four numbers from the user and find:…

A: As per the requirement program is developed. Algorithm: Step 1: Include the required header file…

Q: A segmentation architecture in logical address consists of a two tuple (segment-number, offset).…

A: A procedure called segmentation divides a user programme into segments. It is divided into pieces of…

Q: 1. The following data structure gives the marks for three Programming exams for three students arks…

A: Given:

Q: Problem 2 Design a 5-bit combinational circuit 2's complementer with inputs A, B, C, D, E and…

A: Here A, B, C, D, E corresponds to b4, b3, b2, b1, b0 and  V, W, X, Y, Z corresponds to b4`, b3`,…

Q: a) Use the last six integer numbers from your UiTM student ID as unsorted data. Then, determine the…

A: The basic sorting algorithm is the bubble sort, in which nearby components are compared and sorted…

Q: NW_Q3) IP addressing operates at the network layer (Layer 3) of OSI, IP addresses must be able to…

A: As given in this question we need to finda) Sub-net maskb) sub-net idc) range of ip address  for…

Q: c++ program The program below misses the function declaration and definition of Sum_Of_Squares…

A: Here is the approach :  For the function defination . We can see that we have to save the result in…

Q: What are the names of these topologies? lbc 2b Wraparound link

A: Names:

Q: The following if-statement is valid: if 2 < age < 18 then Select one: True False

A: Given statement is: if 2 &lt; age &lt; 18, means age should be greater than 2 and less than 18. In…

Q: int array 1 [H][J]; int array2[J][H]; void copy_array(int x, int y) { array2[x][y] = array1[y][x]; }…

A: Assembly code An assembler is a tool that transforms Java assembly code into executable machine…

Q: To transmit the data 1011000 to his friend using hamming code technique. Calculate (i) number of…

A: Answer: Given transmitted data=1011000

Q: Calculate the delay x bandwidth product for the following links. Use one-way delay, measured from…

A: calculate delay * bandwidth product for the following links:

Q: Write a c++ program that includes a function which requires 4 input parameters. After calculation,…

A: The C++ code is given below with code and output screenshots.   The Standard deviation is given in…

Q: 17. Give the Boolean expression for the following circuit diagram.

A: A Boolean expression is also a logical expression with numerous Boolean values with operations like…

Q: Write a python function octal(n) which takes as an input a positive decimal integer, n<512, and…

A: Input the decimal number. Divide the decimal number by 8. Store the remainder. Repeat steps 2 and 3…

Q: (a) Write Prims algorithm for determine the minimum spanning tree of weighted graph. Also determine…

A: Prism algorithm for minimum spanning tree: Step 1: Select an arbitrary starting vertex. Step 2:…

Q: An investment firm has $1 million to invest in stocks, bonds, certificates of deposit, and real…

A: The answer for the above question is given in the following steps.

Q: Timing error occurs in synchronization as a result of frequency difference between two physically…

A:

Q: In C++ A system is set up to take raw grading information from the console and calculate a…

A: C++ code: #include &lt;iostream&gt;#include &lt;string&gt;#include &lt;cmath&gt; using namespace…

Q: 1 1. Let A = 204 1 3 6 13 7 a) What size is A? b) What is the third column of A? c) What is the…

A: What size is  A ?  --&gt; This sturcture is called as the matrix . Which consist of the rows and the…

Q: Design a program that tests your ESP, or extrasensory perception. The program will randomly pick a…

A: The answer is given in the below step

Q: Do you believe it is OK to part out your personal information in exchange for software that is free…

A: When you're online, you usually share some information about yourself, also known as your data, with…

Q: python not java please

A: START define the function func() with parameter of value 'n' if n is 1, then return 1 else, return n…

Q: The instruction "BTG 0x89,3,1" takes. instruction cycles to execute. If the default RC oscillator…

A: The question has been answered in step2

Q: SIGNAL AND SYSTEMS LABORATORY 3- Perform the deconvolution operation between the following two…

A: Deconvolution operation of given two signals; Deconvolution of the signal; consider the first…

Q: Suppose you have an LFSR with state bits (also known as the seed) (s5, S4, S3, S2, S1, So) = (1, 1,…

A: LFSR stands for Linear Feedback Shift Register, it is a type of shift register whose input bit is a…

Q: (c) The design model is of lower abstraction le than the analysis model. Explain this statement.

A: Lower abstraction level: The lowest level of abstraction describes how a system actually stores…

Q: INFA for the ammar

A: Regular languages are denoted to regular expressions. NFA stands for non-deterministic finite…