We explore importance of defining and designing databases.

Creating data models is an integral part of designing databases.

Representing more complex relationships and entities is important in modelling.

Identifying the correct relationship between two entities is very important for the data model. There are various types of relationships each with its own purpose.

Normalisation removes problems of redundancy

Converting the conceptual data model (ERD) to the physical implementation as a relational database.

CREATE TABLE statement & INSERT INTO statements

SQL SELECT statement is used to retrieve data from the database