This post contains a quick and dirty tutorial on how to use SQL to lookup, insert, update, and delete data. The first video in the series is optional, it shows how to import and setup the data.
The files used in the videos can be found below, you can look at the videos in any order, they aren’t prerequisites for each other.
Download Files here: https://drive.google.com/drive/folders/1HEVam1Vq1Bn1TJI6zzcoH_POf_Z4nZ-Q?usp=share_link
© 2023 Vedesh Kungebeharry. All rights reserved.
© 2023 Vedesh Kungebeharry. All rights reserved.
Marks were assigned on 11th Jan 2023 for groups 1 and 2 and 22nd Jan 2023 for groups 3,4,5.
© 2023 Vedesh Kungebeharry. All rights reserved.
See video:
https://youtu.be/aImIl-d5F9A
© 2021 Vedesh Kungebeharry. All rights reserved.
The guiding rule of thumb for generating exam questions is to use Bloom taxonomy broken into
In Bloom’s Taxonomy, the first two levels, Remembering and Understanding, are generally considered to correspond to knowledge and comprehension, while the remaining four levels, Applying, Analyzing, Evaluating, and Creating, are considered to correspond to the use of knowledge.
Remembering is the lowest level of the taxonomy, and it involves simply recalling information, such as facts or definitions, without necessarily understanding their meaning or significance. Understanding, which is the second level, involves grasping the meaning of the information and being able to explain it in one’s own words.
Applying, the third level, involves using the information in a new situation or context, to solve problems or complete tasks. This level requires students to apply their understanding of the information to a new situation, and to demonstrate that they can use it in a practical way.
Analyzing, the fourth level, involves breaking down complex information into smaller parts, examining the relationships between them, and identifying the underlying principles or causes. This level requires students to apply critical thinking skills to analyze and understand the information.
Evaluating, the fifth level, involves making judgments about the value or quality of information, based on criteria or standards. This level requires students to assess and criticize the information, and to make choices based on evidence.
Creating, the highest level of the taxonomy, involves generating new ideas, products, or solutions, by combining existing knowledge in novel ways. This level requires students to use higher-order thinking skills to synthesize and transform information, and to create something new.
https://youtu.be/Kr8tyBU4SEg
© 2023 Vedesh Kungebeharry. All rights reserved.
See video below:
https://youtu.be/fiv75dM_VXE
© 2023 Vedesh Kungebeharry. All rights reserved.
Client server
The url https://www.buythings.com would be preferred since this http protocol includes SSL (Secure sockets layer) or TLS (Transport layer security) which encrypts all HTTP information such that only the sender and the receiver can decipher the information. This is more secure, especially in the case where the http information can be intercepted by malicious entities on the network, they won’t be able to read the sensitive payment information that can be used defraud the online shopper.
A process is a running program.
The PCB stores metadata necessary for managing the process, e.g. process id, process state, memory allocation addresses, scheduling info (priority, time slice), pointers to it’s resources (files, other processes).
Paging is were each process in an OS is allocated memory in units called pages for easier coordination and management by the operating system. The pages can be stored physically in memory , or stored on the hard disk (in the case that the process is not running at that time). If a process is stored on the disk and needs to be run, a page fault is generated so that the process is swapped back into the physical memory for processing.
Thrashing occurs when memory resources become limited by the amount of running processes. The need for physical memory can be exceeded, thus multiple processes that are in waiting state are stored as pages on disk. For continued running of the system, processes are constantly swapped in and out of physical memory, an execution which spends a lot of time on the cpu when compared to running the processes themselves.
Too little physical memory is available for a system that needs to run a lot of processes.
© 2023 Vedesh Kungebeharry. All rights reserved.
SD Cards (Secure Digital Cards) are a popular form of portable flash memory storage because of it’s small size , speed and durability. It’s used widely in digital video/photography to store media, and as expansion storage for other smart devices including phones , tablets etc.
It was created by a group of companies and has now become a standard for portable data storage.
SD Card readers are devices that allow for SD Cards to be read by the computer system and can be internal (built into) or externally connected via USB ports.
Below: An external SD Card Reader with an inserted Micro SD Card
Below: An internal SD Card Reader built into the computer’s system unit.
Because of it’s widespread use, it has become desirable to include SD card readers in newer computer systems to facilitate easier data transfer from device to device.
A common task that a user would face would be copying their media from their digital camera to their pc. In the past, this meant that the user would have to install the camera’s software and drivers on the pc, then connect a cable from the camera to the pc to access the media.
This process changes when a sd card reader is built in or connected to a computer, the user simply removes the sd card from the digital camera and inserts it into the sd card reader, where the media is immediately accessible as using any other portable secondary storage device.
Original: 毛抜きDerivative work: Tkgd2007, CC BY-SA 3.0, via Wikimedia Commons
Dineshkumar Nallaveerappan, CC BY-SA 4.0, via Wikimedia Commons
liewcf, CC BY-SA 2.0, via Wikimedia Commons
© 2023 Vedesh Kungebeharry. All rights reserved.
Screen sizes are measured along the diagonal of the screen and is usually quoted in inches. For example, a typical computer monitor or laptop screen may be 15” in size.
Screen resolution refers to the quality and level of detail that can be displayed on the screen. The screen is made up of a matrix of individual dots that can be coloured differently. Each dot is know as a picture element or pixel for short.
Example of pixels. Shows a zoomed section of an image to demonstrate how it is made up of pixels.
Maximizing the number of dots in a unit area of the screen will result in a sharper image with more detail , or as we say, a higher resolution image.
A monitor’s screen resolution is denoted as horizontal pixels x vertical pixels. e.g 1920 * 1080
It’s possible for a monitor with large screen to have a small resolution, to the average person, the screen may display images which are blocky, where the pixels are discernable and the image is not smooth.
It’s also possible to have a very small screen have a high resolution, as in the case of a high end smartphone.
Size and resolution consideration depends on where the screen needed, for example, having a large screen with a low resolution at a train station or airport is feasible since a lot of people can easily view the screen at once , however , we do not require the need to display detailed images, just formatted text or cursive fonts.
On the other side of the spectrum, a graphic artist travelling on a long train ride may opt to get his/her/them/they/us work done on a portable tablet computer which has a small but very high resolution stylus touch screen to allow for fine and detailed designs to be viewed while being created.
florisla, CC BY-SA 2.0, via Wikimedia Commons
ed g2s • talk, CC BY-SA 3.0, via Wikimedia Commons
MaedaAkihiko, CC BY-SA 4.0, via Wikimedia Commons
TopSystemsLTD, CC BY-SA 4.0, via Wikimedia Commons
© 2023 Vedesh Kungebeharry. All rights reserved.
.
Island Class 
