How to Draw Entity Relationship Diagrams using MS PowerPoint

1 How to Draw Entity Relationship Diagrams using MS PowerPoint Featuring Crows Foot and UML Notations Richard Holowczak Computer Information Systems Zicklin School of Business Baruch College, CUNY Richard_Holowczak@baruch.cuny.edu September 21, 2009 Step 1: Create a blank presentation Step 2: Insert a new, completely blank slide as below: 2 Step 3: If you do not see the drawing tools on the tool bar, make certain they are displayed View -> Toolbars -> Drawing This toolbar is usually at the Bottom

of the screen Model: Salon – Core Business Creation Date/Time: August 30, 2002 8:01 PM Modified Date/Time: September 9, 2002 3:45 PM Last Modified by: R. Holowczak Step 4: Create a legend on the diagram Use the Text Box drawing tool Include what the ER model represents, when it was Created and last modified and who modified the diagram 12 pt. font Gray background 3 Customer -CustomerID (id) -FirstName -LastName -CustPhone -Street -City -State -Zip Model: Salon – Core Business Creation Date/Time: August 30, 2002 8:01 PM Modified Date/Time: September 9, 2002 3:45 PM Last Modified by: R. Holowczak Step 5: Create an entity Use the text box tool - Format the box with a solid border - Make the Entity name Bold - Use the space bar to center - Make dashes to indicate the attributes - Put (id) next to the identifier(s) 14 pt. font size and 2 pt. sized black border SalonService -ServiceID (id) -ServiceName -ServiceDuration -ServicePrice Customer -CustomerID (id) -FirstName -LastName -CustPhone -Street -City -State -Zip ServiceRendered -LineItemNumber (id) -ServiceExtendedPrice Appointment -AppointmentID (id) -AppointmentDate -AppointmentTime Model: Salon – Core Business Creation Date/Time: August 30, 2002 8:01 PM Modified Date/Time: September 9, 2002 3:45 PM Last Modified...

Website: cisnet.baruch.cuny.edu | Filesize: 224kb
No of Page(s): 6
Download 1 How to Draw Entity Relationship Diagrams using MS PowerPoint Featuring Crows Foot and UML Notations Richard Holowczak Computer Information Systems Zicklin School of Business Baruch College, CUNY Richard_Holowczak@baruch.cuny.edu September 21, 2009 Step 1: Create a blank presentation Step 2: Insert a new, completely blank slide as below: 2 Step 3: If you do not see the drawing tools on the tool bar, make certain they are displayed View -> Toolbars -> Drawing This toolbar is usually at the Bottom

of the screen Model: Salon – Core Business Creation Date/Time: August 30, 2002 8:01 PM Modified Date/Time: September 9, 2002 3:45 PM Last Modified by: R. Holowczak Step 4: Create a legend on the diagram Use the Text Box drawing tool Include what the ER model represents, when it was Created and last modified and who modified the diagram 12 pt. font Gray background 3 Customer -CustomerID (id) -FirstName -LastName -CustPhone -Street -City -State -Zip Model: Salon – Core Business Creation Date/Time: August 30, 2002 8:01 PM Modified Date/Time: September 9, 2002 3:45 PM Last Modified by: R. Holowczak Step 5: Create an entity Use the text box tool - Format the box with a solid border - Make the Entity name Bold - Use the space bar to center - Make dashes to indicate the attributes - Put (id) next to the identifier(s) 14 pt. font size and 2 pt. sized black border SalonService -ServiceID (id) -ServiceName -ServiceDuration -ServicePrice Customer -CustomerID (id) -FirstName -LastName -CustPhone -Street -City -State -Zip ServiceRendered -LineItemNumber (id) -ServiceExtendedPrice Appointment -AppointmentID (id) -AppointmentDate -AppointmentTime Model: Salon – Core Business Creation Date/Time: August 30, 2002 8:01 PM Modified Date/Time: September 9, 2002 3:45 PM Last Modified...

Website: cisnet.baruch.cuny.edu | Filesize: 224kb
No of Page(s): 6
Download How to Draw Entity Relationship Diagrams using MS PowerPoint