ProCodeCG Coding Mum Batch 3 – Day #11 – 9 Jan 2017

Standard

Day #11 🙂 We learned about Database Concepts and Design 😉

IMG_2359

We have to introduce what’s under the hood of back-end programming, because the knowledge will be useful to understand the scope of the work given by clients in the future

IMG_2360

Today we created several tables, normalized it and make relationships between the tables

Bildschirmfoto 2017-02-09 um 10.22.52 PM

We learned about primary and foreign key

Bildschirmfoto 2017-02-09 um 10.23.38 PM

How to keep entity integrity, domain integrity and referential integrity

Bildschirmfoto 2017-02-09 um 10.25.52 PM

And how to use triggers 🙂

Bildschirmfoto 2017-02-09 um 10.25.57 PM

Will learn a bit more tomorrow, and start to do the project next week! 🙂

Advertisement