Simple is a university course design help!
"Database principle and application" course design of
A, curriculum design topic
Students admitted to the university management information system (
Students including students in the school roll management files, one's status as a student, achievement, etc management; Face a lot of student data, reports, manual handling has been difficult to keep up with the pace of modernization, with the rapid development of computer technology and network communication technology, many schools have good computer application, even network hardware construction foundation, thus to improve the modernization of school management and scientific level, to ensure that the information processing real-time, accurate, and to manage the students admitted to the university to develop a set of software is very important,
Should complete the main functions: (1) the student file management, namely, entry, modify, delete, query student file information, this information includes the student basic situation, resume from the student, the student awards, students punishment situation, medical students, (2) the student achievement management, input, modify, delete, query, students enrolled in each semester, each course result information, and support according to the grade, class condition such as query,
Second, the development environment
Database can use original concept provides the sybase database the adaptive server anywhere, development environment can choose: Power builder version 9.0 and above
Three, the basic requirements for
(1) to complete the problem statement mentioned all demand function
(2) the requirements document writing no less than 2500 words,
(3) in the document to include at least: E_R model graph, table, a detailed description of system function diagram,
(4) the user interface design: the window + menu type, interface friendly, operation simple,
Under the table relationships shows a sample
The table name
The field name meaning data types to describe a null value
TeacherID Char (6) teacher id primary key
TeacherName Char (8) the name of the teacher is not null
PS Char (10) teacher title nullable
. . .
Four, document format
1, an overview of the
Including project background, writing purpose, development environment, etc,
2, the demand analysis
The problem statement, complete functions,
Draw the ER model figure
3, the database logic design
The ER model into relational tables,
Describe the relationship between each basic table, which requires all relations to 3 nf paradigm,
Defining a view, define the index, primary key,
Such as the famous Q185872202 CSDN beg ace please contact me
CodePudding user response:
There are schools require with pb?
CodePudding user response:
Homework assignments, obviously this is a waste of timeCodePudding user response:
The homework assignments is also very simple oh, pb two or three daysCodePudding user response:
Introduction to the standard curriculum design topic, when headphones