Homework_03 - Spring 2010: ISAM 5331.01 / ACCT 5333.01...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 5

Homework_03 - Spring 2010: ISAM 5331.01 / ACCT 5333.01...

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

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