《Advanced Data base Management》课程教学大纲.docx

OverseasChineseCollege–CourseSyllabusPagePAGE1ofNUMPAGES1

C

CapitalUniversityofEconomicsandBusiness

OverseasChineseCollege

CourseSyllabus

YearandSemester

Spring(Sophomore)

CourseName

AdvancedDatabaseManagement

CourseCode

MIS237

CourseType

?GeneralEducation(Required)?GeneralEducation(Elective)

?BasicDisciplinaryCourse?ProfessionalCourse(Required)

√ProfessionalCourse(Elective)?ProfessionalCourse(Expanded)

CourseCredits

3

CourseHours

48

Prerequisites

MIS227DatabaseSystems

Instructor

ContactInformation

OfficeHour

LearningCentre

Grade/Section

CourseTime/Place

Textbook

Thetextbookandreferencebookmainlycovertheknowledgethatinstructorintroducedintheclass,butnotlimitedtothesebooks,studentsshouldhavetheabilitytosearchandexposetotheresourcestosupportyourstudy.

CourseDescription

Thiscourseisforstudentstoobtainprinciplesofdatabasesystems.Wewillfocusmainlyonrelationaldatamodelsandrelationalqueryoperations,togetherwithSQLfordatadefinitionsandqueries.Thecoursewillalsoinvolveamulti-partprojectusingSqlServer.StudentsundertakeasemesterprojectthatincludesthequerydesignusingSqlServer.

StudentLearningOutcomes

Afterlearningthiscourse,thestudentswillbeableto:

Knowledge:

applythemajorobjectivesofdatabasetechnology;

applytherelationalmodelfordatabasesandcompetingmodels;

applythetechniquesandtoolstodesignandimplementadatabasesuitableforaninformationsystem;

applyadatabaseretrievalandmanipulationlanguage

Capability:

applytimemanagementtoself-studybeforeorduringlecturetime

analyzeandsolvedatabaseproblems

applyscientificthinkingskillsondatabase

Mindset:

establishtheintegrityandobjectivityindatabase

belogical,ethical,methodical,consistentandaccurate

applycriticalthinkingintheprocessofdecisionma