(c) Who is the most popular? (d) If we're having a party and want to distribute the message the most quickly, who should we tell first? Justify your answer. (e Show how we can store the above data using adjacency matrix. (f) Show how we can store the above data using adjacency list.
Q: 6) What are the values of these sums, where S = {8, 10, 14, 20, 21, 24, 29}? %3D 2 a ) Σκes k b)…
A: 6) Given, S = { 8, 10, 14, 20, 21, 24, 29 } a) Σ k ∈ S k = 8 + 10 + 14 + 20 + 21 + 24 + 29 =…
Q: B) Without using the max command, find the maximum value of matrix (y) where /1 2 y =0 3 8 8 11 10/
A: Declare a variable and initialize it with very first element of matrix Iterate over matrix and…
Q: b. Draw the state table
A: Here A is the input and the state bits is XY. Input to flip flop is Dx=X xor Y xor A Dy=Y'
Q: Compute the longest common subsequence by computing the table for given two strings. X =…
A: SOLUTION: we have used the Dynamic programming approach to find the longest common subsequence…
Q: For the data given below, find the best-fitting line (according to the criteria of the…
A: Instruction: linear fit {1, 1.2},{2, 2.3},{3, 3.6},{4, 4.9},{5,5.9} Screenshot:
Q: In a list there is cost price of n goods. On the most expensive thing there is a loss of x% and on…
A: Input value of n Store all cost prices in list Input values of x, y, p Store all selling prices in…
Q: Prove the following by using (a) truth tables and (b) the Resolution Rule: (Hint: Convert to clause…
A: Part A: We shall prove the given expression by Truth Tables. The given expression ((P → Q) ∧ (Q →…
Q: How do you work out Ellen's vote using just the RSA public keys, which is (N,e) =
A: To work out Ellen's vote using just the RSA public keys, one would need to factorize the modulus N.…
Q: From worksheet General, in cell D6, generate a random number. Answer: From worksheet General, in…
A: Select cell D6 RAND() hit enter This would generate random number
Q: Compute the longest common subsequence by computing the table for given two strings. X = Y =
A: If S1 and S2 are the two given sequences then, Z is the common subsequence of S1 and S2 if Z is a…
Q: Determine whether p→(q→r) and p→(q^ r) are equivalent using truth tables. Not enough information…
A: Option C: Not Equivalent p q r q->r p->(q->r) q^r p->(q^r) F F F F F F F T F T T…
Q: If p is in fact less than 0.301, would it make you suspect that there are not enough numbers in the…
A: In step 2, you will get the answer.
Q: 4. Using a truth table, determine whether the following is true: A A ¬A - B. Then briefly explain…
A: Given Expression : A ^ ~A |= B
Q: solve using python to; - Load the data set "Cars93.csv" or "Cars93.pkl" that provided in the…
A: import numpy as npdata=np.loadtxt('car.csv', delimiter=' , ')print(data[:4,:])
Q: Construct a truth table for each of these compound propositions. a) (p→q)∧(¬p→q)…
A: a) (p→q)∧(¬p→q) P q ¬p p→q ¬p→q (p→q)∧(¬p→q) T T F T T T T F F F T F F T T T T T F F T…
Q: 2. If A = magic (24), what is the value in row 21, column 22?
A: find your Answer below
Q: Using limits, find which symbol, O, Θ, or Ω describes the relationship between nln(n) and n3.…
A: Time соmрlexity is the аmоunt оf time tаken by аn аlgоrithm tо run, аs а funсtiоn оf…
Q: Find the next three terms of the following number pattern? 1.) 1, 1, 2, 3, 5, 8,__, __, __? 2.) 2,…
A: To Do: To find the next term for each number pattern.
Q: 1- Suppose you have the information of sales (la) of poultry factory (elga J),contain several…
A: Answer is given below .
Q: Question 3 One way to solve the key distribution problem is to use a line from a book that both the…
A: Ciphertext is scrambled content changed from plaintext utilizing an encryption calculation.…
Q: how is the inverse of a matrix used? Provide the definition of inverse of a matrix
A: Definition of Inverse matrix When multiplied with the provided matrix, the inverse of a matrix is…
Q: 8. If Eve wants to decode the message, she will need to know the inverse of the matrix you used to…
A: We need to find the total number of possible 3x3 matrices with entries belonging to the set…
Q: For a new patient, ID 9999, with Temp=H, BP=H, Test1=N, Test2=P, is he/she Healthy (H) or Diseased…
A: The question falls under Data mining. Naive Bayes Classifier: Naive Bayes classifiers are a…
Q: 2- Suppose the cell A1 contain your complete name, the first and second name separated( guada) by…
A: In the given example , the full name is in the format of First Name Last Name. The full name is the…
Q: 4.Consider F = {BC -> D, B -> E, CE -> D, E -> CA, BF -> G} and R(A,B,C,D,E,F,G) a)Find all many…
A: Here in this question we have given some set of FDs F = {BC -> D, B -> E, CE -> D, E ->…
Q: Using the RSA public key cryptosystem, with a = 1, b = 2, etc., a. If p = 7 and q = 11, list five…
A: (a) n = p x q = 7 x 11 = 77 z = (p - 1) x (q - 1) = 6 x 10 = 60 d should be…
Q: What is the height of the BTree? k) What are the complete leaves of the BTree
A: Gievn B-TREE what is the height of the BTreeand What are the complete leaves of the BTree.
Q: Draw K map for f'=a'+ab'c'+abc
A:
Q: Q7: Use state elimination method to convert the following DFA to RE and explain your answer. 1- A b…
A: DFA to RE given is given below :
Q: How the inverse of matrix is obtained and how it is used in cryptography Minimum of 10 sentences
A: i give a full example how to find inverse and its uses in decryption.Kindly refer it
Q: Example of Extracting The Square Root. Please also provide explanation!
A: Applying the square root property as means of solving a quadratic equation is called exacting square…
Q: referring to Diffie Hellman, if the prime q is 353, alpha is 5, random secret key Xa is 110 and…
A:
Q: 11) Assume that the text and pattern have been converted to numbers. Use Rabin Karp with 3 digit…
A: Given: T=4 8 6 3 7 9 12 6 Q = 12 P=379
Q: Given the following confusion matrix, calculate the False Postive Rate for B. FPR of B = ACTUAL…
A: For the given matrix, we need to calculate false positive rate for B. We know that, False Positive…
Q: Use dynamic programming to find the longest common subsequence of the following two sequence. (fill…
A: Introduction: Here we are required to explain and create and fill a table accordingly to find the…
Q: Question 15 For Questions 15.1 - 15.2 consider the following integers: In a RSA cryptosystem with…
A: RSA Algorithm: Choose 2 large prime numbers p and q such that…
Q: Show using tableaux that the following wff is valid: (p → q) → (p → (q ∨ r))
A:
Q: This indicates that the signed sum is out of range. a. Carry b. Overflow c. Extra d. Due
A: The complement is the inverse of a variable and is indicated by a bar over variable.
Q: 3- give the difference between who and whos Your answer
A: differerence between who and who's
Q: Theoretical Analysis Brute Force [Write your analysis for the brute force case] Divide and Conquer…
A: Given two methods, Brute Force Divide and Conquer
Q: In Diffie-Hellman key exchange is based on the use of the prime number q = 353 and a primitive root…
A: Ans:) Given, prime number (q) = 353 alpha = 3, Secret keys XA =97 and XB= 233
Q: A short note (in good English) explaining why (*) p → q is true if p and q have the same truth…
A:
Q: Let p = 37 and q In RSA public key generator, which one is a valid choice for e? O e = 25 O e = 8 O…
A: So answer is given below this question is related to RSA algorithm
Q: Show, using worked out examples, that for RSA, PB(PR(M))=M and PR(PB(M))=M, where PB, PR and M,…
A: The answer is written in step 2
Q: Task 4- Giving explanations, use De Morgan's Law to simplify the following: "(AvB ) v (~A^~B) Task…
A: De Morgan's law states the following ~(A v B) = ~A ^ ~B ~(A ^ B) = ~A v ~B
Q: 7. A child has learned about affine ciphers. The parent says NONONO. The child responds with hahaha,…
A: The Vernam cipher: In principle, the Vernam cipher is a complete cipher. The plain line is secured…
Q: 1. Write a truth table to show that P Q and (P^ Q) v (¬P ^ ¬Q) have the same truth values. 2. Write…
A: 1. P⇔Q and P∧Q∨¬P∧¬Q P Q P∧Q ¬P∧¬Q P∧Q∨¬P∧¬Q T T T F T T F F F F F T F F F F F F T T…
Q: This indicates that the unsigned sum is out of range a. Carry b. Overflow c. Extra d. Due
A: According to the given question, it is required to determine that which given parameter indicates…
Step by step
Solved in 2 steps with 1 images
- consider the database below and answer the query. pk refers to primary key and FK refers to foreign key. Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK)) Departments(Department_id(PK), dept_name, manager_id(FK), location_id) Locations(Location_id(PK), street_address, postal_code, city, state_province, country_id) Countries(Country_id(PK), Country_name, region_id) Jobs(Job_id(PK), job_title, min_salary, max_salary) write a pl/sql script (using cursor and %TYPE) query to show the ames of all the departments which are not located in US or Canadaconsider the database below and answer the query. pk refers to primary key and FK refers to foreign key. Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK)) Departments(Department_id(PK), dept_name, manager_id(FK), location_id) Locations(Location_id(PK), street_address, postal_code, city, state_province, country_id) Jobs(Job_id(PK), job_title, min_salary, max_salary) write a pl/sql script (using cursor and %TYPE) query to show the ames of all the departments which are not located in US or Canadaconsider the database below and answer the query. pk refers to primary key and FK refers to foreign key. Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK)) Departments(Department_id(PK), dept_name, manager_id(FK), location_id) Locations(Location_id(PK), street_address, postal_code, city, state_province, country_id) Jobs(Job_id(PK), job_title, min_salary, max_salary) write a pl/aql script to create a procedure the string accordingly, if the employee is receiving any commision(COMMISSION_PCT) or not. the argument of the profedure is Empl_id. also, write the procedure call
- consider the database below and answer the query. pk refers to primary key and FK refers to foreign key. Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK)) Departments(Department_id(PK), dept_name, manager_id(FK), location_id) Locations(Location_id(PK), street_address, postal_code, city, state_province, country_id) Jobs(Job_id(PK), job_title, min_salary, max_salary) write a pl/sql script to create a trigger that prints"the department name is changed from IT to sales" whenever the department is changed from IT to salesconsider the database below and answer the query. pk refers to primary key and FK refers to foreign key. Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK)) Departments(Department_id(PK), dept_name, manager_id(FK), location_id) Locations(Location_id(PK), street_address, postal_code, city, state_province, country_id) Jobs(Job_id(PK), job_title, min_salary, max_salary) wirte a function (with one argument : department name) that calculates and returns the total number of employees who are not working in IT department and earning more than $5000. write an appropriate call also. COMP 214 pl/sqlQ3: How can you tell the difference between Attribute Value Skew and Partition Skew? Please provide an example of your response.
- Answer the following: Consider a scenario where we are required to update a table that already contains data, e.g., adding a new attribute Is it better to regenerate the table or just update it? Consider the situation when the table has not 20, but 20 million records. What are the pros and cons of updating the table vs. re-creating it from scratch? What could you do if you were not allowed to re-create a table from scratch, i.e., you can only modify it? CREATE TABLE HOTEL(hotelNo INT NOT NULL,hotelName VARCHAR(50),City VARCHAR(50),primary key (hotelNo));CREATE TABLE ROOM(roomNo INT NOT NULL,H_hotelNo INT NOT NULL,roomType CHAR(10),price decimal(5,2),primary key (roomNo, H_hotelNo),foreign key (H_hotelNo) REFERENCES HOTEL(hotelNo),CHECK (price >= 50.00),CHECK (price <= 500.00),CHECK (roomType = 'Single' OR roomType = 'Double' OR roomType = 'Standard'),CHECK (RoomNo >= 1),CHECK (RoomNo <= 9999));CREATE TABLE BOOKING(H_hotelNo INT NOT NULL,G_guestNo INT NOT NULL,dateFrom DATE…Closely examine the following tables and use it to answer the questions that follow: department course student_type student_category Student registration registration_type Suppose that the following are true: - all id column are primary keys in whichever table they are - the dept_id in course table is foreign key that is referencing the id column in the department table - the foreign keys stud_type_id, stud_cat_id in the student table are referencing the id columns in the student_type and student_category tables respectively. - the coursecode and stud_id columns in the registration table are foreign keys in the course and student tables respectively. 1. Design an Entity Relationship Diagram for the system above. 2. Write query that would return the names and contacts of all Local students. 3. Write a query that would return names, contact and locations of all departments that has a location text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”] 4. What would…plz quickly ?????????????? /*Inserting into patient table*/ INSERT INTO patientVALUES ('1234','Kim Minji','06-05-1994','0557375017'); INSERT INTO patientVALUES ('1334','Han Sohee','06-07-1996','0567374017'); INSERT INTO patientVALUES ('1434','Jeon soyeon','07-10-1998','0537372017'); INSERT INTO patientVALUES ('1646','Lee Taemin','18-06-1993','0501346257'); INSERT INTO patientVALUES ('1645','Yu jimin','11-09-2000','0501846257'); select*from patient; /*Inserting into Doctor table*/INSERT INTO DOCTOR VALUES(2000432, 'khaled' , '05-12-1994' , 0556677880,'Dermatologists'); INSERT INTO DOCTOR VALUES(2000509, 'Ali' , '09-01-2000' , 0559918100, 'Dentistry'); INSERT INTO DOCTOR VALUES(2000389, 'Lewis' ,'21-01-1996' , 0559910000,'Family Physicians'); INSERT INTO DOCTOR VALUES(2000504, 'Saleh' ,'16-06-1998' , 055611500,'Family Physicians'); INSERT INTO DOCTOR VALUES(2000235, 'sara' ,'22-06-1998', 0557745500,'Orthopedics'); select *from doctor; /*Inserting into appointment table*/ INSERT INTO…
- Write a mysql query to get the answer to the following question using the given tables and data. Which player(s) had the longest reception in the 4th quarter. What team where they on and what year was it? (breaking non-trivial ties is 5 of the 15 points, (i.e 10 points with LIMIT, 15 points without LIMIT) cfb_player has columns player_id, team_id, last_name, first_name cfb_team with columns team_id, year, name, conference_id cfb_reception with columns game_id, team_id, player_id, yards cfb_game with columns game_id, game_date, visit_team_id, home_team_idYou are given the schema of a table with its columns inside the bracket as follows: STUDENT(Name, Student_id, Major, Marks, Email) (The Primary Key is underlined) Write an SQL query for the following tasks: (Hint: the queries are nested) 1. Write an SQL query to retrieve the name, student id and the maximum marks of students of each major where that maximum marks is greater than all students with CS major. 2. Write an SQL query to retrieve the name, student id and the maximum marks of students with ECE major where that maximum marks is greater than all students with CS major.Closely examine the following tables and use it to answer the questions that follow:departmentstudent_type student_categorycourseStudentregistration registration_typeSuppose that the following are true:- all id column are primary keys in whichever table they are- the dept_id in course table is foreign key that is referencing the id column in the department table- the foreign keys stud_type_id, stud_cat_id in the student table are referencing the id columnsin the student_type and student_category tables respectively.- the coursecode and stud_id columns in the registration table are foreign keys in the courseand student tables respectively.1. Design an Entity Relationship Diagram for the system above.2. Write query that would return the names and contacts of all Local students.3. Write a query that would return names, contact and locations of all departments that has alocation text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”]4. What would be the result returned…