Press "Enter" to skip to content

Oracle Learning Part – 1

Table of Contents

How to Install Oracle Database 12c Enterprise Edition

Database……………………………………..

DBMS………………………………………….

SQL…………………………………………….

Application Program………………………..

Figure 1 The database approach showing Sales and Stock Control Departments accessing the database through application programs and the DBMS.

View……………………………………………

Relational Database Management System(RDBMS)……………………………..

Data model…………………………………..

Relation……………………………………….

Attribute………………………………………

Domain………………………………………..

Tuple…………………………………………..

Relational Database…………………………

Properties of Relational Tables……………

Figure 2 An Example of Relations……….

Relational keys……………………………..

Super key…………………………………….

Candidate key………………………………

Primary key…………………………………

Foreign key…………………………………

Representing Relational Databases-……

Figure 3 An Example of StayHome Video Rental Database…………………..

Null……………………………………………

Entity integrity……………………………..

Referential integrity………………………..

 

Entity Relationship Diagramming:-

ENTITIES…………………………………….

RELATIONSHIPS……………………………

Types of Database Relationships………..

Relationships and Referential Integrity…

ATTRIBUTES………………………………..

Figure 4 An Example of Entities, Relationships & Attributes………………..

Figure 5 An Example of E-R Diagram for University…………………………………….

  1. Yesterday, while I was at work, my sister stole my iphone and
    tested to see if it can survive a thirty foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views.

    I know this is completely off topic but I had
    to share it with someone!

  2. Mridha IT Provide Best Website Design and Development, SEO, Clipping Path, Accounting And Inventor Software, Domain and Hosting Services, Email Marketing, SMS Marketing, Facebook Marketing,in dhaka, Bangladesh, Chittagong, USA, UK.

  3. Hurrah! Finallу I got ɑ Ƅlog from wheгe I knoѡ how to
    in fact obtain useful data concerning mmy study and knowledցe.

  4. Woah! I’m really digging the template/theme of this
    blog. It’s simple, yet effective. A lot of times it’s very difficult to get that “perfect balance” between user friendliness and visual appeal.

    I must say you have done a awesome job with this.

    Additionally, the blog loads super quick for me on Chrome.
    Excellent Blog!

Leave a Reply

Your email address will not be published. Required fields are marked *

Share