Database 08: Introduction to Relational Database Design #1

[@austinlew3225]

Great video! Learned a lot and very informative. If you will, i do have a question for you Mr Bill Sky sir. You emphasize getting a database designed well and correctly the first time, how would an aspiring database designer know what Tables and Attributes to include such that it is good enough to be deployed into production? The potential consequences of designing a database in an unoptimized way seem very scary.

[@billskycomputerguy]

What a great question. You need to visit “domain experts” who will educate you in the subject you are trying to model into the database. So if you are putting together an on-line sales DB, go see the sales department. If you have been tasked with modeling Space-X assets or operations, go see those experts. You interview these people to learn from them and obtain enough knowledge to understand the domain and separate “objects” into database entities (tables) and how they relate to each other. This is what I love about database administration. You learn so much about other industries and disciplines. Keep the questions coming! I may do a video on just this subject.