'Special value null' diaporamas de présentation

PMIT-6102 Advanced Database Systems

PMIT-6102 Advanced Database Systems. By- Jesmin Akhter Assistant Professor, IIT, Jahangirnagar University. Lecture 02 Overview of Relational DBMS. Outline. Overview of Relational DBMS Structure of Relational Databases Relational Algebra. Why Relational DBMS.

786 views • 69 slides

More on SQL

562 views • 40 slides

The Relational Model

The Relational Model. Chapter 3. Relational Database: Definitions. Relational database : a set of relations Relation: made up of 2 parts: Instance : a table , with rows (records) and columns (fields). #Rows = cardinality , #fields = degree / arity .

417 views • 33 slides

SQL: The Query Language Part 2

SQL: The Query Language Part 2. R & G - Chapter 5 . Reserves. Example Instances. Sailors. Boats. Queries With GROUP BY. To generate values for a column based on groups of rows, use aggregate functions in SELECT statements with the GROUP BY clause.

357 views • 28 slides

The Relational Model

328 views • 24 slides