This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Spring 2010: ISAM 5331.01 / ACCT 5333.01 Copyright 2010 Richard Meyer. All rights reserved. This material may not be reproduced, displayed, modified or distributed without the express prior written permissions of the copyright holder. Homework Assignment 03 1. Creating an Entity Relationship Diagram Create an ERD using Microsoft Visio or other ERD graphical tool from the following description and rules: Note: Be sure to include your name on the ERD and print a copy ! Hint: You will need to create attribute identifiers that are not listed for these entities to establish relationships! 1. Entity Name: Schools a. Attributes : i. School Code Identifies a unique school ii. Name The name of the school iii. Phone Number The primary phone number for the school or their dean iv. Dean The name of the schools dean b. Rules & Relationships : i. A school code must be unique 2. Entity Name: Majors a. Attributes : i. Major Code Identifies a unique major ii. Description A description or name of the major b. Rules & Relationships : i. Major Code must be unique ii. A major is a child of a school; many majors can be assigned to one school 3. Entity Name:...
View Full Document
This note was uploaded on 10/09/2010 for the course MIS 5339 taught by Professor Gercek,g during the Spring '10 term at UH Clear Lake.
- Spring '10