ZhongnanUniversityofEconomicsandLawDatabaseandapplicationSyllabusTotalteachinghour:17*3=51Credit:3Grade:Homework:30%FinalExam:70%1).theworldsofdatabasesystem(2hours)DataManagementTechnologyandDevelopmentBasicConceptofDatabaseSystemArchitectureofDatabaseSystemandApplicationSystemContentsofDatabaseSystem2).TheEntity-RelationshipHYPERLINK"http://www.stanford.edu/class/cs145/slides/intro.ppt"DataModel(4hours)InformationModelingPeriodConceptModelandDataModelHYPERLINK"http://www.stanford.edu/class/cs145/slides/er.ppt"Entity/RelationshipModel3).RelationalDataModel(8hours)FoundationofRelationalModelMethodsofTransformingE-RModeltoRelationalModelRelationDecomposingTheoriesandMethodsDataDependenceDatabaseDesign4.RelationalAlgebra(4hours)RelationalAlgebraLanguagesCharacteristics/operator/expressionofRelationalAlgebraConstraintsonRelations5.StandardRelationalDatabaseLanguage:SQL(12hours)CharacteristicsofSQLDataDefinitionStatementsDataQueryStatementsDataUpdateStatementsDefinitionandUseofViewDataControlMethod6.DevelopingPlatformandTools(4hours)DatabaseSecurityandControlMethodIntegralityConstraintsandControlTrigger7.SystemAspectsofSQL(10hours)TheEmbeddedSQLTheStoredProcedureCursorTransactionsinSQL8.LatestDatabaseTechnology(4hours)TrendofDatabaseSystemApplicationFieldsofDatabase