Tarea 1: Registrar Kilometraje por Práctica Insertada

Requisito: Crear un TRIGGER donde, cada vez que se inserta una práctica a un alumno, se deben sumar 50 KMS al vehículo que tiene asignado el alumno.

Definición del Trigger PRAC (Inserción de Práctica)

CREATE TRIGGER PRAC
ON PRACTICA
FOR INSERT
AS
    DECLARE @CODMON INT;
    DECLARE @CODAL INT;

    -- 1. Obtener el ID del Monitor asignado al Alumno de la práctica insertada
    SELECT @CODAL = A.CodMon#
    FROM ALUMNO A
    INNER JOIN INSERTED I ON A.CodAl# = I.CodAl#;

    -- Nota: La siguiente selección es redundante o lógicamente incorrecta en este contexto:
    -- SELECT @CODMON = M.CodMon#
    -- FROM MONITOR M
    -- INNER JOIN ALUMNO A ON M.CodMon# = A.CodAl#
    -- WHERE M.

Expert systems

have four major components. Which of the following is not one of the four?

• Interference motor

Major categories of E-commerce

include all of the following except which one?

• Business to department (B2D)

Computing environment

that is always present and is capable perceive the surroundings and offer recommendations based on individual need and requirement is known as:

• Contextual computing

AI application

includes Bots, Virtual agents, and Intelligent virtual agents. Which of the following best describes this AI technology?

• Intelligent agents

Application used in all the functions of a business

which supports decision making throughout the organization is known as___

• Enterprise system

Four phases of the decision-making process

in a typical organization... Continue reading "Key Concepts in Information Systems and Technology" »

MIPS Arithmetic and Addressing Solutions

This document provides detailed solutions for problems related to MIPS arithmetic hardware (non-optimized and optimized multiplication) and MIPS instruction addressing (beq, bne, and j instructions).

Multiplication Hardware Constants

• UNSIGNED = 0
• SIGNED = 1

Non-Optimized Multiplication Hardware

Unsigned Multiplication: 10111 × 01011

Use the non-optimized multiplication hardware to perform unsigned multiplication 10111 × 01011. Show the bit value of the multiplicand, the multiplier, and the product after Step 4, separated by commas.

Answer: 0101110000, 00000, 0011111101

Signed Multiplication: 1100111 × 0011011

Use the non-optimized multiplication hardware to perform signed multiplication 1100111 × 0011011.... Continue reading "MIPS Hardware Multiplication and Branch Addressing Solutions" »

COLLABORATIVE SOLUTIONS FOR PRACTICE PROBLEMS

CSE 12

God help us all

ALL MIGHTY CS LORDS GIVE US MERCY

• Use the google comment system to ask questions or leave comments on any answer

• How to use comments: https://support.Google.Com/docs/answer/65129?Hl=en

• When you write an answer, add the question along with the answer

• Add an explanation for your answer

• Always doubt everyone else’s answers until you confirm for yourself they’re correct

____________________________________________________________________________

Complexity Problems

1. Consider a small array a and large array b. Accessing the first element of a takes more/less/the same amount of time as accessing the first element of b.

A. The same amount of time

B. Less time  

C. More time

Should be the same... Continue reading "Collaborative Study Guide: CSE 12 Complexity, Generics, Data Structures & Algorithms" »

Types of HTML Headings

HTML headings are classified into six levels, ranging from <h1> to <h6>, with <h1> representing the most important heading and <h6> the least important.

Usage of HTML Headings

Headings play a crucial role in structuring your web content and enhancing its readability. They help:

• Organize content: Headings divide your content into logical sections, making it easier for users to navigate and understand.
• Establish hierarchy: The different heading levels create a visual hierarchy, indicating the relative importance of each section.
• Improve accessibility: Headings provide context and structure for screen readers, assisting users with disabilities.

SEO Optimization of HTML Headings

Headings are significant for... Continue reading "Comprehensive Guide to HTML Headings: Types, Usage, and SEO Optimization" »

Forum Database Schema: Creation Scripts

Database Creation

CREATE DATABASE ForumDeDiscussoes;

USE ForumDeDiscussoes;

Usuario Table

CREATE TABLE Usuario (
  idUsuario INT AUTO_INCREMENT,
  nome VARCHAR(70),
  email VARCHAR(45),
  PRIMARY KEY (idUsuario)
);

Forum Table

CREATE TABLE Forum (
  idForum INT AUTO_INCREMENT,
  nome VARCHAR(45),
  PRIMARY KEY (idForum)
);

Topico Table

CREATE TABLE Topico (
  idTopico INT AUTO_INCREMENT,
  nome VARCHAR(45),
  idForum INT,
  PRIMARY KEY (idTopico),
  CONSTRAINT fkForum FOREIGN KEY (idForum) REFERENCES Forum (idForum)
);

Comentario Table

CREATE TABLE Comentario (
  idComentario INT AUTO_INCREMENT,
  Descricao VARCHAR(255),
  idTopico INT,
  PRIMARY KEY (idComentario),
  CONSTRAINT fkTopico FOREIGN KEY (idTopico)

System Bus (Data, Address, and Control Bus)

This network of wires or electronic pathways is called the 'Bus'. A system bus is a single computer bus that connects the major components of a computer system.

It combines the functions of:

• Data Bus: Carries information.
• Address Bus: Determines where information should be sent.
• Control Bus: Determines the operation to be performed.

This technique was developed to reduce costs and improve modularity.

Figure: System Bus

Address Bus

The address bus is a group of wires or lines used to transfer the addresses of memory or I/O devices.

• It is unidirectional.
• The width of the address bus determines the maximum addressing capacity, representing the largest address within memory that the bus can handle.
• Addresses are

A programming language is an artificial language designed to express computations that can be performed by a machine, particularly a computer. Programming languages can be used to create programs that control the behavior of a machine, to express algorithms precisely. Thousands of different programming languages have been created, mainly in the computer field, with many more being created every year. Most programming languages describe computation in an imperative style, i.e., as a sequence of commands.

Requirements and Objectives

A computer programming language is a language used to write computer programs, which involve a computer performing some kind of computation or algorithm and possibly control external devices such as printers, disk drives,... Continue reading "Characteristics and Requirements of Programming Languages" »

{

}

{

{

{

} } }

{

{

{