Use Microsoft Visio to write DBDL and create a ERD . 

 

InstructorNu instructor Rank jm 123 Professor 104 Asst Prof 118 Assoc Prof 1120 Assoc Prof instructor Name Ghee Rankin Ortega Smith depCode CIS CHEM CIS ENG DeptName Student D 1215, 2315, 3293 Computer Info System KDD-567 2218, 2098 Chemistry mentor Office English BLF-119 3102, 2782 3456, Computer Info System KDD-562 2378 PRT-345 2002, 2046, 2018, 2764 2134, 2789, 3311, 2008, 2876, 2222, 3745, 1783, 2873, 2765, 2238, 2901 2308 Student Names CommitteeCode JournalCode. PROMO,TRAF APPL,DUMIS, QED,JMGT Each student ID has a first DEV and last name SPR, TRAF PROMO.SPR. DEV JCIS, JMGT Committee Journal meeting description Location Each code Every has a Committee description has a location Committee name Every Committee has a name