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

Introduction to Database Management Systems

A database is a structured collection of data stored on a computer system. It is managed using a Database Management System (DBMS), which provides the necessary tools for data storage, retrieval, and modification.

Core Benefits of Using a DBMS

• Reduced Data Redundancy: A DBMS helps minimize repeated data through organizational rules such as normalization.
• Enhanced Data Accuracy: The system uses specific rules, such as referential integrity, to maintain data consistency.
• Support for Multiple Users: Many people can access and use the database simultaneously without encountering operational problems.

Centralized vs. Distributed Databases

• Centralized: All data is stored in a single, primary location. This setup

Hexadecimal Integer Grammar Analysis

Consider the following grammar for hexadecimal integers:

• <hex literal> ::= 0x<number>
• <number> ::= <number><number> | <digit>
• <digit> ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | A | B | C | D | E | F

The string 0xF3 is an element of the language generated by this grammar.

Derivation Sequences and Parse Trees

1. How many distinct derivation sequences exist for this string?

There exist 6 distinct derivation sequences:

• <hex literal> ⇒ 0x<number> ⇒ 0x<number><number> ⇒ 0x<digit><number> ⇒ 0x<digit><digit> ⇒ 0xF<digit> ⇒ 0xF3
• <hex literal> ⇒ 0x<number> ⇒ 0x<number><number> ⇒ 0x<number&

This document summarizes key concepts and solutions from previous database exam questions.

Relational Schema with Functional Dependencies

• Schema: R(A, B, C, D, E, F)
• Dependencies: C → F, E → A, EC → D, A → B

1. Candidate Keys: CE
2. Prime Attributes: C, E
3. Second Normal Form (2NF):
   • No, because of partial dependencies:
     • C → F (partial dependency)
     • E → A, B (partial dependency)

EMP_DEPT Table Analysis

1. Functional Dependencies:
   • Ssn → Ename, Bdate, Address, Dnumber, Dname, Dmgr_ssn
   • Dnumber → Dname, Dmgr_ssn
   • Dmgr_ssn → Dnumber, Dname
   • Dname → Dnumber, Dmgr_ssn
2. First Normal Form (1NF):
   • Split names into first_name and last_name.
3. Second Normal Form (2NF):
   • Already in 2NF because there are no partial dependencies.

EMP_PROJ Table Normalization

1. Functional Dependencies:

React Hooks and Essential Libraries

useState Hook

Purpose

Purpose: Adds state to functional components.

Import

import { useState } from 'react';

Syntax

const [state, setState] = useState(initialValue);

Update Methods

• setState(newValue);
• setState(prevState => ...); (for updates based on previous state)

Example

import React, { useState } from 'react';

function Counter() {
  const [count, setCount] = useState(0);

  return (
    <div>
      <p>Count: {count}</p>
      <button onClick={() => setCount(count + 1)}>Increment</button>
    </div>
  );
}

useEffect Hook

Purpose

Purpose: Performs side effects such as data fetching, subscriptions, or direct DOM manipulations.

Import

import { useEffect } from 'react';

Syntax

useEffect(

Input three numbers and find the largest. Enter a number and display the day name of the week.
#include
#include
using namespace std;
using namespace std;
int main() {
int num1, num2, num3;
int day;
cout << "Enter three numbers: ";
cout << "Enter a number (From 1 to 7): ";
cin >> num1 >> num2 >> num3;
cin >> day;
if (num1 > num2 && num1 > num3) {
cout << "Largest number is " << num1;
} else if (num2 > num3) {
cout << "Largest number is " << num2;
} else {
cout << "Largest number is " << num3;
}
switch (day) {
case 1: cout << "Sunday"; break;
case 2: cout << "Monday"; break;
... Continue reading "Find the Largest Number and Calculate Factorial in C++" »

Lab 1: Basic TensorFlow Computation Graph

This example demonstrates how to define and execute a simple computation graph in TensorFlow using the @tf.function decorator, which converts a Python function into a high-performance TensorFlow graph.

import tensorflow as tf

# Define a simple computation graph
@tf.function  # Converts Python function into a TensorFlow graph
def my_graph(x, y):
  return x * y + 5  # Simple equation: (x * y) + 5

# Create TensorFlow constants (nodes)
x = tf.constant(3.0)
y = tf.constant(4.0)

# Run the computation graph
result = my_graph(x, y)

# Print the result
# Convert tensor to a NumPy array to see the value
print(f"Result of (x * y) + 5: {result.numpy()}")

Lab 2: Simple Linear Regression with Keras

Here, we build,... Continue reading "Practical Machine Learning Labs in TensorFlow and PyTorch" »

Python Django Project Setup

Follow these steps to initialize and configure your Python Django environment.

Initial Environment Navigation

• Step 1: Open the Command Prompt and use cd.. to navigate back.
• Step 2: Use cd.. again to reach the desired root.
• Step 3: Navigate to your Python directory: cd Raj_Python.
• Step 4: Enter your project folder: cd mscit_dproject.

Creating the Project and Application

• Step 5: Create the project: django-admin startproject [Project Name].
• Step 6: Navigate into the project folder: cd [Project Name].
• Step 7: Create a new application: python manage.py startapp [App Name].
• Step 8: Open the project in VS Code and configure settings.py.

Configuring settings.py

In settings.py, import the OS module and define your template directory:

import

Corrected Exam

<!DOCTYPE html>

• Images
• Table
• Alert
• Form
• Grid

Images and Table with Nav Tabs

Lorem ipsum dolor sit amet consectetur adipisicing elit. Ducimus deserunt natus est et, incidunt id quasi ex veniam tenetur quibusdam optio dolor rem dicta officia voluptate nemo rerum quod amet.

Data Table

Alert Notification

Hello! This is an alert that can be closed by clicking on the "X" button.

<!DOCTYPE html>

Document

Form Section

Send

Grid

Lorem ipsum, dolor sit amet consectetur adipisicing elit. Assumenda autem culpa dolorum dolorem voluptatum quisquam ipsam quia quae libero rerum aut pariatur saepe quaerat doloribus... Continue reading "Bootstrap Components: Navigation Tabs, Tables, and Forms" »