Dean of Admission at DeAnza College has hired you to do the database design for

Question

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.)  

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

Explanation / Answer

The StudentID table was partitioned by range .This is because this table field is having minimum 10 digits at the least and also has a range.

Next the partitioning is done on Payment.ID table. This table uses a hash to be partitioned. We can see that both the StudentID in StudentRegistration table is same though it refers to payment and membership respectively. Both the fields are same.

This partitioning is useful in our implementation because the id’s may not be organized in an ordered way and hence using ranges to partition the table is not easy in this case as the former case.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.