پاورپوینت Relational Database Systems

توضیحات

پاورپوینت Relational Database Systems : Relational database management systems (RDBMSs) are based on a data definition language called Structured Query Language or SQL (often pronounced “sequel”).

MySQL takes its name from SQL.

Introducing SQL:

SQL is a data definition language

CREATE DATABASE `DVD Rentals`

CREATE TABLE Member(`Member Number` integer, Name varchar(30), Address varchar(50), `Post Code` varchar(7), `Telephone Number` varchar(11))

SQL is also a data manipulation language

INSERT INTO MemberVALUES (`233`, `Jo Soap`, `1 Getting Close`, `IS99 2QZ`, `123456`)

SELECT * FROM MemberWHERE `Member Number` BETWEEN 1 and 250ORDER BY `Member Number` DESC

DELETE FROM MemberWHERE `Member Number` > 500

phpMyAdmin:

A graphical user interface for MySQL

Viewing a table definition

Adding a record

Selecting records

Viewing selected records

Referential Integrity:

For the database to work properly, it is essential to guarantee that a foreign key always refers to a record which exists in the other table.

This is called referential integrity.

Validation: Range Check:

Range checking is performed by the interface

پاورپوینت Relational Database Systems

فایل شامل 44 اسلاید می باشد.

اسلاید های فایل دارای تصاویر می باشد.

فایل امکان ویرایش دارد.

بعد از دانلود فایل را از حالت ZIP استخراج کنید.

پیشنهاد فایلینو (پاورپوینت کارگاه شبکه های محلی)