Day 6 Modeling - Course Discipline Semester Registration...

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

View Full Document Right Arrow Icon
Modeling Exercise
Background image of page 1

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

View Full DocumentRight Arrow Icon
Academic Database Design a database to support the academic component of a typical university Ignore: Non-Academic Staff Faculty Payroll Dorms Athletics Etc
Background image of page 2
Major Functions to Support Registration Class Rosters Transcript Generation Faculty Course Load Reports Major/Minor Reports Scholarship Analysis
Background image of page 3

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

View Full DocumentRight Arrow Icon
Major Tables Students Faculty Disciplines (majors & minors) Courses Registration & Grades
Background image of page 4
Major Relationships Students-Disciplines At most one Major At most one Minor Faculty-Discipline Exactly one Department Faculty-Course No team teaching Student-Course M:N No double registration
Background image of page 5

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

View Full DocumentRight Arrow Icon
Major Indices Students SID, EID, etc LN/FN Major Minor Faculty FID, EID, etc SSN LN/FN Discipline
Background image of page 6
Major Indices Disciplines Discipline College Courses
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11

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

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

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

View Full DocumentRight Arrow Icon
Background image of page 14
Background image of page 15

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

View Full DocumentRight Arrow Icon
Background image of page 16
Background image of page 17

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

View Full DocumentRight Arrow Icon
Background image of page 18
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Course Discipline Semester Registration & Grades SID CID Normalization 1NF PK for every table One value per field One field per value 2NF One subject per table 3NF No "computed" values Modification: Team Teaching Original model required each class to have exactly one faculty Allow one or more faculty to teach a class Modification: Dual Majors Original model allowed each student to have at most one major and one minor Allow a student to have at most two majors, but still just one minor Modification: Multiple Majors/Minors Allow a student to have any number of majors and minors But, don't allow any duplicates Final Modification: Tuition Generate a fee bill Allow a student to use scholarships and external payments to cover their bill...
View Full Document

Page1 / 18

Day 6 Modeling - Course Discipline Semester Registration...

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

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