Niuniu on the database course learning related knowledge database, but he ran into the following several problems, please help him to solve:
1. Niuniu need to create a name for the information database, the database contains several tables: the teacher, course, TCC, sc, which are listed in the table information please see the Excel document, note there are corresponding constraints under the corresponding column names, please help him create the four tables to information database (4 points);
2. Due to the need of educational administration, now you need to join jw_ before each table name, such as the first table the teacher to change jw_teacher and so on, please help him to modify the name of the table to the correct format (2 points);
3. Please help him to go to the four corresponding data table to add, add data please see the Excel document (4)
4. Please help him to complete the following query tasks, shows that the results of the corresponding (6 points) :
(1) query the title is a lecturer and electrical system in teachers information (2 points);
(2) query teachers name for a course name, course of the semester and venue (2 points);
(3) query period of more than 80, and the inspection way as the test, or a period of more than 100, and the inspection way for the exam course (2 points)
CodePudding user response:
Basic SQL, you could just recommend learning, self operationCodePudding user response:
Very urgent want to hand in the helpless