自考 管理系统中的计算机应用 实践(例题及答案)（Practice of computer application in examination management system (examples and answers)）.docVIP

自考 管理系统中的计算机应用 实践(例题及答案)（Practice of computer application in examination management system (examples and answers)） First, the basic operation items (4 items, first and 2 is 7, third and 4 is 8 points) Notice that the candidates folder appears below is C:\KSThere is a database STSK.dbc in the candidate folder. Please complete the following operations: 1., add table STUD1 to the database, its table structure is as follows: student number (C, 5), the name (C, 8), age (N, 2,0), gender (C, 2), department number (C, 2). Add table STUD2, its table structure is as follows: student number (C, 5), subjects (C, 6), grades (N, 3). The contents of the STUD1 table are as follows: Number, name, age, gender, department number 10100 Li Luo, 20 men, 1 10104 weeks, red 21, female 1 20100 Li Zhen 20 men 2 10109 Liu Hong 20 male 1 20109 alcohol, 21 male, 2 10110 Lang Chun, 19 men, 1 The contents of the STUD2 table are as follows: Number of students, subjects, scores 10100 math 88 10100 Chinese 90 10104 politics 95 20100 English 85 10109 math 87 10109 foreign language 87 20109 math 85 10110 math 85 2. for table STUD1 to establish the main index, the index name is student number, the index expression is student number. 3. for table STUD2 to establish a common index, the index name is student number, the index expression is student number 4. establish permanent links between the STUD1 table and the STUD2 table. As to... Answer analysis: Basic operation questions answer: 1, double-click the STSK.dbc database to open it In 2, in the database designer right-click pop-up shortcut menu, click the new form menu, and then click new table command button, pop-up create a dialog box in the input table name after the text box, enter STUD1 as the name of the table, click the Save button pop-up table the designer dialog box, type the table structure according to the topic request within, and finally click OK button to eject the input data records now? Dialog box, select the yes command button