Welcome to Mobilarian Forum - Official Symbianize forum.

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Practical Database Design - Blog Schema

GravHosting
TOP 110

TOP

Alpha and Omega
Member
Access
Joined
Jan 21, 2021
Messages
405,703
Reaction score
20,060
Points
113
Age
38
Location
OneDDL
grants
₲555,415
4 years of service
0d1be8d7980ad0cd1ac5995d56d1ca17.jpeg

Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.42 GB | Duration: 5h 33m
Database Theory and Practical Application

What you'll learn
Build a database design from a given set of requirements
Determine a set of prelimiary entities and attributes to start a database design
Normalise a database design into 1NF taking into consideration multivalued and miltipart fields
Establish table candidate and primary keys
Normalise a database design into 2NF taking into consideration partial key dependencies
Identify multiple types of table relationships and define relationships between tables
Normalise a database design into 3NF taking into consideration transitive dependencies
Develop database design solutions to common features of a blog application
Requirements
No Prior experience needed but would be advantageous
Description
Out of all the tech subjects I have lectured on, databases or relational database systems have always been a subject with a "steep learning curve". Students tend to find it challenging, and it just takes much more effort to learn than other subjects.To my surprise, I am one of many people who have observed this trend. There is, in fact, a small niche of research papers written on this topic.So why is it so challenging? When I think of how we might overcome some challenges when learning databases instantly, I think of one fact that remains true, which goes back to even when I started learning database systems. There needed to be more examples or actual database design in practice. This course aims to help support anyone starting their journey into relational database systems by establishing underpinning skills and concepts of database and database design by working through practical scenario reasoning and providing the rationale to design decisions. Nothing beats experience in most subjects. That is amplified in the realms of relational database development. With the knowledge and experience gained in the course in hand, I hope that on completion of this course, it will provide the scaffolding, underpinning knowledge to support your endeavours in the world of relational database development.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Course Resources
Section 2: Relational Database Underpinning Knowledge
Lecture 3 Key Terminology: Databases, RDBMS, and the Data Lifecycle
Lecture 4 Key Terminology: Entity and Tables
Lecture 5 Key Terminology: Attributes and Fields
Lecture 6 Database Design Objectives
Section 3: Stage 1: Project Initiation
Lecture 7 Project Introduction: Designing a Blog Database
Section 4: Stage 2: Establishing Entities and Attributes
Lecture 8 Introducing the Entities
Lecture 9 Identifying Significant Entities
Lecture 10 Project: Approach 1 - Formulate the Preliminary Entity List
Lecture 11 Project: katz Chart
Lecture 12 Project: Approach 1 - Associate Attributes with Entities
Lecture 13 Project: Approach 2 - Identifying Entities from a List of Attributes
Lecture 14 Illustrating a Database Design - Entity Relationship Diagram (ERD)
Lecture 15 Table and Field Naming Convention[19]
Section 5: Stage 3: Refining the Table Structures
Lecture 16 Normalisation and 1NF
Lecture 17 Multivalued Fields
Lecture 18 Project: Identify and Resolve Multivalued Fields
Lecture 19 Multipart (composite) Fields
Lecture 20 Project: Identify and Resolve Multipart Fields
Section 6: Stage 4: Establishing Keys
Lecture 21 Table Keys
Lecture 22 Candidate Key
Lecture 23 Primary Key
Lecture 24 Project: Establishing Table Keys
Section 7: Stage 5: Dependency
Lecture 25 Dependency
Lecture 26 Normalization Second Normal Form (2NF)
Lecture 27 Partial Key Dependencies
Lecture 28 Project: Identify and Resolve Partial Key Dependencies
Section 8: Stage 6: Establishing Table Relationships
Lecture 29 Table Relationships
Lecture 30 Identifying Table Relationships
Lecture 31 One-to-Many
Lecture 32 Many-to-Many
Lecture 33 One-to-One
Lecture 34 Project: Establishing Table Relationships
Section 9: Stage 7: Normalization 3NF
Lecture 35 Normalization Third Normal Form (3NF)
Lecture 36 Transitive Dependency
Lecture 37 Project: Identity and Resolving Transitive Dependencies
Section 10: Stage 8: Expanding the Database Design
Lecture 38 Project Requirement: Capture User Actions
Lecture 39 Project Requirement: Alert to Any Objectionable Material by Flagging
Lecture 40 Project Requirement: Custom Post Attributes
Lecture 41 Project Requirement: Post Comments
Lecture 42 Project Requirement: Post Ratings
Beginners, Developers, Students, and Enthusiasts new to relational database design


Homepage
Code:
Please, Log in or Register to view codes content!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
 
K 0

KatzSec DevOps

Alpha and Omega
Philanthropist
Access
Joined
Jan 17, 2022
Messages
820,501
Reaction score
8,459
Points
83
grants
₲59,133
3 years of service
TOP salamat sa pag contribute. Next time always upload your files sa
Please, Log in or Register to view URLs content!
para siguradong di ma dedeadlink. Let's keep on sharing to keep our community running for good. This community is built for you and everyone to share freely. Let's invite more contributors para mabalik natin sigla ng Mobilarian at tuloy ang puyatan. :)
 
Top Bottom