tailieunhanh - 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: - .

• Cơ sở dữ liệu
• Database design
• Database development
• Relational databases
• Database environments
• Database design
• Student loan limited
• Database Systems
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Database system concepts
• Lecture Database system concepts
• Database languages
• Relational database design
• Physical database design
• Physical records
• Database System
• Lecture Database Systems
• Fundamentals of database systems
• Relational database design algorithms
• Lecture Database System
• Practical database design and tuning
• Database tuning in relational systems
• Database design process
• Database management
• Database characteristics
• Database administration
• Database specialists
• Application design
• Object database management systems
• Object database
• Enhanced ER Model
• Database design modeling tools
• Design choices
• Logical database design
• Relational tables
• Database system architectures
• View design with forms
• View integration
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Client server processing
• Parallel database processing
• Multivalued dependencies
• Database management systems
• Fundamentals of database management systems
• Object oriented database management
• Data administration
• Relational design
• Database concepts
• Lecture Database concepts
• Database fundamentals
• Database processing environment