《数据库原理》(双语)教学大纲_English.doc

Database PrinciplesCourse Syllabus1、 Course Number: 0403052、 Course Type: Optional-limitedCourse periods: 32 hours (Theoretical 24 / Practical 8)Supported Majors: Communication Engineering，Electronic and Information Engineering，Electronic Information Science and Technology，Information EngineeringPre-Course: Introduction to Computer Science，C Programming Language3、 Course Quality and MissionDatabase technology has become the core technology and an important base of computer information systems and application systems. Database Principles is a backbone course of Computer Science & Engineering and other related disciplines. Through the study of theory and practice in this course, students should grasp the basic concept of database systems and basic theory. Besides, we should focused on the study of relations between the relevant content database system, use SQL proficiently, master the theories and methods of designing database, master basic skills of database systems operation and maintenance, understanding of database technology developments.4、 Teaching Outlines and Periods4.1 The worlds of database system (2 hours)4.1.1 Data Management Technology and Development4.1.2 Basic Concept of Database System4.1.3 Architecture of Database System and Application System4.1.4 Contents of Database System4.2 Database Models (2 hours)4.2.1 Information Modeling Period4.2.2 Concept Model and Data Model4.2.3 Entity/Relationship Model4.3 Relational Data Model (4 hours)4.3.1 Foundation of Relational Model4.3.2 Methods of Transforming E-R Model to Relational Model4.3.3 Relation Decomposing Theories and Methods4.3.4 Data Dependence4.3.5 Database Design4.4 Relational Algebra (2 hours)4.4.1 Relational Algebra Languages4.4.2 Characteristics/operator/ expression of Relational Algebra 4.5 Standard Relational Database Language: SQL (6 hours)4.5.1 Characteristics of SQL4.5.2 Data Definition Statements4.5.3 Data Query Statements4.5.4 Data Update Statements4.5.5 Definition and Use of View4.5.6 Data Control Method4.6 Transactions Management (2 hours)4.6.1 Concept and Characteristics of Transaction4.6.2 Database Recovery Technology4.6.3 Database Concurrency Control Technology4.7 Developing Platform and Tools (2 hours)4.7.1 Database Security and Control Method 4.7.2 Integrality Constraints and Control 4.8 Latest Database Technology (4 hours)4.8.1 Trend of Database System4.8.2 Application Fields of Database5、 Basic Teaching Requirements The theoretical knowledge and practical ability of this course are both important, and has good application background. Through studying of theoretical and practical knowledge, the basic teaching requirements for the students are divided into three levels: 5.1 Master: Belonging to the higher demand, the master of content should be more thorough understanding, can analysis and handle problems skillfully in the real environment.5.2 Understand: Belonging to the general request, understand relevant content in-depth, can analysis and handle general issues5.3 Know: Belonging to lower demand, understand the contents of the phenomenon in which the issues involved in, structures or related experiments. 6、 Main Teaching Contents6.1 Grasp the concept of data management technology and its development process; master database , database management systems, database systems and other basic concept; grasp the characteristics of database system; grasp the concept of data models and the abstract processing of information modeling, understand and distinguish concept model and data model; can describe the conceptual model using E/R graph; master popular database model and its characteristics; master relational model and related terms; master database structure, three-mode & two-mapping, and on the basis of this data independence guarantee, understand database system composition from the view of hardware, software and the user; understand the architecture of popular database application system.6.2 Master the data structure of relational model, relational operation and integrity constraints; master the type of relational-data language; master formalized-definition in the view of set-theory, including concepts of domain, Cartesian plot, relationship, code, attributes, tuple, relational databases and so on; understand the relationship and distinction between relation and relational-mode; can describe queries sent by user using relational algebra language.6.3 Master data definitions, data query, data update, the definition and query of view, data control statements; master embedded SQL and can embed SQL in C programming language; understand ODBC, JDBC interface.6.4 Master standardized theory and the basic concept of data dependency; grasp the basic idea, the essence and purpose of standardization process; master the definition of 1 NF, 2NF, 3NF, BCNF paradigm, be able to judge which paradigm a relational-mode belong to.6.5 Master features, basic steps and the mission of every design stage during database designing; establish the concept of software engineering; focus grasping the features, methods and results of concept-designing and logic-designing; master data abstract methods and can use E/R graph when describe entities, attributes, relations and codes; master approach of converting E/R model into relation mode.6.6 Grasp the concept and features of transactions; master the role of database recovery mechanism and the significance, as well as various types of failures and the possible impact to the database; master database recovery technology, such as data dump, log; master the database recovery strategy when fault is targeted.6.7 Master and analysis the potential inconsistencies of database during concurrent operation; master the concept and significance of concurrent control; master the embargo-lock technology and protocols of concurrent control.6.8 Understand the concept and methods of database security and safety; understand the integrity constraints, integrity control mechanism and its implementation.6.9 Learn new database technology (by teachers from the optional talk)7、 Requirments on the Extra-curricular Work7.1 For TeachersIn principle, each knowledge point of the chapter should be consolidated by enabling students through the appropriate amount of exercise. Extra-curricular work can be designed like the forms of thinking, calculating, comprehensive-reporting and so on. Generally, thinking work has a theoretical depth, and is not necessarily to be submission, but should encourage students conducting in-depth thinking. The purpose of calculating work is to practice a certain point by the exercise. Comprehensive report is suitable for large-scale designing or developing project, and students can complete it in a team with submitting a formal report. The comprehensive training should focus on the students thinking, hands, collaborating and writing skills. The homework or the report must be marked within two weeks, and give explanation at the appropriate time.7.2 For StudentsStudents must complete and submit exercises within the specified time limit. Should be completed independently, give full play to individual initiative, positive thinking, no copying.8、 The Relations between This Course and the Follow-up CoursesThis course mainly about the senior data management techniques, involving database-model analyzing, designing and application developing. The core part of Database management system related to the data storage, indexing, query processing and optimization, buffer management, concurrency control, recovery and so on. Studying this course well means mastering the advanced data management techniques, and can be applied to various segments or areas where data management is needed. By the content of this course, it will closely related to other courses, such as the principle of compilers, computer networks, software engineering, advanced database technology, data warehousing, data mining, artificial intelligence, and so on.9、 Requirements for the Ability of StudentsThis course will not only require students to study the theoretical knowledge hard, but also to take the initiative in the creation, practice in the real environment and application development. As there are lots of development environments, they can not be detail introduced in the classroom, which requires students to take the initiative to understand the market on commercial products and the skills of developing tools. Furthermore, in order to meet the goal of professional and opened-vision, we must improve the learning ability by increasing the use of English professionally with network platform and read the latest English literature.10、 Reference books and teaching materials10.1 A First Course in Database Systems(second edition), Jeffrey D.Ullman, Jennifer Widom, China machine press, 2007.10.2 Database System Introduction（The 4th Edition）. Wang Shan, Sa ShiXuan, High Education Press. 2006.10.3 Silberschatz, Korth and Sudarshan. Database System Concepts. China Machine Press and McGraw-Hill. 1999.10.4 Patrick ONeil and Elizabeth ONeil, Principles, Programming, and Performance. Higher Education Press and Morgan Kaufmann Publishers. 2001.11、 Teaching Methods and the Using of MediaAs there is quite a number of flexible and designing knowledge in this course, teaching methods need to be used in the course of heuristic, discussion-style. Students should be mobilized