Database Fundamentals

Database Fundamentals icon
 00:38:38 Hrs

Course Description

A database is an organized collection of data which can be used for various for purposes. This course explains the fundamental concepts involved in database.

Video Resolution:
   800 X 600
   1024 X 768
BM
Lesson Plans
Duration
Status
Notes

Collapse all Expand all

  •   Introduction to Database SystemsOpen or Close
    -

    Architecture of a Database System

    02:15

     
     


    -

    Advantages of a DBMS

    02:06

     
     


    -

    Entity-Relationship Model

    03:16

     
     


    -

    Meanings of Entities, Attributes and Entity Sets

    02:03

     
     


    -

    Relationships and Relationship Sets

    01:44

     
     


  •   Introduction to SQLOpen or Close
    -

    The History of the Relational Database Model

    02:02

     
     


    -

    Why industry uses Relational Database Management System?

    04:44

     
     


    -

    Creating and Accessing Database with SQL

    01:43

     
     


BM
Tips & Tricks
Status
Self Assessments
Attempts
Status
Lesson Plans
Tips and Tricks

Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Alternate (candidate) Key

A column or combination of columns, other than the primary key column(s), which may be used to uniquely identify a row in a table. The primary key is chosen from one of the candidate keys. As you can read from the article behind this term; if you have many candidate keys, you have a problem of selecting the best fit.

Attribute

An attribute is a part of the description of the entity. The entity itself is described by one or more attributes; together, they describe all things of importance about the entity. Example: Typhical attributes for a customer would be name, address, telephone, etc.