Sign into your dashboard at [Baserow.](https://baserow.io/?utm_source=newsletter&utm_medium=email&utm_campaign=100daysofnocode)

Search and select the "**Brand Assets Manager**" template (within Content Marketing).

Click "**Brand Assets Manager**" on your dashboard once the template has loaded (this might take a minute or so).

On the left-hand side of the page you'll see all the tables that are included within this database. Take a moment to scroll through the tables and look at all the various fields and how they're configured.\
\
This is a great brand asset database template, but let's say that we also want to add a table that includes all of our brand *templates* in one place. That's what you're going to do next!\
\
Click '**+ Create table**'.

Name this table '**Template'** and click "**Add table**".

By default, this table includes three fields. \
\
Edit the last field in the table so that is shows the date the template was last update.\
\
Click the button to open the field settings.

Change the name of the field to '**Date Updated**'.\
\
Now **click the drop-down menu for the field format.**

Now we're going to change the second field in the table to show the person that created the template.\
\
This is where you can see how relational database functionality works. \
\
You're going to connect this field to the 'Creator' table that already exists within the database.\
\
**Select the field settings menu.**

Change the field name to '**Creator**'.\
\
Click the drop-down menu for the field types.

Click the drop-down menu and select '**Creators**' as the table to link to.

Now you're going to configure the first field in this table to include unique brand templates.\
\
Select the field settings menu for the first field.

Call this field '**Template**'.\
\
Select the drop-down menu for field types.

Now enter some dummy information into this table so you can see how it works.\
\
First, you'll notice that when you click inside the 'Template' field, you're prompted to upload a file.\
\
Upload a dummy file from your device (you can use anything as this is just for demonstration purposes, and you can delete it later).

You'll see that your brand template can now be accessed directly from this table.

Now it's time to see the power of relational databases. \
\
In the 'Creator' field, click the button to assign a creator to this template.

The pop-up window that appears will now show the '**Creators**' table in your database. \
\
Select any of the creators.

You'll see that you've now linked one table to another in your database via the '**Creator**' field.

Now complete this row of data by selecting a date for the 'Date Updated' field.

Repeat steps 25-32 to enter two more rows of dummy data. This is just so that you can get a feel for how this might work in the real world.\
\
You should end up with something that looks like this.

Brandon Waiyne
01/04/2024
Amanda Rochmoore
10/04/2024
William Shakesmoore
19/04/2024

Another way to get a feel for how the relational database works is by clicking into a '**Creator**' record. 

Scroll down and you'll see that the record for the creator has now also been updated with the templates that you've assigned to them.

Finally, select the '**Creators**' table within your database.

Scroll right, and you'll find a new field has been added within the 'Creator' table for '**Templates**'. This is because of the previous you link you made between your 'Templates' table and your 'Creators' table!

amanda.rochmoore@brandmgmtltd.com
www.brandmgmtltd.com
Created style guides for the company.
sheets template v1.xlsx
andrew.garfunkle@brandmgmtltd.com
www.brandmgmtltd.com
Left the company a couple of years ago.
brandon.waiyne@brandmgmtltd.com
www.brandmgmtltd.com
First graphic designer of the company.
docs template v1.docx
daniel.waiyne@brandmgmtltd.com
www.brandmgmtltd.com
Expert in vector graphics.
marlon.braidee@mmbrwmasters.org
www.mmbrwmasters.org
Audio and video expert.
michael.turnbuckle@geemail.com
Audio and video contractor.
rachel.lancasterr@brandmgmtltd.com
www.brandmgmtltd.com
Resident emoji expert! 👩‍🎨
rowena.stillerton@fontbrwmasters.com
www.fontbrwmasters.com
Font contractor.
selena.growver@writersfieldbr.com
www.writersfieldbr.com
Backup PR writer.
william.shakesmoore@brandmgmtltd.com
www.brandmgmtltd.com
Our very own prolific content writer.
slides template v1.pptx

Congrats, that wraps up today's lesson.\
\
You've built a brand asset manager AND learned about relational databases in the process. 