Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Database design, application development and administration - Chapter 13: Database design for student loan limited

Chapter 13 - Database design for student loan limited. This chapter presents a case derived from discussions with information systems professionals of a large commercial processor of student loans. Servicing student loans is a rather complex business owing to the many different kinds of loans, changing government regulations, and numerous billing conditions. | Chapter 13 Database Design for Student Loan Limited Moderate size case to in which to apply knowledge and skills of Parts 2 to 6 - Based on loan processing system of a large student loan processor - Simplified to fit into one chapter: essential ideas but omitting complicating details - Real database is more than 150 tables Objectives: - Perform view modeling and view integration for a moderate size case - Perform schema conversion and normalization - Estimate workload - Perform index selection - Specify the data requirements for applications in a comparable case For details about the case that could not be shown in slides, see the file Chapter13FiguresTables. Outline Case description Conceptual data modeling Logical database design Physical database design Case description: - Workflow - Description of forms and reports Conceptual data modeling: - View modeling - Incremental view integration Logical database design: - Schema conversion - Normalization Physical database design: - Workload estimation - Index selections - Application development: data requirements Case Overview Guaranteed Student Loans Environment Student Lender Service Provider Guarantor Department of Education Replace existing information system Guaranteed student loans: - Subsidized and unsubsidized: interest paid during school on subsidized - Multiple GSL loans during school - Repayment begins after separation from school Student: receives loan from a lender Lender: makes loan with repayment guarantee from Department of Education Service provider: Student Loan Limited - Usually separate from lender - Collects payments - Tracks student status - Calculates repayment schedules Guarantor: audits work of the service provider Department of Education - Makes repayment guarantee - Notifies lenders of loan terms and amounts Loan Processing Workflow Apply Approve loan Originate loan Separate from school Send bill Make payment Miss payments Claim Apply: students apply to banks Approve loan: lender Loan . | Chapter 13 Database Design for Student Loan Limited Moderate size case to in which to apply knowledge and skills of Parts 2 to 6 - Based on loan processing system of a large student loan processor - Simplified to fit into one chapter: essential ideas but omitting complicating details - Real database is more than 150 tables Objectives: - Perform view modeling and view integration for a moderate size case - Perform schema conversion and normalization - Estimate workload - Perform index selection - Specify the data requirements for applications in a comparable case For details about the case that could not be shown in slides, see the file Chapter13FiguresTables. Outline Case description Conceptual data modeling Logical database design Physical database design Case description: - Workflow - Description of forms and reports Conceptual data modeling: - View modeling - Incremental view integration Logical database design: - Schema conversion - Normalization Physical database design: - .