Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Relational Database Design with FileMaker Pro [repost]

    Posted By: ParRus
    Relational Database Design with FileMaker Pro [repost]

    Relational Database Design with FileMaker Pro
    WEBRip | English | MP4 + Project files | 1280 x 720 | AVC ~634 kbps | 29.970 fps
    AAC | 160 Kbps | 48.0 KHz | 2 channels | 2h 40mn | 447.8 MB
    Genre: Video Tutorial / Development, Programming

    Let author Cris Ippolite show you how to translate aspects of the real world into the form and language of a relational database, using three practical data modeling examples. The course begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the Relationship Graph. Then, after demonstrating how to establish relationships in a database, the course concludes with a demonstration of some advanced modeling techniques, such as filtering, scripting, and the use of portals. The course applies to versions of FileMaker Pro from 7 through the most current version.
    Main topics covered:
    Introduction
    Welcome UPDATED
    Why relational databases? UPDATED
    Using the exercise files UPDATED

    1. Reviewing Data Modeling
    Introduction to data modeling UPDATED
    Reviewing relationships types UPDATED
    Diagramming relationships UPDATED

    2. Resolving Many-to-Many Relationship
    Understanding problems caused by many-to-many relationships UPDATED
    Adding a join table UPDATED

    3. Introducing Key Fields
    Using primary and foreign key fields UPDATED
    Determining which tables need keys UPDATED

    4. Using the FileMaker Relationship Graph
    Defining tables UPDATED
    Defining key fields UPDATED
    Introducing the Relationship Graph UPDATED

    5. Working with Relationships
    Understanding related fields UPDATED
    Understanding portals UPDATED
    Using relationship options to create related fields UPDATED
    Using multiple match fields in one relationship UPDATED

    6. Real-World Data Modeling Examples
    Donations example UPDATED
    Class enrollment example UPDATED
    Personnel management example UPDATED

    7. Advanced Relationship Techniques
    Using global fields to filter portals UPDATED
    Using global fields to create a date range filter UPDATED
    Using relationships in a script to navigate UPDATED
    Using portals to connect to data more than one table away UPDATED
    Creating self-relationships UPDATED
    Adding charts with related data to layouts NEW

    8. Relationships in Calculation
    Creating aggregate functions using relationships UPDATED
    Using the List function UPDATED

    Conclusion
    Next steps UPDATED

    also You can watch my other last: Programming-posts

    General
    Complete name :019 Class enrollment example.mp4
    Format : MPEG-4
    Format profile : Base Media / Version 2
    Codec ID : mp42 (mp42/isom)
    File size : 35.2 MiB
    Duration : 6mn 9s
    Overall bit rate mode : Variable
    Overall bit rate : 800 Kbps
    Encoded date : UTC 2015-05-11 11:34:49
    Tagged date : UTC 2015-05-11 11:34:49

    Video
    ID : 1
    Format : AVC
    Format/Info : Advanced Video Codec
    Format profile : Main@L3.2
    Format settings, CABAC : Yes
    Format settings, ReFrames : 5 frames
    Codec ID : avc1
    Codec ID/Info : Advanced Video Coding
    Duration : 6mn 9s
    Bit rate mode : Variable
    Bit rate : 634 Kbps
    Maximum bit rate : 1 000 Kbps
    Width : 1 280 pixels
    Height : 720 pixels
    Display aspect ratio : 16:9
    Frame rate mode : Constant
    Frame rate : 29.970 fps
    Color space : YUV
    Chroma subsampling : 4:2:0
    Bit depth : 8 bits
    Scan type : Progressive
    Bits/(Pixel*Frame) : 0.023
    Stream size : 27.9 MiB (79%)
    Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
    Writing library : x264 core 129
    Encoding settings : cabac=1 / ref=5 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=10 / lookahead_threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=1 / b_pyramid=0 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=300 / keyint_min=29 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=22.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1000 / vbv_bufsize=14900 / crf_max=0.0 / nal_hrd=vbr / ip_ratio=3.00 / aq=1:1.00
    Language : English
    Encoded date : UTC 2015-05-11 11:34:49
    Tagged date : UTC 2015-05-11 11:34:49

    Audio
    ID : 2
    Format : AAC
    Format/Info : Advanced Audio Codec
    Format profile : LC
    Codec ID : 40
    Duration : 6mn 9s
    Source duration : 6mn 9s
    Bit rate mode : Constant
    Bit rate : 160 Kbps
    Nominal bit rate : 128 Kbps
    Channel(s) : 2 channels
    Channel positions : Front: L R
    Sampling rate : 48.0 KHz
    Frame rate : 46.875 fps (1024 spf)
    Compression mode : Lossy
    Stream size : 7.05 MiB (20%)
    Source stream size : 7.05 MiB (20%)
    Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
    Language : English
    Encoded date : UTC 2015-05-11 11:34:49
    Tagged date : UTC 2015-05-11 11:34:49

    Screenshots

    Relational Database Design with FileMaker Pro [repost]

    Relational Database Design with FileMaker Pro [repost]

    Relational Database Design with FileMaker Pro [repost]

    Relational Database Design with FileMaker Pro [repost]

    For more Exclusive material, Visit my AH-blog

    Relational Database Design with FileMaker Pro [repost]