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!

  5. Hey I know this is off topic but I was wondering if you knew of any widgets
    I could add to my blog that automatically tweet my newest twitter updates.
    I’ve been looking for a plug-in like this for quite
    some time and was hoping maybe you would have some experience
    with something like this. Please let me know if you run into anything.
    I truly enjoy reading your blog and I look forward to your new updates.

  6. I’ve been browsing online more than 4 hours today, yet I never found any interesting article like yours.
    It is pretty worth enough for me. Personally, if all
    webmasters and bloggers made good content as you did,
    the web will be much more useful than ever before.

  7. Hello there! I know this is kinda off topic but I was wondering if you
    knew where I could find a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having trouble finding one?
    Thanks a lot!

Leave a Reply

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

Share