Question

Name at least 4 entities, some sample attributes for each entity, and the primary key field for each entity, in a university environment

Answer 1

An entity in dbms can be a real world objects, it can be a living thing and non-living thing.

Whereas, attributes are the properties of an entity.

Lets take your example of University environment:-

We can think of many entities for university like Student, Teacher, Department and Subject.

Attributes of different entities:-

1. Student
   • StudentID (Primary Key)
   • StudentName
   • Address
   • ContactNo
2. Teacher
   • TeacherID (Primary Key)
   • TeacherName
   • Salary
   • Department
3. Department
   • DepartmentID (Primary Key)
   • DepartmentName
   • Semester
4. Subject
   • SubjectID (Primary Key)
   • SubjectName

For you better understanding I created diagram thats shows the relationship between each entities.