To display 'Question 2'in the command :window,the correct command is disp(Question 2) O disp(num2str(Question 2)) O disp('Question 2') O Sort rows is used to perform which data analysis function? Sort in ascending order O Sort rows in descending order O Sort rows in ascending order O SA descending order
Q: 1. Finding the biggest of two numbers. 2. Calculate the salary (daily) of a worker. 3. Convert…
A: In this question we have to write the pseudocode for the problems provided in the list of…
Q: the last address of the network .(192.168.168.64) which has (30) host 192.168.168.94 O…
A: Given network Ip address is, 192.168.168.64 Number of required hosts= 30 To get 30 hosts, we require…
Q: What is type casting? Explain implicit and explicit type conversion with example.
A: Typecasting is converting one data type into another one. There are two types of type casting/ type…
Q: Please explain why user-defined functions are preferable than pre-defined ones in the context of…
A: Pre-defined functions: The pre-defined function is built into the software and does not need to be…
Q: identify, characterize, and discuss non-technical cyberattacks
A: Non-technical cybersecurity assaults are defined and explained: Non-technical attacks do not need a…
Q: Question 9 What would be the content of the ArrayList list after the given lines of code ArrayList…
A: Given program contains an ArrayList. This array contains some elements which are added using the…
Q: Do you have to worry about privacy while shopping on a social network like Facebook, which already…
A: Introduction: However, as the use of social media has increased, so has the possibility of data…
Q: A fingerprint reader, rather than a username and password, is the new way that your organization…
A: A fingerprint reader is a device that identifies a person's fingerprint and can be used as an…
Q: In the software system design process, there are a plethora of variables that need be considered.
A: The software system design process is defined as the process of designing the elements of a system…
Q: What are the benefits of evaluating and testing on a model rather than a real object or situation?
A: Model Evaluation is a necessary piece of the model advancement process. It assists with finding the…
Q: There can be multiple decision variables for while loop. True O O
A: There can be multiple decision variables for while loop. True.
Q: the number of subnets specified by the .network address (192.168.155.0/26)
A: The number of all possible sub networks available for 192.168.155.0/26 are 4
Q: Explain if...else... with example and draw flowchart.
A: if-else:- if else statement is that in which if the condition which is written in the if is true it…
Q: Describe the behaviours that are governed by the rules that apply to functions that have default…
A: Introduction: In the event that an argument value is not provided while calling the function, the…
Q: rentiate between the physical and logical designs
A: Lets see the solution.
Q: daily dema pain P the maximum daily demand for interior paint is 2 tons. Reddy M optimum (best)…
A: Given that, Raw material- exterior- 6,1 Raw materia- Interior- 4,2 Profit- 5,4 Availability- 24,6…
Q: A Windows Service is different from a conventional program in how it is set up.
A: Standard application: A standard/regular application on a Windows system is one that the user…
Q: etrics of the software development process should be described in more detail if feasible Explain…
A: oftware development metrics are quantitative measurements that help managers understand software…
Q: In this type of digital circuit, its output is dependent of the new input, previous state and clock…
A: A digital logic circuit is defined as a circuit in which the voltage is a circuit with a finite…
Q: IP address routing prefix of .(255.255.255.192) can be written as /25 O /26 O /27 O /28 O
A: IP address routing prefix of (255.255.255.192) can be written as /26.(255.255.255.192)
Q: I. What does certification for my program entail? For many fields and jobs, being certified in the…
A: There are many hospital prefers the Certified Medical Assistants or CMA. The certification needed to…
Q: Write a java program that will validate user given password with following conditions a. length of…
A: As per the question statement, We need to write JAVA program.
Q: When do physical security and information technology (IT) security need to collaborate in order to…
A: Physical security is the assurance of faculty, equipment, programming, organizations and information…
Q: Understanding the heap's purpose is critical when working with dynamic data. For a programmer, what…
A: Introduction: By allocating and deallocating memory from a location known as the heap, dynamic data…
Q: Investigate different software testing issues, difficulties, as well as recommended procedures.
A: Overview: This question discusses software testing principles, concerns, and methods. Testing…
Q: There are a lot of benefits that come with using pure functions.
A: Introduction: The following are some of the benefits of pure functions:
Q: What stages are involved in modelling completely distributed systems?
A: Introduction:Here we need to give the steps involve in the fully distributed system modeling.
Q: Which of the following statements shows the result of executing the following line in the editor…
A: abs() function returns the absolute value of a number.
Q: ficance of firewalls in ensuring the safety of computer networks and the internet. Make sure you use…
A: Introduction: Below describe the distinguish the significance of firewalls in ensuring the safety of…
Q: een allocated to it at the same time.With the use of a single memory management strategy and a few…
A: Answer: The memory management capability assists with allocating the main memory space to their…
Q: Please explain why user-defined functions are preferable than pre-defined ones in the context of…
A: Solution :- Please explain why user-defined functions are preferable than pre-defined ones in the…
Q: The commands (hold on ) and (sub plot) are the same in terms of showing more than one plot at the…
A: Answer for both mcqs given below with explanation
Q: How do you display letters in uppercase in MySQL, Oracle, and SQL Server? How do you display letters…
A: 1) In MySQL, Oracle, and SQL server uses the UPPER( ) function to converts all character in the…
Q: What exactly do the phrases "static media" and "dynamic media" mean? The following are instances of…
A: Answer:
Q: Privacy is a broad term, but what do you mean by that? Does it truly make a difference?? And what…
A: Solution:- The right to privacy is the right to be free of distraction or interruption. You have a…
Q: Please explain why user-defined functions are preferable than pre-defined ones in the context of…
A: User-defined functions : User-defined functions are a kind of function that may be used inside the…
Q: Is it even feasible to describe the significance of the construction of functions when it comes to…
A: Function: Functions are one of the fundamental elements of programming; they are made up of a…
Q: ware "in the network" might be difficult to d
A: Introduction: Administrators can use an antivirus solution to detect when a device has been infected…
Q: In light of Facebook's privacy concerns, you have chosen to quit using the social networking…
A: Facebook has had a number of security problems. These stem mostly from the company's business…
Q: we can execute a saved function by writing the function name in the : figure window O work space O…
A: Figure window is used create plot in the separate window. That means the figure window is used to…
Q: Imagine that you have been given the responsibility of serving as the JAD session's facilitator. If…
A: Introduction: Session leader for the Joint Anti-Doping Agency As a JAD session leader, you're solely…
Q: What are two real-world instances of utilizing menus in an application? What are the advantages of…
A: Two real-world instances of utilizing menus in an application are : Twitter and Google sheets.…
Q: Are there any other factors that developers should keep in mind?
A: Software developer: Developers is an expert who develops, designs and builds software. Software…
Q: We'll use an example to demonstrate how to deal with multiple interruptions and how to prioritise…
A: Introduction: A mechanism known as a priority interrupt is one that governs the order in which the…
Q: It is important that the guidelines that govern functions that are equipped with default parameters…
A: Given: When the caller function gives values for default parameters, they are rewritten. For…
Q: * The role of MTA forwards the emails into mailboxes O transfer the Email across the network to the…
A: A message transfer agent ( in short MTA), often known as a mail transfer agent/ mail relay is a…
Q: The following matrix illustrates the estimated times (days) of an assignment problem. By using…
A: In polynomial time, a combinatorial optimization technique used to solve the assignment problem is…
Q: A- Read the text and complete it with a verb from the parentheses in the past tense: (spend, need,…
A: BELOW:
Q: Is there a particular justification for why a computer need both RAM and ROM to function properly?
A: The computer is required because: Due to their precision, speed, and versatility, computers have…
Q: Privacy is a broad term, but what do you mean by that? Does it truly make a difference?? And what…
A: Internet access should be restricted will not be very helpful as the attackers and other crackers…
Step by step
Solved in 2 steps
- Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted asHHyperion Dev STU_ STU_SNAME STU_FNAME STU_INITIAL STU_START NUM DATE 01 02 03 04 05 06 07 ● ● Snow Stark Lannister Lannister Greyjoy Tyrell Baratheon Jon Arya Jamie Cercei Theon Margaery Tommen E C с J I Y R 05-Apr-14 12-Jul-17 05-Sep-12 05-Sep-12 9-Dec-15 12-Jul-17 Review work 13-Jun-19 COURSE CODE 201 305 101 Completed the task(s)? Ask an expert to review your work! 101 402 305 201 PROJ_ NUM 6 Write the SQL code that will delete the Student table entirely. 11 2 2 14 Write the SQL code to change the course code to 304 for the person whose student number is 07. 10 Write the SQL code to delete the row of the person named Jamie Lannister, who started on 5 September 2012, whose course code is 101 and project number is 2. Use logical operators to include all of the information given in this problem. 5 Write the SQL code that will change the PROJ_NUM to 14 for all those students who started before 1 January 2016 and whose course code is at least 201. Write the SQL code that will delete all…Online shopping system & online book store: Rebuild View/Edit cart and checkout pages using PL/SQL like the following: Create a function/procedure to update the quantity of the product in the cart if the new quantity is available in the store. Create a trigger that deletes the product from the cart after updating the quantity to 0. Don't forget to return the old quantity to the store. Create a trigger that empties the customer cart after the customer clicks on the checkout.
- Create a table in your own database using the following statement. CREATE TABLE DateRange (DateID INT IDENTITY, DateValue DATE, DayOfWeek SMALLINT, Week SMALLINT, Month SMALLINT, Quarter SMALLINT, Year SMALLINT ); Write a stored procedure that accepts two parameters: A starting date The number of the consecutive dates beginning with the starting date The stored procedure then inserts data into all columns of the DateRange table according to the two provided parameters.#Fill in comments to spec. import sqlite3from contextlib import closing from Objects import Player, Lineup conn = None def connect():global connif not conn:DB_FILE = "player_db.sqlite"conn = sqlite3.connect(DB_FILE)conn.row_factory = sqlite3.Row def close():if conn:conn.close() def get_players():return None #remove this line when code is added.# SQL statement to select all 7 fields for all players # Use a with statement to execute the query # Create a lineup object# use a loop to populate the lineup object with player objects# return the lineup object def get_player(playerID):return None #remove this line when code is added.# SQL statement to select all 7 fields for a player # Use a with statement to execute the query & return a player object if the player exists def add_player(player):return None #remove this line when code is added.# SQL statement to insert 6 fields for a player added to the table # Use a with statement to execute the query def delete_player(player):return None…Design and Implement “To do list” app same as shown below, save data in local database (SQLite) and database name should be your full name.
- with it, paste your code in a text file named Student.txt and save it in your task folder. Write the SQL code to create a table called Student. The table structure is summarised in the table below (Note that STU_NUM is the primary key): STU_NUM Attribute Name STU_SNAME STU_FNAME STU_INITIAL STU_STARTDATE COURSE_CODE PROJ_NUM STU STU_S STU_F STU_INITIAL NUM NAME NAME 01 02 Snow John E CHAR(6) After you have created the table in question 1, write the SQL code to enter the first two rows of the table as below: Stark Arya с VARCHAR(15) VARCHAR(15) CHAR(1) DATE CHAR(3) INT(2) Data Type STU_STARTDATE COURSE_ PROJ_ CODE NUM 05-Apr-14 12-Jul-17 201 305 6 11 Assuming all the data in the Student table has been entered as shown below, write the SQL code that will list all attributes for a COURSE_CODE of 305.1.Cruise(cid, name, number_of_days, price, number_of_stops) Port(pid, city, country, number_of_stars, сaрacity) Stops(cid, pid, stopno, stopduration) Assume that the number_of_stops attribute of the Cruise table contains the total number of stops for each cruise. Write a trigger that will be fired whenever the Stops table is modified to increase or decrease the number_of_stops value accordingly. 11:04Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.
- 2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…For all questions, you can assume that the following $() function is available:const $ = selector => document.querySelector(selector); Which of the following statements is NOT true? To display changes made to the DOM, you must refresh the web page. The DOM for a web page is built as the page is loaded by the web browser. The DOM is a hierarchical collection of nodes in the web browser’s memory. You can modify the DOM using the properties and methods that are defined by the DOM Core specification.Create Trigger for When a student marks are being inserted, if the marks that are inserted are greater than 50, allow the insertion, but update marks to 50. Marks(Id , Marks) -> Table Fill in the blanks: ___ triggerName Before ___ ON Marks REFERENCING _____ AS nrow FOR EACH ROW WHEN (nrow.marks>50) _____ nrow SET nrow.marks = 50;