TOPIC : Collect one example for mapping of ER model to relational model.

ENROLLMENT SYSTEM

ER diagram of an enrollment system is given below.

Student enrolls lectures by enrollment. Lecturer leactures subject through lecture.

Student is uniquely identified by NID. It also consists Lastname, Firstname, Address, birthdate.

Lecturer is uniquely identified by lecture_ id . It also consists of lectures lastname , firstname, email id, address.

Lecture is uniquely identified by cc#. It also consists of subject, time, date, lecture name.

Enrollment  is uniquely identified by student_num. It also consist of date of enrollment , coursename, cc#.

Subject_is uniquely identified by subject_code. It also consists of subject_unit, subject_udsc.

ER DIAGRAM

RELATIONAL MODEL

 

 

Advertisements