Module_3_Exercises_-_MS_Office_2007 - Module 3 Exercises...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
115.107 Management Information Systems Module 3 Exercises Page | 2 Semantics Now, what does the diagram you are drawing in this exercise mean? It can be seen as representing the following business situation: There are students (potentially many), and there are paper offerings (potentially many distinct paper offerings). A student can be enrolled in zero to 4 paper offerings (it is OK for a student not to be enrolled in any paper offerings, but a student is not allowed to enroll in five or more paper offerings). A paper offering should have at least one student enrolled (presumably, if there are no students enrolled, the paper offerings would be cancelled). There is no limit on how many students can be enrolled in a given paper offering. Individual students or paper offerings are known as “entity instances”. Pairs of entity instances
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/01/2010 for the course PN 178.328 taught by Professor Sue during the Spring '10 term at Massey Palmerston North.

Page1 / 7

Module_3_Exercises_-_MS_Office_2007 - Module 3 Exercises...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online