id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
10	Entity Relationship Diagram and Relational model	139037	somebody	"
Entity Relationship Diagram
[[BR]]

  The basic constructs of the ER model are entities, relationships, and attributes. Entities are concepts, real or abstract, about which information is collected. As entities in the ER diagram which is below are: Appointment, Patient, lab, examination.

[[BR]]
Relational model
[[BR]]

The transformation of E-R diagram into relational model is an important step, because this model defines the tables that should be implemented in Access. This transformation is also very important because there can be seen in details which attributes are used as primary keys and which are foreign keys, this scheme also provides a better distinction between identifiers and descriptors which were mentioned above. 
The organization of data into relational tables is also known as the logical view of the database. That is the form in which a relational database presents data to the user and the programmer.

"	defect	closed	major		component1		fixed