Homework_08 - Spring 2010: ISAM 5331 / ACCT 5333 Homework...

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

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331 / ACCT 5333 Homework Assignment 08 Assignment Details: 1. Review and analyze the studb_schema_install.sql script used in Homework 3 and create an ERD in Microsoft Visio that accurately details the existing database structure and the relationships. Note: Be sure to configure Microsoft Visio to use Crow’s Foot notation and show the data types . school PK sch_code VARCHAR(8) sch_name VARCHAR(50) sch_name VARCHAR(12) sch_dean VARCHAR(20) advisor PK adv_code VARCHAR(8) adv_lname VARCHAR(15) adv_fname VARCHAR(15) adv_phone VARCHAR(15) FK1 sch_code VARCHAR(8) major PK maj_code VARCHAR(12) maj_desc VARCHAR(30) sch_code VARCHAR(8) maj_adv PK,FK2 maj_code VARCHAR(12) PK,FK1 adv_code VARCHAR(8) student PK std_code VARCHAR(9) std_lname VARCHAR(15) std_fname VARCHAR(15) std_gen VARCHAR(8) maj_code VARCHAR(10) std_dob DATETIME Grade1 PK,FK1 std_code VARCHAR(9) GR_T01 NUMERIC(10,2) GR_T02 NUMERIC(10,2) GR_HW01 NUMERIC(10,2) GR_HW02 NUMERIC(10,2) GR_HW03 NUMERIC(10,2) GR_HW04 NUMERIC(10,2) GR_HW05 NUMERIC(10,2) GR_HW06 NUMERIC(10,2) GR_HW07 NUMERIC(10,2) GR_HW08 NUMERIC(10,2)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Homework_08 - Spring 2010: ISAM 5331 / ACCT 5333 Homework...

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