Database

Question 1

What is a relational database?

Answer 1

Anatomy:

• Tables: Data representing an entity organized into columns in rows
• Properties: Attributes that you want to store about an entity
• Relationships: The relationships between tables
• Indexes: Useful for connecting tables and making quick lookups

Question 2

High level todos in designing a schema

Answer 2

1) Understand the business needs

2) Identify entities

3) Identify properties/fields on those entities

4) Define relationships between tables