VOIP Project: Database modeling - Part 2
As mentioned in the part 1 of this project, the system which is created during this project contains 3 main components and one of them is the database. In this part we will cover the design of the database. For creation of Entity-Relationship Diagram(ERD) of the database of the system is used the community edition of visual paradigm application. Below, in the figure 1, is show the diagram of the database used by the system. As shown in the picture in consists in 6 tables: cit_classroom, cit_subject, cit_scheudle, cit_sip_account, cit_consultation, cit_user . The table cit_classroom as described by its name, contains information about the classroom, labs and lesson classrooms. It has 2 columns, Id , which is of type varchar(10) and contains the name of the classroom, for example: lab2 or D3 , which is unique and is this case is used as primary key. The next column is the Capacity , of type int(11), in which is stored information of the number of the students that the classroom ...