A2 - CS 338: Computer Applications in Business: Databases...

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

View Full Document Right Arrow Icon
CS 338: Computer Applications in Business: Databases (Winter 2012) Assignment 2 ( Due in class on Tuesday, February 28, 2012) Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social insurance number, current address, permanent address, cell phone number, home phone number, birth date, gender, major department, minor department (if any), and degree program (B.A., B.S., . .., Ph.D.). Some user applications need to refer to the city, province, and postal code of the student's permanent address, and to the student's last name. Both social insurance number and student number have unique values for each student. (b) Each department is described by a name, department code, office number, office phone, and college. Both name and code have unique values for each department. (c)
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 / 2

A2 - CS 338: Computer Applications in Business: Databases...

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