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

《Database Principles》Course 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 Algebra4.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 Method4.7.2 Integrality Constraints and Control4.8 Latest Database Technology (4 hours)4.8.1 Trend of Database System4.8.2 Application Fields of Database5、Basic Teaching RequirementsThe 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 realenvironment.5.2Understand: Belonging to the general request, understand relevant content in-depth, can analysis and handle general issues5.3Know:Belonging to lower demand, understand the contents of the phenomenon in which the issues involved in, structures or related experiments.6、Main Teaching Contents6.1Grasp 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 di stinguish ‘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.2Master 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.3Master 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.4Master 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.5Master 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, relationsand codes; master approach of converting E/R model into relation mode.6.6Grasp 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.7Master 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.9Learn 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 ofDatabase 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. ChinaMachine Press and McGraw-Hill. 1999.10.4 Patrick O’Neil and Elizabeth O’Neil, Principles, Programming, andPerformance. 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 and think enthusiastically, and it is necessary to fully affirmed the innovation of students. As the relatively information of this course may be quite alarge amount, and also there will be a lot of text description information, we recommend the method of using multimedia equipment, together with writing on the blackboard. When it comes to the introduction of a database product or developing tools, the PPT files should be beautiful, intuitive courseware, so that the student s’ interest in learning can be fully exploded.12、Learning Methods and RecommendationsAs the contents of this course are mostly involved in the real application background, it will not be very abstract. However, the relevant knowledge can only be grasped to the essence after practicing, which can also help accumulating the corresponding development experience. So the learning process should combine the theory with practice. At the same time, we should also strive to raise the professional standard of English, particularly the listening and speaking ability.。