Course Code

045101532

Course Title

Database Course Design

Course Category

Practice Course

Course Nature

Compulsory Course、Elective Course

Class Hours

Class Hours: 2 weeks  Lab Hours: 2 weeks  Practice: 0  Other: 0

Credits

2

Semester

Fifth

Institute

School of Computer Science and Engineering

ProgramOriented

Computer Science and Technology, Network Engineering, and Information Security

Teaching Language

Chinese

Prerequisites

Database

Student Outcomes

 (Special Training Ability)

Students who complete this course are required to generate the following outcomes:

3. Design / Development Solutions: An ability to design solutions for complex engineering problems and innovatively design systems, components or process that meet specific needs with societal, public health, safety, legal, cultural and environmental considerations.

5.  Applying Modern Tools: An ability to create, select and apply appropriate techniques, resources, and modern engineering and IT tools, including prediction and modeling, to complex engineering activities, with an understanding of the limitations.

9.  Individual and Teams: An ability to function effectively as an individual, and as a member or leader in diverse teams and in multi-disciplinary settings.

10. Communication: An ability to communicate effectively on complex engineering problems with the engineering community and with society at large, such as being able to comprehend and write effective reports and design documentation, make effective presentations, give and receive clear instructions, and communicate in cross-cultural contexts with international perspective.

11. Project Management: Demonstrate knowledge and understanding of engineering management principles and methods of economic decision-making, to function in multidisciplinary environments.

Course Objectives

Course Design acts as a critical link for transforming database theory into practical capability. It aims at deepening students’ understanding of basic theory of database by conducting design operation. To help students master a realistic DBMS and relevant operation by using a specified DBMS. The key for those in this class is to master conceptual structure design and logic framework design, to be proficient in using SQL to create, apply and maintain a specific database, and to develop a small database system through programming and designing.

Course Description

This course stands as a training course of professional technology and technique for students major in computer related categories in engineering institutions of higher learning. To help students solidify and put learned theory into use through designing a database application system or small relational database management system, including requirements analysis, database design(design of E-R chart, graph, and definition of view, procedures, and trigger, etc), and design of program interface. It remains as a good chance for students to improve practical ability and helps students put learned knowledge of database into realistic application system design process.

Teaching Content and Class Hours Distribution

1. Course description           1 Class Hour

1. Understand the main objectives and tasks of the course, and understand the relationship between database  system development and national security。

2. Propose course design topics and requirements

（二）Mid-term examination          4学时

（三）On-site reply and presentation    4学时

Experimental Teaching

Included

Teaching Method

The course teaching mainly lets the student take the group as the unit, designs and develops a miniature management information system. The whole course design process, from topic selection, research, reference, software design and implementation are all completed by students independently. Students are divided into groups. Students with good learning ability will lead students with poor learning foundation. Everyone should participate in the activity. The teacher guides the whole process.

Examination Method

On-site reply and presentation (80%) + course design report (20%)

Teaching Materials and Reference Books

[1] Zhou Aiwu, Wang Haiwei, Xiao Yun. Database Course Design [M]. Beijing: China Machine Press. 2012

[2] Wang Shan, Sa ShiXuan. An Introduction to Database System (Fifth Edition) [M]. Beijing: Higher Education Press. 2014

[3] Interpreted by Yang Dongqing, etc. Database System Concepts (Sixth Edition) [M]. Beijing: China Machine Press. 2012

Prepared by Whom and When

Shouling DONG, 2019.4.10