SQL Database Schema: Library Data Model
Exercise 1: Library Database Schema
This document outlines the SQL code for creating a library database, including tables for publishers, distributors, customers, articles (books and journals), and rentals. It also includes sample queries for data insertion and retrieval.
Database Initialization
DROP DATABASE IF EXISTS library;
CREATE DATABASE IF NOT EXISTS library;
USE library;Table Creation
Publisher Table
Stores information about publishers.
CREATE TABLE publisher (
id INT AUTO_INCREMENT PRIMARY HTML Param Tag: Definition and Usage
HTML <param> Tag: Defining Parameters for Objects
The <param> tag defines parameters for an <object> element. It allows you to pass information to the object, such as settings or initial values.
Key Attribute: name
The name attribute specifies the name of the parameter. In the example below, the parameter name is “property”.
Example:
<div> <param name="property" value="objA"></div>Usage Notes:
- The
<param>tag must be placed inside an<object>element. - The
Essential MySQL Commands and Operations
Listing Databases
To list all databases:
mysql> SHOW DATABASES;Listing Tables in a Database
To list all tables in the currently selected database:
mysql> SHOW TABLES;Describing a Table’s Format
To describe the format of a table:
mysql> DESCRIBE table;Creating a Database
To create a new database:
mysql> CREATE DATABASE db_name;Creating a Table
To create a new table:
mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE));
Ex: mysql> CREATE TABLE pet (name VARCHAR(20)Oracle Database Performance Tuning: Shared Pool & Statistics
Shared Pool Analysis
Selecting Shared Pools for Performance Analysis:
To determine the best performing shared pools, use the following query:
SELECT SHARED_POOL_SIZE_FOR_ESTIMATE TAMANHO_EM_MB, SHARED_POOL_SIZE_FACTOR, ESTD_LC_TIME_SAVED TEMPO FROM V$SHARED_POOL_ADVICE;Checking Shared Pool Size:
To check the current shared pool size, execute:
SHOW PARAMETER SHARED_POOL_SIZEAltering Shared Pool Size:
To modify the shared pool size, for example, to 60MB, use:
ALTER SYSTEM SET SHARED_POOL_SIZE = 60M;Oracle
Read MoreJavaScript Image Rotator and Opacity Effects
JavaScript Image Rotator
Slide del ejercicio 1
Image Opacity Effects
Contact Image Opacity
Presentation Image Opacity
Methodology Image Opacity
Content Image Opacity
Form Validation
Date Selection
Radio Button Disabler
Read MoreSystem Configuration and Device Management
Configuration tools in operating systems have different uses for system administration. These applications allow you to configure the desktop, the appearance of windows, users, internet connection, devices, etc. Configuration tools are similar in all operating systems, even though each has a personalized name or location. To use the administrative tools, it is required to have Administrator or root privileges.
Windows Administration
There are many applications for system administration in Windows.
Read More