{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Basic SQL Statement Presentation.pdf - Relational Database...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
I-12 Copyright © Oracle Corporation, 2001. All rights reserved. Relational Database Concept Dr. E.F. Codd proposed the relational model for database systems in 1970. It is the basis for the relational database management system (RDBMS). The relational model consists of the following: Collection of objects or relations Set of operators to act on the relations Data integrity for accuracy and consistency
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
I-13 Copyright © Oracle Corporation, 2001. All rights reserved. Definition of a Relational Database A relational database is a collection of relations or two-dimensional tables. Oracle Oracle server server Table Name: EMPLOYEES Table Name: DEPARTMENTS
Background image of page 2
I-18 Copyright © Oracle Corporation, 2001. All rights reserved. Relating Multiple Tables Each row of data in a table is uniquely identified by a primary key (PK). You can logically relate data from multiple tables using foreign keys (FK). Table Name: EMPLOYEES Table Name: DEPARTMENTS Primary key Primary key Foreign key
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
I-21 Copyright © Oracle Corporation, 2001. All rights reserved. Communicating with a RDBMS Using SQL SELECT department_name FROM departments; SQL statement is entered. Oracle server Statement is sent to Oracle Server.
Background image of page 4
I-22 Copyright © Oracle Corporation, 2001. All rights reserved. Relational Database Management System User tables Data dictionary Oracle server
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
I-23 Copyright © Oracle Corporation, 2001. All rights reserved. SQL Statements SELECT INSERT UPDATE DELETE MERGE CREATE ALTER DROP RENAME TRUNCATE COMMIT ROLLBACK SAVEPOINT GRANT REVOKE Data retrieval Data manipulation language (DML) Data definition language (DDL) Transaction control Data control language (DCL)
Background image of page 6
I-24 Copyright © Oracle Corporation, 2001. All rights reserved.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}