CreatinganERDusingMicrosoftVISIO.docVIP

Creating an ERD using Microsoft VISIO In this exercise, you’ll use VISIO to create the ERD shown here. Open VISIO. Select Software and Database from the list of template categores (shown on the left). Select Database Model Diagram. (If you don’t see the option to select a drawing type, select File from the menu bar then select New … Software and Database from the list of templates. If you don’t every see Software and Database as a template option, you probably don’t have the correct version of Visio installed. Use a computer in the BC lab.) Drag-n-drop an entity from the Shapes panel (on the left) into the drawing grid (on the right). Change the generic name initially provided by typing “Patient” for the Physical name and Conceptual Name in the Database Properties panel (lower right). In the Database Properties panel, switch to the Columns category. Type the name of an column (an attribute). Type FNAME then click the Edit button to change the default fields size of 10 characters. Select the Data Type tab and change the field length to 12 and switch from “fixed length” to “variable length.” Enter the columns names shown here. Modify the Patient_ID column data type as shown below. Reduce the “precision” of the field which give the total number of digits the field can have. Set the scale to zero, which means only integers will be stored. (The scale value determines how many digits to the right of the decimal place are allowed.) Also, make the patient name fields required (see above) and make Patient_ID the primary key (PK). Create a second entity called Appointment and create the columns as shown below. Designate all the columns as required and mark Appt_ID as the primary key. Create a relationship between the PATIENT and APPOINTMENT entities. What is this relationship? Any one patient (Bill Jones, for example) may have no appointments but may have many. Any one appointment (#