connect your family tree world search www.connectyourfamily.com

Database Fundamentals

Posted on

Learn about the fundamentals of databases. What are entities, attributes, relationships, primary keys, and foreign keys? This video covers the basics.
Video Rating: 4 / 5

Filed under: Genealogy Comments Off
Comments (25) Trackbacks (0)
  1. suzuki140291
    January 11th, 2012 - 14:45

    the sound is little bit low :(

  2. MegaTylerLynch
    January 11th, 2012 - 15:22

    I really enjoyed this video.
    I watched it along with other database videos and it helped me with my decision. It is so important that the database identifies relationships.
    After looking around I found the right database for my business, a company called Mybusybiz.
    Thanks so much for posting this video.

  3. profbbrown
    January 11th, 2012 - 15:39

    @Aloysius1966 Most database systems are set up like this (from outer to inner): Database -> Schema -> Table/View

    So a database can contain multiple schemas, and those schemas can contain multiple tables and views.

  4. profbbrown
    January 11th, 2012 - 16:33

    @BadAss708 Are you looking for something practical or more theoretical? For practical, take a look at Database Design for Mere Mortals or the Absolute Beginner’s Guide to Databases.

  5. profbbrown
    January 11th, 2012 - 17:28

    @peahead210 Thanks!

  6. profbbrown
    January 11th, 2012 - 17:31

    @sideshow557 You’ve highlighted a difference between concept and reality. Conceptually, every table ought to have a PK. For the car table it might be the set of all attributes which are needed to uniquely identify each record. But in reality, a database table can be created without explicitly specifying what the key fields are and the DB will happily store whatever data you throw at it, even if there are duplicates. The PK in a “real” database enforces the uniqueness.

  7. sideshow557
    January 11th, 2012 - 17:46

    How then would you create a primary key for the car table or can the table existe without a primary key? (Great vid. BTW)

  8. abubruno
    January 11th, 2012 - 17:56

    Please Mister,

    Would it be possible for you to post a video with more Database explanation??? I found your material very didactic and it falls into a very easy understanding….

  9. peahead210
    January 11th, 2012 - 17:56

    After watching about 20 other database videos, this one finally made sense…thank you. I’m in Business Management Tools class and we are on database and this helped out a lot.

  10. Fhemmati
    January 11th, 2012 - 18:54

    incredible thanks

  11. BadAss708
    January 11th, 2012 - 19:36

    Thank you for the video on the database fundamentals.
    I am in India and I am student of Computer Engineering.
    I am looking for good book on Fundamentals Of Database.
    Can you suggest any book?

  12. solde99
    January 11th, 2012 - 20:33

    What a good tutorial!!!!!!!! I am subscribing right now.

  13. Aloysius1966
    January 11th, 2012 - 20:53

    Thanks for the response.

    RE: Database – I meant the latter in your response — the actual tables, views, etc.

    I don’t have a visual representation for the schema, other than it looks like an organization chart, like I do for the instance and database, I can see them and their relationship.

    Using the Russian Doll analogy …. tables, views, etc., inside a schema, a schema inside of a database and a database inside an instance?

  14. profbbrown
    January 11th, 2012 - 21:44

    @Aloysius1966 “Database” is a term used in several ways. It could be short for Database Management System (DBMS), which is a software package such as SQL Server, Oracle, etc. that allow you to store, query, and manipulate data. Or database could refer to a specific collection of related tables; for example, the “database for inventory control.” However, “schema” generally means the specific definition of those tables; ie, the actual field names, types, and table names.

  15. Aloysius1966
    January 11th, 2012 - 22:19

    Thank’s for the video.

    What’s the difference between a database and a schema?

  16. kusubos
    January 11th, 2012 - 22:48

    wow. i’m always asking myself what my profs are doing wrong. it’s so simple if they would take an example as you do! thank you!

  17. TheRealAnalysis
    January 11th, 2012 - 23:17

    Thank you very much for posting this video. It is very helpful and I learned a lot. Thanks.

  18. faheemboy
    January 11th, 2012 - 23:38

    thank you 4 the effort

  19. AlyAmmad
    January 12th, 2012 - 00:20

    Your video was very helpful in understanding the basics of databases. Hope you will upload more videos on the same topic.Thanks

  20. profbbrown
    January 12th, 2012 - 00:21

    @kb112937 No problem.

  21. kb112937
    January 12th, 2012 - 01:04

    am I able to copy some of your presentation slides like samples of the databases?

  22. rkolb2567
    January 12th, 2012 - 01:17

    You could easily teach a child this stuff. Everything about your videos are perfect. Keep it up. I’d love to see some more database stuff

  23. MsWishYouJoy
    January 12th, 2012 - 01:51

    Thank You! Wonderful video…Clean and simple.
    Can you do a video on the basics of connecting any application to any database?

  24. hamza98888
    January 12th, 2012 - 02:06

    perfect work

  25. TheProid
    January 12th, 2012 - 02:44

    more tutorials! please, Your a great teacher.


Trackbacks are disabled.

» «


Family Tree

Genealogical data can be represented in several formats, for example as a pedigree or ancestor chart. Family trees are often presented with the oldest generations at the top and the newer generations at the bottom. An ancestry chart, which is a tree showing the ancestors of an individual, will more closely resemble a tree in shape, being wider at the top than the bottom. In some ancestry charts, an individual appears on the left and his or her ancestors appear to the right. A descendancy chart, which depicts all the descendants of an individual will be narrowest at the top.

Categories

Recent Posts