“Database”Syllabus
CourseCode | 045100892 |
CourseTitle | Database |
CourseCategory | SpecialtyBasic Courses |
CourseNature | CompulsoryCourse |
ClassHours | TotalClass Hours: 64 Computer-aided Class Hours: 16 LabHours: 0 Practice Hours: 0 |
Credits | 3.5 |
Semester | 4 |
Institute | Schoolof Computer Science and Engineering |
ProgramOriented | ComputerScience and Technology Full English Creative Class |
TeachingLanguage | English |
Prerequisites | None |
StudentOutcomes (Special Training Ability) | (1)Design / Development Solutions: An ability to design solutions forcomputer engineering complex problems, to design computer hardwareand software systems that meet with specific requirements, and toembody innovation awareness in the design process and take intoaccount social, health, safety, cultural and environmentalfactors. (2)Research: An ability to develop computer system-related knowledgeand research computer engineering complex issues, to develop thebasic capacity of computer systems research & development,systematic cognitive and practice, master the Bottom-up andtop-down problem analysis methods. (3)Applying Modern Tools: An ability to develop, select and useappropriate technologies, resources, modern engineering tools andinformation technology tools for complex computer engineeringissues. |
TeachingObjectives | (1)Master the basic principles and basic knowledge of database, andlay a solid foundation for training students’ ability ofresearch and practice application. (2)Master the construction and optimization methods of databasemodel, cultivate the basic ability of students to find problems,analyze problems and solve problems. (3)Master the SQL language and database application development,training students’ ability of design and practice application. |
CourseDescription | Databasetechnology is one of the fastest and most widely used technologyin the development of computer science and technology, and it isthe core technology of computer information system and applicationsystem. This course systematically introduces and studies thetheoretical knowledge and practical techniques of the database,students will fully understand and master the basic principles andconcepts of database systems, master the basic skills of databasedesign and application, and the system structure, functioncomponents and implementation methods of database managementsystems. The modules of the course organized as follow: relationalmodel, database language, database design and optimization, datastructures in database, algorithms in database, concurrencycontrol, database recovery and database frontier knowledge. |
Instrumentsand Equipments | Thiscourse is designed for database curriculum. The purpose of thecourse is to hope that students can use the database in practice,require students to use the MySQL database system, and learn touse SQL, and can develop an application system based on thedatabase. In this wat wo can train students Practical ability,innovation ability, development ability and so on. The course hasa strong practical, open, necessary, comprehensive, design andexploratory. |
ExperimentReport | Writeexperiment reports using South China University of Technologycurriculum design common template . After finishing theexperiment, write the report according the requirement of guidebook. |
Assessment | grade=attendance（10%）+Performance inclass（20%）+experimentreport（70%） |
TeachingMaterials and Reference Books | TeachingMaterials provided by myself ReferenceBooks Silberschatz, Abraham. Database System Concepts.McGraw-Hill, 2010 |
Preparedby Whom and When | ZhiwenYu in April 29th 2019 |
“Database”ExperimentalTeaching Arrangements
No. | ExperimentItem | ClassHours | ContentSummary | Category | Requirements | Numberof StudentsEach Group | Instruments,Equipments and Software |
1 | SQLprogramming | 6 | Master therelevant SQL statements, learn to create table, query, insert,delete and other database operations according to requirements. | Design | Compulsory | 1 | MYSQL |
2 | Builddatabase application | 10 | Master thedatabase technology to develop database application, learn toconstruct a student management system in groups, focus on thecombination of database technology and specific application. | Design | Compulsory | 3 | MYSQL |
…… | …… |
