Databases Questions and Answers September 24, 2021

Question 3: This question has two part, please answer part a and b, and please make sure that there are no errors when executing the queries. You can download the database from this link: https://drive.google.com/drive/folders/11FLfdYZUbIDxLuifwLcZfb9sMxGBnPiI Part a) C reate a schema bound view with check option named Schedule that will return a

,

If one of the inputs of a binary subtractor A is greater than B then what is the output for the operation ( A - B ) ?

? ? ? ? ? ? ? i s a m e t h o d f o r a n a l y z i n g a n d r e d u c i n g a r e l a t i o n a l d a t a b a s e t o a n e f f i c i e n t , s t r e a m l i n e d f o r m . Group o f answer choices Relational analysis Normalization Data modeling Structural querying

Answer questions in SAS language, please show work, I will upvote! 1. Given a value $250,028.17, what informat do you need to read into SAS? 2. Please write a program to define a SAS library "Test" to refer the directory of "D:/Stat493/Data". 3. Please write a program to view the all files in the directory in the Question 2, and no detailed

Lasers are characterized by Large bandwidth Multi bandwidth Multicolor coherant

A Chief Information Security Officer wants to monitor the company's servers for SQLi attacks and allow for comprehensive investigations if an attack occurs. The company uses SSL decryption to allow traffic monitoring. Which of the following strategies would best accomplish this goal? A . Logging all NetFlow traffic into a SIEM B . Deploying

I want to ask some questions about DATABASE 1.The most important development in the database field during the past decade is the development of relational databases. True False 2.You have created a QUERY_DEPT procedure that references the public synonym dept that is created on the adam.departments view. You have decided to create a table dept with

1 . 1 1 . 1 : Printing a message with ints and chars. Print a message telling a user to press the letterToQuit key numPresses times to quit. End with newline. Ex: If letterToQuit = ' q ' and numPresses = 2 , print: Press the q key 2 times to quit.

Given the following array: 67, 78, 122, 15, 12, 17, 312, 11, 10, 222, 18, 19, 121 What will be the array contents looking like in the following situations: 1) after calling the partition method three times in quick sort if pivot is the last element. 2) after the third iteration of the outer loop in insertion sort. 3) in bucket sort, after the

Express the following statements using augmented assignment. x = x + 6 y = y>>1 z = 8*z

i want this answer for eclipse workspace. JavaScript Problem 1 Create an HTML file and JavaScript that calculates total cost of tickets ordered. The form should look like this: Enter in number of tickets Adult: Child: order If either value is less than zero, an alert should appear saying "The values must be zero or greater!". Otherwise, an alert

Read paragraphs below and repond to it . In 2 0 2 3 , VoIP software provider 3 CX was breached by multiple supply chain attacks. 3 CX is a software company whose application is used in a wide variety of industries for calls. In March 2 0 2 3 , their desktop application which serviced about 1 2 million users was compromised and allowed malicious

0-6[18] 1. Circuit analysis: (a (21) Derive the D-FF input equation. (b[4]) Derive the state table. (c (41) Draw the state diagram. 2. Circuit redesign: (d[4]) Apply K-map reduction. (e [4]) Draw the circuit. - Clock - 10 0-6[18] 1. Circuit analysis: (a (21) Derive the D-FF input equation. (b[4]) Derive the state table. (c (41) Draw the state

,

Which of the following is a valid long literal? ABH 8 0 9 7 1 9 9 0 0 2 3 9 0 4 4 2 3 Oxnf 0 2 9 L

1 . 1 1 . 1 : Printing a message with ints and chars. Print a message telling a user to press the letterToQuit key numPresses times to quit. End with newline. Ex: If letterToQuit = ' q ' and numPresses = 2 , print: Press the q key 2 times to c + +

1 5 . 1 6 LAB: What order? ( generic methods ) Define a generic method called checkOrder ( ) that checks if four items are in ascending, neither, or descending order. The method should return - 1 if the items are in ascending order, 0 if the items are unordered, and 1 if the items are in descending order. The program reads four items from input

please help me with python 3 program of recycling machine. I have to following below criteria1.) Create a computer program that allows a user to enter items that are able to be recycled into a machine. During the process the machine prompts the user for the type of item to be recycled and how many they have to enter. The machine keeps track of the

How can you control the output generation in AI models? a . Controlling the output generation in Al models is achieved by avoiding the use of output filters b . The control of output generation in AI models is unrelated to adapting models for domain - specific tasks c . Controlling the output generation in AI models is achieved by using only open

what is the minimum number of bits to represent the number 32 base 10 ? Veuillez choisir une rponse. a. Aucune b. 7 C. 9 d. 6 e. 8 aucune means nothing

(d) Explain the key components of ARM Cortex A8 superscalar processor. (e) What additional components need to be added the MIPS data path to make it an out-of-order superscalar processor. (f) What is the function of loop stream detection in Intel iCore7 processor?

( 3 points ) Section 2 . 1 Question 7 : ( The answer to III is at the bottom of this document ) Find dfa's for the following languages on = { a , b } . I. , * * * * L = { w : | w | m o d 3 0 } II . L = { w : n b ( w ) m o d 3 > 1 } III. L = { w : | w | m o d 5 = 0 , | w | 5 }

C++ programming Define the void function SwapNodes that takes three generic type Node pointer parameters named root, ptr and nptre respectively. Given that root pointers to the head of a linked list which contains the nodes nptrl and aptr point to swap the nodes pointed to by npt and pre in the linked list pointed to by root. Define the double

Week 1 1 Program Create a Person, Customer and PreferredCustomer classes. Design a Class named Person with fields for holding a person's name, address ( including street, city, state, and Zip XXXXX - YYYY ) , and telephone number. Write at least two Constructors, Assessor and Mutator methods for all data elements. Add toString ( ) to output person

ii . ) Make a graph of z vs . x for this data. ( Read how to use Excel, step 1 on page 3 to learn about how to highlight non - adjacent columns in the graphing guidelines. ) Exercise II: Linear Least Squares Fit / Error Analysis First, read Section II of the "Error Analysis" section in the beginning of your lab manual. 1 . ) Create a new sheet

I need help with the last part of my programming assignment. My class uses java code in jGrasp. I need to print out the events from a separate text document as well as any that the user inputs. Also, I have to print the calendar to a file. I can paste my code as well as the assignment and the text document. Assignment: Task: For the third part of

Before using the data type string, the program must include the header file _ _ _ _ . string enum std iostream

What versions of hardware does ABO 2 . 2 targets the IBM Z mainframes? answer a . z 1 4 ZR 1 , z 1 4 Models M 0 1 - M 0 5 b . All of above c . z 1 3 , z 1 3 s d . z 1 6 Models e . zEC 1 2 , BC 1 2 f . z 1 5 Models

Given the Following Code: public static int mystery ( int n ) { if ( n = = 0 ) { return 1 ; } else { return n * mystery ( n 1 ) ; } } What is the output when mystery ( 4 ) is called? 0 1 0 4 2 4

Question 4 Which are true regarding CheckBox and RadioButton? A CheckBox generates an ActionEvent when its state is changed. Both can be added to ToggleGroups where only one component can be selected at a time. The state of both components can be checked by calling its isSelected ( ) method. Both components are either selected or not selected.

Which two OSI model layers have the same functionality as a single layer of the TCP / IP model? ( Choose two. ) network session physical data link transport

Your address apace is 1 9 2 . 1 0 0 . 1 0 . 0 2 4 . The number of hosts needed for each LAN is shown in Elgure. Use VLSM to create a contiguous IPv 4 addressing where. Lublel Figure With your addressing ineluding network, subnet mask, tirst - usable, last - usable and broadcast address scheme. Note: Exclude WAN 1 inka. [ 5 Marks ]

Problem 2 (a. 10 points). Write an algorithm (using pseudocode) for the binary search of an array A[1,..,n], where n>1. Please provide the running time of your algorithm. Hint: the array A has been sorted as the ascending order

Consider the ER scheme for the MOVIES database shown in the figure below (attributes arent important for this problem and are omitted): Assume MOVIES is a populated database. Actor is used as a generic term and includes actresses. Given the constraints shown in the ER diagram, respond to the following statements with True, False, or Maybe. Assign

R programming question I have this folder and it has about 8 files in it. In each individual file has data and I did cbind and I got all of the files to go together. but there is just one problem. Every file is different but they have one thing that they all have in common, they all have a column that says participant (to represent the person

need help with MATLAB Error \% Temperature Data temp =[75,77,76,73,69,68,63,59,57,55,54,52, 50,50,49,49,49,50,54,56,59,63,67,72]; \% Time t=1:24; \% Query the polynomial fit X= linspace (1,24,100); \% Time Vector N=10;% Polynomial Degree % \% *Polynomial regression order* % \% Initialize phi matrix phi =zeros(24,N) \% _*Create a design matrix for

,

Show that the collection of decidable languages is closed under the following set operations: ( a ) Intersection. ( b ) Complement.

Find an orthogonal basis for the column spoce of the matrix to the right. 110114226441449 Ar orthogonal basis for the colimn space of the given matrix is (Type a vector or list of vectors. Use a comma to separate vectors as noeded.)

This is in Python: Alter your code for previous Do It Now problem, with the change that the row should only be printed by the second number that the user enters. For example, the user enters two numbers of 5 and 7 for the two input lines in the code, and the following will be printed: 5 x 1 = 5 5 x 2 = 10 5 x 3 = 15 5 x 4 = 20 5 x 5 = 25 5 x 6 =

Solve the separable differential equation d x d t = 6 x and find the particular solution satisfying the initial condition x ( 0 ) = 7 . x ( t ) = The problem is solved with the correct answer. I need this to be solved with python solver code. Please provide screenshots of the code used and the output in python including the correct answer.

Hi, this question is about Computational Linear Algebra and Matlab. Matlab is a computer program commonly used in engineering. Exercise 1 (4 points) Difficulty: Moderate In this exercise, you will be given two matrices A and B. You will write a set of commands in MATLAB that determine whether Row A and Row B are subspaces of the same space R". If

,,

Read chapter 3 and be sure to do all the tutorials from the very beginning of the chapter. You must submit the following for grading: 1. Topic 3.10: Focus on Program Design and Problem Solving: Building the Room Charge Calculator (10 points) Note: Study and complete Chapter 3 Topics 3.1 through 3.9. These topics comprise tutorials 3.1 through 3.9.

Write a script to find N m i n , the smallest possible value for N in Eq . ( 1 ) so that l n ( 5 ) evaluated using myLog with Matlab's default double precision arithmetics is exact when written as a half - precision binary floating point number in engineering notation. Use decimal 2 binary developed in Module 1 to answer this question and do not

Write expressions to concatenate the following. 1. ''His name is ", "Patience." 2. "Wel", "come" 3. "Fayette", "ville", " State"

( 9 points) Jared is asked in class to decode a message by reordering letters in a certain order, but unfortunately, they never learned how to read. Jared can only distinguish what each letter looks like, and is trying every possible ordering of letters, since they cannot read. Thus far, they only know the letters of the first part of the message:

,,

1. (25 points) Please design regular expressions for the following languages (a) r over 0, 1) | r starts with 0 and has an odd number of symbols, or starts with 1 and has an even number of symbols (b) z over 0, 1 | r is any string except 11 and 1111 (c)over 0, 1) contains at least two Os and at most one 1 )

Write a job resume for a cyber security and IT Specialist in 300 words.

The U.S. Supreme Court struck down a California law banning the sale or rental of violent video games to minors. The court ruled that the law violated free-speech rights and that government did not have the power to restrict ideas to which children may be exposed. In a letter to the IEEE magazine The Institute, a reader expressed his disagreement

A critical section is a segment of code, in which a process may be changing common and shared variables, updating a table, writing a file, and so on . Group of answer choices True False

o What does a.compareTo(d) return? Why?

Why might you want to set use the reminder window?

Description : Write a C++ program to determine the winner of the contest. The contest has five judges, each of whom awards a score between 1 and 10 for each of the performers. Fractional scores are not allowed. A contestants final score is determined by dropping the highest and lowest scores received, then averaging the three remaining scores (the

Original Address: 1 0 . 0 . 0 . 0 / 8 Custom Address Map: N . sshhhhhh . H . H Interval and Octet: Prefix Length: Custom Subnet Mask: Total Number of Subnets Possible Number of Addresses per Subnet: Usable Addresses per Subnet: First Network Address: Second Network Address: Third Network Address: Fourth Network Address:

QUESTION 7 interviewing is patient - centered and nonconfrontational. A . None of these B . Motivational C . Rogerian D . Health Belief QUESTION 8 When nurses reveal personal information about themselves to patients, it is known as A . self - disclosure B . connecting c . sharing D . divulging

Your task is to perform a step of logical database design, i . e . to transform a conceptual schema given above into a collection of relational schemas. For each relational schema clearly list the names of attributes, primary key, candidate keys ( if any ) , and foreign keys ( if any ) . Assume, that superset method must be used to implement a

Instructions In this assignment, you will create pseudocode that reflects the main elements of the logic for your final project. Use the How To Write Pseudocode document to help you write the pseudocode. To complete this assignment, review the Pseudocode Guidelines and Rubric document. IT 312 Pseudocode Guidelines and Rubri Overview: In this

,,,

SQL class : Desperate need of homework assistance and explanation A database at a college must support the following requirements: For a department, store its number and name. For an advisor, store his ID number, last name, first name, the department number to which he is assigned. (We will assume an advisor works for only one department, not two

i want it before one hour Question 17 Not yet answered Marked out of 1.00 P Flag question For a 64 point DFT using direct method, No of complex multiplication is O a. 4069 O b. 4096 O c. 4032 O d. 4023

Find the language that recognizes each of these 2 DFA 90, 91, 92} 1,2,3,4,5,6,7,8,9} : 1 2 3 = (, , , 91, F), 1 2020 93, 94, 95, 96, 97} : 7

,

Lab 10 List of Objects //*************** Main Class********************* public class Java Application25 { public static void main(String[] args) { list obj=new list(10): obj.add("soso"); obj.add("lolo"): obj.add("dodo"); obj.add("dodo"); obj.add("dodo"); obj.displayo; } //******** ***********List Classs********************** public class list

,,

Fatima wants to record a voice - over to add to a presentation. Other than a microphone, what does Fatima need to record the audio? Select one: a . audio codec b . sound recorder software c . special effects software d . audio - streaming software

Prepare a 4 page (not including title) reflection paper on your ISS680 readings, exercises and discussion posts. The paper should include: - A brief summary of your course experience. - Identify and explain relevant conceptual material (theories, concepts) from the course. - How the course concept/idea/theory may or will change your future

Convert the following decimal values to IEEE 32-bit floating point format: 1- -1313.3125 2- 0.1015625 3- 39887.5625

Use Project to create a Gantt chart for a project called "_CS405." Add the following tasks and their durations, start and end dates. The project should complete within three (3) months of the start date. A. Tasks: 1. Planning 2. Requirements analysis 3. Design 4. Coding and unit testing 5. Integration 6. Integration testing 7. User Training 8.

Quick l have a midterm (Systems Analysis phase) Read the following scenario carefully and based on, answer the below questions: Scenario: In the Systems Analysis phase the following data has been collected (The Interactive Marketing System or suppliers are marketing their products to Customers. This scenario is centered around shopping". The

What activity in a SOC involves using data obtained from automated sources, including AI and ML , to search for advanced threats? A . threath unting b . vulnerability analysis C . threat intelligence D . incidence response

Express your times in picoseconds and your throughputs in GIPS Equal-lengthed Stages: Consider the design of a processor, with a max instruction length of 600 ps. The propagation delay to load a register is 25 ps. (a) What is the minimum clock cycle time, the instruction latency and CPU throughput using serial execution? (b) What is the minimum

MISC5 (1.5pts) class LegoMov public: bool *evIsAwes; void setEvIsAwes (bool b) *evIsAwes-b; LegoMovO evIsAwes new bool(false) int main (void) LegoMov movie; mo vie.setEvIsAwes(true); return 0; Are there any errors in the code? O Yes, movie is not initialized so we cannot call setEvIsAwes O Yes, the value that evIsAwes points to is not modified

it ('getTypes()', () => { const special: Record { const specialItems: UlItem[] = []; const subType = special[key]; subType.forEach((specialItem) => { const item = {} as UlItem; item.label = specialItem.description; item.value = specialItem.code; specialItems.push(item); ) specialTypes[key] - specialItems; }): } return specialTypes; }

The following is / are example ( s ) of Vulnerability Scanners / Vulnerability Management software applications used in practice. The following is / are example ( s ) of Vulnerability Scanners / Vulnerability Management software applications used in practice. Nexpose Nessus OpenVAS All of the above

A group of developers are working on the same codebase. They need an online system to allow them to submit their work and check out work when others update their code. Which type of collaboration system should the group implement?

Question 1 9 Employees often have extensive knowledge of systems and can pose a greater risk than external attackers. True False

The entire operating system must be rewritten when major components of Windows need to be replaced. Question 5 0 Select one: True False

When creating a method that will have an array as a parameter we must: Ensure that the size of the array is included in the square brackets of the array parameter Will only work if the array is created inside of the method Ensure that the size of the array is also included as a separate parameter Ensure that the method will work regardless of

Write x as the sum of two vectors, one in Span {u1,u2,u3} and one in Span {u4}. Assume that {u1,u4} is an orthogonal basis for R4. u1=0181,u2=7911,u3=1018,u4=9711,x=11930 x= (Type an integer or simplified fraction for each matrix element.)

The syntax for accessing a struct member is struct VariableName q , a . memberName b . * memberName c . [ memberName ] d . SmemberName

The goal of this assignment is to implement the Apriori algorithm to discover association rules withina grocery store dataset. Students will gain hands - on experience in data mining and association rulelearning.Dataset:Use the following grocery store transaction dataset:Transaction 1 : Chips, Soda, Ice CreamTransaction 2 : Soda, Cookies,

Create a new list called ratios where the i'th element of ratios is equal to the growth [ i + 1 ] / growth [ i ] . Because you need to compute ratios from pairs of elements, the list ratios will have one fewer element than the list growth.

Please answer both parts of the following question for part 1 and explain why? QUESTION 1A) A hard drive imager can clone 2 different types of interfaces (IDE and SATA) at the same time? A) True B) False QUESTION 1B What is the purpose of Adapters as it relates to the hardware drive imagers? a. They are needed to be able to image all interfaces

python Question 3: Write a program that reads from the user the length of two sides of a triangle and the angle in degrees) between these two edges. The program should use Turtle Graphics to draw such a triangle. Your program should work with any set of inputs, which means no hardcoding of lengths or angles. For example, if the user enters 150 and

2. (10 points) Prepare a Matlab script that enters and solves the given linear system, comment every line. Also write the solution as a comment. 2.0 - 4.14 = -10 3x2 + 3.13 = 0 13 +44 = -1 -3.01 + 2.02 + 3.13 + 14 = 5

Create a Visual Basic program as described below. Write a program to calculate the cost of widgets. There are $25,000 in fixed costs and each widget costs $17 to manufacture. Display total costs and the cost per widget for 10,000 to 20,000 widgets in increments of 100. Display your output in a RichTextBox.

Recall Merge Sort, in which a list is sorted by first sorting the left and right halves, and then merging the two lists. We define the \ textit { 3 - Merge Sort } algorithm, in which the input list is split into $ 3 $ equal length parts ( or as equal as possible ) , each is sorted recursively, and then the three lists are merged to create a final

Based on the mode, is there one member group associated with the protected class variable that, on average, is less likely to open an account over others? If this information was used in an algorithm to determine hireability of future employees, do you think it would introduce any biases? Explain ( in no more than 2 - 3 sentences )

Needs help with Javafx Programming Your task is to write a Java application to play the game of tic-tac-toe. this is a human player VS computer player game The game of tic-tac-toe is played on a 3x3 grid of cells. One player is designated as X and the other is O. The X player always goes first and places an X symbol on one of the nine empty cells.

Analyze the following code: public class Test{ public static void main(String[] args) { int[] x = {1, 2, 3, 4, 5); xMethod(x, 5); } public static void xMethod (int[] x, int length) { System.out.print("" + x[length - 1]); xMethod(x, length - 1); } } Select one: The program displays 5 4 3 2 1 and then raises an ArrayIndexOutOfBoundsException. The

A client computer uses the IP address 1 0 . 2 5 4 . 2 5 4 . 1 8 9 . It has made a connection to a web server by opening the outbound port 1 5 8 9 . The server uses the IP address 6 5 . 1 9 . 2 8 . 1 5 4 . You want to filter out any HTTP packets coming from the server. Which IP address and port should you specify to be filtered on the firewall?

Consider the graph shown below and the use of Dijkstra's algorithm to compute a least cost path from a to all destinations. Suppose that nodes b and d have already been added to N '. What is the path cost to the next node to be added to N ? 5 9 7 6 4 8

p q, q r, r p { 1. p -> q premise 2. q -> r premise 3. ~r premise } Complete the above proof using the following rules: example : p q r, q s, r t p (t s) { 1. p q r premise 2. { 3. p assume 4. q r e 1 3 5. { 6. q assume 7. q s premise 8. s e 7 6 9. t s i2 8 } 10. { 11. r assume 12. r t premise 13. t e 12 11 14. t V s Vi1 13 } 15. t s e 4 5 10 }

Five processes (A through E) are available in the ready queue (see below). A C E B D The processes are scheduled using Round-Robin approach and the quantum is set to be 4 millisecond. At time 0 millisecond, process A starts to run. Therefore, which process will be running at time 25 millisecond? Group of answer choices 1.Process A 2. Process B 3.

In an online bank application that transfers funds from a checking account to a savings account, the q , property ensures that another transaction sees the transferred funds in one account or the other, but not in both, nor in neither. consistency atomicity isolation durability

Hide column E and column F in the worksheet, then create a custom view with the name Public View showing the worksheet with the two columns hidden. Accept all other default display settings.

Let $L [ 0 ] $ be defined formally as $ \ { x _ 1 0 x _ 2 . . . 0 x _ n | x _ i \ in \ Sigma , x _ 1 . . . x _ n \ in L \ } $ . In other words, strings of $L [ 0 ] $ are formed by taking a string from $L$ and inserting a $ 0 $ between each character of the word, so that if $L = \ { \ bl { 1 1 } , \ bl { 1 0 1 0 } \ } $ , then $L [ 0 ] = \ { \ bl {

Overview: You have been tasked with encoding and decoding supersecret information for a government organization. We will be using a substitution cipher in this project. A substitution cipher with a unit of a letter is a method of encoding by which specific letters in a text are replaced with a different letter everytime. For example, the letter a

5 . Write a recurrence relation describing the worst case running time of the following algorithmand determine the asymptotic complexity of the function defined by the recurrence relation.Justify your solution using substitution / expansion or a recursion tree. You may not use theMaster Theorem as justification of your answer. Simplify and express

Consider the following two threads, to be run concurrently in a shared memory (all variables are shared between the two threads). Assuming a single processor system, that load and store are atomic, that x is initialized to 0, and that x must be loaded into a register before being incremented (and stored back to memory afterwards), what are all the

Write the code for invoking a method named sendSignal . There are no arguments for this method. Assume that sendSignal is defined in the same class that calls it . in java

What is the output of an XNOR gate with 8 - bit inputs 1 0 1 1 _ 0 1 1 1

Question 19 Not yet answered Given below is the block diagram of a unity feedback continuous time system. a. Obtain the characteristic equation of the system (1 Mark) b. Check if the system satisfies the necessary and sufficient condition of Routh Hurwitz criteria for stability (3 Marks) C. Comment on the stability and the mumber of poles in Right

Question# 2 : ( Select one answer ) What does the following code do ? SELECT * FROM customer WHERE zip = ' 9 8 1 1 8 ' OR zip = ' 9 8 0 9 2 ' ANDbalance > 5 0 0 0 ;a ) shows customers with zipcodes of either 9 8 1 1 8 or 9 8 0 9 2 - but only ones with a balance of over $ 5 , 0 0 0 . b ) shows customers wth zipcodes in either 9 8 1 1 8 or 9 8 0 9 2

Mark bought a sweater from a store in the mall. As he left the store, he set off the alarm. This is because the cashier likely left the on the item Mark purchased. RFID tag WiMax bar code QR Code