Consider the following two statements: 1) Open-ended questi…
Consider the following two statements: 1) Open-ended questions are those which can be answered with a yes or no; 2) Behavioral questions are questions which ask a candidate to recall past behavior in how they actually have handled a situation in the past.
Read DetailsAssume that a course may or may not use a textbook, but that…
Assume that a course may or may not use a textbook, but that a textbook by definition is a book that is used in some course. A course may not use more than five books. Instructors teach from two to six courses. Additional assumptions are as follows. Each course is taught by exactly one instructor. Each textbook is used by at least one and can be used up to three courses. An instructor does not have to adopt a textbook for all courses. If a textbook exists: it is used in some course, hence it is adopted by some instructor who teaches that course. An instructor is considered to adopt a text if it is used in some course taught by that instructor. Supply (min, max) constraints on this diagram using the label letter as a reference for the position of the notation. You can provide your notations in the following format (the values below are just an example): A: (0, N) B: (1, 1) … State clearly any additional assumptions you make.
Read DetailsFigure 1. One possible database state for the COMPANY relati…
Figure 1. One possible database state for the COMPANY relational database schema. Specify the following queries on the database schema shown in Figure 1 using the relational operators (relational algebra). Retrieve the names of employees in department 5 who work more than 10 hours per week on the ‘Computerization’ project. List the names of employees who have a dependent with the same first name as themselves. Find the names of employees that are directly supervised by ‘Jennifer S. Wallace’. NOTE: Express each of the provided information needs as a relational algebra query using only projection (π), selection (σ), renaming (ρ), inner joins (⋈), set union/intersection (∪, ∩), and division (/). You may write your queries using either the symbol (i.e. π) using the ‘Insert Math Equation’ option or the operations’ word terminology (i.e. projection).
Read Details