Description: 1) import and reverse data
A) how to import data from other formats into the table
B) how to backup and restore the database (LKJ. Dat file in the download directory for a database backup)
C) how do you backup and restore data from other servers
2) after backup recovery, there are the following tables. There is no constraint between these tables. Please increase the constraint
A) student information sheet
B) teacher information form
C) course information form
D) course information table
E) the teacher opens the curriculum
3) the Class table has a duplicate record (course code), please delete it
4) there is a NULL value in the course information table. Please replace it with 0
5) query operation
A) total number of enquiries
B) enquiries about the number of electives per course;
C) according to the number of surnames
D) calculate the average credit scores per student
E) to check the selection of students (details)
F) enquiries about the course information of the students in the course name containing "computer"
G) students who took all the courses
H) complete some subqueries against the textbook
6) insert data
7) update data
A) the surname of li and wang is called
8) delete data
A) deleted the students who took "psychology"
9) try
A) cascade deletion
B) cascade update
10) transaction
A) write a transaction program to implement the name change operation
B) switch king li
File list (Check if you may need any files):
Download