Notes, summaries, assignments, exams, and problems for Computers

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" »

{

}

{

{

{

} } }

{

{

{

Data Structure (Syllabus)

Semester & Branch: 3rd sem CSE/IT Teachers Assessment : 10 Marks
Theory: 4 Periods per Week Class Test : 20 Marks
Total Periods: 60 Periods per Semester End Semester Exam : 70 Marks
Examination: 3 Hours TOTAL MARKS : 100 Marks

Objective :

The effectiveness of implementation of any application in computer mainly depends on the that how effectively its information can be stored in the computer. For this purpose various -structures are used. This paper will expose the students to various fundamentals structures arrays, stacks, queues, trees etc. It will also expose the students to some fundamental, I/0 manipulation techniques like sorting, searching etc

1.0 INTRODUCTION: 04

• 1.1 Explain Data, Information, data types
• 1.2 Define

What is a Process?

A process is essentially a program in execution.

Lightweight Processes in Linux

Lightweight Processes (LWPs) in Linux are processes that offer better support for multithreaded applications.

Multithreaded Applications in Linux

A multithreaded application is designed to perform multiple tasks concurrently within a single process. In Linux, a straightforward way to implement multithreaded applications is to associate a lightweight process with each thread.

This approach allows threads to access the same set of application data structures by simply sharing the same memory address space, the same set of open files, and so on. Simultaneously, each thread can be scheduled independently by the kernel, meaning one thread may sleep while... Continue reading "Linux Process Management: Deep Dive into Kernel Internals" »

C# Project and Developer Management Controller

This document outlines the core logic for a C# controller designed to manage software projects and their associated developers. It demonstrates fundamental operations such as adding, finding, and listing projects and developers, ensuring data integrity by preventing duplicates.

GestorController Class Definition

The GestorController class serves as the central hub for managing project and developer data. It resides within the GestionProyectos.Controllers namespace and utilizes models from GestionProyectos.Models.

using GestionProyectos.Models; //Controllers-GestionP

namespace GestionProyectos.Controllers
{
    public class GestorController
    {
        public static List Projects { get; set; };

IPv6 Packet Format: Base Header

Each IPv6 packet consists of a mandatory base header followed by the payload. The payload is made up of two parts: optional extension headers and the upper-layer data. The base header is 40 bytes long, whereas the extension headers and the data from the upper layer can contain up to 65,535 bytes of information.

The base header has 8 fields:

• Version: A 4-bit field that defines the version of IP, such as IPv4 or IPv6. For IPv6, the value of this field is 6.
• Priority: A 4-bit field that defines the priority of the packet, which is important in connection with traffic congestion.
• Flow Label: A 24-bit field designed for providing special handling for a particular flow of data.
• Payload Length: A 2-byte field used to define

3/10/16 Notes

Chapter 7/8

Top-Down Design

Takes the most basic aspect of a program and breaks it down into subprograms.

Control Structure

An expression that determines the order in which a program executes.

In Python, this is an if statement.

It can also be a looping statement.

Boolean Expression

A "True or False" program statement.

Composite Data Types

Example:

• numbers[0] = 1066
• numbers[1] = 1492
• numbers[2] = 999
• numbers[3] = 553
• numbers[4] = 1892

Example Code:

for i in range(3):
    print(numbers[i])

Arrays

When data is being read into an array, a counter is updated for each operation (e.g., for i in range(5)).

Sequential Search of an Unsorted Array

A sequential search examines each item in turn and compares it to the target item. If it matches, the item is found.... Continue reading "Top-Down Design and Control Structures in Python" »

Categories of Data Models

• Entity: Represents a real-world object or concept.
• Attribute:
  • Represents some property of interest.
  • Further describes an entity.
• Relationship: Represents an association among two or more entities.
• Entity-Relationship model
• Relational data model: Used most frequently in traditional commercial DBMSs.
• Object data model:
  • New family of higher-level implementation data models.
  • Closer to conceptual data models.
• Physical data models: Describe how data is stored as files in the computer.
• Access path: Structure that makes the search for particular database records efficient.
• Index:
  • Example of an access path.
  • Allows direct access to data using an index term or a keyword.

Schemas, Instances, and Database State

• Database schema: Description of a