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!

  8. ZatthewAgent

    related:www.aclepsa.com/ viagra
    http://glviagragtr.com – viagra generic
    viagra online yabb
    viagra generic
    – purchase of viagra and viagra pills
    online doctor viagra side effects

  9. RoyzeLic

    viagra for women reviews occupation
    http://xlviagracan.com – viagra sale
    viagra soft gel tabs
    viagra sale
    – viagra without a prescription from mexico
    5mg viagra online

  10. ZillieHal

    canadian pharmacy viagra professional board index
    http://gtviagracan.com – viagra for sale for men
    buy generic .5mg viagra daily
    viagra for sale
    – viagra interaction with nsaid’s
    generic viagra pro 20 mg x 20

  11. Zachazycloms

    levitra tadalafil 20mg price gaestebuch.htm
    http://levitragls.com – levitra for sale
    india levitra
    levitra for sale
    – levitra and alcoholic drinks forum software
    levitra from canada no prescription you have posted in this thread

  12. I always used to read piece of writing in news papers but now
    as I am a user of web so from now I am using net for articles, thanks to web.

  13. Appreciating the hard work you put into your website and detailed information you provide.
    It’s nice to come across a blog every once in a while that isn’t the same out of date rehashed information. Excellent
    read! I’ve saved your site and I’m adding your RSS feeds to my Google account.

  14. Pretty nice post. I just stumbled upon your weblog and wanted
    to say that I have truly enjoyed browsing your blog posts.

    After all I will be subscribing to your rss feed and I hope you write again soon!

  15. viagra
    I was curious if you ever considered changing the structure of
    your website? Its very well written; I love what youve
    got to say. But maybe you could a little more in the way of content so people could connect with it better.
    Youve got an awful lot of text for only having 1 or 2 images.
    Maybe you could space it out better?