L only nu
Q: Write an algorithm and draw a flowchart to print the square of all numbers from 1 to 10 .
A: Given : Write an algorithm and draw a flowchart to print the square of all numbers from 1 to 10 . ...
Q: Distinguish between compilers and translators. Describe an algorithm to sum 2 values whose answer ...
A: Lets see the solution.
Q: . Most industries has been successful by providing multimedia services online; services such as onli...
A: Note: As per the guidelines can answer the first question, please re-submit the other questions. On...
Q: In evaluating the arithmetic expression 2 * 3 - (4 + 5), using stacks to evaluate its equivalent pos...
A: Lets see the solution.
Q: java method ****just write the method ******* method heading public class VaccinationQueue { ...
A: public static int prioritizeQueue(ArrayDeque<Integer> q1,ArrayDeque<Integer> q2){ ...
Q: Explain the following terms? Utility Programs. Ring Topology.
A: Explain the following terms? Utility Programs. Ring Topology.
Q: Assume you have been contracted by a university to develop a database system to keep track of studen...
A: a) Main entity types are:- University Course Faculty Student Hostel Room
Q: In booth’s multiplication methods is applied on ___________number. And the default value of accumula...
A: Booth's algorithm - It is an algorithm to multiply signed 2’s complement binary integers in an effic...
Q: Dintinguish between fuctional and cross-functional enterprise applications giving practical examples...
A: Given: Dintinguish between fuctional and cross-functional enterprise applications giving practical e...
Q: Please fast no time Programing
A: Answer is in step 2.
Q: With well-designed diagram, explain software and the 2 major classification ofsoftwareNB: pls avoid ...
A: Answer: Software: It is basically a operating system with some of the programs and routines for a c...
Q: output
A: Output screen shot is in step 2.
Q: i need the answer quickly
A: Given :
Q: Question 39. Which of the following R commands evaluates to TRUE? a) 5 >= 5 I b) TRUE & FALSE I FALS...
A: Given:
Q: Simplify the following expression as much as possible
A: Answer: (A+B)C.C'+(A+A')C = C
Q: Discuss the uses of computer in kohat university.
A: Given: Discuss the uses of computer at Kohat University.
Q: Can you tell me the history of computer technology
A: А соmрlete histоry оf соmрuting wоuld inсlude а multitude оf diverse deviсes suсh аs t...
Q: oding system for graphical images (with different re
A: Q
Q: One of these statements is false in terms of the I/O channels types: a.selector channel transfer da...
A: Selector channel - Handles a number of devices but sends data from only one input or output device a...
Q: Explain the process of electronic data processing in kohat university.
A: Explain the process of electronic data processing in kohat university.
Q: Design a Network Infrastructure for an organization (ef, university, hotel and restaurant, hospital,...
A: Given : Design a Network Infrastructure for an organization (ef, university, hotel and restaurant, ...
Q: Take a sorted array of 15 elements of type int and a value x from user, you need to find the ceiling...
A: Given:- Take a sorted array of 15 elements of type int and a value x from user, you need to find the...
Q: As a Project Manager you come to know that there is a competing project going to be launch in the ma...
A: Whether you manage to design a website, design a car, move a door to a new location, update an infor...
Q: i need explainig of this circuit how to work(design of DHT11 humidity and temperature sensor circuit...
A: Lets see the solution.
Q: Write a C++ program to read two-time objects t1, t2 in the form of years and weeks by encapsulating ...
A: Class is a user-defined data structure. A class consists of data members and member functions. The m...
Q: Add the following BINARY NUMBERS 11110.0111 + 10110.1011 The final answer must be entered in the box...
A: Given:
Q: With the aid of diagram,analyze and evaluate the booting process when a computer is turned on. NB: a...
A:
Q: Discuss the advantages of the centralized database management approach to organizing, accessing and ...
A: Given:- Discuss the advantages of the centralized database management approach to organizing, access...
Q: Q.5.1 Explain how each of the following data anomalies could arise in this sample data: Q.5.1.1 Upda...
A: Answer: Update anomaly If we update any non prime attribute like company name or departname or the ...
Q: Write a JavaScript program to convert degrees centigrade into degrees Fahrenheit, and to write the r...
A: Answer: CODE FOR THE FOLLOWING PROGRAM:- //Ask user to enter temp in centigrade var c...
Q: 1, Calculate Estimated effort for a semi-detached project of 56KlOC if the following cost drivers ar...
A: Given: 1, Calculate Estimated effort for a semi-detached project of 56KlOC if the following cost dri...
Q: What is a (computer} cookie? What ethical and privacyissues relate to cookies?
A: Given: What is a (computer} cookie? What ethical and privacyissues relate to cookies?
Q: Question 2: 2. For a computer that uses 9-bit word size and Signed Magnitude (SM) arithmetic to repr...
A: Given:
Q: 2. Encrypt the following message using RSA cryptosystem. Message : THIS , with n=2633 and e=29.
A: Given: Message :"THIS" n=2633 e=29 Using the RSA cryptosystem the encryption can be done with the...
Q: Discuss the steps a programmer follows to analyze to solve real life problem with coding
A: Step 1 : Get fluent with the syntax and purpose of all methods and keywords. Step 2 : Understand the...
Q: Can relationship exist if cardinality is reduced to zero. Provide reason and Explain with the help o...
A: Relationship: For internal process reasons, a “quantity outstanding” price is related to every detai...
Q: QUESTION 8 How many times is the println statement executed? for (int i 0; i < 10; i++) 0; j <i; j++...
A: Lets see the solution.
Q: Tick (V) the right answer [True or False]. Statement True False 1 If w is a string then wlw* is a pa...
A: 1) w1wr is the condition when we check both the strings and returns 1 which is true for string is pa...
Q: Evaluate with examples how the generations/evolutions of computers have impacted the economies of yo...
A: Given: Evaluate with examples how the generations/evolutions of computers have impacted the economie...
Q: Discuss an IT system which could be used to eliminate impersonation during examination
A: Given: Discuss an IT system which could be used to eliminate impersonation during examination
Q: what is the difference between Map Phase vs. Reduce phase? i need answer in points /tabular form.
A: Lets see the solution.
Q: Create a simple class record program(C program) that will do the following: - Accept a student's...
A: The program is implemented in C programming language with procedural approach. It uses pointers to s...
Q: Car Service MaintenanceCreate a program for car service maintenance. Based on numbers of months / di...
A: Given:- Car Service MaintenanceCreate a program for car service maintenance. Based on numbers of m...
Q: Consider the following function fun: int fun(int n) { int s = 0; while(n > 1) { n= n/2; s+t; } retur...
A: Given :
Q: (Regression) Load the Boston dataset from sklearn. Split the dataset into training and testingparts....
A: Answer: a) Value of alpha without polynomial features, alpha = 0.0001 b) Value of alpha with polynom...
Q: It is commonly referred to as a network of all networks. O a. Internet O b. Telecommunications O c. ...
A: Computer network: A group of computer system or computer nodes that are connected to each other and ...
Q: Write the output of the following circuits.
A: Answer: 1. ABC B' C' B'+C' A(B'+C') Q 0 1 1 1 0 0 0 1 0 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0...
Q: write a java method (*****just the method ***)
A: public static int prioritizeQueue(ArrayDeque<Integer> q1,ArrayDeque<Integer> q2){ ...
Q: int fun() int a, b, c, result; cout>a>>b>>c; cout<<"The result is "; reutrn result;
A: Lets see the solution.
Q: function phone (inputtext) { var phonenum = /^\d{8}$/; if(inputtext.value.match(phonenum)) { return ...
A: The answer is b.8 Given code var phonenum = /^\d{8}$/ indicates phone number should contain 8 digits...
Step by step
Solved in 2 steps
- Given the following relation: Movie (MovieID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: Read a movie id provided by user at run time and store it in a variable. Fetch the Genre and title of the movie having the entered id and store them inside two variables Display the fetched movie Genre and title.Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: Read a Book id provided by user at run time and store it in a variable. Fetch the Author and title of the book having the entered id and store them inside two variables Display the fetched book author and title.Instructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a…
- Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. 1. Write an anonymous block to retrieve the doctor’s ID and name which in charge of certain patient. Allow the user to enter the patient’s ID. 2. Write an anonymous PL/SQL block that will insert a new doctor into the DOCTOR table. Verify that insert has been done successfully by issuing a select * from doctor. 3. Write an anonymous PL/SQL block that will update the salary of all doctors in the Pediatrics area by 1000 (Note: Current salary + 1000). Verify that the salary has been updated by issuing a select * from doctor where area = ‘Pediatrics’. You may have to run the select statement twice to check the data before and after the update. 4. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice area. Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’.…Write the pl/sql block of code to call the above created package by passing the employee number in the above created function, run it and take the screenshot of the result and paste it in the output section give below. (SQL)Imagine a student table with following columns: Student(Stuid, Name , Age, Major)Write a PL/SQL program to create a cursor and to display all the records from student table.
- Write the code steps to perform the following within SQL Create a database bearing the name of the department in which you study. This database includes three tables. The first is for teachers. The following columns ( id, address, name, age ) contain a specific column value that cannot be empty in this table The second table is for employees, holds the following columns (, Salary id, address, name, age) the value of a specified column as the primary key of this table. The third and last table is for students and includes the following columns (id, address, name, age) and a specific column value that cannot be empty Fill in the tables with data and do the following:1. Arrange employees in descending order . 2. Find the average ages of the people in all the tables.3. Merging the first table for teachers with the second table for employees. If the number of elements of the combined table is greater than 15 or less than 15, write a message explaining thatInstructor(Instructor_Id, Instructor_Name, specialization, Address,#Department_Id)Department(Department_Id, Department_Name)Course(Course_code, Course_Title,Credit_hours,Contact_hours,#Department_Id)Teaching(#Instructor_Id, #Course_code)a) Express in SQL the following queries:i. Change to 6 the number of contact hours of the course which has thecode “ITDR2104”.ii. Add a new column named instructorLoad of type Number(2) to thetable instructor.iii. List the details of all the courses having a code that starts with“ITDR”. The output should be sorted in descending order by credithours.iv. Find the number of courses taught by the instructor whose name is“Ahmed”.v. List the names of all departments along with the number of coursesoffered by each department.vi. Find the titles of courses, which are taught by the instructor who isnamed “Ahmed”.b) Create a view named instructor_of_DBCourse to contain the details(Instructor_Name, specialization, Address, Department_Id) ofinstructors who teach…Write a PL/SQL block that uses a searched case statement to classify students based on their scores in a certain test according to the following table. Score Action 90 80-89 A certificate is given 70-79 A training course is recommended <70 A scholarship is given The course should be repeatcd NB: Write the searched CASE structure only. Use the editor to format your answer
- Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) Assignment (projectNo, studNo, startDate, dueDate, hoursSpent) QUESTION 1. Write a PL/SQL FUNCTION that calculates the cost each student has to pay for all courses taken. In the photo is example the cost detail for each course. 2. Write a PL/SQL Procedure to call the function you created in question 1 . Allow the user to enter the student ID (studno). SECOND PHOTO IS THE EXAMPLE OF EXPECTED OUTPUTPart 2: PL/SQL By using PL/SQL create the following: 1- A procedure Proc_Insert(arg2,arg3..argn): When the procedure is executed, the value of the passed arguments will be inserted into a table of your database.Note(you have to use one of the created Sequences to generate a value to be inserted into a field of your table). 2- A Procedure Update_value(arg1,arg2): The procedure searches about arg1 value in a specific column of your table and changes the value of the searched item to be equals arg2. 3- A procedure called del_Record_from_Table(arg1) that deletes a specific row from one of the tables you created. 4- A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. 5- A row type trigger that's fires to accept the deleted rows from a table on your database and store them into another table. -You must create a new table to accept the deleted rows. - The new table must contain two additional columns, the first…Database course: Write SQL queries to do the following A. List names of IT students. B. List titles of courses of type E. C. Display the results of student with ID 201006 D. List student names and the courses they took. E. List total credits that student with ID 201002.