{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Module_3_Exercises_-_MS_Office_2007

# Module_3_Exercises_-_MS_Office_2007 - Module 3 Exercises...

This preview shows pages 1–3. Sign up to view the full content.

115.107 Management Information Systems Module 3 Exercises Page | 1 Module 3 Exercises 1 Topic Design a simple ER model of a database meeting business requirements specified in natural language (English). Render the ER diagram electronically by using Microsoft Word. 2 Relevance to Assignments These exercises will prepare you for completing Part 1 of the Assignment. 3 Exercises 3.1 Drawing an ER Diagram 3.1.1 Overview Draw the following diagrams by using Microsoft Word: Some tips: 1) After opening Microsoft Word, keep the Zoom value (on View tab) as 100%, so that the elements of the diagram appear large enough and easy to work with. 2) To depict rectangles (representing in ER notation “Entity Types”); use the Rectangle from the Basic Shapes of Drawing Tools . 3) To depict the line connecting the rectangles (representing in ER notation “Relationship Types”); use the straight connector (line) with no arrows from the Basic Shapes of Drawing Tools . A connector is a line that has connection points at the ends of the line and stays connected to the shapes that you attach it to. After you choose a connector, circular dots appear on shapes as you move your pointer over them. When you rearrange shapes that are joined with connectors, the connectors remain attached to and move with the shapes. 4) To depict number ranges, such as 0..4 (representing in ER notation “Multiplicity Constraints”), use the Text box from the Basic Shapes of Drawing Tools . Number ranges representing multiplicity constraints are supposed to be located near the ends of the connectors (“relationship types”) they adorn. Unfortunately, in Microsoft Word it is not possible to “attach” labels like this to connectors, so every time you drag the rectangles around, you have to adjust the positions of labels representing multiplicity constraints manually. As usual, it is preferable that you do all that without using the step-by-step instructions, however, these are provided in section 3.1.2 in case you encounter insurmountable difficulties. Student Paper Offering 1..* 0..4 enrolled in

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document