00:01
To be need to draw er which is entity relationship diagram for define need.
00:10
So basically in this case, we need to draw the diagram so i can give you a step so can you can easily able to draw so we i need to identify the entities attributes and relationship between them.
00:34
So based on the provided information the following entities can be used first we can talk about the entities.
00:43
So what are entities are available number one user director of research third is foundation fourth one is facility fifth one is employee and six one is project.
01:12
Now, these are entities next one is attributes.
01:18
We are discussing of each entity.
01:21
So when we talk about the first user, so there is no specific attribute no specific attribute mentioned in the provided information when we talk about the second entity, which is director of research so we can say no specific attribute is provided for third foundation also, no specific attribute mentioned in provided information when we talk about the fourth one which is facility.
01:57
So here attribute is number one facility id, which is primary key then facility name and then number of employees then fifth one is employee.
02:25
So here it is given employee id, which is primary key then first name last name then facility id, which is foreign key and project id, which is also foreign key.
02:56
Now the next one is project.
03:00
So for project attributes are project id, which is primary key then project name project name and then status active or inactive.
03:23
Now, we can talk about the third at the third is relationship between entities relationship between entities can determine below like director of research has a relationship with user.
03:40
We can say director of research has relationship with user...