Page 463 - Computer_Science_F5

Step 1: Entity identification
Computer Science We have three entities: Student, Course and Professor. Professor

Student
Course
FOR ONLINE READING ONLY

Step 2: Relationship identification
Analyse the relationships between students, courses, and professors. Consider the
constraints such as student enrollment in courses and professor assignment to
courses. You have two relationships: The student is assigned a course, and the
professor delivers a course.

Student Course Professor
Assigned Delivers

Step 3: Cardinality identification

From the problem statement, we know that, a student can be assigned multiple
courses, and at a time Professor can deliver only one course.

Student Course Professor

Assigned Delivers

Step 4: Identify attributes
To identify attributes, you need to study the files, forms, reports, and data currently
maintained by the organisation. You can also conduct interviews with various
stakeholders to identify entities. Initially, identify the attributes without mapping
them to a particular entity. Once you have a list of attributes; you need to map
them to the identified entities. Ensure an attribute is to be paired with exactly
one entity. If you think an attribute should belong to more than one entity, use a
modifier to make it unique. Once the mapping is done, identify the primary keys.
If a unique key is not readily available, create one.

Entity Primary Key Attribute
Student Student_ID StudentName
Professor Employee_ID ProfessorName
Course Course_ID CourseName

454
for Advanced Secondary Schools

Computer Science Form 5.indd 454 23/07/2024 12:34