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...........................................