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

Database Modeling and Relationships

• Multi-valued: Derived
• Cardinality: 1(0,3), M(1,1)
• Optionality: ()
• Weak Entities: [[]]
• Formula: TS = PS - DC + OC

Data Integrity Constraints

• Entity Integrity: Different Primary Key (PK) values.
• Cascading Referential Integrity: Foreign Keys (FK) must exist in the referral table.
• Domain Integrity: Predefined data types, maximum and minimum values.

Database Normalization

• 1st Normal Form: Multi-valued attributes removed.
• 2nd Normal Form: Partial dependency (PD) removed.
• 3rd Normal Form: Transitive dependency (TD) removed.

Objectives: Eliminate redundancy, prevent data inconsistencies (anomalies), and ensure consistent database design.

Database Anomalies

• Addition/Insertion anomaly
• Deletion anomaly
• Update anomaly

Logic and Decomposition

• Lossless

Internet Fundamentals: A Network of Networks

The Internet is often described as a "network of networks," comprising interconnected Internet Service Providers (ISPs).

Key Components of the Internet

• Hosts: End Systems for Applications

  Hosts are the end systems (clients & servers) that run applications. They connect at the edge of the Internet.

• Packet Switches: Forwarding Data

  Packet switches forward data in chunks called packets. These include:

  • Routers: Forward data between different networks.
  • Switches: Operate within the core of the Internet, not at the edge.

• Communication Links: The Data Pathways

  Communication links connect routers and can be made of:

  • Fiber optic cables
  • Copper wires
  • Radio waves
  • Satellite connections

  The transmission rate of a link is

Core Software Design Principles

• Abstraction: Removal or masking of detail and complexity.
• Modularity: Software is divided into separately named and addressable components.
• Separation of Concerns: Any complex problem can be more easily handled if it is subdivided into pieces.
• Information Hiding / Encapsulation: Hide implementation details from client components; communicate only via controlled interfaces.
• High Cohesion: Components provide specific functionality.
• Low Coupling: Components have as few dependencies as possible so they can change with minimal impact on other components.

SOLID Principles

Single Responsibility Principle

The idea here is simple: Separate the code that supports different actors (i.e., users, stakeholders, or client components)... Continue reading "Mastering Software Design Principles and SOLID Patterns" »

Keyword Research and Analysis

SEO keywords are the important words and phrases related to the developed website content. A list of keywords needs to be carefully chosen to optimize the search. Keyword Research and Analysis is an important part of Search Engine Optimization (SEO) as well as Search Engine Marketing. For Search Engine Marketing, one can pay for certain keywords. There are various online Keyword Planner tools (such as Google Ads Keyword Planner) to shortlist keywords. This is more useful to compare the cost of various keywords if the website designer opts for Paid Search Engine Marketing.

Features of PHP Scripting Language

PHP is the most popular and frequently used worldwide server-side scripting language. Following are features... Continue reading "Effective SEO Strategies and PHP Web Development Essentials" »

Types of Interrupts in the 8086 Microprocessor

The 8086 microprocessor utilizes various mechanisms to handle external events and internal errors. These mechanisms are categorized into three primary types of interrupts: Hardware, Software, and Internal (Exceptions).

1. Hardware Interrupts

Hardware interrupts are generated by external hardware devices to request service from the microprocessor. The 8086 supports two hardware interrupt pins:

• INTR (Interrupt Request)

  This is a maskable interrupt, meaning it can be enabled or disabled using the IF (Interrupt Flag) in the flag register. When an external device wants to interrupt the microprocessor, it sends a signal on the INTR pin.

  The 8086 acknowledges the interrupt if the IF flag is set, and the INTA

Windows Popularity and Vista Features

Unit 13

Interviewer: There is no doubt that Windows has revolutionized the way we use computers today. Bill, can you explain just why it’s so popular?

Bill: Well, very simply, people find Windows very easy to use because everything is presented in graphic images. It’s also compatible with thousands of programs.

Interviewer: The big news at the moment is, of course, the launch of Windows Vista – the successor to Windows XP. I understand that there are several versions of Vista available. Could you give us some advice on which one to get?

Bill: Yes, you’re right – there are four main editions: Home Basic, Home Premium, Business and Ultimate.

Windows Vista Editions:

• Home Basic: Designed for users with basic

Unit 14: Moving Text

Cutting and Pasting

Anna: Ben, do you know how I can move this paragraph? I want to put it at the end of this page.

Ben: I think so. First, select the text with your mouse. Then, choose "Cut" from the Edit menu.

Anna: Like this?

Ben: Yes. The text disappears and is copied to the Clipboard. Click where you want the text to go.

Anna: Okay. Is that right?

Ben: Yes, if that's the correct spot. Next, choose "Paste" from the Edit menu, or press CTRL+V.

Anna: Okay, done. Is that all?

Ben: Yes. If you make a mistake, choose "Undo" from the Edit menu to reverse your last action.

Anna: Brilliant! Thanks!

Ben: You're welcome.

Unit 15: Spreadsheet Fundamentals

Introduction

Let's start with the basics. Spreadsheets are used in business for financial... Continue reading "Spreadsheet Basics and Text Editing Tips" »

What is Information Security?

Information security means protecting data from theft, alteration, destruction, disclosure, or denial of access. It has traditionally relied on physical measures (e.g., locked cabinets) and administrative controls (e.g., personnel screening). Even today, some reliance on physical security remains.

Modern Information Security Needs

With increased computer usage, automated tools are now essential for protecting stored information. As network usage grows, securing data during transmission has become equally essential.

Aspects of Information Security (ITU-T X.800/1205)

• Security Attack: Any action that compromises system security.
• Threat: A potential violation, defined as capability plus intent.
• Security Mechanism: Any policy

Evolution and History of the World Wide Web

1. Introduction and Origins of the Web

The World Wide Web (WWW) is an information system where documents and other web resources are identified by Uniform Resource Locators (URLs), interlinked by hypertext links, and accessible via the Internet.

• The Genesis: Invented by British scientist Sir Tim Berners-Lee in 1989 while working at CERN (European Organization for Nuclear Research).
• The Core Motivation: Developed to automate information-sharing among scientists globally, overcoming compatibility barriers between different computers and operating systems.
• The Core Building Blocks: By 1990, Berners-Lee defined the three fundamental technologies that remain the backbone of the modern web:

1. HTML (HyperText Markup