东南大学数据库英文教案7

教学大纲（数据库教学大纲（双语））发布时间：2016-01-10 发布人：superadmin 访问数量：93陕西师范大学本科计算机科学与技术、软件工程、信息管理与信息系统专业理论课教学大纲数据库原理与应用（双语）学时：72 学分：4.5课程属性：专业必修课开课单位：计算机科学学院先修课程：程序设计、数据结构、操作系统、编译原理等一、课程的性质数据库技术是计算机科学的重要分支，也是信息领域的核心技术与重要支撑。

在2002年编写的《中国计算机科学与技术学科教程》中，数据库课程被明确规定为计算机科学与技术学科专业的核心课程之一。

数据库原理课程是一门理论性和实践性都很强的课程，具有知识体系完整、理论丰富、实践性强、数据库技术发展迅速等特点。

近年来，数据库技术不断发展、创新、完善，并广泛应用于社会各行各业，特别是随着Internet的发展与普及，基于网络和数据库技术的信息管理系统、应用系统得到了飞速的发展与深入广泛的应用，作为其后台与基础的数据库技术也在不断的发展中被赋予了新的能力，成为发展最快、应用最广的技术之一。

目前绝大多数计算机应用都需要数据库技术的支撑，数据库已经成为计算机信息系统与应用系统的核心技术和重要基础。

在该课程的教学中，不仅应教会学生数据库的知识本身，使学生能够正确理解数据库的基本原理，熟练掌握数据库的设计方法和应用技术，更应激发学生对数据库及相关知识的兴趣，培养学生独立探求新技术、新方法的能力，使其成为适应能力强、并富有创造才能的专门人才。

课程的深入学习对增强学生的计算机科学理论素养，提高计算机技术应用水平，培养专业素质与创新能力有明显的帮助。

近年来，计算思维作为人类科学思维的基本方式之一，受到国内外计算机界的广泛关注。

ACM 和IEEE-CS在修订后的计算机科学教程2008（Computer Science Curriculum 2008）中明确指出应将计算思维作为计算机科学教学的重要组成部分。

IntroductionThe database system is one of the most essential tools used in managing and storing data in an organized andefficient manner. Understanding the basics of database management systems has become a fundamental requirement in the field of computer science and information technology. A beginner’s guide to database systems is a necessary resource for both students and professionals seeking to advance their knowledge in this field.The Database System Basics Tutorial, Third Edition, is an exceptional resource for learning database system fundamentals. The tutorial provides a comprehensive overview of database systems and their application to real-world scenarios. This document presents an instructional design for using the tutorial material in a classroom setting for teaching database systems to beginners.Learning ObjectivesThe primary goal of this instructional design is to equip students with the essential knowledge and skills required for managing and building databases. Upon completion of this course, students should be able to:1.Define the fundamental concept of database systemsand their applications.2.Describe the architecture of the database systemmodel.3.Understand the concepts of database designincluding data modeling, normalization, and relational database management system.4.Develop standard SQL queries and understand thedifferent SQL operators and clauses.5.Create and execute basic SQL commands to manipulatedata.6.Understand the concept of transaction management.7.Evaluate the different types of data storagetechniques and data warehousing.8.Analyze and efficiently manage database systemsecurity and integrity.Course OutlineWeek 1: Introduction to Database Systems•Overview of Database Management System (DBMS).•Types of database systems.•Importance of database systems.•Basic database terminologies.Week 2: Database System Architecture•The database system model.•Levels of abstraction in a database system.•Data independence concept.•Client-server model in database systems.Week 3: Data Modeling and Database Design•Data modeling concepts.•Types of data models.•Transitional diagrams and entity-relationship modeling.•The process of designing a database.Week 4: Relational Database Management System (RDBMS) •Concepts of a relational DBMS.•Structured Query Language (SQL) overview.•Types of SQL commands.•Basic SQL queries-SELECT, INSERT, UPDATE, DELETE. Week 5: Advanced SQL•Aggregate functions in SQL.•Subqueries in SQL.•SQL connectivity tools.•Join and union operations.Week 6: Transaction Management•The concept of transaction management.•Transaction properties and states.•Distributed transaction management.•Database locking mechanisms.Week 7: Database System Storage•Data storage techniques.•Data warehousing.•Data mining and big data concepts.•The concept of data compression.Week 8: Database System Security and Integrity•Data security and privacy.•Database system security measures.•Security threats to database systems.•Integrity constrnts in database design.Teaching MethodologyThe teaching methodology will primarily consist of the following: - Lectures: Lecture sessions will be conducted in the classroom to provide students with an overview of the week’s topic. The lecture will serve as a guide for students to read and comprehend the material provided in the tutorial.- Class discussion: This session will allow students to exchange thoughts on the topic of the week. Class discussion will be moderated to ensure the relevance and quality of the discussion. - Assignments: Students will be provided weekly assignments to gauge their understanding of the topicscovered in the lecture. Assignments will be based onexercises drawn from the tutorial and will contribute to the final grading of the course. - Project Work: The project work will be individual or group-based and will enable students to apply the knowledge learned in the course. The project will contribute significantly to the final grading of the course.- Co-learning session: The co-learning session is designed to enable students to collaborate on the topic of the week. Collaborative learning encourages knowledge-sharing between students and enhances their understanding of the course material.ConclusionThe Database System Basics Tutorial, Third Edition, is a practical resource for learning database systems fundamentals. This instructional design provides lecturers with precise guidance on teaching database administration to beginners. By using this instructional design, students will receive an in-depth understanding of database administration, enabling them to apply their knowledge in real-world databaseadministration situations.。

A First Course in Database Systems 第三版教学设计课程简介本课程主要介绍数据库系统的基本概念、原理和应用技术。

学生将会学习到数据库系统的设计、建模、管理和优化等方面的知识，以及数据库应用程序的开发和部署技术。

教学目标1.理解数据库系统的原理和架构。

2.掌握数据库设计和建模的方法和技巧。

3.熟悉关系型数据库和SQL语言的基本操作和应用。

4.能够设计和实现简单的数据库应用程序。

教学内容本课程主要涵盖以下章节：1.数据模型与关系模型2.数据库设计与规范化3.SQL语言和基本操作4.高级SQL和视图5.查询优化和索引6.事务和并发控制7.数据库安全和备份8.数据库应用程序开发教学方法本课程采用讲授、实践和案例分析相结合的教学方法。

具体包括教师授课、学生讨论、小组演练和课堂展示等环节。

同时，将提供实际案例和项目，供学生应用所学知识进行实践操作。

评估方式本课程的评估方式包括平时作业、实验报告和期末考试。

平时作业占总成绩的20%，实验报告占总成绩的30%，期末考试占总成绩的50%。

教材本课程所采用的教材为A First Course in Database Systems, Third Edition，作者为Jeffrey D. Ullman和Jennifer Widom。

参考资料1.Database Management Systems, Third Edition，作者为Raghu Ramakrishnan和Johannes Gehrke。

2.Database System Concepts, Sixth Edition，作者为Abraham Silberschatz、Henry Korth和S. Sudarshan。

3.Fundamentals of Database Systems, Sixth Edition，作者为Ramez Elmasri和Shamkant B. Navathe。