Course Code: 119463
Course Name: Database Technology and Application
Course Type: Fundamental Course
Periods: 48(18 Experimental Classes)
Credits: 3
Target Students: Undergraduates Majoring in Economics and Management
Assessment: Computer Operating Examination
Preparatory Courses: Computer Application Base
Database technology which was born in mid-1960, is well-developed both in theory and application. It is one of the fastest growing branch in Computer Science. With the rapid development of computer technology and its widening application, especially in the development of computer network and Internet technology, the database application system has developed quickly. At present, many technologies, such as information management system, e-commerce and e-government, large and medium-sized websites, decision support systems(DSS) enterprise resource planning (ERP), customer relationship management (CRM) and data warehouse and data mining, etc. are based on database technology. As long as there is a computer, there is database technology. Database technology development requires contemporary college students to have abilities to organize, utilize and plan information resources.
Database technology and application is a course based on Access 2010 operating environment which introduces basic operations of the database and application technology. It is one of the mandatory courses for undergrads of Administration School and Economics School. Main contents of this course include: to give students an introduction to database system, the Access of 2010 operating base, database creation and management, table creation and management, query creation and operation, the operation of the SQL query, forms creation and application, report creation and application, macro creation and application, module and VBA programming, database application system development, etc. This course will be in the form of lectures and labs. It will focus on the basic principle and technology of the database, while at the same time help students develop operation ability.
Through this course, students will be able to accurately understand the basic concept of database and the application of database in various fields, to grasp the method of database technology and application development, basic skills to develop database application system, to provide students with new prospective in the follow-up database courses in data processing and problem-solving skills in their fields of study, help to cross integration of information technology and other disciplines, and build the foundation for future use in database management.