Diagram Initials Lease For Free

hello and welcome to this video about how we can translate an ER diagram into the relational data model that we later on can use to implement in MySQL for instance we have this y ER diagram we got some employees we have departments we have projects and then we have some relations both one-to-many and many-to-many relations we have composite attributes like the address and the name we also have multivalued attributes and also derived attributes okay so how do we convert this into the relational data model first of all there is a conversion guide that contains steps to how you can translate each type from the ER diagram into the relational data model and this is basically what what we would use to do this so first of all I'm gonna take each of these entities and make a table first I'm gonna make some room for this diagram here first we take the employee we need to create a table for that go and select a table this is draw IO that I'm gonna use here because it's free and well suited to make er diagrams and also relational data models employee we call that it has a primary key of employee in 19 we can see we have a lot of attributes we have gender birth date and then we also have these two composite attributes and how do we convert them to the relational data model well we take only the simple part we cannot have any composite or multivalued attributes when we convert it so we will take the simple parts the street the postal code and the city so we will take Street and the city all right and if I can align this connection then we have the name which is also composite attribute and we follow the same procedure we will take this simple atomic part first name initials and last name all right okay so we have gender we have birthday we have streets postal code city first name Nationals last name and the primary key alright this is one of the first table let's get a new one we need one for Department and Department has a department ID we have a name and then we got this multivalued attribute called locations and how should we translate that well we need to create a new table we can just use this one here copy we will call this location we will make a primary key for it location ID and then the location and this we will later on connect to this department and in order to connect this we will make in here we will create a location and this will be a foreign key because it will relate to this primary key over here right so we have dealt with these then we need the project that's going copy this one and the project has project has a project ID also have a name and that is basically it alright so these are our four initial tables then we have some we have a couple of relations between them we have three one of many relations we have one many too many relation and if we start by if we start with the many many relation we can see here that an employee can work on multiple projects and a project can have multiple employees work on them so that's a...