《数据库原理》(双语)授课计划_English.doc

Database PrinciplesLecture PlanTeacher: Date:Year & Semester:Course NO.：040305Course name：Database PrinciplesGrade：Major： Period/ Credit：32/2 Theory period：24Exp. period：8Teaching materials & Publishing house.：A First Course in Database System, J.D.Ullman/ China Machine PressApply to：Communication Engineering，Electronic and Information Engineering，Electronic Information Science and Technology，Information EngineeringNO.WeekTeaching contentsHoursKey and RequirmentsAssignments11Introduction to Database System (The worlds of database system)The development of information technology management, database and DBMS, database systems concept. Characteristics of Database.2Master data management technology and its development, master basic concepts and characteristics of database systems.Master the basic functions of DBMS. Master three-mode of database system. Master the structure of database system.Reading 1.122Database Modeling (Database modeling) Process of Information modeling. Conceptual model and data model. The methods of drawing E-R graph. Database designing principles.2Master the process of Information modeling. Grasp the concept of model and data model and their similarities and differences. Master the component data model. Master the methods and skills of designing E-R graph.Reading 2.2,2.3,2.5,2.6One project about E-R design.33The relational data model (The relational data model) Data model, relationship model, and the integrity constraints. The method of change E-R into relationship model. Methods of designing database.2Master the common data model; master the basic concept, nature and characteristics of relationship model. Relational integrity constraints. Master the characteristics and basic steps of database designing.Reading 3.1,3.344Standardized theories and methods. Data-dependent. 1NF, 2NF, 3NF and BCNF.2Master standardized theories and the basic concept of data-dependent. Master the definition and judgment of 1 NF, 2NF, 3NF and BCNF.Reading 3.5-3.755Algebra of Relational Model (Algebra of Relational Model) Relational data language classification and the characteristics, operators and expressions of algebra.2Realize the classifications of relationship data language. Master the characteristics, operators and expressions of relational algebraic language.Reading 4.1One Comprehensive title.66Features of SQL. Data definition statement. Query in a single table.2Master the features of SQL. Master the table definition, integrity constraint definition, grammar, querying in a single-table and set function, and so on. Experiment 1: Install SQL Server2000. Experiment 2: Starting SQL Server2000 and building the table.Reading 4.5,5.1,5.4,5.5,6.1-6.577SQL (The Database Language SQL) Join query. Embedded query.2Master the join query and embedded query. Experiment 3: SQL Server2000 query analyzer. Experiment 4: SQL DDL.Reading 5.2,5.3One Comprehensive title.88Update sentence. Control sentence. Sentences of defining and using view. Intro to embedded SQL and dynamic SQL.2Master the update and control statements of SQL. Realize embedded SQL and dynamic SQL.Experiment 5: SQL and preliminary DML. Experiment 6: Data query of DML.Reading 5.6,5.8,7.499Transaction management(Added content, Chinese)2Grasp the concept and features of transaction. Realize the resume of database, the purpose of concurrency control and main technology. Experiment 7: SQL DCL.Experimental 8: Comprehensive exercises on SQL.A database application design.1010Popular database application development platform and tools, database applications examples (Added content, Chinese)2Realize the current