Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Friday, January 16th, 2009Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 63 Patients Doctors Surgeons Nurses Training Employees Medicine Labs Machinery Academic Faculty Courses Trainees A standard documentation technique is to draw entities as rectangular boxes with enough space to hold many attributes. At this point, taking things one step at a time, you aren t quite ready to complete the attributes and relationships for your model. After you have identified the major nouns, you are ready to begin a diagram or sketch for the design. Rough paper or any of the previously mentioned software packages can be used for the design. These diagrams make up what is known as a data model diagram, better known as an entity- relationship diagram.(ERD) STEP BY STEP 2.2 ER Modeling To complete the entity portion of an ER model, you need to begin documenting the model. Try out these next two steps now to begin putting the picture together. 1. Draw the entities on paper and then, if desired, transfer them to computer. 2. Write a brief description of each entity. Answer to Step by Step 2.2: The following are the nouns that would most logically be made into entities. These nouns should have enough significance to be used; the other nouns possibly would be contained within some of these entities. Patient Machinery Employee Course Medicine Trainee
For high quality website hosting services please check tomcat web hosting website.