Question

use IE Crow's Foot notation to make an E-R diagram. provide entity names and identifiers for each entity, along with all necessary relationships between entities, including minimum and maximum cardinalities

A professor wants to use a small database to track information about personal student software use during a course. He would like to store student names and email addresses, the name and installation instructions of each type of software required for the course, and the date each student installed the software on their personal machine.

Assume that there are multiple different software packages available for use during the class. Assume that students are not required to download the software on their personal machine, but they can choose to download any of the multiple software programs, and the professor wants to keep track of which students download which software on their personal machine so that he can better assist them with the homework.

Answer 1

No of entities according to the given Database

• 1. Professor entity: Attributes are { professor_id , name , phone_no}
• 2. Student entity : Attributes are { Student_ID , Student_name, email_address ,phone_no}
• 3. Personal Machine entity :Attributes are { IP_address , modelNo , OperatingSystem}
• 4. Software entity: Attributes are {name , Installation_instruction ,Installation_date}

Relationship between Entities

1. There are Track relationship between Professor entity , Student entity and Software entity
2. There are BelongsTo relationship between PersonalMachine entity and Student entity
3. There are Installed In relationship between PersonalMachine entity and Software entity
4. There are Use relationship between Student entity and Software entity

Cardinalities between entities:

1. There are 1:M cardinalities between Professor entity and Student entity
2. There are 1:M cardinalities between Professor entity and Software entity
3. There are M:M cardinalities between Student entity and Software entity
4. There are M:1 cardinalities between Software entity and Personal Machine entity
5. There are 1:1 cardinalities between Student entity and Personal Machine entity.

ERD:

Thank you.....................