Dean of Admission at DeAnza College has hired you to do the database design for a new registration system. That has

1. College has several departments

2. Department offer several courses

3. Courses have sections.

4. College has locations (Room Sem 5 etc.)

5. Students register for a section from a catalog (which is composed of Departments, Courses, Sections, Location.)

6. Students have to pay for the course they take. You may want to think about resident, non resident.

QUESTION. Project which tables will increase quickly and implement partitioning types in at least 2 tables in your schema. Explain why these partitioning types would be useful in the context of your implementation. :

Resident Resident Id ResiName Fee schedule userId resides USER userId FirstName Last Name Address Telno ma Resident Type regld registers Payment Paymentld PaymentName regld (FH) pays StudentRegistration regld Studentld(fk) Section ld(fk) Fee status Paymentld(fk) Sectionld (FK) Student (FH) Location Locid Location Name Section Section ld Section No Courseld(fk) Locld (fk) starttime end time startdate enddate userId College S lol olegeld Name Address Telno Locid (FK) Deptid has Department Deptid Name Locid Collegeld (fk) Courseid (FK) offers Course our seid Course No Course Name Prereq Deptid (fk) Sectionld has