Theteche.com

Education Tips

  • Facebook
  • Twitter
  • Google Plus
  • Home
  • Education
  • Computer Science
  • Electrical
  • Mechanical
  • Microprocessor
  • Question & Answers

Category - Software

Schema Change Statement in SQL
  • Software

Schema Change Statement in SQL

September 21, 2021
by Santhakumar Raja
5 min read
Add Comment

In this section, we give an overview of the schema evolution commands available in SQL, which can be used to alter a schema by adding or dropping tables, attributes, constraints, and other schema elements. This can be done while...

Continue reading

  • Software

Specifying Constraints as Assertions and Actions as Triggers

September 12, 2021
by Santhakumar Raja
7 min read
Add Comment

In this section, we introduce two additional features of SQL: the CREATE ASSERTION statement and the CREATE TRIGGER statement. Before discusses CREATE ASSERTION, which can be used to specify additional types of constraints that...

Continue reading

Additional Features of SQL
  • Software

Additional Features of SQL – theteche.com

September 7, 2021
by Santhakumar Raja
3 min read
Add Comment

SQL has a number of additional features that we have not described in this chapter but that we discuss elsewhere in the book. These are as follows: we will present the following additional SQL features: various techniques for...

Continue reading

Insert, Delete, and Update Statements in SQL
  • Software

Insert, Delete, and Update Statements in SQL

August 30, 2021
by Santhakumar Raja
6 min read
Add Comment

In SQL, three commands can be used to modify the database: INSERT, DELETE, and UPDATE. We discuss each of these in turn. The INSERT Command In its simplest form, INSERT is used to add a single tuple to a relation. We must specify...

Continue reading

  • Software

SQL Data Definition and Data Types

August 29, 2021
by Santhakumar Raja
3 min read
Add Comment

SQL uses the terms table, row, and column for the formal relational model terms relation, tuple, and attribute, respectively. We will use the corresponding terms interchangeably. The main SQL command for data definition is the...

Continue reading

  • Software

Relational Model Constrains and Relational Database Schemas

August 28, 2021
by Santhakumar Raja
5 min read
Add Comment

So far, we have discussed the characteristics of single relations. In a relational database, there will typically be many relations, and the tuples in those relations are usually related in various ways. The state of the whole...

Continue reading

  • Software

Relational Model Concepts in DBMS

August 28, 2021
by Santhakumar Raja
13 min read
Add Comment

The relational model represents the database as a collection of relations. Informally, each relation resembles a table of values or, to some extent, a flat file of records. It is called a flat file because each record has a...

Continue reading

Network model notation
  • Software

Classification of Database Management Systems

August 27, 2021
by Santhakumar Raja
8 min read
Add Comment

Several criteria are normally used to classify DBMSs. The first is the data model on which the DBMS is based. The main data model used in many current commercial DBMSs is the relational data model. The object data model has been...

Continue reading

Physical two tier client server
  • Software

Centralized and Client/Server Architectures for DBMSs

August 26, 2021
by Santhakumar Raja
9 min read
Add Comment

Centralized DBMSs Architecture Architectures for DBMSs have followed trends similar to those for general computer system architectures. Earlier architectures used mainframe computers to provide the main processing for all system...

Continue reading

Database System
  • Software

The Database System Environment

August 26, 2021
by Santhakumar Raja
8 min read
Add Comment

A DBMS is a complex software system. In this section we discuss the types of software components that constitute a DBMS and the types of computer database system software with which the DBMS interacts. DBMS Component...

Continue reading

1 2 3 … 8 Next

Categories

  • Communications
  • Computer Science
  • Education
  • Electrical
  • Language C
  • Law
  • Management
  • Mechanical
  • Microcontroller
  • Microprocessor
  • Question & Answers
  • Robotics
  • Software

Ads

Recent Posts

  • Interactions Between IPv4 and the Datalink Layer
  • Organisation of the Network Layer – theteche.com
  • TCP connection establishment in Computer Networks
  • The Transmission Control Protocol (TCP) – theteche.com
  • The User Datagram Protocol (UDP) – theteche.com
  • Reliable Data Transfer on Top of a Perfect Network Service
  • The Transport Layer in the Reference Model
  • The HyperText Transfer Protocol – theteche.com

Archives

  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020

Featured Posts

  • IPv4 on point-to-point links Interactions Between IPv4 and the Datalink Layer
    by Santhakumar Raja
  • Virtual circuit establishment Organisation of the Network Layer – theteche.com
    by Santhakumar Raja
  • Utilization of the TCP source and destination ports TCP connection establishment in Computer Networks
    by Santhakumar Raja
  • Transmission Control Protocol Header Format The Transmission Control Protocol (TCP) – theteche.com
    by Santhakumar Raja
  • Usage of the User Datagram Protocol (UDP) port numbers The User Datagram Protocol (UDP) – theteche.com
    by Santhakumar Raja
  • Finite state machine of the simplest transport protocol Reliable Data Transfer on Top of a Perfect Network Service
    by Santhakumar Raja
  • The transport layer in the reference model The Transport Layer in the Reference Model
    by Santhakumar Raja
  • HyperText Transfer Protocol The HyperText Transfer Protocol – theteche.com
    by Santhakumar Raja
June 2022
S M T W T F S
 1234
567891011
12131415161718
19202122232425
2627282930  
« May    
Copyright © 2022. Created by Meks. Powered by WordPress.
  • Home
  • About Me
  • Contact Us
  • Privacy Policy
  • Home
  • Education
  • Computer Science
  • Electrical
  • Mechanical
  • Microprocessor
  • Question & Answers
  • Facebook
  • Twitter
  • Google Plus