Results 1 to 2 of 2
  1. #1
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863

    Where should I start? Understanding Relational Database - RDBMS

    Before you begin developing an application that relies on a relational database, I suggest you have an understanding of relational databases. It will be beneficial to understand object oriented programming and the programming language VBA. However, the first steps are creating your tables and queries. Define your entities and create a diagram that will guide you in the creation of your tables/relations.

    Here is a good overview of what a Relational Database is
    http://www.youtube.com/watch?v=t587Q...VlgZ_xRRSsyesu

    You need an Entity Relationship Diagram. Here is a super basic explanation. 15 minutes
    http://www.youtube.com/watch?v=-fQ-bRllhXc

    Here is an hour long class on applying Business Rules while you diagram and design your database (the beginning stages). The audio is terrible but the info is good. It seems most of the technical videos are created by people who have better things to do than worry about audio.
    http://www.youtube.com/watch?v=mxYy4OINoSo

    Here is a 10 minute tutorial on Normalization. Normalization is super complicated and not very intuitive when trying to understand all of the technical aspects. At least gloss over it and then try to apply knowledge gleaned from first blush. You can always revisit the topic later.


    http://www.youtube.com/watch?v=y_MDbbqQIUU

    In order to apply Normalization to your Entity Relationship Diagram (ERD) you need to understand what Keys are. Primary Keys and Foreign Keys are critical. How you decide what your PK’s and FK’s are can be, well, not so much fun.

    This video is a brief description of some types of Keys
    https://www.youtube.com/watch?v=_aN-8kszIdA

    This series of videos is about Logic Data Modeling. However, the second video is a good description of how to go about using Candidate Keys to then define your Primary Key. The user, Orange, here in this forum, first introduced me to his series.
    http://www.youtube.com/playlist?list=PL196FE5448948D9B4
    Last edited by June7; 08-10-2014 at 08:41 PM.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,704
    ItsMe,

    Good stuff. The playlist on ERD was the best I could find about 3 years ago. It deals with the same example all the way through. The quality isn't great and the terminology less rigorous than Date or Codd would use, but several posters found them useful.
    Here is another playlist to complement your list.

    https://www.youtube.com/watch?v=7-Ek...7870F94CDE8F21

    For a youtube playlist for learning Access, here is a series created by xipoo. It goes from intro to more advanced.
    https://www.youtube.com/playlist?lis...03jQ_t9nFV737s
    Last edited by orange; 06-14-2015 at 04:49 PM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Relational Database
    By javier571 in forum Database Design
    Replies: 1
    Last Post: 04-13-2014, 07:05 AM
  2. Simple Relational Database - Please Help!
    By hannahskellam in forum Database Design
    Replies: 2
    Last Post: 05-09-2013, 11:47 AM
  3. Few relational database questions
    By rik1254 in forum Access
    Replies: 10
    Last Post: 12-13-2012, 01:13 PM
  4. Setting up relational database
    By aceoftrades in forum Access
    Replies: 1
    Last Post: 02-22-2012, 08:42 AM
  5. Relational Database/query help
    By Champin4 in forum Queries
    Replies: 7
    Last Post: 07-14-2010, 08:49 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums