Its nice being an independent turtle


Comments

Post a Comment

Popular posts from this blog

Osun State University in Collaboration with British Computer Society

is offering   The British Computer Society Chartered Institute of IT Professionals Foundation in Business Analysis On successfully passing the examination, candidates will be awarded the Chartered Certificate of the Foundation in Business Analysis Candidates will also be awarded Associate Membership of the Chartered IT Professional (CITP) Registration is on !!! Registration can be made through the following link   https://docs.google.com/forms/d/e/1FAIpQLSc95O9kEpLfxtqpwV5ofhS-qVv3AlDk7T2SfVRRMm829-VKEw/viewform Note: F ee offered by Osun State University is very much less than the amount offered by the body in the UK. T his is because UNIOSUN is an accredited training provider (ATP). Examination date: September 28, 2020 Examination is online based accessible through individual computers Lecture materials can be obtained by enquiring email: patrick.ozoh@uniosun.edu.ng There are periodic classes on Skype Send enquiry to patrick.ozoh@uniosun.edu.ng  
Read more

Database System Concepts - SQL

  SQL (Structured Query Language) is THE standard DML for relational database products. The query language is based on relational algebra, but borrows from tuple relational calculus. Topics: •  the data-definition language (DDL) - creating, deleting and modifying relation   schemas •  the data-manipulation language (DML) - the query   language •  modification of relations (insert, delete,   update) •  integrity constraints (domain constraints and foreign   keys) •  creation and use of   views •  transaction   control •  application   programming Five major standards have been defined for SQL: •  SQL-86 •  SQL-89 •  SQL-92 •  SQL:1999 •  SQL:2003 Each standard is essentially a superset of the previous ones. Most major commercial systems support essentially the SQL-92 standard along with some part of the SQL:1999 and SQL:2003 standards. In the following examples, we continue to use the flys...
Read more

Database PowerPoint Presentation Lectures by Dr Patrick Ozoh Dept of ICT Osun State University

A transaction is a sequence of DML commands that forms a logical unit of work Example: transferring money from one bank account to another Transaction Management A transaction is a sequence of DML commands that forms a logical unit of work Example: transferring money from one bank account to another Some Definitions Atomicity - a transaction must execute completely or not at all Consistency - once a transaction completes successfully, the database must be in a consistent state Isolation: A transaction must not be affected by other transactions that are executing concurrently Durability: Once a transaction compketes successfully, its effect must persist even in the presence of system failures Concurrency control Concurrency control is a database management systems (DBMS) concept meant to coordinate simultaneous transactions while preserving data integrity. Control protocols ensures atomicity, isolation, and serializability of concurrent transactions Concurrency control protoc...
Read more