A University has adopted a personal identity card ( PID ) system to…

Question Answered step-by-step A University has adopted a personal identity card ( PID ) system to… A University has adopted a personal identity card (PID) system to improve security and to restrict access to certain groups of people (such as students, teachers, professors , secretaries, managers etc) and at certain times and dates. A person is issued a PID card as soon as they become part of the University community (either employed or on a course of study). Each person belongs to only one group which determines what buildings they can access.To enter a building, a person (each having a unique personID) must have permission which is established when their PID card is swiped through a PID card reader outside the building they wish to enter. A PID card reader is located outside the door of a building users wish to access. Permission is granted only if their access credentials are successful. If access is allowed, the captured data is logged, recording the date, personID (from the PIDcard) and the PIDreaderID. a) Produce an ERD of the above scenario. State the notation you used and include in your ERD model.  (20 marks) Cardinality expressed as either 1:M or M: N.Primary keys and sample attributes. b) Derive relation model from your ERD. (10 marks) Computer Science Engineering & Technology MYSQL DBS 211 Share QuestionEmailCopy link Comments (0)